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

Response
200 OK
IP
216.73.216.44
Profiled on
Token
d6fbad

Query Metrics

307 Database Queries
11 Different statements
166.99 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
64.45 ms
(38.59%) 		99 
SELECT t0.ID_historikoa AS ID_historikoa_1, t0.ID_eskeintza AS ID_eskeintza_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.oharrak AS oharrak_6, t0.oharraknotetan1 AS oharraknotetan1_7, t0.oharraknotetan2 AS oharraknotetan2_8, t0.oharraknotetan3 AS oharraknotetan3_9, t0.asistentziaFaltak1 AS asistentziaFaltak1_10, t0.asistentziaFaltak2 AS asistentziaFaltak2_11, t0.asistentziaFaltak3 AS asistentziaFaltak3_12, t0.notaFinalCurso AS notaFinalCurso_13, t0.notaInprimatu AS notaInprimatu_14, t0.notaPasoModulo1 AS notaPasoModulo1_15, t0.notaPasoModulo2 AS notaPasoModulo2_16, t0.notaPasoModulo3 AS notaPasoModulo3_17, t0.fechaPasoModulo1texto AS fechaPasoModulo1texto_18, t0.fechaPasoModulo2texto AS fechaPasoModulo2texto_19, t0.fechaPasoModulo3texto AS fechaPasoModulo3texto_20, t0.tribunalPasoModulo1 AS tribunalPasoModulo1_21, t0.tribunalPasoModulo2 AS tribunalPasoModulo2_22, t0.tribunalPasoModulo3 AS tribunalPasoModulo3_23, t0.mailaPasoModulo1 AS mailaPasoModulo1_24, t0.mailaPasoModulo2 AS mailaPasoModulo2_25, t0.mailaPasoModulo3 AS mailaPasoModulo3_26, t0.kurtsoaPasoModulo1 AS kurtsoaPasoModulo1_27, t0.kurtsoaPasoModulo2 AS kurtsoaPasoModulo2_28, t0.kurtsoaPasoModulo3 AS kurtsoaPasoModulo3_29, t0.fechaPasoModulo1 AS fechaPasoModulo1_30, t0.fechaPasoModulo2 AS fechaPasoModulo2_31, t0.fechaPasoModulo3 AS fechaPasoModulo3_32, t0.fechaMatriculacion AS fechaMatriculacion_33, t0.bajadata AS bajadata_34, t0.itxarotezerrendaordena AS itxarotezerrendaordena_35, t0.ID_ikaslea AS ID_ikaslea_36, t0.ID_ikasgaia AS ID_ikasgaia_37, t0.ID_irakaslea AS ID_irakaslea_38, t0.ID_lekua AS ID_lekua_39, t0.ID_datosCurso AS ID_datosCurso_40 FROM historikoa t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  107
]
View formatted query    View runnable query    Explain query    View query backtrace
49.66 ms
(29.74%) 		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: 
[
  107
]
View formatted query    View runnable query    Explain query    View query backtrace
40.39 ms
(24.19%) 		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: 
[
  107
]
View formatted query    View runnable query    Explain query    View query backtrace
2.99 ms
(1.79%) 		1 
SELECT count(DISTINCT p0_.ID_ikaslea) AS sclr_0 FROM pertsonala p0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.72 ms
(1.63%) 		1 
SELECT COUNT(p0_.ID_ikaslea) AS sclr_0 FROM pertsonala p0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.60 ms
(1.56%) 		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: 
[
  107
  108
  109
  110
  111
  112
  113
  114
  115
  116
  117
  119
  120
  121
  122
  123
  124
  125
  126
  127
  128
  130
  131
  132
  133
  134
  135
  136
  137
  138
  139
  140
  141
  142
  143
  144
  145
  146
  147
  148
  149
  151
  152
  153
  154
  155
  156
  158
  160
  161
  162
  163
  164
  165
  166
  167
  169
  170
  171
  173
  174
  175
  176
  177
  178
  179
  181
  182
  183
  184
  185
  186
  187
  189
  190
  192
  193
  194
  195
  196
  197
  198
  199
  200
  201
  202
  203
  204
  205
  206
  209
  210
  211
  212
  213
  214
  215
  216
  217
  218
]
View formatted query    View runnable query    Explain query    View query backtrace
2.29 ms
(1.37%) 		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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(0.33%) 		1 
SELECT t0.ID_ordainketa AS ID_ordainketa_1, t0.ordainketaznb AS ordainketaznb_2, t0.totalTasas AS totalTasas_3, t0.pagoforzado AS pagoforzado_4, t0.pagoteorico AS pagoteorico_5, t0.fecharemesa AS fecharemesa_6, t0.pagorealizado AS pagorealizado_7, t0.fecharealizado AS fecharealizado_8, t0.pagoNoRemesable AS pagoNoRemesable_9, t0.pendiente AS pendiente_10, t0.ID_ikaslea AS ID_ikaslea_11, t0.ID_datosCurso AS ID_datosCurso_12 FROM ordainketa t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  195
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.32%) 		1 
SELECT t0.ID_historikopago AS ID_historikopago_1, t0.totaltasas AS totaltasas_2, t0.fecharemesa AS fecharemesa_3, t0.pagoteorico AS pagoteorico_4, t0.pagorealizado AS pagorealizado_5, t0.pagoforzado AS pagoforzado_6, t0.fecharealizado AS fecharealizado_7, t0.pagoNoRemesable AS pagoNoRemesable_8, t0.pendiente AS pendiente_9, t0.ID_ikaslea AS ID_ikaslea_10, t0.ID_datosCurso AS ID_datosCurso_11 FROM historikopago t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  195
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.27%) 		1 
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.asignatura1 AS asignatura1_8, t0.matrikulaznb AS matrikulaznb_9, t0.onartua AS onartua_10, t0.ID_ikaslea AS ID_ikaslea_11, t0.ID_ikasgaia AS ID_ikasgaia_12, t0.ID_eskeintza AS ID_eskeintza_13, t0.ID_lekua AS ID_lekua_14, t0.ID_datosCurso AS ID_datosCurso_15 FROM matrikulazioa t0 WHERE t0.ID_ikaslea = ?
Parameters: 
[
  195
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.23%) 		1 
SELECT DISTINCT p0_.ID_ikaslea AS ID_ikaslea_0 FROM pertsonala p0_ LIMIT 100 OFFSET 100
Parameters: 
[]
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.

Entities Mapping

Class Mapping errors
App\Entity\AppSetup No errors.
App\Entity\DatosCurso No errors.
App\Entity\Pertsonala No errors.
App\Entity\Irakaslea No errors.
App\Entity\Ordainketa No errors.
App\Entity\Akademikoa No errors.
App\Entity\Matrikulazioa No errors.
App\Entity\Historikoa No errors.
App\Entity\HistorikoPago No errors.
App\Entity\Dirulaguntzak No errors.
App\Entity\Hitzordua No errors.
App\Entity\Ikasgaia No errors.
App\Entity\Eskeintza No errors.
App\Entity\OrdutegiIzena No errors.
App\Entity\Zenso No errors.
App\Entity\Lekua No errors.
App\Entity\Multibilera No errors.
App\Entity\Nota No errors.
App\Entity\Asistentzia No errors.