Symfony Profiler

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;

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
  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.bestetelefonoa AS bestetelefonoa_23,
  t0.mobila AS mobila_24,
  t0.baimenawhatsapp AS baimenawhatsapp_25,
  t0.emaila AS emaila_26,
  t0.emailcorporativo AS emailcorporativo_27,
  t0.norenmobila1 AS norenmobila1_28,
  t0.bestemobila1 AS bestemobila1_29,
  t0.bestemobila1whatsapp AS bestemobila1whatsapp_30,
  t0.norenmobila2 AS norenmobila2_31,
  t0.bestemobila2 AS bestemobila2_32,
  t0.bestemobila2whatsapp AS bestemobila2whatsapp_33,
  t0.familiaugaria AS familiaugaria_34,
  t0.familiaugariaepemuga AS familiaugariaepemuga_35,
  t0.registeredDatetime AS registeredDatetime_36,
  t0.lastUpdateDatetime AS lastUpdateDatetime_37,
  t0.exentoLM AS exentoLM_38,
  t0.oharrakExentoLM AS oharrakExentoLM_39,
  t0.udalzorra AS udalzorra_40,
  t0.zenbatekodeskontua AS zenbatekodeskontua_41,
  t0.alumni AS alumni_42,
  t0.verify AS verify_43,
  t0.hilda AS hilda_44,
  t45.ID_ikaslea AS ID_ikaslea_46,
  t45.berria AS berria_47,
  t45.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_48,
  t45.egoera AS egoera_49,
  t45.kontukorrontea AS kontukorrontea_50,
  t45.ID_pertsonala AS ID_pertsonala_51,
  t45.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_52,
  t45.tutorea AS tutorea_53,
  t54.ID_irakaslea AS ID_irakaslea_55,
  t54.kontratomota AS kontratomota_56,
  t54.altadata AS altadata_57,
  t54.bajadata AS bajadata_58,
  t54.titulazioak AS titulazioak_59,
  t54.egoera AS egoera_60,
  t54.ID_pertsonala AS ID_pertsonala_61,
  t54.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.egoera AS egoera_71,
  t63.ID_pertsonala AS ID_pertsonala_72
FROM
  pertsonala t0
  LEFT JOIN ikaslea t45 ON t45.ID_pertsonala = t0.ID_pertsonala
  LEFT JOIN irakaslea t54 ON t54.ID_pertsonala = t0.ID_pertsonala
  LEFT JOIN langilea t63 ON t63.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.hizkuntzaeredua AS hizkuntzaeredua_21, t0.telefonoa AS telefonoa_22, t0.bestetelefonoa AS bestetelefonoa_23, t0.mobila AS mobila_24, t0.baimenawhatsapp AS baimenawhatsapp_25, t0.emaila AS emaila_26, t0.emailcorporativo AS emailcorporativo_27, t0.norenmobila1 AS norenmobila1_28, t0.bestemobila1 AS bestemobila1_29, t0.bestemobila1whatsapp AS bestemobila1whatsapp_30, t0.norenmobila2 AS norenmobila2_31, t0.bestemobila2 AS bestemobila2_32, t0.bestemobila2whatsapp AS bestemobila2whatsapp_33, t0.familiaugaria AS familiaugaria_34, t0.familiaugariaepemuga AS familiaugariaepemuga_35, t0.registeredDatetime AS registeredDatetime_36, t0.lastUpdateDatetime AS lastUpdateDatetime_37, t0.exentoLM AS exentoLM_38, t0.oharrakExentoLM AS oharrakExentoLM_39, t0.udalzorra AS udalzorra_40, t0.zenbatekodeskontua AS zenbatekodeskontua_41, t0.alumni AS alumni_42, t0.verify AS verify_43, t0.hilda AS hilda_44, t45.ID_ikaslea AS ID_ikaslea_46, t45.berria AS berria_47, t45.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_48, t45.egoera AS egoera_49, t45.kontukorrontea AS kontukorrontea_50, t45.ID_pertsonala AS ID_pertsonala_51, t45.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_52, t45.tutorea AS tutorea_53, t54.ID_irakaslea AS ID_irakaslea_55, t54.kontratomota AS kontratomota_56, t54.altadata AS altadata_57, t54.bajadata AS bajadata_58, t54.titulazioak AS titulazioak_59, t54.egoera AS egoera_60, t54.ID_pertsonala AS ID_pertsonala_61, t54.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.egoera AS egoera_71, t63.ID_pertsonala AS ID_pertsonala_72 FROM pertsonala t0 LEFT JOIN ikaslea t45 ON t45.ID_pertsonala = t0.ID_pertsonala LEFT JOIN irakaslea t54 ON t54.ID_pertsonala = t0.ID_pertsonala LEFT JOIN langilea t63 ON t63.ID_pertsonala = t0.ID_pertsonala;

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.urtekoakuota AS urtekoakuota_13,
  t0.zenbatkuota AS zenbatkuota_14,
  t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_15,
  t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_16,
  t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_17,
  t0.kuotaproporzionala AS kuotaproporzionala_18,
  t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_19,
  t0.bajanDesaktibazioData AS bajanDesaktibazioData_20,
  t0.eskeintzaMuga AS eskeintzaMuga_21,
  t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_22,
  t0.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_23,
  t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_24,
  t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_25,
  t0.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_26,
  t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_27,
  t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_28,
  t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_29,
  t0.matrikulaBerriaEginda AS matrikulaBerriaEginda_30,
  t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_31,
  t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_32
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.urtekoakuota AS urtekoakuota_13, t0.zenbatkuota AS zenbatkuota_14, t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_15, t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_16, t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_17, t0.kuotaproporzionala AS kuotaproporzionala_18, t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_19, t0.bajanDesaktibazioData AS bajanDesaktibazioData_20, t0.eskeintzaMuga AS eskeintzaMuga_21, t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_22, t0.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_23, t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_24, t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_25, t0.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_26, t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_27, t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_28, t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_29, t0.matrikulaBerriaEginda AS matrikulaBerriaEginda_30, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_31, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_32 FROM appsetup t0 WHERE t0.ID_setup = 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 = ?
    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;

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;

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;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE user SET lastconection = '2025-10-21 15:07:00', password = 'ya29.A0AQQ_BDTjti324OwC_AOj4M5HWKK1pLF-Dm-JJcAN3gEAWbGQ-Q3thPstZzxC8Zvp3qe4hRWBLCTxGB-FY9wzc7oVV-ajpWNuAyRYfJlKTzgSdqV9i1s24CR7wo4gMUmWlvj2N43opoaAGXyION2BofZwMnWS9lcODlVS0kOcFJH7D2IdKpux0cSu96hzRKTGSU6i_k12NMNd9GV8LVB-vmNcWCjQZrNFRzXEbxOFbofFF0b5C9n8Wk4fyJfiMlu3MmfNsPluyRmjGZPGPpqZE01bWxNnoQaCgYKATQSARMSFQHGX2Mi8t3VnTN2WtjZTMAARCBJpA0293', google_access_token = 'ya29.A0AQQ_BDTjti324OwC_AOj4M5HWKK1pLF-Dm-JJcAN3gEAWbGQ-Q3thPstZzxC8Zvp3qe4hRWBLCTxGB-FY9wzc7oVV-ajpWNuAyRYfJlKTzgSdqV9i1s24CR7wo4gMUmWlvj2N43opoaAGXyION2BofZwMnWS9lcODlVS0kOcFJH7D2IdKpux0cSu96hzRKTGSU6i_k12NMNd9GV8LVB-vmNcWCjQZrNFRzXEbxOFbofFF0b5C9n8Wk4fyJfiMlu3MmfNsPluyRmjGZPGPpqZE01bWxNnoQaCgYKATQSARMSFQHGX2Mi8t3VnTN2WtjZTMAARCBJpA0293' WHERE id = 2;

"COMMIT"

"COMMIT";