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"
]
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)
) = ?
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)) = 'itziarfernandez@pasaiamusikal.eus' OR LOWER(TRIM(i1_.emaila)) = 'itziarfernandez@pasaiamusikal.eus' OR LOWER(TRIM(l2_.emaila)) = 'itziarfernandez@pasaiamusikal.eus' OR LOWER(TRIM(i3_.emaila)) = 'itziarfernandez@pasaiamusikal.eus';
|
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 = ?
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 = ?
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 = 1;
|