Symfony Profiler

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

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;

"COMMIT"

"COMMIT";

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

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;

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
  )

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 = 'itziarfernandez@pasaiamusikal.eus' AND EXISTS (SELECT i2_.ID_ikaslea FROM ikaslea i2_ WHERE i2_.ID_ikaslea = f0_.ID_ikaslea);

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

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 = 'itziarfernandez@pasaiamusikal.eus' OR (p1_.emaila = 'itziarfernandez@pasaiamusikal.eus' AND 1 = 1) LIMIT 1;

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 = ?

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 = 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

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 = '110407137063296007556' LIMIT 1;

UPDATE
  user
SET
  lastconection = ?,
  password = ?,
  google_access_token = ?
WHERE
  id = ?

UPDATE user SET lastconection = '2025-09-09 09:40:59', password = 'ya29.a0AS3H6Nw36_aKLRwXm0pPDexhY11882OIA4v3zC57owyKs0XW46Duav9lSxAzT6Wj-zsxPZjKM-XrgzY_RdPRmkfVqxExfLIua0KumXiEiHVTSR9WYrKoKrg9XrR5Mc4h0n0jaVUR3r2QO56Ic9hSsSe-qxMuVypEGY2x-yPzMorrkV1FF7k3-a0pQYQATak9ffK0Fzlj6gaCgYKAWYSARMSFQHGX2MiwlLB2uwbFirhEfNICKIUvA0209', google_access_token = 'ya29.a0AS3H6Nw36_aKLRwXm0pPDexhY11882OIA4v3zC57owyKs0XW46Duav9lSxAzT6Wj-zsxPZjKM-XrgzY_RdPRmkfVqxExfLIua0KumXiEiHVTSR9WYrKoKrg9XrR5Mc4h0n0jaVUR3r2QO56Ic9hSsSe-qxMuVypEGY2x-yPzMorrkV1FF7k3-a0pQYQATak9ffK0Fzlj6gaCgYKAWYSARMSFQHGX2MiwlLB2uwbFirhEfNICKIUvA0209' WHERE id = 2;

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

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 = 'itziarfernandez@pasaiamusikal.eus' OR (p1_.emaila = 'itziarfernandez@pasaiamusikal.eus' AND 0 = 1)) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

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 = 'itziarfernandez@pasaiamusikal.eus' OR (p1_.emaila = 'itziarfernandez@pasaiamusikal.eus' AND 1 = 1) LIMIT 1;