Symfony Profiler

[
  "route" => "google_login"
  "route_parameters" => [
    "_route" => "google_login"
  ]
  "request_uri" => "https://www.pasaiamusikal.eus/login/check-google?authuser=0&code=4%2F0AVMBsJgdCHzo-4E1jTfl_0MCtTCfnJKNnhtKVGfxBGiNWN7u3g404HXqqeUGbBQQpDqXnQ&hd=pasaiamusikal.eus&prompt=none&scope=email%20profile%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email%20openid"
  "method" => "GET"
]

[
  "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"
]

[
  "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.google_id = ? LIMIT 1"
  "params" => [
    1 => "110407137063296007556"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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"
]

[
  "sql" => "SELECT t0.ID_pertsonala AS ID_pertsonala_1, t0.izenabizenak AS izenabizenak_2, t0.avatar AS avatar_3, t0.izena AS izena_4, t0.abizena1 AS abizena1_5, t0.abizena2 AS abizena2_6, t0.nan AS nan_7, t0.jaiotzedata AS jaiotzedata_8, t0.sexua AS sexua_9, t0.nazionalitatea AS nazionalitatea_10, t0.ikastola AS ikastola_11, t0.baimenalopd AS baimenalopd_12, t0.sinaduralopd AS sinaduralopd_13, t0.oharrak AS oharrak_14, t0.aboutyou AS aboutyou_15, t0.helbidea AS helbidea_16, t0.herria AS herria_17, t0.postakodea AS postakodea_18, t0.errolduta AS errolduta_19, t0.informazioahizkuntza AS informazioahizkuntza_20, t0.telefonoa AS telefonoa_21, t0.bestetelefonoa AS bestetelefonoa_22, t0.mobila AS mobila_23, t0.baimenawhatsapp AS baimenawhatsapp_24, t0.emaila AS emaila_25, t0.emailcorporativo AS emailcorporativo_26, t0.norenmobila1 AS norenmobila1_27, t0.bestemobila1 AS bestemobila1_28, t0.bestemobila1whatsapp AS bestemobila1whatsapp_29, t0.norenmobila2 AS norenmobila2_30, t0.bestemobila2 AS bestemobila2_31, t0.bestemobila2whatsapp AS bestemobila2whatsapp_32, t0.familiaugaria AS familiaugaria_33, t0.familiaugariaepemuga AS familiaugariaepemuga_34, t0.registeredDatetime AS registeredDatetime_35, t0.lastUpdateDatetime AS lastUpdateDatetime_36, t0.exentoLM AS exentoLM_37, t0.oharrakExentoLM AS oharrakExentoLM_38, t0.udalzorra AS udalzorra_39, t0.zenbatekodeskontua AS zenbatekodeskontua_40, t0.alumni AS alumni_41, t0.verify AS verify_42, t0.hilda AS hilda_43, t44.ID_ikaslea AS ID_ikaslea_45, t44.berria AS berria_46, t44.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_47, t44.egoera AS egoera_48, t44.kontukorrontea AS kontukorrontea_49, t44.ID_pertsonala AS ID_pertsonala_50, t44.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_51, t44.tutorea AS tutorea_52, t53.ID_irakaslea AS ID_irakaslea_54, t53.kontratomota AS kontratomota_55, t53.altadata AS altadata_56, t53.bajadata AS bajadata_57, t53.titulazioak AS titulazioak_58, t53.egoera AS egoera_59, t53.ID_pertsonala AS ID_pertsonala_60, t53.ID_ohikogela AS ID_ohikogela_61, t62.ID_langilea AS ID_langilea_63, t62.mota AS mota_64, t62.roles AS roles_65, t62.kontratomota AS kontratomota_66, t62.altadata AS altadata_67, t62.bajadata AS bajadata_68, t62.titulazioak AS titulazioak_69, t62.egoera AS egoera_70, t62.ID_pertsonala AS ID_pertsonala_71 FROM pertsonala t0 LEFT JOIN ikaslea t44 ON t44.ID_pertsonala = t0.ID_pertsonala LEFT JOIN irakaslea t53 ON t53.ID_pertsonala = t0.ID_pertsonala LEFT JOIN langilea t62 ON t62.ID_pertsonala = t0.ID_pertsonala"
]

[
  "sql" => "SELECT t0.ID_setup AS ID_setup_1, t0.infoEmail AS infoEmail_2, t0.infoIzena AS infoIzena_3, t0.infoLOPD AS infoLOPD_4, t0.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_5, t0.matrikulaznb AS matrikulaznb_6, t0.zenbatebaluaketa AS zenbatebaluaketa_7, t0.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_8, t0.modulogainditzekoazterketa AS modulogainditzekoazterketa_9, t0.multisede AS multisede_10, t0.multibilera AS multibilera_11, t0.remesaksortu AS remesaksortu_12, t0.eskeintzaMuga AS eskeintzaMuga_13, t0.urtekoakuota AS urtekoakuota_14, t0.zenbatkuota AS zenbatkuota_15, t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_16, t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_17, t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_18, t0.kuotaproporzionala AS kuotaproporzionala_19, t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_20, t0.bajanDesaktibazioData AS bajanDesaktibazioData_21, t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_22, t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_23, t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_24, t0.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_25, t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_26, t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_27, t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_28, t0.matrikulaBerriaEginda AS matrikulaBerriaEginda_29, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_30, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_31 FROM appsetup t0 WHERE t0.ID_setup = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT i0_.ID_irakaslea AS ID_irakaslea_0, i0_.kontratomota AS kontratomota_1, i0_.altadata AS altadata_2, i0_.bajadata AS bajadata_3, i0_.titulazioak AS titulazioak_4, i0_.egoera AS egoera_5, i0_.ID_pertsonala AS ID_pertsonala_6, i0_.ID_ohikogela AS ID_ohikogela_7 FROM irakaslea i0_ INNER JOIN pertsonala p1_ ON i0_.ID_pertsonala = p1_.ID_pertsonala WHERE i0_.egoera = 1 AND (p1_.emailcorporativo = ? OR (p1_.emaila = ? AND ? = 1)) LIMIT 1"
  "params" => [
    1 => "itziarfernandez@pasaiamusikal.eus"
    2 => "itziarfernandez@pasaiamusikal.eus"
    3 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT l0_.ID_langilea AS ID_langilea_0, l0_.mota AS mota_1, l0_.roles AS roles_2, l0_.kontratomota AS kontratomota_3, l0_.altadata AS altadata_4, l0_.bajadata AS bajadata_5, l0_.titulazioak AS titulazioak_6, l0_.egoera AS egoera_7, l0_.ID_pertsonala AS ID_pertsonala_8 FROM langilea l0_ INNER JOIN pertsonala p1_ ON l0_.ID_pertsonala = p1_.ID_pertsonala WHERE l0_.egoera = 1 AND p1_.emailcorporativo = ? OR (p1_.emaila = ? AND ? = 1) LIMIT 1"
  "params" => [
    1 => "itziarfernandez@pasaiamusikal.eus"
    2 => "itziarfernandez@pasaiamusikal.eus"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT f0_.ID_familia AS ID_familia_0, f0_.patriapotestad AS patriapotestad_1, f0_.senidetasuna AS senidetasuna_2, f0_.ID_pertsonala AS ID_pertsonala_3, f0_.ID_ikaslea AS ID_ikaslea_4 FROM familia f0_ INNER JOIN pertsonala p1_ ON f0_.ID_pertsonala = p1_.ID_pertsonala WHERE p1_.emaila = ? AND EXISTS (SELECT i2_.ID_ikaslea FROM ikaslea i2_ WHERE i2_.ID_ikaslea = f0_.ID_ikaslea)"
  "params" => [
    1 => "itziarfernandez@pasaiamusikal.eus"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT i0_.ID_ikaslea AS ID_ikaslea_0, i0_.berria AS berria_1, i0_.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_2, i0_.egoera AS egoera_3, i0_.kontukorrontea AS kontukorrontea_4, i0_.ID_pertsonala AS ID_pertsonala_5, i0_.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_6, i0_.tutorea AS tutorea_7 FROM ikaslea i0_ INNER JOIN pertsonala p1_ ON i0_.ID_pertsonala = p1_.ID_pertsonala WHERE p1_.emailcorporativo = ? OR (p1_.emaila = ? AND ? = 1) LIMIT 1"
  "params" => [
    1 => "itziarfernandez@pasaiamusikal.eus"
    2 => "itziarfernandez@pasaiamusikal.eus"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "UPDATE user SET lastconection = ?, password = ?, google_access_token = ? WHERE id = ?"
  "params" => [
    1 => "2025-09-09 09:40:59"
    2 => "ya29.a0AS3H6Nw36_aKLRwXm0pPDexhY11882OIA4v3zC57owyKs0XW46Duav9lSxAzT6Wj-zsxPZjKM-XrgzY_RdPRmkfVqxExfLIua0KumXiEiHVTSR9WYrKoKrg9XrR5Mc4h0n0jaVUR3r2QO56Ic9hSsSe-qxMuVypEGY2x-yPzMorrkV1FF7k3-a0pQYQATak9ffK0Fzlj6gaCgYKAWYSARMSFQHGX2MiwlLB2uwbFirhEfNICKIUvA0209"
    3 => "ya29.a0AS3H6Nw36_aKLRwXm0pPDexhY11882OIA4v3zC57owyKs0XW46Duav9lSxAzT6Wj-zsxPZjKM-XrgzY_RdPRmkfVqxExfLIua0KumXiEiHVTSR9WYrKoKrg9XrR5Mc4h0n0jaVUR3r2QO56Ic9hSsSe-qxMuVypEGY2x-yPzMorrkV1FF7k3-a0pQYQATak9ffK0Fzlj6gaCgYKAWYSARMSFQHGX2MiwlLB2uwbFirhEfNICKIUvA0209"
    4 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => HWI\Bundle\OAuthBundle\Security\Core\Authentication\Token\OAuthToken {#769
    -user: App\Entity\User {#768 …}
    -roleNames: [
      "ROLE_FULLACCESS"
      "ROLE_ZUZENDARIA"
      "ROLE_LANGILEA"
      "ROLE_FAMILIA"
      "ROLE_IKASLEA"
    ]
    -attributes: []
    -accessToken: "ya29.a0AS3H6Nw36_aKLRwXm0pPDexhY11882OIA4v3zC57owyKs0XW46Duav9lSxAzT6Wj-zsxPZjKM-XrgzY_RdPRmkfVqxExfLIua0KumXiEiHVTSR9WYrKoKrg9XrR5Mc4h0n0jaVUR3r2QO56Ic9hSsSe-qxMuVypEGY2x-yPzMorrkV1FF7k3-a0pQYQATak9ffK0Fzlj6gaCgYKAWYSARMSFQHGX2MiwlLB2uwbFirhEfNICKIUvA0209"
    -rawToken: [
      "access_token" => "ya29.a0AS3H6Nw36_aKLRwXm0pPDexhY11882OIA4v3zC57owyKs0XW46Duav9lSxAzT6Wj-zsxPZjKM-XrgzY_RdPRmkfVqxExfLIua0KumXiEiHVTSR9WYrKoKrg9XrR5Mc4h0n0jaVUR3r2QO56Ic9hSsSe-qxMuVypEGY2x-yPzMorrkV1FF7k3-a0pQYQATak9ffK0Fzlj6gaCgYKAWYSARMSFQHGX2MiwlLB2uwbFirhEfNICKIUvA0209"
      "expires_in" => 3599
      "scope" => "https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/userinfo.profile openid"
      "token_type" => "Bearer"
      "id_token" => "eyJhbGciOiJSUzI1NiIsImtpZCI6IjljNjI1MTU4Nzk1MDg0NGE2NTZiZTM1NjNkOGM1YmQ2Zjg5NGM0MDciLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJhY2NvdW50cy5nb29nbGUuY29tIiwiYXpwIjoiMzU3MTg3OTA4ODEyLTB1ZmhmZ2ltZXY3aGlmbnQ2aGcxamY4ZGlzb2EzYzA0LmFwcHMuZ29vZ2xldXNlcmNvbnRlbnQuY29tIiwiYXVkIjoiMzU3MTg3OTA4ODEyLTB1ZmhmZ2ltZXY3aGlmbnQ2aGcxamY4ZGlzb2EzYzA0LmFwcHMuZ29vZ2xldXNlcmNvbnRlbnQuY29tIiwic3ViIjoiMTEwNDA3MTM3MDYzMjk2MDA3NTU2IiwiaGQiOiJwYXNhaWFtdXNpa2FsLmV1cyIsImVtYWlsIjoiaXR6aWFyZmVybmFuZGV6QHBhc2FpYW11c2lrYWwuZXVzIiwiZW1haWxfdmVyaWZpZWQiOnRydWUsImF0X2hhc2giOiJTSk1ITW11MzRCVEJ2dnBmQ3pNbHBRIiwiaWF0IjoxNzU3NDEwODU2LCJleHAiOjE3NTc0MTQ0NTZ9.ti114-Nm093PTkvHtcqwKbfDATLSaas6WWMYOJAe1cyji3tvD0ZD5on23QmUUrYlLvWkh9uKi531PCvBvupVvmDia4r55T0hWP8PgGpG4IAAHZxrTX28F_8WysXjfc1xxRWyMK3LNJEnMZ7iM7wr_CKjdIP9eGFSf17CJnKqGYmw9ZUGCVgtchUPUvmOJk1euWoB3q3navDlLSZ-hjevAzEWkz8fIXeQ-8B1h5DeK4SmAfPqCFRmXre7Xey6usQUkqh6lI57NYW4qxLlVgPN2c4Ev4LOlKU8-c24E7r9rD2pM3FAdZGVzwaPZBA_r-zSVnrFX7cFXKrW6HuBOATOHQ"
    ]
    -expiresIn: 3599
    -createdAt: 1757410856
    -resourceOwnerName: "google"
    -tokenSecret: null
    -refreshToken: null
  }
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\SessionStrategyListener::onSuccessfulLogin"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

[
  "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" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

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

[
  "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"
]