POST https://www.pasaiamusikal.eus/eu_ES/langilea/asistentzia/astekoegunbatenasistentziaajax

Response
200 OK
Browse referrer URL
IP
88.10.224.66
Profiled on
Token
290d72

Query Metrics

40 Database Queries
12 Different statements
34.26 ms Query time
2 Invalid entities
229 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.01 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.id = ? LIMIT 1
Parameters: 
[
  1173
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.79 ms 
SELECT t0.ID_baimena AS ID_baimena_1, t0.kodea AS kodea_2, t0.multxoa AS multxoa_3, t0.ordena AS ordena_4, t0.azalpena AS azalpena_5, t0.descripcion AS descripcion_6, t0.baimendutakorolak AS baimendutakorolak_7, t0.langilerola AS langilerola_8, t0.ID_menuitem AS ID_menuitem_9, t10.ID_menuitem AS ID_menuitem_11, t10.ordena AS ordena_12, t10.tagId AS tagId_13, t10.izena AS izena_14, t10.nombre AS nombre_15, t10.path AS path_16, t10.itxura AS itxura_17, t10.fontawesome AS fontawesome_18, t10.target AS target_19, t10.parentmenu AS parentmenu_20, t10.gutxienekobaimena AS gutxienekobaimena_21 FROM baimena t0 LEFT JOIN menuitem t10 ON t10.gutxienekobaimena = t0.ID_baimena WHERE t0.kodea = ? LIMIT 1
Parameters: 
[
  "Jar_asisJa"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.81 ms 
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.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_26, t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_27, t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_28, t0.onartualumni AS onartualumni_29, t0.whatsappbidezinformazioa AS whatsappbidezinformazioa_30, t0.gurasoeninformaziorakohizkuntza AS gurasoeninformaziorakohizkuntza_31, t0.matrikulaBerriaEginda AS matrikulaBerriaEginda_32, t0.lanaldiRegistroa AS lanaldiRegistroa_33, t0.asistentziaBakarrikX AS asistentziaBakarrikX_34, t0.faltaJustifikatuak AS faltaJustifikatuak_35, t0.sepaEmpresaIzena AS sepaEmpresaIzena_36, t0.sepaEmpresaIban AS sepaEmpresaIban_37, t0.sepaEmpresaBic AS sepaEmpresaBic_38, t0.sepaEmpresaIdentifikatzailea AS sepaEmpresaIdentifikatzailea_39, t0.sepaAktibatuta AS sepaAktibatuta_40, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_41, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_42 FROM appsetup t0 WHERE t0.ID_setup = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.90 ms 
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
Parameters: 
[
  "maribeleskutxuri@pasaiamusikal.eus"
  "maribeleskutxuri@pasaiamusikal.eus"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.14 ms 
SELECT i0_.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_0, i0_.orduaHasi AS orduaHasi_1, i0_.orduaBukatu AS orduaBukatu_2, i0_.astekoEguna AS astekoEguna_3, i0_.ordutegiMota AS ordutegiMota_4, i0_.ID_irakaslea AS ID_irakaslea_5, i0_.ID_gela AS ID_gela_6, i0_.ID_ikasturtea AS ID_ikasturtea_7, i0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_8 FROM irakasleordutegia i0_ WHERE i0_.ID_ikasturtea = ? AND i0_.ID_irakaslea = ? GROUP BY i0_.astekoEguna ORDER BY i0_.astekoEguna ASC
Parameters: 
[
  2025
  7316
]
View formatted query    View runnable query    Explain query    View query backtrace
6 4.33 ms 
SELECT a0_.ID_akademikoa AS ID_akademikoa_0, a0_.maila AS maila_1, a0_.kurtsoa AS kurtsoa_2, a0_.taldea AS taldea_3, a0_.hurrengokurtsoa AS hurrengokurtsoa_4, a0_.bigarrenmusikatresna AS bigarrenmusikatresna_5, a0_.funtsezkoikaskuntza AS funtsezkoikaskuntza_6, a0_.oharraknotetan1 AS oharraknotetan1_7, a0_.oharraknotetan2 AS oharraknotetan2_8, a0_.oharraknotetan3 AS oharraknotetan3_9, a0_.kurtsokoNotaOrokorra AS kurtsokoNotaOrokorra_10, a0_.notaInprimatu AS notaInprimatu_11, a0_.egoera AS egoera_12, a0_.itxarotezerrendaordena AS itxarotezerrendaordena_13, a0_.matrikulazioData AS matrikulazioData_14, a0_.bajadata AS bajadata_15, a0_.ezohikobaja AS ezohikobaja_16, a0_.ezohikobajaarrazoia AS ezohikobajaarrazoia_17, a0_.aktibazioData AS aktibazioData_18, a0_.desaktibazioData AS desaktibazioData_19, a0_.ezOhikoPrezioa AS ezOhikoPrezioa_20, a0_.prezioaIkasgaia AS prezioaIkasgaia_21, a0_.porzentaia1 AS porzentaia1_22, a0_.porzentaia2 AS porzentaia2_23, a0_.porzentaia3 AS porzentaia3_24, a0_.porzentaia4 AS porzentaia4_25, a0_.porzentaia5 AS porzentaia5_26, a0_.porzentaia6 AS porzentaia6_27, a0_.porzentaia7 AS porzentaia7_28, a0_.porzentaia8 AS porzentaia8_29, a0_.porzentaia9 AS porzentaia9_30, a0_.porzentaia10 AS porzentaia10_31, a0_.kobraezin AS kobraezin_32, a0_.lehenengoikasgaia AS lehenengoikasgaia_33, a0_.zenbatklase AS zenbatklase_34, a0_.aprobetxamentua AS aprobetxamentua_35, a0_.faltakbehartu AS faltakbehartu_36, a0_.matrikulaznb AS matrikulaznb_37, a0_.eskaeraznb AS eskaeraznb_38, a0_.zenbatzenso AS zenbatzenso_39, a0_.zenbatajustezenso AS zenbatajustezenso_40, a0_.ikasleakonartutakoa AS ikasleakonartutakoa_41, a0_.ID_ikaslea AS ID_ikaslea_42, a0_.ID_irakaslea AS ID_irakaslea_43, a0_.ID_hurrengoikasturtekoakademikoa AS ID_hurrengoikasturtekoakademikoa_44, a0_.ID_eskeintza AS ID_eskeintza_45, a0_.ID_ikasgaia AS ID_ikasgaia_46, a0_.ID_aukera1 AS ID_aukera1_47, a0_.ID_aukera2 AS ID_aukera2_48, a0_.taldekomusikatresna AS taldekomusikatresna_49, a0_.ID_zenso AS ID_zenso_50, a0_.ID_zensoajuste AS ID_zensoajuste_51, a0_.ID_sedea AS ID_sedea_52, a0_.ID_ikasturtea AS ID_ikasturtea_53, a0_.ID_Multibilera AS ID_Multibilera_54, a0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_55 FROM akademikoa a0_ INNER JOIN irakaslea i1_ ON a0_.ID_irakaslea = i1_.ID_irakaslea INNER JOIN pertsonala p2_ ON i1_.ID_pertsonala = p2_.ID_pertsonala LEFT JOIN ordutegiaukera o3_ ON a0_.ID_OrdutegiAukera = o3_.ID_OrdutegiAukera WHERE a0_.ID_ikasturtea = ? AND a0_.ID_irakaslea = ? AND EXISTS (SELECT i4_.ID_IrakasleOrdutegia FROM irakasleordutegia i4_ LEFT JOIN ordutegiaukera o5_ ON i4_.ID_OrdutegiAukera = o5_.ID_OrdutegiAukera WHERE o5_.ID_OrdutegiAukera = o3_.ID_OrdutegiAukera AND i4_.astekoEguna = ?) ORDER BY a0_.ID_ikasgaia ASC, a0_.kurtsoa ASC, a0_.taldea ASC, o3_.aukeraIzena ASC
Parameters: 
[
  2025
  7316
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.81 ms 
SELECT t0.ID_matrikula AS ID_matrikula_1, t0.eskatzailearenemaila AS eskatzailearenemaila_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.matrikulazioData AS matrikulazioData_6, t0.itxarotezerrendaordena AS itxarotezerrendaordena_7, t0.oharrak AS oharrak_8, t0.ezohikoprezioa AS ezohikoprezioa_9, t0.lehenengoikasgaia AS lehenengoikasgaia_10, t0.matrikulaznb AS matrikulaznb_11, t0.onartua AS onartua_12, t0.verify AS verify_13, t0.ID_ikaslea AS ID_ikaslea_14, t0.ID_ikasgaia AS ID_ikasgaia_15, t0.ID_sedea AS ID_sedea_16, t0.aukera1 AS aukera1_17, t0.aukera2 AS aukera2_18, t0.ID_ikasturtea AS ID_ikasturtea_19, t0.ID_akademikoa AS ID_akademikoa_20 FROM matrikula t0 WHERE t0.ID_akademikoa = ?
Parameters: 
[
  249899
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.68 ms 
SELECT t0.ID_matrikula AS ID_matrikula_1, t0.eskatzailearenemaila AS eskatzailearenemaila_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.matrikulazioData AS matrikulazioData_6, t0.itxarotezerrendaordena AS itxarotezerrendaordena_7, t0.oharrak AS oharrak_8, t0.ezohikoprezioa AS ezohikoprezioa_9, t0.lehenengoikasgaia AS lehenengoikasgaia_10, t0.matrikulaznb AS matrikulaznb_11, t0.onartua AS onartua_12, t0.verify AS verify_13, t0.ID_ikaslea AS ID_ikaslea_14, t0.ID_ikasgaia AS ID_ikasgaia_15, t0.ID_sedea AS ID_sedea_16, t0.aukera1 AS aukera1_17, t0.aukera2 AS aukera2_18, t0.ID_ikasturtea AS ID_ikasturtea_19, t0.ID_akademikoa AS ID_akademikoa_20 FROM matrikula t0 WHERE t0.ID_akademikoa = ?
Parameters: 
[
  249808
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.59 ms 
SELECT t0.ID_matrikula AS ID_matrikula_1, t0.eskatzailearenemaila AS eskatzailearenemaila_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.matrikulazioData AS matrikulazioData_6, t0.itxarotezerrendaordena AS itxarotezerrendaordena_7, t0.oharrak AS oharrak_8, t0.ezohikoprezioa AS ezohikoprezioa_9, t0.lehenengoikasgaia AS lehenengoikasgaia_10, t0.matrikulaznb AS matrikulaznb_11, t0.onartua AS onartua_12, t0.verify AS verify_13, t0.ID_ikaslea AS ID_ikaslea_14, t0.ID_ikasgaia AS ID_ikasgaia_15, t0.ID_sedea AS ID_sedea_16, t0.aukera1 AS aukera1_17, t0.aukera2 AS aukera2_18, t0.ID_ikasturtea AS ID_ikasturtea_19, t0.ID_akademikoa AS ID_akademikoa_20 FROM matrikula t0 WHERE t0.ID_akademikoa = ?
Parameters: 
[
  250205
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.56 ms 
SELECT t0.ID_matrikula AS ID_matrikula_1, t0.eskatzailearenemaila AS eskatzailearenemaila_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.matrikulazioData AS matrikulazioData_6, t0.itxarotezerrendaordena AS itxarotezerrendaordena_7, t0.oharrak AS oharrak_8, t0.ezohikoprezioa AS ezohikoprezioa_9, t0.lehenengoikasgaia AS lehenengoikasgaia_10, t0.matrikulaznb AS matrikulaznb_11, t0.onartua AS onartua_12, t0.verify AS verify_13, t0.ID_ikaslea AS ID_ikaslea_14, t0.ID_ikasgaia AS ID_ikasgaia_15, t0.ID_sedea AS ID_sedea_16, t0.aukera1 AS aukera1_17, t0.aukera2 AS aukera2_18, t0.ID_ikasturtea AS ID_ikasturtea_19, t0.ID_akademikoa AS ID_akademikoa_20 FROM matrikula t0 WHERE t0.ID_akademikoa = ?
Parameters: 
[
  249618
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.58 ms 
SELECT t0.ID_matrikula AS ID_matrikula_1, t0.eskatzailearenemaila AS eskatzailearenemaila_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.matrikulazioData AS matrikulazioData_6, t0.itxarotezerrendaordena AS itxarotezerrendaordena_7, t0.oharrak AS oharrak_8, t0.ezohikoprezioa AS ezohikoprezioa_9, t0.lehenengoikasgaia AS lehenengoikasgaia_10, t0.matrikulaznb AS matrikulaznb_11, t0.onartua AS onartua_12, t0.verify AS verify_13, t0.ID_ikaslea AS ID_ikaslea_14, t0.ID_ikasgaia AS ID_ikasgaia_15, t0.ID_sedea AS ID_sedea_16, t0.aukera1 AS aukera1_17, t0.aukera2 AS aukera2_18, t0.ID_ikasturtea AS ID_ikasturtea_19, t0.ID_akademikoa AS ID_akademikoa_20 FROM matrikula t0 WHERE t0.ID_akademikoa = ?
Parameters: 
[
  249660
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.54 ms 
SELECT t0.ID_matrikula AS ID_matrikula_1, t0.eskatzailearenemaila AS eskatzailearenemaila_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.matrikulazioData AS matrikulazioData_6, t0.itxarotezerrendaordena AS itxarotezerrendaordena_7, t0.oharrak AS oharrak_8, t0.ezohikoprezioa AS ezohikoprezioa_9, t0.lehenengoikasgaia AS lehenengoikasgaia_10, t0.matrikulaznb AS matrikulaznb_11, t0.onartua AS onartua_12, t0.verify AS verify_13, t0.ID_ikaslea AS ID_ikaslea_14, t0.ID_ikasgaia AS ID_ikasgaia_15, t0.ID_sedea AS ID_sedea_16, t0.aukera1 AS aukera1_17, t0.aukera2 AS aukera2_18, t0.ID_ikasturtea AS ID_ikasturtea_19, t0.ID_akademikoa AS ID_akademikoa_20 FROM matrikula t0 WHERE t0.ID_akademikoa = ?
Parameters: 
[
  249804
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.58 ms 
SELECT t0.ID_matrikula AS ID_matrikula_1, t0.eskatzailearenemaila AS eskatzailearenemaila_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.matrikulazioData AS matrikulazioData_6, t0.itxarotezerrendaordena AS itxarotezerrendaordena_7, t0.oharrak AS oharrak_8, t0.ezohikoprezioa AS ezohikoprezioa_9, t0.lehenengoikasgaia AS lehenengoikasgaia_10, t0.matrikulaznb AS matrikulaznb_11, t0.onartua AS onartua_12, t0.verify AS verify_13, t0.ID_ikaslea AS ID_ikaslea_14, t0.ID_ikasgaia AS ID_ikasgaia_15, t0.ID_sedea AS ID_sedea_16, t0.aukera1 AS aukera1_17, t0.aukera2 AS aukera2_18, t0.ID_ikasturtea AS ID_ikasturtea_19, t0.ID_akademikoa AS ID_akademikoa_20 FROM matrikula t0 WHERE t0.ID_akademikoa = ?
Parameters: 
[
  249802
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.68 ms 
SELECT t0.ID_ikasgaia AS ID_ikasgaia_1, t0.ikasgaia AS ikasgaia_2, t0.ikasgaiaErderaz AS ikasgaiaErderaz_3, t0.ikasgaiMota AS ikasgaiMota_4, t0.tutoretzarakolehentasuna AS tutoretzarakolehentasuna_5, t0.espezialitatea AS espezialitatea_6, t0.aktiboa AS aktiboa_7, t0.numeroKlauso AS numeroKlauso_8, t0.zenbatikaslezahar AS zenbatikaslezahar_9, t0.zenbatikasleberri AS zenbatikasleberri_10, t0.zenbatikaslebaja AS zenbatikaslebaja_11, t0.gutxienekoadina AS gutxienekoadina_12, t0.gehienekoadina AS gehienekoadina_13, t0.sarreramaila AS sarreramaila_14, t0.zenbatkurtso1nibelean AS zenbatkurtso1nibelean_15, t0.zenbatderrigorrez1nibelean AS zenbatderrigorrez1nibelean_16, t0.zenbatkurtso2nibelean AS zenbatkurtso2nibelean_17, t0.zenbatderrigorrez2nibelean AS zenbatderrigorrez2nibelean_18, t0.zenbatkurtso3nibelean AS zenbatkurtso3nibelean_19, t0.zenbatderrigorrez3nibelean AS zenbatderrigorrez3nibelean_20, t0.zenbatkurtso4nibelean AS zenbatkurtso4nibelean_21, t0.zenbatderrigorrez4nibelean AS zenbatderrigorrez4nibelean_22, t0.ID_ikasketaplana AS ID_ikasketaplana_23, t0.ID_notamota AS ID_notamota_24 FROM ikasgaia t0 WHERE t0.ID_ikasgaia = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.98 ms 
SELECT t0.ID_jarraipena AS ID_jarraipena_1, t0.data AS data_2, t0.ordezkodata AS ordezkodata_3, t0.asistentzia AS asistentzia_4, t0.justifikatua AS justifikatua_5, t0.justifikazioarrazoia AS justifikazioarrazoia_6, t0.berandu AS berandu_7, t0.beranduZenbat AS beranduZenbat_8, t0.lehenago AS lehenago_9, t0.lehenagoZenbat AS lehenagoZenbat_10, t0.materialagabe AS materialagabe_11, t0.jarreradesegokia AS jarreradesegokia_12, t0.etxekolanakegingabe AS etxekolanakegingabe_13, t0.etxekolanak AS etxekolanak_14, t0.klaseanlandutakoa AS klaseanlandutakoa_15, t0.oharrak AS oharrak_16, t0.emailezbidalita AS emailezbidalita_17, t0.ID_akademikoa AS ID_akademikoa_18, t0.ID_eskeintza AS ID_eskeintza_19 FROM jarraipena t0 WHERE t0.ID_akademikoa = ? ORDER BY t0.data ASC
Parameters: 
[
  249899
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.52 ms 
SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?
Parameters: 
[
  106
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.70 ms 
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.ID_pertsonala AS ID_pertsonala_6, t0.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_7, t0.tutorea AS tutorea_8 FROM ikaslea t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  6501
]
View formatted query    View runnable query    Explain query    View query backtrace
18 1.45 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.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 WHERE t0.ID_pertsonala = ?
Parameters: 
[
  6501
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.80 ms 
SELECT t0.ID_jarraipena AS ID_jarraipena_1, t0.data AS data_2, t0.ordezkodata AS ordezkodata_3, t0.asistentzia AS asistentzia_4, t0.justifikatua AS justifikatua_5, t0.justifikazioarrazoia AS justifikazioarrazoia_6, t0.berandu AS berandu_7, t0.beranduZenbat AS beranduZenbat_8, t0.lehenago AS lehenago_9, t0.lehenagoZenbat AS lehenagoZenbat_10, t0.materialagabe AS materialagabe_11, t0.jarreradesegokia AS jarreradesegokia_12, t0.etxekolanakegingabe AS etxekolanakegingabe_13, t0.etxekolanak AS etxekolanak_14, t0.klaseanlandutakoa AS klaseanlandutakoa_15, t0.oharrak AS oharrak_16, t0.emailezbidalita AS emailezbidalita_17, t0.ID_akademikoa AS ID_akademikoa_18, t0.ID_eskeintza AS ID_eskeintza_19 FROM jarraipena t0 WHERE t0.ID_akademikoa = ? ORDER BY t0.data ASC
Parameters: 
[
  249808
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.49 ms 
SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?
Parameters: 
[
  102
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.41 ms 
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.ID_pertsonala AS ID_pertsonala_6, t0.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_7, t0.tutorea AS tutorea_8 FROM ikaslea t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  6562
]
View formatted query    View runnable query    Explain query    View query backtrace
22 1.07 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.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 WHERE t0.ID_pertsonala = ?
Parameters: 
[
  6562
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.92 ms 
SELECT t0.ID_jarraipena AS ID_jarraipena_1, t0.data AS data_2, t0.ordezkodata AS ordezkodata_3, t0.asistentzia AS asistentzia_4, t0.justifikatua AS justifikatua_5, t0.justifikazioarrazoia AS justifikazioarrazoia_6, t0.berandu AS berandu_7, t0.beranduZenbat AS beranduZenbat_8, t0.lehenago AS lehenago_9, t0.lehenagoZenbat AS lehenagoZenbat_10, t0.materialagabe AS materialagabe_11, t0.jarreradesegokia AS jarreradesegokia_12, t0.etxekolanakegingabe AS etxekolanakegingabe_13, t0.etxekolanak AS etxekolanak_14, t0.klaseanlandutakoa AS klaseanlandutakoa_15, t0.oharrak AS oharrak_16, t0.emailezbidalita AS emailezbidalita_17, t0.ID_akademikoa AS ID_akademikoa_18, t0.ID_eskeintza AS ID_eskeintza_19 FROM jarraipena t0 WHERE t0.ID_akademikoa = ? ORDER BY t0.data ASC
Parameters: 
[
  250205
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.37 ms 
SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?
Parameters: 
[
  112
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.43 ms 
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.ID_pertsonala AS ID_pertsonala_6, t0.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_7, t0.tutorea AS tutorea_8 FROM ikaslea t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  448
]
View formatted query    View runnable query    Explain query    View query backtrace
26 1.79 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.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 WHERE t0.ID_pertsonala = ?
Parameters: 
[
  448
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.75 ms 
SELECT t0.ID_jarraipena AS ID_jarraipena_1, t0.data AS data_2, t0.ordezkodata AS ordezkodata_3, t0.asistentzia AS asistentzia_4, t0.justifikatua AS justifikatua_5, t0.justifikazioarrazoia AS justifikazioarrazoia_6, t0.berandu AS berandu_7, t0.beranduZenbat AS beranduZenbat_8, t0.lehenago AS lehenago_9, t0.lehenagoZenbat AS lehenagoZenbat_10, t0.materialagabe AS materialagabe_11, t0.jarreradesegokia AS jarreradesegokia_12, t0.etxekolanakegingabe AS etxekolanakegingabe_13, t0.etxekolanak AS etxekolanak_14, t0.klaseanlandutakoa AS klaseanlandutakoa_15, t0.oharrak AS oharrak_16, t0.emailezbidalita AS emailezbidalita_17, t0.ID_akademikoa AS ID_akademikoa_18, t0.ID_eskeintza AS ID_eskeintza_19 FROM jarraipena t0 WHERE t0.ID_akademikoa = ? ORDER BY t0.data ASC
Parameters: 
[
  249618
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.48 ms 
SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?
Parameters: 
[
  93
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.44 ms 
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.ID_pertsonala AS ID_pertsonala_6, t0.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_7, t0.tutorea AS tutorea_8 FROM ikaslea t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  5365
]
View formatted query    View runnable query    Explain query    View query backtrace
30 1.08 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.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 WHERE t0.ID_pertsonala = ?
Parameters: 
[
  5365
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.76 ms 
SELECT t0.ID_jarraipena AS ID_jarraipena_1, t0.data AS data_2, t0.ordezkodata AS ordezkodata_3, t0.asistentzia AS asistentzia_4, t0.justifikatua AS justifikatua_5, t0.justifikazioarrazoia AS justifikazioarrazoia_6, t0.berandu AS berandu_7, t0.beranduZenbat AS beranduZenbat_8, t0.lehenago AS lehenago_9, t0.lehenagoZenbat AS lehenagoZenbat_10, t0.materialagabe AS materialagabe_11, t0.jarreradesegokia AS jarreradesegokia_12, t0.etxekolanakegingabe AS etxekolanakegingabe_13, t0.etxekolanak AS etxekolanak_14, t0.klaseanlandutakoa AS klaseanlandutakoa_15, t0.oharrak AS oharrak_16, t0.emailezbidalita AS emailezbidalita_17, t0.ID_akademikoa AS ID_akademikoa_18, t0.ID_eskeintza AS ID_eskeintza_19 FROM jarraipena t0 WHERE t0.ID_akademikoa = ? ORDER BY t0.data ASC
Parameters: 
[
  249660
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.39 ms 
SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?
Parameters: 
[
  96
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.74 ms 
SELECT t0.ID_jarraipena AS ID_jarraipena_1, t0.data AS data_2, t0.ordezkodata AS ordezkodata_3, t0.asistentzia AS asistentzia_4, t0.justifikatua AS justifikatua_5, t0.justifikazioarrazoia AS justifikazioarrazoia_6, t0.berandu AS berandu_7, t0.beranduZenbat AS beranduZenbat_8, t0.lehenago AS lehenago_9, t0.lehenagoZenbat AS lehenagoZenbat_10, t0.materialagabe AS materialagabe_11, t0.jarreradesegokia AS jarreradesegokia_12, t0.etxekolanakegingabe AS etxekolanakegingabe_13, t0.etxekolanak AS etxekolanak_14, t0.klaseanlandutakoa AS klaseanlandutakoa_15, t0.oharrak AS oharrak_16, t0.emailezbidalita AS emailezbidalita_17, t0.ID_akademikoa AS ID_akademikoa_18, t0.ID_eskeintza AS ID_eskeintza_19 FROM jarraipena t0 WHERE t0.ID_akademikoa = ? ORDER BY t0.data ASC
Parameters: 
[
  249804
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.97 ms 
SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?
Parameters: 
[
  101
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.47 ms 
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.ID_pertsonala AS ID_pertsonala_6, t0.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_7, t0.tutorea AS tutorea_8 FROM ikaslea t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  1505
]
View formatted query    View runnable query    Explain query    View query backtrace
36 1.23 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.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 WHERE t0.ID_pertsonala = ?
Parameters: 
[
  1505
]
View formatted query    View runnable query    Explain query    View query backtrace
37 1.06 ms 
SELECT t0.ID_jarraipena AS ID_jarraipena_1, t0.data AS data_2, t0.ordezkodata AS ordezkodata_3, t0.asistentzia AS asistentzia_4, t0.justifikatua AS justifikatua_5, t0.justifikazioarrazoia AS justifikazioarrazoia_6, t0.berandu AS berandu_7, t0.beranduZenbat AS beranduZenbat_8, t0.lehenago AS lehenago_9, t0.lehenagoZenbat AS lehenagoZenbat_10, t0.materialagabe AS materialagabe_11, t0.jarreradesegokia AS jarreradesegokia_12, t0.etxekolanakegingabe AS etxekolanakegingabe_13, t0.etxekolanak AS etxekolanak_14, t0.klaseanlandutakoa AS klaseanlandutakoa_15, t0.oharrak AS oharrak_16, t0.emailezbidalita AS emailezbidalita_17, t0.ID_akademikoa AS ID_akademikoa_18, t0.ID_eskeintza AS ID_eskeintza_19 FROM jarraipena t0 WHERE t0.ID_akademikoa = ? ORDER BY t0.data ASC
Parameters: 
[
  249802
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.48 ms 
SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = ?
Parameters: 
[
  100
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.51 ms 
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.ID_pertsonala AS ID_pertsonala_6, t0.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_7, t0.tutorea AS tutorea_8 FROM ikaslea t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  6603
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.96 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.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 WHERE t0.ID_pertsonala = ?
Parameters: 
[
  6603
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Jarraipena 180
App\Entity\OrdutegiAukera 9
App\Entity\Pertsonala 7
App\Entity\Akademikoa 7
App\Entity\Ikaslea 7
App\Entity\Multibilera 4
App\Entity\IrakasleOrdutegia 3
App\Entity\User 1
App\Entity\Baimena 1
App\Entity\MenuItem 1
App\Entity\AppSetup 1
App\Entity\Ikasturtea 1
App\Entity\Irakaslea 1
App\Entity\Gela 1
App\Entity\Eskeintza 1
App\Entity\Ikasgaia 1
App\Entity\Zenso 1
App\Entity\Sedea 1
App\Entity\NotaMota 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Baimena No errors.
App\Entity\MenuItem No errors.
App\Entity\AppSetup No errors.
App\Entity\Ikasturtea No errors.
App\Entity\Irakaslea No errors.
App\Entity\Pertsonala
  • The mappings App\Entity\Pertsonala#notificationnoris and App\Entity\NotificationNori#pertsonala are inconsistent with each other.
App\Entity\Gela No errors.
App\Entity\Akademikoa No errors.
App\Entity\Inbentarioa No errors.
App\Entity\Eskeintza No errors.
App\Entity\Ikaslea No errors.
App\Entity\Hitzordua No errors.
App\Entity\Abestia No errors.
App\Entity\IrakasleOrdutegia No errors.
App\Entity\OrdutegiAukera No errors.
App\Entity\Ikasgaia No errors.
App\Entity\Zenso No errors.
App\Entity\Sedea No errors.
App\Entity\Multibilera No errors.
App\Entity\Matrikula No errors.
App\Entity\Jarraipena No errors.
App\Entity\Etxekolana No errors.
App\Entity\Landutakoa No errors.
App\Entity\Nota No errors.
App\Entity\PasoModulo No errors.
App\Entity\IkasketaPlana No errors.
App\Entity\NotaMota No errors.
App\Entity\PlanarenIkasgaia No errors.
App\Entity\Ordutegia No errors.
App\Entity\Familia No errors.
App\Entity\AbestiaPartaidea No errors.
App\Entity\Ordainketa No errors.
App\Entity\Dirulaguntza No errors.
App\Entity\Langilea No errors.
App\Entity\Soldata No errors.
App\Entity\LanaldiRegistroa No errors.
App\Entity\NotificationNori
  • The association App\Entity\NotificationNori#pertsonala refers to the inverse side field App\Entity\Pertsonala#oharranoris which does not exist.