Redirect 302 redirect from GET @hwi_oauth_service_redirect (eaa8c1)

Query Metrics

13 Database Queries
12 Different statements
278.73 ms Query time
0 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

Time Count Info
251.45 ms
(90.21%)
2
SELECT p0_.ID_pertsonala AS ID_pertsonala_0, p0_.izenabizenak AS izenabizenak_1, p0_.avatar AS avatar_2, p0_.izena AS izena_3, p0_.abizena1 AS abizena1_4, p0_.abizena2 AS abizena2_5, p0_.nan AS nan_6, p0_.jaiotzedata AS jaiotzedata_7, p0_.sexua AS sexua_8, p0_.nazionalitatea AS nazionalitatea_9, p0_.ikastola AS ikastola_10, p0_.baimenalopd AS baimenalopd_11, p0_.sinaduralopd AS sinaduralopd_12, p0_.oharrak AS oharrak_13, p0_.aboutyou AS aboutyou_14, p0_.helbidea AS helbidea_15, p0_.herria AS herria_16, p0_.postakodea AS postakodea_17, p0_.errolduta AS errolduta_18, p0_.informazioahizkuntza AS informazioahizkuntza_19, p0_.hizkuntzaeredua AS hizkuntzaeredua_20, p0_.telefonoa AS telefonoa_21, p0_.mobila AS mobila_22, p0_.baimenawhatsapp AS baimenawhatsapp_23, p0_.emaila AS emaila_24, p0_.emailcorporativo AS emailcorporativo_25, p0_.norenmobila1 AS norenmobila1_26, p0_.bestemobila1 AS bestemobila1_27, p0_.bestemobila1whatsapp AS bestemobila1whatsapp_28, p0_.norenmobila2 AS norenmobila2_29, p0_.bestemobila2 AS bestemobila2_30, p0_.bestemobila2whatsapp AS bestemobila2whatsapp_31, p0_.familiaugaria AS familiaugaria_32, p0_.familiaugariaepemuga AS familiaugariaepemuga_33, p0_.registeredDatetime AS registeredDatetime_34, p0_.lastUpdateDatetime AS lastUpdateDatetime_35, p0_.exentoLM AS exentoLM_36, p0_.oharrakExentoLM AS oharrakExentoLM_37, p0_.udalzorra AS udalzorra_38, p0_.zenbatekodeskontua AS zenbatekodeskontua_39, p0_.alumni AS alumni_40, p0_.verify AS verify_41, p0_.hilda AS hilda_42 FROM pertsonala p0_ LEFT JOIN irakaslea i1_ ON p0_.ID_pertsonala = i1_.ID_pertsonala LEFT JOIN langilea l2_ ON p0_.ID_pertsonala = l2_.ID_pertsonala LEFT JOIN ikaslea i3_ ON p0_.ID_pertsonala = i3_.ID_pertsonala WHERE LOWER(TRIM(p0_.emaila)) = ? OR LOWER(TRIM(i1_.emaila)) = ? OR LOWER(TRIM(l2_.emaila)) = ? OR LOWER(TRIM(i3_.emaila)) = ?
Parameters:
[
  "itziarfernandez@pasaiamusikal.eus"
  "itziarfernandez@pasaiamusikal.eus"
  "itziarfernandez@pasaiamusikal.eus"
  "itziarfernandez@pasaiamusikal.eus"
]
16.52 ms
(5.93%)
1
"COMMIT"
Parameters:
[]
3.68 ms
(1.32%)
1
SELECT COUNT(*) FROM pertsonala t0
Parameters:
[]
1.17 ms
(0.42%)
1
SELECT COUNT(*) FROM user t0
Parameters:
[]
1.08 ms
(0.39%)
1
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
Parameters:
[
  "110407137063296007556"
]
1.02 ms
(0.37%)
1
SELECT t0.ID_setup AS ID_setup_1, t0.infoEmail AS infoEmail_2, t0.herria AS herria_3, t0.eskolaIzena AS eskolaIzena_4, t0.nombreEscuela AS nombreEscuela_5, t0.domeinua AS domeinua_6, t0.headerImg AS headerImg_7, t0.logoUdalaImg AS logoUdalaImg_8, t0.logoExtraImg AS logoExtraImg_9, t0.logoEskolaImg AS logoEskolaImg_10, t0.infoIzena AS infoIzena_11, t0.infoLOPD AS infoLOPD_12, t0.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_13, t0.matrikulaznb AS matrikulaznb_14, t0.bajaznb AS bajaznb_15, t0.zenbatebaluaketa AS zenbatebaluaketa_16, t0.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_17, t0.modulogainditzekoazterketa AS modulogainditzekoazterketa_18, t0.multisede AS multisede_19, t0.multibilera AS multibilera_20, t0.remesaksortu AS remesaksortu_21, t0.urtekoakuota AS urtekoakuota_22, t0.zenbatkuota AS zenbatkuota_23, t0.sepaEmpresaIzena AS sepaEmpresaIzena_24, t0.sepaEmpresaIban AS sepaEmpresaIban_25, t0.sepaEmpresaBic AS sepaEmpresaBic_26, t0.sepaEmpresaIdentifikatzailea AS sepaEmpresaIdentifikatzailea_27, t0.sepaAktibatuta AS sepaAktibatuta_28, t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_29, t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_30, t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_31, t0.kuotaproporzionala AS kuotaproporzionala_32, t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_33, t0.bajanDesaktibazioData AS bajanDesaktibazioData_34, t0.bajaOnartuAutomatikoki AS bajaOnartuAutomatikoki_35, t0.eskeintzaMuga AS eskeintzaMuga_36, t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_37, t0.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_38, t0.notaknibelekakolorez AS notaknibelekakolorez_39, t0.espezialitateanKurtsorikEz AS espezialitateanKurtsorikEz_40, t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_41, t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_42, t0.dirulaguntzak AS dirulaguntzak_43, t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_44, t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_45, t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_46, t0.onartualumni AS onartualumni_47, t0.whatsappbidezinformazioa AS whatsappbidezinformazioa_48, t0.gurasoeninformaziorakohizkuntza AS gurasoeninformaziorakohizkuntza_49, t0.dokumentoenPolitika AS dokumentoenPolitika_50, t0.lanaldiRegistroa AS lanaldiRegistroa_51, t0.asistentziaBakarrikX AS asistentziaBakarrikX_52, t0.faltaJustifikatuak AS faltaJustifikatuak_53, t0.komunikazioakIlaraBitartez AS komunikazioakIlaraBitartez_54, t0.akademikoaEgoeraAldatuJakinarazi AS akademikoaEgoeraAldatuJakinarazi_55, t0.ordutegiAldaketaJakinarazi AS ordutegiAldaketaJakinarazi_56, t0.faltakGurasoeiJakinarazi AS faltakGurasoeiJakinarazi_57, t0.faltajustifituakIrakasleeiJakinarazi AS faltajustifituakIrakasleeiJakinarazi_58, t0.delayJakinarazpenakBidaltzeko AS delayJakinarazpenakBidaltzeko_59, t0.autosortuEskeintzaIkasturteBerria AS autosortuEskeintzaIkasturteBerria_60, t0.autosortuKuotaMatrikulaIkasturteBerria AS autosortuKuotaMatrikulaIkasturteBerria_61, t0.autosortuEgutegiAukeraIkasturteBerria AS autosortuEgutegiAukeraIkasturteBerria_62, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_63, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_64 FROM appsetup t0 WHERE t0.ID_setup = ?
Parameters:
[
  1
]
1.01 ms
(0.36%)
1
UPDATE user SET lastconection = ?, password = ?, google_access_token = ? WHERE id = ?
Parameters:
[
  "2026-03-27 10:14:40"
  "ya29.a0Aa7MYirErJ_evM0npOqHmCv2bKRaTLv1vTS42XDY3-DQo_BpYV4TdRhZmjNr0_rSzUCmY0boPKloDmyU4omTaBBClY8jBhtsl8g5U_Dm4qLPm2L61zHM5V_uttBTjRqgTatkiksMjg65HpJOUkHogtRZb9Iy-eVZFXfHgWCwYn9iDrEKrdm5WpVRAje9sRmIk5XUPMnXYHYZZHEljauM9hDU9K6tY5e7qTih15Z_6VFU2vyrfqrUc76qfR1BJOcnOMdl8iTGXwOQU5_1AnczvS1cFs9agyoaCgYKASkSARMSFQHGX2MiX6Z1N9l2K4RTb96JHQ-Q1Q0294"
  "ya29.a0Aa7MYirErJ_evM0npOqHmCv2bKRaTLv1vTS42XDY3-DQo_BpYV4TdRhZmjNr0_rSzUCmY0boPKloDmyU4omTaBBClY8jBhtsl8g5U_Dm4qLPm2L61zHM5V_uttBTjRqgTatkiksMjg65HpJOUkHogtRZb9Iy-eVZFXfHgWCwYn9iDrEKrdm5WpVRAje9sRmIk5XUPMnXYHYZZHEljauM9hDU9K6tY5e7qTih15Z_6VFU2vyrfqrUc76qfR1BJOcnOMdl8iTGXwOQU5_1AnczvS1cFs9agyoaCgYKASkSARMSFQHGX2MiX6Z1N9l2K4RTb96JHQ-Q1Q0294"
  2
]
0.82 ms
(0.30%)
1
SELECT t0.ID_ikaslea AS ID_ikaslea_1, t0.berria AS berria_2, t0.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_3, t0.egoera AS egoera_4, t0.kontukorrontea AS kontukorrontea_5, t0.emaila AS emaila_6, t0.informazioaemailpertsonalera AS informazioaemailpertsonalera_7, t0.ID_pertsonala AS ID_pertsonala_8, t0.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_9, t0.tutorea AS tutorea_10 FROM ikaslea t0 WHERE t0.ID_pertsonala = ?
Parameters:
[
  355
]
0.72 ms
(0.26%)
1
SELECT t0.ID_irakaslea AS ID_irakaslea_1, t0.kontratomota AS kontratomota_2, t0.lanhitzarmena AS lanhitzarmena_3, t0.altadata AS altadata_4, t0.bajadata AS bajadata_5, t0.titulazioak AS titulazioak_6, t0.egoera AS egoera_7, t0.emaila AS emaila_8, t0.mezuakEmailPertsonaleraBidali AS mezuakEmailPertsonaleraBidali_9, t0.jakinarazpenakEmailPertsonaleraBidali AS jakinarazpenakEmailPertsonaleraBidali_10, t0.mobila AS mobila_11, t0.mezuakWhatsappPertsonaleraBidali AS mezuakWhatsappPertsonaleraBidali_12, t0.jakinarazpenakWhatsappPertsonaleraBidali AS jakinarazpenakWhatsappPertsonaleraBidali_13, t0.telefonoa AS telefonoa_14, t0.extensioa AS extensioa_15, t0.ID_pertsonala AS ID_pertsonala_16, t0.ID_ohikogela AS ID_ohikogela_17 FROM irakaslea t0 WHERE t0.ID_pertsonala = ?
Parameters:
[
  355
]
0.51 ms
(0.18%)
1
SELECT t0.ID_familia AS ID_familia_1, t0.patriapotestad AS patriapotestad_2, t0.senidetasuna AS senidetasuna_3, t0.ID_pertsonala AS ID_pertsonala_4, t0.ID_ikaslea AS ID_ikaslea_5 FROM familia t0 WHERE t0.ID_pertsonala = ?
Parameters:
[
  355
]
0.48 ms
(0.17%)
1
SELECT t0.ID_langilea AS ID_langilea_1, t0.mota AS mota_2, t0.roles AS roles_3, t0.kontratomota AS kontratomota_4, t0.altadata AS altadata_5, t0.bajadata AS bajadata_6, t0.titulazioak AS titulazioak_7, t0.eskolakoMezuakJaso AS eskolakoMezuakJaso_8, t0.egoera AS egoera_9, t0.emaila AS emaila_10, t0.mezuakEmailPertsonaleraBidali AS mezuakEmailPertsonaleraBidali_11, t0.jakinarazpenakEmailPertsonaleraBidali AS jakinarazpenakEmailPertsonaleraBidali_12, t0.mobila AS mobila_13, t0.mezuakWhatsappPertsonaleraBidali AS mezuakWhatsappPertsonaleraBidali_14, t0.jakinarazpenakWhatsappPertsonaleraBidali AS jakinarazpenakWhatsappPertsonaleraBidali_15, t0.telefonoa AS telefonoa_16, t0.extensioa AS extensioa_17, t0.ID_pertsonala AS ID_pertsonala_18 FROM langilea t0 WHERE t0.ID_pertsonala = ?
Parameters:
[
  355
]
0.28 ms
(0.10%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Ikasturtea 2
App\Entity\User 1
App\Entity\AppSetup 1
App\Entity\Pertsonala 1
App\Entity\Ikaslea 1
App\Entity\Langilea 1

Entities Mapping