Symfony Profiler

[
  "route" => "eguneratuirakasleordutegiaajax"
  "route_parameters" => [
    "_route" => "eguneratuirakasleordutegiaajax"
    "_controller" => "App\Controller\IrakasleOrdutegiaController::eguneratuirakasleordutegiaajaxAction"
    "_locale" => "eu_ES"
  ]
  "request_uri" => "https://www.pasaiamusikal.eus/eu_ES/langilea/eguneratuirakasleordutegiaajax"
  "method" => "POST"
]

[
  "key" => "_security_main"
  "token_class" => "HWI\Bundle\OAuthBundle\Security\Core\Authentication\Token\OAuthToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "web"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "pasaiamusikal"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.lastconection AS lastconection_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_access_token AS google_access_token_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.is_verified AS is_verified_11, t0.def_menu AS def_menu_12, t0.akademikoak_fiels AS akademikoak_fiels_13, t0.pertsonalak_fields AS pertsonalak_fields_14 FROM user t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "App\Security\MyEntityUserProvider"
  "username" => "itziarfernandez@pasaiamusikal.eus"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerEsb6zj0\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT t0.ID_baimena AS ID_baimena_1, t0.kodea AS kodea_2, t0.multxoa AS multxoa_3, t0.ordena AS ordena_4, t0.azalpena AS azalpena_5, t0.baimendutakorolak AS baimendutakorolak_6, t0.langilerola AS langilerola_7, t0.ID_menuitem AS ID_menuitem_8, t9.ID_menuitem AS ID_menuitem_10, t9.ordena AS ordena_11, t9.tagId AS tagId_12, t9.izena AS izena_13, t9.path AS path_14, t9.itxura AS itxura_15, t9.fontawesome AS fontawesome_16, t9.target AS target_17, t9.parentmenu AS parentmenu_18, t9.gutxienekobaimena AS gutxienekobaimena_19 FROM baimena t0 LEFT JOIN menuitem t9 ON t9.gutxienekobaimena = t0.ID_baimena WHERE t0.kodea = ? LIMIT 1"
  "params" => [
    1 => "Ord_jarri"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_1, t0.orduaHasi AS orduaHasi_2, t0.orduaBukatu AS orduaBukatu_3, t0.astekoEguna AS astekoEguna_4, t0.ordutegiMota AS ordutegiMota_5, t0.ID_irakaslea AS ID_irakaslea_6, t0.ID_gela AS ID_gela_7, t0.ID_ikasturtea AS ID_ikasturtea_8, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_9 FROM irakasleordutegia t0 WHERE t0.ID_IrakasleOrdutegia = ?"
  "params" => [
    1 => 296
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ID_gela AS ID_gela_1, t0.ordena AS ordena_2, t0.solairua AS solairua_3, t0.gela AS gela_4, t0.aforo AS aforo_5, t0.argazkia AS argazkia_6, t0.ekipamendua AS ekipamendua_7, t0.aktiba AS aktiba_8, t0.ID_Sedea AS ID_Sedea_9 FROM gela t0 WHERE t0.ID_gela = ?"
  "params" => [
    1 => 69
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "UPDATE irakasleordutegia SET ID_gela = ? WHERE ID_IrakasleOrdutegia = ?"
  "params" => [
    1 => 69
    2 => 296
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_1, t0.orduaHasi AS orduaHasi_2, t0.orduaBukatu AS orduaBukatu_3, t0.astekoEguna AS astekoEguna_4, t0.ordutegiMota AS ordutegiMota_5, t0.ID_irakaslea AS ID_irakaslea_6, t0.ID_gela AS ID_gela_7, t0.ID_ikasturtea AS ID_ikasturtea_8, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_9 FROM irakasleordutegia t0 WHERE t0.ID_IrakasleOrdutegia = ?"
  "params" => [
    1 => 296
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?"
  "params" => [
    1 => 212
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ID_Ordutegia AS ID_Ordutegia_1, t0.orduaHasi AS orduaHasi_2, t0.orduaBukatu AS orduaBukatu_3, t0.astekoEguna AS astekoEguna_4, t0.ID_gela AS ID_gela_5, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_6 FROM ordutegia t0 WHERE t0.ID_OrdutegiAukera = ? ORDER BY t0.astekoEguna ASC, t0.orduaHasi ASC"
  "params" => [
    1 => 212
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "DELETE FROM ordutegia WHERE ID_Ordutegia = ?"
  "params" => [
    1 => 605
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT i0_.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_0, i0_.orduaHasi AS orduaHasi_1, i0_.orduaBukatu AS orduaBukatu_2, i0_.astekoEguna AS astekoEguna_3, i0_.ordutegiMota AS ordutegiMota_4, i0_.ID_irakaslea AS ID_irakaslea_5, i0_.ID_gela AS ID_gela_6, i0_.ID_ikasturtea AS ID_ikasturtea_7, i0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_8 FROM irakasleordutegia i0_ WHERE i0_.ID_OrdutegiAukera = ? ORDER BY i0_.astekoEguna ASC, i0_.orduaHasi ASC"
  "params" => [
    1 => 212
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO ordutegia (orduaHasi, orduaBukatu, astekoEguna, ID_gela, ID_OrdutegiAukera) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "19:00:00"
    2 => "19:30:00"
    3 => 5
    4 => 69
    5 => 212
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "SELECT t0.ID_eskeintza AS ID_eskeintza_1, t0.zerrenda AS zerrenda_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.gutxienekoAdina AS gutxienekoAdina_6, t0.gehienekoAdina AS gehienekoAdina_7, t0.bileraordutegia AS bileraordutegia_8, t0.bileraordutegiaerderaz AS bileraordutegiaerderaz_9, t0.prezioa AS prezioa_10, t0.prezioa1ikasgaia AS prezioa1ikasgaia_11, t0.remesable AS remesable_12, t0.subvencionable AS subvencionable_13, t0.ordutegiaerakutsi AS ordutegiaerakutsi_14, t0.ikasleakklasebakoitzean AS ikasleakklasebakoitzean_15, t0.klaseareniraupena AS klaseareniraupena_16, t0.banakakoa AS banakakoa_17, t0.kolorea AS kolorea_18, t0.aktibazioData AS aktibazioData_19, t0.desaktibazioData AS desaktibazioData_20, t0.ID_ikasgaia AS ID_ikasgaia_21, t0.ID_irakaslea AS ID_irakaslea_22, t0.ID_kuotamatrikula AS ID_kuotamatrikula_23, t0.ID_sedea AS ID_sedea_24, t0.ID_ikasturtea AS ID_ikasturtea_25 FROM eskeintza t0 WHERE t0.ID_eskeintza = ?"
  "params" => [
    1 => 1565
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT o0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_0, o0_.aukeraIzena AS aukeraIzena_1, o0_.dataHasi AS dataHasi_2, o0_.dataBukatu AS dataBukatu_3, o0_.ID_eskeintza AS ID_eskeintza_4 FROM ordutegiaukera o0_ LEFT JOIN eskeintza e1_ ON o0_.ID_eskeintza = e1_.ID_eskeintza LEFT JOIN ikasgaia i2_ ON e1_.ID_ikasgaia = i2_.ID_ikasgaia WHERE e1_.ID_irakaslea = ? AND e1_.ID_ikasturtea = ? OR EXISTS (SELECT a3_.ID_akademikoa FROM akademikoa a3_ WHERE o0_.ID_OrdutegiAukera = a3_.ID_OrdutegiAukera AND a3_.ID_irakaslea = ? AND a3_.ID_ikasturtea = ?) ORDER BY o0_.aukeraIzena ASC, i2_.ikasgaiMota ASC, i2_.tutoretzarakolehentasuna ASC"
  "params" => [
    1 => 7321
    2 => 2025
    3 => 7321
    4 => 2025
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT t0.ID_gela AS ID_gela_1, t0.ordena AS ordena_2, t0.solairua AS solairua_3, t0.gela AS gela_4, t0.aforo AS aforo_5, t0.argazkia AS argazkia_6, t0.ekipamendua AS ekipamendua_7, t0.aktiba AS aktiba_8, t0.ID_Sedea AS ID_Sedea_9 FROM gela t0"
]

[
  "sql" => "SELECT t0.ID_akademikoa AS ID_akademikoa_1, t0.maila AS maila_2, t0.kurtsoa AS kurtsoa_3, t0.taldea AS taldea_4, t0.hurrengokurtsoa AS hurrengokurtsoa_5, t0.bigarrenmusikatresna AS bigarrenmusikatresna_6, t0.funtsezkoikaskuntza AS funtsezkoikaskuntza_7, t0.oharraknotetan1 AS oharraknotetan1_8, t0.oharraknotetan2 AS oharraknotetan2_9, t0.oharraknotetan3 AS oharraknotetan3_10, t0.kurtsokoNotaOrokorra AS kurtsokoNotaOrokorra_11, t0.notaInprimatu AS notaInprimatu_12, t0.egoera AS egoera_13, t0.itxarotezerrendaordena AS itxarotezerrendaordena_14, t0.matrikulazioData AS matrikulazioData_15, t0.bajadata AS bajadata_16, t0.ezohikobaja AS ezohikobaja_17, t0.ezohikobajaarrazoia AS ezohikobajaarrazoia_18, t0.aktibazioData AS aktibazioData_19, t0.desaktibazioData AS desaktibazioData_20, t0.ezOhikoPrezioa AS ezOhikoPrezioa_21, t0.prezioaIkasgaia AS prezioaIkasgaia_22, t0.porzentaia1 AS porzentaia1_23, t0.porzentaia2 AS porzentaia2_24, t0.porzentaia3 AS porzentaia3_25, t0.porzentaia4 AS porzentaia4_26, t0.porzentaia5 AS porzentaia5_27, t0.porzentaia6 AS porzentaia6_28, t0.porzentaia7 AS porzentaia7_29, t0.porzentaia8 AS porzentaia8_30, t0.porzentaia9 AS porzentaia9_31, t0.porzentaia10 AS porzentaia10_32, t0.kobraezin AS kobraezin_33, t0.lehenengoikasgaia AS lehenengoikasgaia_34, t0.zenbatklase AS zenbatklase_35, t0.aprobetxamentua AS aprobetxamentua_36, t0.faltakbehartu AS faltakbehartu_37, t0.matrikulaznb AS matrikulaznb_38, t0.eskaeraznb AS eskaeraznb_39, t0.zenbatzenso AS zenbatzenso_40, t0.zenbatajustezenso AS zenbatajustezenso_41, t0.ikasleakonartutakoa AS ikasleakonartutakoa_42, t0.ID_ikaslea AS ID_ikaslea_43, t0.ID_irakaslea AS ID_irakaslea_44, t0.ID_hurrengoikasturtekoakademikoa AS ID_hurrengoikasturtekoakademikoa_45, t0.ID_eskeintza AS ID_eskeintza_46, t47.ID_matrikula AS ID_matrikula_48, t47.eskatzailearenemaila AS eskatzailearenemaila_49, t47.maila AS maila_50, t47.kurtsoa AS kurtsoa_51, t47.taldea AS taldea_52, t47.matrikulazioData AS matrikulazioData_53, t47.itxarotezerrendaordena AS itxarotezerrendaordena_54, t47.oharrak AS oharrak_55, t47.ezohikoprezioa AS ezohikoprezioa_56, t47.lehenengoikasgaia AS lehenengoikasgaia_57, t47.matrikulaznb AS matrikulaznb_58, t47.onartua AS onartua_59, t47.verify AS verify_60, t47.ID_ikaslea AS ID_ikaslea_61, t47.ID_ikasgaia AS ID_ikasgaia_62, t47.ID_sedea AS ID_sedea_63, t47.aukera1 AS aukera1_64, t47.aukera2 AS aukera2_65, t47.ID_ikasturtea AS ID_ikasturtea_66, t47.ID_akademikoa AS ID_akademikoa_67, t0.ID_ikasgaia AS ID_ikasgaia_68, t0.ID_aukera1 AS ID_aukera1_69, t0.ID_aukera2 AS ID_aukera2_70, t0.taldekomusikatresna AS taldekomusikatresna_71, t0.ID_zenso AS ID_zenso_72, t0.ID_zensoajuste AS ID_zensoajuste_73, t0.ID_sedea AS ID_sedea_74, t0.ID_ikasturtea AS ID_ikasturtea_75, t0.ID_Multibilera AS ID_Multibilera_76, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_77 FROM akademikoa t0 LEFT JOIN matrikula t47 ON t47.ID_akademikoa = t0.ID_akademikoa WHERE t0.ID_OrdutegiAukera = ?"
  "params" => [
    1 => 212
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]