Query Metrics
92
Database Queries
61
Different statements
200.55 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.24 ms |
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:
[
"47"
]
|
2 | 1.85 ms |
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 <> 47 ORDER BY p0_.fecha_acuartelamiento DESC LIMIT 1
Parameters:
[] |
3 | 3.47 ms |
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:
[
47
]
|
4 | 5.03 ms |
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:
[ 47 8 ] |
5 | 5.09 ms |
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:
[ 47 10 ] |
6 | 2.67 ms |
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:
[ 47 8 ] |
7 | 2.16 ms |
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:
[ 47 85 ] |
8 | 1.81 ms |
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:
[ 47 14 ] |
9 | 2.48 ms |
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:
[ 47 34 ] |
10 | 1.96 ms |
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:
[ 47 13 ] |
11 | 3.12 ms |
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:
[ 47 31 ] |
12 | 2.49 ms |
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:
[ 47 33 ] |
13 | 2.34 ms |
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:
[ 47 11 ] |
14 | 2.45 ms |
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:
[ 47 26 ] |
15 | 1.89 ms |
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:
[ 47 36 ] |
16 | 2.15 ms |
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:
[ 47 38 ] |
17 | 2.01 ms |
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:
[ 47 86 ] |
18 | 2.06 ms |
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:
[ 47 11 ] |
19 | 2.13 ms |
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:
[ 47 28 ] |
20 | 1.90 ms |
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:
[ 47 29 ] |
21 | 2.36 ms |
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:
[ 47 39 ] |
22 | 1.70 ms |
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:
[ 47 37 ] |
23 | 1.80 ms |
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:
[ 47 10 ] |
24 | 1.73 ms |
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:
[ 47 18 ] |
25 | 2.57 ms |
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:
[ 47 49 ] |
26 | 2.33 ms |
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:
[ 47 17 ] |
27 | 2.48 ms |
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:
[ 47 93 ] |
28 | 1.53 ms |
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:
[ 47 46 ] |
29 | 1.84 ms |
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:
[ 47 9 ] |
30 | 2.29 ms |
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:
[ 47 22 ] |
31 | 1.76 ms |
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:
[ 47 92 ] |
32 | 2.22 ms |
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:
[ 47 48 ] |
33 | 2.01 ms |
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:
[ 47 90 ] |
34 | 1.82 ms |
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:
[ 47 23 ] |
35 | 1.34 ms |
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:
[ 47 21 ] |
36 | 0.64 ms |
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:
[] |
37 | 0.67 ms |
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:
[] |
38 | 2.07 ms |
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:
[] |
39 | 25.16 ms |
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 <> 47
Parameters:
[] |
40 | 1.20 ms |
SELECT CURRENT_DATABASE()
Parameters:
[] |
41 | 7.42 ms |
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"
]
|
42 | 1.46 ms |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
43 | 0.49 ms |
SHOW search_path
Parameters:
[] |
44 | 0.46 ms |
SELECT CURRENT_DATABASE()
Parameters:
[] |
45 | 1.09 ms |
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 = 47
Parameters:
[] |
46 | 11.62 ms |
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 = 20
Parameters:
[] |
47 | 7.28 ms |
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 = 38
Parameters:
[] |
48 | 23.32 ms |
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 = 88
Parameters:
[] |
49 | 1.31 ms |
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 = 89
Parameters:
[] |
50 | 1.09 ms |
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 = 90
Parameters:
[] |
51 | 1.02 ms |
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 = 91
Parameters:
[] |
52 | 0.87 ms |
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 = 92
Parameters:
[] |
53 | 0.84 ms |
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 = 93
Parameters:
[] |
54 | 0.74 ms |
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 = 94
Parameters:
[] |
55 | 1.42 ms |
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 = 95
Parameters:
[] |
56 | 0.81 ms |
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 = 39
Parameters:
[] |
57 | 0.77 ms |
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 = 96
Parameters:
[] |
58 | 0.79 ms |
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 = 40
Parameters:
[] |
59 | 0.87 ms |
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 = 97
Parameters:
[] |
60 | 0.82 ms |
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 = 21
Parameters:
[] |
61 | 0.83 ms |
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 = 41
Parameters:
[] |
62 | 0.79 ms |
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 = 98
Parameters:
[] |
63 | 0.82 ms |
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 = 99
Parameters:
[] |
64 | 0.89 ms |
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 = 42
Parameters:
[] |
65 | 0.76 ms |
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 = 100
Parameters:
[] |
66 | 0.82 ms |
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 = 101
Parameters:
[] |
67 | 0.73 ms |
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 = 102
Parameters:
[] |
68 | 0.80 ms |
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 = 43
Parameters:
[] |
69 | 0.80 ms |
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 = 103
Parameters:
[] |
70 | 0.73 ms |
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 = 104
Parameters:
[] |
71 | 0.71 ms |
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 = 105
Parameters:
[] |
72 | 0.79 ms |
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 = 106
Parameters:
[] |
73 | 0.75 ms |
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 = 22
Parameters:
[] |
74 | 0.77 ms |
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 = 44
Parameters:
[] |
75 | 0.75 ms |
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 = 107
Parameters:
[] |
76 | 0.80 ms |
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 = 45
Parameters:
[] |
77 | 0.72 ms |
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 = 108
Parameters:
[] |
78 | 0.74 ms |
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 = 46
Parameters:
[] |
79 | 0.79 ms |
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 = 109
Parameters:
[] |
80 | 0.74 ms |
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 = 110
Parameters:
[] |
81 | 0.70 ms |
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 = 111
Parameters:
[] |
82 | 0.77 ms |
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 = 23
Parameters:
[] |
83 | 0.87 ms |
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 = 47
Parameters:
[] |
84 | 0.68 ms |
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 = 112
Parameters:
[] |
85 | 0.77 ms |
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 = 113
Parameters:
[] |
86 | 0.79 ms |
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 = 114
Parameters:
[] |
87 | 0.70 ms |
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 = 24
Parameters:
[] |
88 | 0.73 ms |
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 = 48
Parameters:
[] |
89 | 0.74 ms |
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 = 115
Parameters:
[] |
90 | 0.65 ms |
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 = 25
Parameters:
[] |
91 | 0.70 ms |
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 = 49
Parameters:
[] |
92 | 0.66 ms |
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 = 116
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. |