Query Metrics
8
Database Queries
7
Different statements
18.63 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.87 ms (42.25%) |
1 |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_catalog = ? AND table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type = 'BASE TABLE'
Parameters:
[
"integral_produccion"
]
|
3.29 ms (17.66%) |
1 |
SELECT t0.id AS id_1, t0.anno AS anno_2, t0.llamada AS llamada_3, t0.fecha_inicio_registro AS fecha_inicio_registro_4, t0.fecha_fin_registro AS fecha_fin_registro_5, t0.fecha_acuartelamiento AS fecha_acuartelamiento_6, t0.fecha_fin_dias AS fecha_fin_dias_7, t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8, t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9, t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10, t0.minutos_test AS minutos_test_11, t0.bajas_permitidas AS bajas_permitidas_12, t0.activo AS activo_13, t0.cant_cursos AS cant_cursos_14, t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15, t0.titulo_reporte_jockey AS titulo_reporte_jockey_16, t0.titulo_reporte_calzado AS titulo_reporte_calzado_17, t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18, t0.titulo_reporte_estudios AS titulo_reporte_estudios_19, t0.foto_uniforme AS foto_uniforme_20, t0.foto_jockey AS foto_jockey_21, t0.foto_calzado AS foto_calzado_22, t0.foto_camiseta AS foto_camiseta_23 FROM proceso_reclutamiento t0 WHERE t0.activo = ? LIMIT 1
Parameters:
[
1
]
|
3.25 ms (17.44%) |
1 |
SELECT p0_.id AS id_0, p0_.anno AS anno_1, p0_.llamada AS llamada_2, p0_.fecha_inicio_registro AS fecha_inicio_registro_3, p0_.fecha_fin_registro AS fecha_fin_registro_4, p0_.fecha_acuartelamiento AS fecha_acuartelamiento_5, p0_.fecha_fin_dias AS fecha_fin_dias_6, p0_.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_7, p0_.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_8, p0_.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_9, p0_.minutos_test AS minutos_test_10, p0_.bajas_permitidas AS bajas_permitidas_11, p0_.activo AS activo_12, p0_.cant_cursos AS cant_cursos_13, p0_.titulo_reporte_uniforme AS titulo_reporte_uniforme_14, p0_.titulo_reporte_jockey AS titulo_reporte_jockey_15, p0_.titulo_reporte_calzado AS titulo_reporte_calzado_16, p0_.titulo_reporte_camiseta AS titulo_reporte_camiseta_17, p0_.titulo_reporte_estudios AS titulo_reporte_estudios_18, p0_.foto_uniforme AS foto_uniforme_19, p0_.foto_jockey AS foto_jockey_20, p0_.foto_calzado AS foto_calzado_21, p0_.foto_camiseta AS foto_camiseta_22 FROM proceso_reclutamiento p0_ ORDER BY p0_.anno ASC, p0_.llamada ASC, p0_.fecha_inicio_registro ASC, p0_.fecha_inicio_registro ASC, p0_.fecha_fin_registro ASC, p0_.fecha_fin_registro ASC, p0_.fecha_acuartelamiento ASC, p0_.fecha_acuartelamiento ASC, p0_.fecha_fin_dias ASC, p0_.fecha_fin_dias ASC, p0_.fecha_fin_dias_posteriores ASC, p0_.fecha_fin_dias_posteriores ASC, p0_.minutos_test ASC, p0_.bajas_permitidas ASC, p0_.activo ASC, p0_.cant_cursos ASC, p0_.titulo_reporte_uniforme ASC, p0_.titulo_reporte_jockey ASC, p0_.titulo_reporte_calzado ASC, p0_.titulo_reporte_camiseta ASC, p0_.titulo_reporte_estudios ASC
Parameters:
[] |
1.31 ms (7.03%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1 FROM cursos c0_
Parameters:
[] |
1.24 ms (6.67%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
1.10 ms (5.93%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
0.56 ms (3.02%) |
1 |
SHOW search_path
Parameters:
[] |
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\ProcesoReclutamiento | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\Curso | No errors. |
App\Entity\ReclutaProceso | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\UnidadMilitar | No errors. |
App\Entity\Recluta | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\SeguridadUsuario | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |