GET https://www.pasaiamusikal.eus/eu_ES/administrazioa/pertsonalak/pertsonala_index?direction=asc&page=61

Query Metrics

205 Database Queries
7 Different statements
95.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
50.34 ms
(52.66%)
100
SELECT t0.ID_ikasketa AS ID_ikasketa_1, t0.maila AS maila_2, t0.kurtsoa AS kurtsoa_3, t0.taldea AS taldea_4, t0.fechaMatriculacion AS fechaMatriculacion_5, t0.oharrak AS oharrak_6, t0.precioexcepcion AS precioexcepcion_7, t0.precioIkasgaia AS precioIkasgaia_8, t0.porcentaje1 AS porcentaje1_9, t0.porcentaje2 AS porcentaje2_10, t0.porcentaje3 AS porcentaje3_11, t0.porcentaje4 AS porcentaje4_12, t0.porcentaje5 AS porcentaje5_13, t0.porcentaje6 AS porcentaje6_14, t0.porcentaje7 AS porcentaje7_15, t0.porcentaje8 AS porcentaje8_16, t0.porcentaje9 AS porcentaje9_17, t0.porcentaje10 AS porcentaje10_18, t0.incobrable AS incobrable_19, t0.asignatura1 AS asignatura1_20, t0.numclases AS numclases_21, t0.notaInprimatu AS notaInprimatu_22, t0.bajadata AS bajadata_23, t0.egoera AS egoera_24, t0.aprovechamiento AS aprovechamiento_25, t0.fuerzafaltas AS fuerzafaltas_26, t0.matrikulaznb AS matrikulaznb_27, t0.eskaeraznb AS eskaeraznb_28, t0.zenbatzenso AS zenbatzenso_29, t0.zenbatajustezenso AS zenbatajustezenso_30, t0.ID_ikaslea AS ID_ikaslea_31, t0.ID_datosCurso AS ID_datosCurso_32, t0.ID_ikasgaia AS ID_ikasgaia_33, t0.ID_irakaslea AS ID_irakaslea_34, t0.ID_eskeintza AS ID_eskeintza_35, t0.ordutegiIzena AS ordutegiIzena_36, t0.ID_zenso AS ID_zenso_37, t0.ID_zensoajuste AS ID_zensoajuste_38, t0.ID_lekua AS ID_lekua_39, t0.ID_Multibilera AS ID_Multibilera_40 FROM akademikoa t0 WHERE t0.ID_ikaslea = ?
Parameters:
[
  180
]
34.38 ms
(35.97%)
100
SELECT t0.ID_dirulaguntza AS ID_dirulaguntza_1, t0.eskatzailea AS eskatzailea_2, t0.aprobechamiento AS aprobechamiento_3, t0.naneskatzailea AS naneskatzailea_4, t0.KKbakarrikItzulketa AS KKbakarrikItzulketa_5, t0.haciendaBaimena AS haciendaBaimena_6, t0.seguridadsocialbaimena AS seguridadsocialbaimena_7, t0.data AS data_8, t0.udalzorra AS udalzorra_9, t0.denaOrdainduta AS denaOrdainduta_10, t0.haciendaZorra AS haciendaZorra_11, t0.SSZorra AS SSZorra_12, t0.eskaeraeginda AS eskaeraeginda_13, t0.ID_ikaslea AS ID_ikaslea_14 FROM dirulaguntzak t0 WHERE t0.ID_ikaslea = ?
Parameters:
[
  180
]
2.70 ms
(2.83%)
1
SELECT count(DISTINCT p0_.ID_ikaslea) AS sclr_0 FROM pertsonala p0_
Parameters:
[]
2.31 ms
(2.41%)
1
SELECT COUNT(p0_.ID_ikaslea) AS sclr_0 FROM pertsonala p0_
Parameters:
[]
2.23 ms
(2.33%)
1
SELECT p0_.ID_ikaslea AS ID_ikaslea_0, p0_.izenabizenak AS izenabizenak_1, p0_.izena AS izena_2, p0_.abizena1 AS abizena1_3, p0_.abizena2 AS abizena2_4, p0_.jaiotzedata AS jaiotzedata_5, p0_.sexua AS sexua_6, p0_.telefono AS telefono_7, p0_.movil AS movil_8, p0_.emaila AS emaila_9, p0_.emailcorporativo AS emailcorporativo_10, p0_.helbidea AS helbidea_11, p0_.herria AS herria_12, p0_.nacionalidad AS nacionalidad_13, p0_.postakodea AS postakodea_14, p0_.ikastola AS ikastola_15, p0_.nazionalitatea AS nazionalitatea_16, p0_.nan AS nan_17, p0_.hizkuntzaeredua AS hizkuntzaeredua_18, p0_.baimenalopd AS baimenalopd_19, p0_.egoera AS egoera_20, p0_.berriazaharra AS berriazaharra_21, p0_.oharrak AS oharrak_22, p0_.kontukorrontea AS kontukorrontea_23, p0_.titularcuenta AS titularcuenta_24, p0_.titularrarennan AS titularrarennan_25, p0_.berria AS berria_26, p0_.matrikulatzekolehentasuna AS matrikulatzekolehentasuna_27, p0_.errolduta AS errolduta_28, p0_.exentolm AS exentolm_29, p0_.oharrakexentolm AS oharrakexentolm_30, p0_.alumni AS alumni_31, p0_.guraso1izena AS guraso1izena_32, p0_.guraso1abizena1 AS guraso1abizena1_33, p0_.guraso1abizena2 AS guraso1abizena2_34, p0_.guraso1nan AS guraso1nan_35, p0_.guraso1mobila AS guraso1mobila_36, p0_.guraso1whatsapp AS guraso1whatsapp_37, p0_.guraso1emaila AS guraso1emaila_38, p0_.guraso2izena AS guraso2izena_39, p0_.guraso2abizena1 AS guraso2abizena1_40, p0_.guraso2abizena2 AS guraso2abizena2_41, p0_.guraso2nan AS guraso2nan_42, p0_.guraso2mobila AS guraso2mobila_43, p0_.guraso2whatsapp AS guraso2whatsapp_44, p0_.guraso2emaila AS guraso2emaila_45, p0_.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_46, p0_.verify AS verify_47, p0_.norkEmanNotak AS norkEmanNotak_48 FROM pertsonala p0_ WHERE p0_.ID_ikaslea IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  7098
  5322
  5328
  5340
  5597
  5880
  5889
  5893
  5894
  6234
  6302
  6463
  6471
  6826
  6831
  6862
  7076
  7077
  7078
  7079
  7080
  7084
  180
  432
  807
  1018
  1021
  1251
  1270
  1554
  2688
  3111
  3219
  3321
  4156
  4315
  4391
  4514
  4696
  4999
  5192
  5387
  5395
  5401
  5413
  5420
  5452
  5693
  5724
  5740
  5953
  6016
  6021
  6033
  6165
  6181
  6195
  6203
  6222
  6223
  6346
  6435
  6442
  6476
  6478
  6479
  6480
  6482
  6484
  6503
  6527
  6570
  6637
  6638
  6639
  6640
  6641
  6642
  6643
  6644
  6645
  6646
  6647
  6648
  6649
  6651
  6652
  6653
  6654
  6655
  6665
  6688
  6690
  6759
  6780
  6815
  6841
  6842
  6843
  6846
]
2.00 ms
(2.09%)
1
SELECT DISTINCT p0_.ID_ikaslea AS ID_ikaslea_0 FROM pertsonala p0_ LIMIT 100 OFFSET 6000
Parameters:
[]
1.64 ms
(1.71%)
1
SELECT t0.ID_setup AS ID_setup_1, t0.defEmail AS defEmail_2, t0.akademikoak_fiels AS akademikoak_fiels_3, t0.pertsonalak_fields AS pertsonalak_fields_4, t0.matrikulaznb AS matrikulaznb_5, t0.zenbatebaluaketa AS zenbatebaluaketa_6, t0.multisede AS multisede_7, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_8, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_9 FROM appsetup t0 WHERE t0.ID_setup = ?
Parameters:
[
  "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.

Entities Mapping