Redirect 302 redirect from GET @hwi_oauth_service_redirect (6e7d8b)

Query Metrics

15 Database Queries
11 Different statements
16.95 ms Query time
0 Invalid entities
784 Managed entities

Queries

Group similar statements

# Time Info
1 0.70 ms
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:
[
  "105369605489147334679"
]
2 0.43 ms
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
Parameters:
[]
3 4.13 ms
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.hizkuntzaeredua AS hizkuntzaeredua_21, t0.telefonoa AS telefonoa_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.lanhitzarmena AS lanhitzarmena_56, t53.altadata AS altadata_57, t53.bajadata AS bajadata_58, t53.titulazioak AS titulazioak_59, t53.egoera AS egoera_60, t53.ID_pertsonala AS ID_pertsonala_61, t53.ID_ohikogela AS ID_ohikogela_62, t63.ID_langilea AS ID_langilea_64, t63.mota AS mota_65, t63.roles AS roles_66, t63.kontratomota AS kontratomota_67, t63.altadata AS altadata_68, t63.bajadata AS bajadata_69, t63.titulazioak AS titulazioak_70, t63.eskolakoMezuakJaso AS eskolakoMezuakJaso_71, t63.egoera AS egoera_72, t63.ID_pertsonala AS ID_pertsonala_73 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 t63 ON t63.ID_pertsonala = t0.ID_pertsonala
Parameters:
[]
4 0.76 ms
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.zenbatebaluaketa AS zenbatebaluaketa_15, t0.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_16, t0.modulogainditzekoazterketa AS modulogainditzekoazterketa_17, t0.multisede AS multisede_18, t0.multibilera AS multibilera_19, t0.remesaksortu AS remesaksortu_20, t0.urtekoakuota AS urtekoakuota_21, t0.zenbatkuota AS zenbatkuota_22, t0.sepaEmpresaIzena AS sepaEmpresaIzena_23, t0.sepaEmpresaIban AS sepaEmpresaIban_24, t0.sepaEmpresaBic AS sepaEmpresaBic_25, t0.sepaEmpresaIdentifikatzailea AS sepaEmpresaIdentifikatzailea_26, t0.sepaAktibatuta AS sepaAktibatuta_27, t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_28, t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_29, t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_30, t0.kuotaproporzionala AS kuotaproporzionala_31, t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_32, t0.bajanDesaktibazioData AS bajanDesaktibazioData_33, t0.eskeintzaMuga AS eskeintzaMuga_34, t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_35, t0.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_36, t0.notaknibelekakolorez AS notaknibelekakolorez_37, t0.espezialitateanKurtsorikEz AS espezialitateanKurtsorikEz_38, t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_39, t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_40, t0.dirulaguntzak AS dirulaguntzak_41, t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_42, t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_43, t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_44, t0.onartualumni AS onartualumni_45, t0.whatsappbidezinformazioa AS whatsappbidezinformazioa_46, t0.gurasoeninformaziorakohizkuntza AS gurasoeninformaziorakohizkuntza_47, t0.dokumentoenPolitika AS dokumentoenPolitika_48, t0.lanaldiRegistroa AS lanaldiRegistroa_49, t0.asistentziaBakarrikX AS asistentziaBakarrikX_50, t0.faltaJustifikatuak AS faltaJustifikatuak_51, t0.komunikazioakIlaraBitartez AS komunikazioakIlaraBitartez_52, t0.akademikoaEgoeraAldatuJakinarazi AS akademikoaEgoeraAldatuJakinarazi_53, t0.ordutegiAldaketaJakinarazi AS ordutegiAldaketaJakinarazi_54, t0.faltakGurasoeiJakinarazi AS faltakGurasoeiJakinarazi_55, t0.faltajustifituakIrakasleeiJakinarazi AS faltajustifituakIrakasleeiJakinarazi_56, t0.delayJakinarazpenakBidaltzeko AS delayJakinarazpenakBidaltzeko_57, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_58, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_59 FROM appsetup t0 WHERE t0.ID_setup = ?
Parameters:
[
  1
]
5 0.65 ms
SELECT i0_.ID_irakaslea AS ID_irakaslea_0, i0_.kontratomota AS kontratomota_1, i0_.lanhitzarmena AS lanhitzarmena_2, i0_.altadata AS altadata_3, i0_.bajadata AS bajadata_4, i0_.titulazioak AS titulazioak_5, i0_.egoera AS egoera_6, i0_.ID_pertsonala AS ID_pertsonala_7, i0_.ID_ohikogela AS ID_ohikogela_8 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
Parameters:
[
  "rvergara@donostiaeskola.eus"
  "rvergara@donostiaeskola.eus"
  1
]
6 0.48 ms
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_.eskolakoMezuakJaso AS eskolakoMezuakJaso_7, l0_.egoera AS egoera_8, l0_.ID_pertsonala AS ID_pertsonala_9 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
Parameters:
[
  "rvergara@donostiaeskola.eus"
  "rvergara@donostiaeskola.eus"
  1
]
7 1.84 ms
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)
Parameters:
[
  "rvergara@donostiaeskola.eus"
]
8 0.86 ms
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
Parameters:
[
  "rvergara@donostiaeskola.eus"
  "rvergara@donostiaeskola.eus"
  1
]
9 0.45 ms
"START TRANSACTION"
Parameters:
[]
10 0.94 ms
UPDATE user SET lastconection = ?, password = ?, google_access_token = ? WHERE id = ?
Parameters:
[
  "2026-03-06 11:46:30"
  "ya29.A0ATkoCc60VxUdW0MG2l6siOXqLWt0jtFk4yYzQFR4Kt4nQAx91VlzPHGsMXpX6xIT8mf40jqgY2kbghujIfdBBz3xniwLf5dCYk6xeTct0BNhWLceSo_5qh44wNtXZdL2sSzQsuhi8IzfErN5tmnCiXJxDs4VDHapXWUZAiv9P70BMoZ2Ylr6eCxJb6Oj4iWNn_7K1byN2HkzRiA7SHRO-FuJTRAhmCqP70wYgJgNtS2RQdQ_GdskafX0Cl92YYyWPu_Nc1Zx8oesFWToiE2kb939Zfy_MFMaCgYKAaYSARISFQHGX2MiSV6ocyEHZwP1yk1aBA9YzQ0294"
  "ya29.A0ATkoCc60VxUdW0MG2l6siOXqLWt0jtFk4yYzQFR4Kt4nQAx91VlzPHGsMXpX6xIT8mf40jqgY2kbghujIfdBBz3xniwLf5dCYk6xeTct0BNhWLceSo_5qh44wNtXZdL2sSzQsuhi8IzfErN5tmnCiXJxDs4VDHapXWUZAiv9P70BMoZ2Ylr6eCxJb6Oj4iWNn_7K1byN2HkzRiA7SHRO-FuJTRAhmCqP70wYgJgNtS2RQdQ_GdskafX0Cl92YYyWPu_Nc1Zx8oesFWToiE2kb939Zfy_MFMaCgYKAaYSARISFQHGX2MiSV6ocyEHZwP1yk1aBA9YzQ0294"
  2
]
11 2.29 ms
"COMMIT"
Parameters:
[]
12 0.58 ms
SELECT i0_.ID_irakaslea AS ID_irakaslea_0, i0_.kontratomota AS kontratomota_1, i0_.lanhitzarmena AS lanhitzarmena_2, i0_.altadata AS altadata_3, i0_.bajadata AS bajadata_4, i0_.titulazioak AS titulazioak_5, i0_.egoera AS egoera_6, i0_.ID_pertsonala AS ID_pertsonala_7, i0_.ID_ohikogela AS ID_ohikogela_8 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
Parameters:
[
  "rvergara@donostiaeskola.eus"
  "rvergara@donostiaeskola.eus"
  1
]
13 0.51 ms
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_.eskolakoMezuakJaso AS eskolakoMezuakJaso_7, l0_.egoera AS egoera_8, l0_.ID_pertsonala AS ID_pertsonala_9 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
Parameters:
[
  "rvergara@donostiaeskola.eus"
  "rvergara@donostiaeskola.eus"
  1
]
14 1.45 ms
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)
Parameters:
[
  "rvergara@donostiaeskola.eus"
]
15 0.86 ms
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
Parameters:
[
  "rvergara@donostiaeskola.eus"
  "rvergara@donostiaeskola.eus"
  1
]

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\Pertsonala 573
App\Entity\Ikaslea 201
App\Entity\User 4
App\Entity\Irakaslea 2
App\Entity\Gela 1
App\Entity\Langilea 1
App\Entity\AppSetup 1
App\Entity\Ikasturtea 1