Query Metrics
93
Database Queries
61
Different statements
116.86 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
49.26 ms (42.15%) |
29 |
SELECT p0_.id AS id_0, p0_.nombre_unidad AS nombre_unidad_1, p0_.prioridad AS prioridad_2, p0_.cupo_masculino AS cupo_masculino_3, p0_.cupo_femenino AS cupo_femenino_4, p0_.registrado_masculino AS registrado_masculino_5, p0_.registrado_femenino AS registrado_femenino_6, p0_.fuerza AS fuerza_7, p0_.organico_masculino AS organico_masculino_8, p0_.organico_femenino AS organico_femenino_9, u1_.id AS id_10, u1_.siglas_unidad AS siglas_unidad_11, u1_.nombre AS nombre_12, u1_.fuerza AS fuerza_13, u1_.cupo_masculino AS cupo_masculino_14, u1_.adicional_masculino AS adicional_masculino_15, u1_.cupo_femenino AS cupo_femenino_16, u1_.adicional_femenino AS adicional_femenino_17, u1_.direccion AS direccion_18, u1_.geometria AS geometria_19, u1_.activo AS activo_20, c2_.id AS id_21, c2_.nombre AS nombre_22, c2_.direccion AS direccion_23, c2_.geometria AS geometria_24, c2_.direccion_acuartelamiento AS direccion_acuartelamiento_25, c2_.activo AS activo_26, p0_.unidad AS unidad_27, p0_.lugar AS lugar_28, p0_.proceso AS proceso_29, u1_.centro_instruccion AS centro_instruccion_30, u1_.localizacion AS localizacion_31, c2_.localizacion AS localizacion_32, c2_.jefe AS jefe_33 FROM proceso_reclutamiento_unidad_lugar p0_ INNER JOIN proceso_reclutamiento p3_ ON p0_.proceso = p3_.id INNER JOIN unidad_militar u1_ ON p0_.unidad = u1_.id INNER JOIN centro_movilizacion c2_ ON p0_.lugar = c2_.id WHERE p3_.id = ? AND c2_.id = ? ORDER BY p0_.nombre_unidad ASC
Parameters:
[ 44 120 ] |
8.87 ms (7.59%) |
4 |
SELECT p0_.id AS id_0, p0_.nombre_lugar AS nombre_lugar_1, p0_.jefe_cedula AS jefe_cedula_2, p0_.jefe_nombres AS jefe_nombres_3, p0_.jefe_apellidos AS jefe_apellidos_4, p0_.jefe_cargo AS jefe_cargo_5, p0_.jefe_grado AS jefe_grado_6, p0_.turno AS turno_7, p0_.cupo_masculino AS cupo_masculino_8, p0_.cupo_femenino AS cupo_femenino_9, p0_.registrado_masculino AS registrado_masculino_10, p0_.registrado_femenino AS registrado_femenino_11, p0_.organico_masculino AS organico_masculino_12, p0_.organico_femenino AS organico_femenino_13, b1_.id AS id_14, b1_.nombre AS nombre_15, b1_.direccion AS direccion_16, b1_.geometria AS geometria_17, b1_.activo AS activo_18, c2_.id AS id_19, c2_.nombre AS nombre_20, c2_.direccion AS direccion_21, c2_.geometria AS geometria_22, c2_.direccion_acuartelamiento AS direccion_acuartelamiento_23, c2_.activo AS activo_24, p0_.proceso AS proceso_25, p0_.lugar AS lugar_26, p0_.base AS base_27, p0_.psicologo AS psicologo_28, p0_.medico AS medico_29, p0_.odontologo AS odontologo_30, p0_.laboratorista AS laboratorista_31, b1_.localizacion AS localizacion_32, b1_.jefe AS jefe_33, c2_.localizacion AS localizacion_34, c2_.jefe AS jefe_35 FROM proceso_reclutamiento_lugar_base p0_ INNER JOIN proceso_reclutamiento p3_ ON p0_.proceso = p3_.id INNER JOIN base_movilizacion b1_ ON p0_.base = b1_.id INNER JOIN centro_movilizacion c2_ ON p0_.lugar = c2_.id WHERE p3_.id = ? AND b1_.id = ?
Parameters:
[ 44 8 ] |
5.55 ms (4.75%) |
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.50 ms (3.00%) |
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.id = ?
Parameters:
[
"44"
]
|
3.46 ms (2.97%) |
1 |
SELECT p0_.id AS id_0, p0_.jefe_cedula AS jefe_cedula_1, p0_.jefe_nombres AS jefe_nombres_2, p0_.jefe_apellidos AS jefe_apellidos_3, p0_.jefe_cargo AS jefe_cargo_4, p0_.jefe_grado AS jefe_grado_5, p0_.nombre_base AS nombre_base_6, b1_.id AS id_7, b1_.nombre AS nombre_8, b1_.direccion AS direccion_9, b1_.geometria AS geometria_10, b1_.activo AS activo_11, p0_.proceso AS proceso_12, p0_.base AS base_13, b1_.localizacion AS localizacion_14, b1_.jefe AS jefe_15 FROM proceso_reclutamiento_bases p0_ INNER JOIN proceso_reclutamiento p2_ ON p0_.proceso = p2_.id INNER JOIN base_movilizacion b1_ ON p0_.base = b1_.id WHERE p2_.id = ? ORDER BY p0_.nombre_base ASC
Parameters:
[
44
]
|
2.19 ms (1.87%) |
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_ WHERE p0_.id <> 44 ORDER BY p0_.fecha_acuartelamiento DESC LIMIT 1
Parameters:
[] |
1.68 ms (1.44%) |
1 |
SELECT u0_.id AS id_0, u0_.siglas_unidad AS siglas_unidad_1, u0_.nombre AS nombre_2, u0_.fuerza AS fuerza_3, u0_.cupo_masculino AS cupo_masculino_4, u0_.adicional_masculino AS adicional_masculino_5, u0_.cupo_femenino AS cupo_femenino_6, u0_.adicional_femenino AS adicional_femenino_7, u0_.direccion AS direccion_8, u0_.geometria AS geometria_9, u0_.activo AS activo_10, u0_.centro_instruccion AS centro_instruccion_11, u0_.localizacion AS localizacion_12 FROM unidad_militar u0_ WHERE u0_.activo = true ORDER BY u0_.nombre ASC
Parameters:
[] |
1.44 ms (1.23%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 30
Parameters:
[] |
1.32 ms (1.13%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 14
Parameters:
[] |
1.26 ms (1.08%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
1.20 ms (1.03%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
1.11 ms (0.95%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.sistema AS sistema_2 FROM test_ejes t0_ INNER JOIN test_sistemas t1_ ON t0_.sistema = t1_.id WHERE t1_.id = 8
Parameters:
[] |
1.09 ms (0.93%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.proceso AS proceso_2 FROM test_sistemas t0_ INNER JOIN proceso_reclutamiento p1_ ON t0_.proceso = p1_.id WHERE p1_.id = 44
Parameters:
[] |
1.03 ms (0.88%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.anno AS anno_1, p0_.llamada AS llamada_2 FROM test_sistemas t1_ INNER JOIN proceso_reclutamiento p0_ ON t1_.proceso = p0_.id WHERE p0_.id <> 44
Parameters:
[] |
0.87 ms (0.75%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 31
Parameters:
[] |
0.84 ms (0.72%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 17
Parameters:
[] |
0.83 ms (0.71%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 22
Parameters:
[] |
0.81 ms (0.70%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 49
Parameters:
[] |
0.80 ms (0.69%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 55
Parameters:
[] |
0.80 ms (0.68%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 23
Parameters:
[] |
0.80 ms (0.68%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 51
Parameters:
[] |
0.79 ms (0.68%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 58
Parameters:
[] |
0.78 ms (0.66%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 48
Parameters:
[] |
0.77 ms (0.66%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.sistema AS sistema_2 FROM test_ejes t0_ INNER JOIN test_sistemas t1_ ON t0_.sistema = t1_.id WHERE t1_.id = 10
Parameters:
[] |
0.77 ms (0.66%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 56
Parameters:
[] |
0.76 ms (0.65%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 16
Parameters:
[] |
0.76 ms (0.65%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 19
Parameters:
[] |
0.75 ms (0.65%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 20
Parameters:
[] |
0.75 ms (0.64%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 50
Parameters:
[] |
0.74 ms (0.64%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 25
Parameters:
[] |
0.74 ms (0.64%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 36
Parameters:
[] |
0.74 ms (0.63%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 46
Parameters:
[] |
0.74 ms (0.63%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.sistema AS sistema_2 FROM test_ejes t0_ INNER JOIN test_sistemas t1_ ON t0_.sistema = t1_.id WHERE t1_.id = 11
Parameters:
[] |
0.74 ms (0.63%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 21
Parameters:
[] |
0.74 ms (0.63%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 33
Parameters:
[] |
0.74 ms (0.63%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 43
Parameters:
[] |
0.74 ms (0.63%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 47
Parameters:
[] |
0.73 ms (0.63%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 44
Parameters:
[] |
0.73 ms (0.62%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 45
Parameters:
[] |
0.73 ms (0.62%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 52
Parameters:
[] |
0.72 ms (0.62%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 18
Parameters:
[] |
0.71 ms (0.61%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 15
Parameters:
[] |
0.71 ms (0.61%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.riesgo_bajo_desde AS riesgo_bajo_desde_2, t0_.riesgo_bajo_hasta AS riesgo_bajo_hasta_3, t0_.riesgo_medio_desde AS riesgo_medio_desde_4, t0_.riesgo_medio_hasta AS riesgo_medio_hasta_5, t0_.riesgo_alto_desde AS riesgo_alto_desde_6, t0_.riesgo_alto_hasta AS riesgo_alto_hasta_7, t0_.eje AS eje_8 FROM test_criterios t0_ INNER JOIN test_ejes t1_ ON t0_.eje = t1_.id WHERE t1_.id = 24
Parameters:
[] |
0.71 ms (0.60%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 57
Parameters:
[] |
0.70 ms (0.60%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 54
Parameters:
[] |
0.69 ms (0.59%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 38
Parameters:
[] |
0.69 ms (0.59%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 32
Parameters:
[] |
0.69 ms (0.59%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 40
Parameters:
[] |
0.68 ms (0.58%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 53
Parameters:
[] |
0.68 ms (0.58%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 34
Parameters:
[] |
0.67 ms (0.57%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 35
Parameters:
[] |
0.67 ms (0.57%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.geometria AS geometria_3, c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4, c0_.activo AS activo_5, c0_.localizacion AS localizacion_6, c0_.jefe AS jefe_7 FROM centro_movilizacion c0_ WHERE c0_.activo = true ORDER BY c0_.nombre ASC
Parameters:
[] |
0.66 ms (0.56%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 41
Parameters:
[] |
0.66 ms (0.56%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 42
Parameters:
[] |
0.65 ms (0.56%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 37
Parameters:
[] |
0.65 ms (0.56%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.sistema AS sistema_2 FROM test_ejes t0_ INNER JOIN test_sistemas t1_ ON t0_.sistema = t1_.id WHERE t1_.id = 9
Parameters:
[] |
0.65 ms (0.55%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.sistema AS sistema_2 FROM test_ejes t0_ INNER JOIN test_sistemas t1_ ON t0_.sistema = t1_.id WHERE t1_.id = 13
Parameters:
[] |
0.63 ms (0.54%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ INNER JOIN test_criterios t1_ ON t0_.criterio = t1_.id WHERE t1_.id = 39
Parameters:
[] |
0.63 ms (0.53%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.sistema AS sistema_2 FROM test_ejes t0_ INNER JOIN test_sistemas t1_ ON t0_.sistema = t1_.id WHERE t1_.id = 12
Parameters:
[] |
0.60 ms (0.52%) |
1 |
SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.direccion AS direccion_2, b0_.geometria AS geometria_3, b0_.activo AS activo_4, b0_.localizacion AS localizacion_5, b0_.jefe AS jefe_6 FROM base_movilizacion b0_ WHERE b0_.activo = true ORDER BY b0_.nombre ASC
Parameters:
[] |
0.43 ms (0.36%) |
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\ProcesoReclutamientoBase | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\SeguridadUsuario | No errors. |
App\Entity\ProcesoReclutamientoCentro | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\ProcesoReclutamientoUnidad | No errors. |
App\Entity\UnidadMilitar | No errors. |
App\Entity\TestSistema | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\SeguridadRol | No errors. |
App\Entity\Notificacion | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\NmclLocalizacion | No errors. |
App\Entity\TestEje | No errors. |
App\Entity\TestCriterio | No errors. |
App\Entity\TestPregunta | No errors. |