https://integral.dirmov.mil.ec/es/admin/procesoreclutamiento/crud/plain/47/show?p=es%2Fadmin%2Fprocesoreclutamiento%2Fcrud%2Fplain%2F47%2Fshow

Forwarded to
ProcesoReclutamientoController :: showAction (76e949)
Method
GET
HTTP Status
200
IP
10.101.48.174
Profiled on
Token
342e8a

Query Metrics

95 Database Queries
64 Different statements
130.31 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.37 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"
]
View formatted query    View runnable query    Explain query
2 2.71 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_vigencia_password AS fecha_vigencia_password_10, t0.causa_bloqueo AS causa_bloqueo_11, t0.password AS password_12, t0.eliminado AS eliminado_13, t0.fecha_eliminacion AS fecha_eliminacion_14, t0.intentos_fallidos AS intentos_fallidos_15, t0.primer_ingreso AS primer_ingreso_16, t0.activo AS activo_17, t0.conectado AS conectado_18, t0.fecha_acceso AS fecha_acceso_19, t0.cargo AS cargo_20, t0.grado AS grado_21, t0.foto AS foto_22, t0.base AS base_23, t0.centro AS centro_24, t0.unidad AS unidad_25, t0.centro_instruccion AS centro_instruccion_26 FROM seg_usuario t0 WHERE t0.id = ?
Parameters: 
[
  122
]
View formatted query    View runnable query    Explain query
3 2.44 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.sistema AS sistema_3, t0.descripcion AS descripcion_4, t0.asignable AS asignable_5 FROM seg_rol t0 INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol WHERE seg_usuario_rol.usuario = ?
Parameters: 
[
  122
]
View formatted query    View runnable query    Explain query
4 1.98 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: 
[]
View formatted query    View runnable query    Explain query
5 2.82 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
]
View formatted query    View runnable query    Explain query
6 3.86 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
]
View formatted query    View runnable query    Explain query
7 3.77 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
]
View formatted query    View runnable query    Explain query
8 2.55 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
]
View formatted query    View runnable query    Explain query
9 2.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
  85
]
View formatted query    View runnable query    Explain query
10 2.50 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
]
View formatted query    View runnable query    Explain query
11 3.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
  34
]
View formatted query    View runnable query    Explain query
12 2.39 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
]
View formatted query    View runnable query    Explain query
13 2.17 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
]
View formatted query    View runnable query    Explain query
14 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
  33
]
View formatted query    View runnable query    Explain query
15 1.90 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
]
View formatted query    View runnable query    Explain query
16 2.18 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
]
View formatted query    View runnable query    Explain query
17 1.68 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
]
View formatted query    View runnable query    Explain query
18 2.02 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
]
View formatted query    View runnable query    Explain query
19 1.59 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
]
View formatted query    View runnable query    Explain query
20 1.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
  86
]
View formatted query    View runnable query    Explain query
21 1.56 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
]
View formatted query    View runnable query    Explain query
22 1.68 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
]
View formatted query    View runnable query    Explain query
23 1.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
  39
]
View formatted query    View runnable query    Explain query
24 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
  37
]
View formatted query    View runnable query    Explain query
25 1.40 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
]
View formatted query    View runnable query    Explain query
26 1.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
  18
]
View formatted query    View runnable query    Explain query
27 1.68 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
]
View formatted query    View runnable query    Explain query
28 1.78 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
]
View formatted query    View runnable query    Explain query
29 1.61 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
]
View formatted query    View runnable query    Explain query
30 1.78 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
]
View formatted query    View runnable query    Explain query
31 1.19 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
]
View formatted query    View runnable query    Explain query
32 1.55 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
]
View formatted query    View runnable query    Explain query
33 1.38 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
]
View formatted query    View runnable query    Explain query
34 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
  48
]
View formatted query    View runnable query    Explain query
35 1.54 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
]
View formatted query    View runnable query    Explain query
36 1.68 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
]
View formatted query    View runnable query    Explain query
37 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
  21
]
View formatted query    View runnable query    Explain query
38 0.81 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: 
[]
View formatted query    View runnable query    Explain query
39 0.94 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: 
[]
View formatted query    View runnable query    Explain query
40 2.45 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: 
[]
View formatted query    View runnable query    Explain query
41 1.20 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: 
[]
View formatted query    View runnable query    Explain query
42 1.31 ms 
SELECT n0_.id AS id_0, n0_.fecha_ingreso AS fecha_ingreso_1, n0_.asunto AS asunto_2, n0_.leida AS leida_3, n0_.fecha_leida AS fecha_leida_4, n0_.texto AS texto_5, n0_.accion AS accion_6, n0_.usuario AS usuario_7 FROM notificacion n0_ INNER JOIN seg_usuario s1_ ON n0_.usuario = s1_.id WHERE n0_.leida = false AND s1_.id = 122 ORDER BY n0_.asunto ASC, n0_.fecha_ingreso DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
43 0.99 ms 
SELECT CURRENT_DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
44 7.18 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"
]
View formatted query    View runnable query    Explain query
45 1.40 ms 
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters: 
[]
View formatted query    View runnable query    Explain query
46 0.68 ms 
SHOW search_path
Parameters: 
[]
View formatted query    View runnable query    Explain query
47 0.53 ms 
SELECT CURRENT_DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
48 1.18 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: 
[]
View formatted query    View runnable query    Explain query
49 1.51 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: 
[]
View formatted query    View runnable query    Explain query
50 1.33 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: 
[]
View formatted query    View runnable query    Explain query
51 1.35 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: 
[]
View formatted query    View runnable query    Explain query
52 0.89 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: 
[]
View formatted query    View runnable query    Explain query
53 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 = 90
Parameters: 
[]
View formatted query    View runnable query    Explain query
54 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 = 91
Parameters: 
[]
View formatted query    View runnable query    Explain query
55 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 = 92
Parameters: 
[]
View formatted query    View runnable query    Explain query
56 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 = 93
Parameters: 
[]
View formatted query    View runnable query    Explain query
57 0.64 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: 
[]
View formatted query    View runnable query    Explain query
58 0.65 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: 
[]
View formatted query    View runnable query    Explain query
59 0.69 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: 
[]
View formatted query    View runnable query    Explain query
60 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 = 96
Parameters: 
[]
View formatted query    View runnable query    Explain query
61 0.91 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: 
[]
View formatted query    View runnable query    Explain query
62 0.65 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: 
[]
View formatted query    View runnable query    Explain query
63 0.63 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: 
[]
View formatted query    View runnable query    Explain query
64 0.69 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: 
[]
View formatted query    View runnable query    Explain query
65 0.63 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: 
[]
View formatted query    View runnable query    Explain query
66 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 = 99
Parameters: 
[]
View formatted query    View runnable query    Explain query
67 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 = 42
Parameters: 
[]
View formatted query    View runnable query    Explain query
68 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 = 100
Parameters: 
[]
View formatted query    View runnable query    Explain query
69 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 = 101
Parameters: 
[]
View formatted query    View runnable query    Explain query
70 0.62 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: 
[]
View formatted query    View runnable query    Explain query
71 0.71 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: 
[]
View formatted query    View runnable query    Explain query
72 0.62 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: 
[]
View formatted query    View runnable query    Explain query
73 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 = 104
Parameters: 
[]
View formatted query    View runnable query    Explain query
74 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 = 105
Parameters: 
[]
View formatted query    View runnable query    Explain query
75 0.64 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: 
[]
View formatted query    View runnable query    Explain query
76 0.58 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: 
[]
View formatted query    View runnable query    Explain query
77 0.66 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: 
[]
View formatted query    View runnable query    Explain query
78 0.62 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: 
[]
View formatted query    View runnable query    Explain query
79 0.66 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: 
[]
View formatted query    View runnable query    Explain query
80 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 = 108
Parameters: 
[]
View formatted query    View runnable query    Explain query
81 0.75 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: 
[]
View formatted query    View runnable query    Explain query
82 0.65 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: 
[]
View formatted query    View runnable query    Explain query
83 0.60 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: 
[]
View formatted query    View runnable query    Explain query
84 0.60 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: 
[]
View formatted query    View runnable query    Explain query
85 0.61 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: 
[]
View formatted query    View runnable query    Explain query
86 0.78 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: 
[]
View formatted query    View runnable query    Explain query
87 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 = 112
Parameters: 
[]
View formatted query    View runnable query    Explain query
88 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 = 113
Parameters: 
[]
View formatted query    View runnable query    Explain query
89 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 = 114
Parameters: 
[]
View formatted query    View runnable query    Explain query
90 0.59 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: 
[]
View formatted query    View runnable query    Explain query
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 = 48
Parameters: 
[]
View formatted query    View runnable query    Explain query
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 = 115
Parameters: 
[]
View formatted query    View runnable query    Explain query
93 0.66 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: 
[]
View formatted query    View runnable query    Explain query
94 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 = 49
Parameters: 
[]
View formatted query    View runnable query    Explain query
95 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 = 116
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\SeguridadUsuario No errors.
App\Entity\NmclCargo No errors.
App\Entity\NmclGrado No errors.
App\Entity\BaseMovilizacion No errors.
App\Entity\CentroMovilizacion No errors.
App\Entity\UnidadMilitar No errors.
App\Entity\CentroInstruccion No errors.
App\Entity\SeguridadRol No errors.
App\Entity\Notificacion No errors.
App\Entity\ProcesoReclutamientoBase No errors.
App\Entity\NmclDominioLocalizacion No errors.
App\Entity\ProcesoReclutamientoCentro No errors.
App\Entity\ProcesoReclutamientoUnidad No errors.
App\Entity\TestSistema No errors.
App\Entity\NmclNivelLocalizacion No errors.
App\Entity\NmclLocalizacion No errors.
App\Entity\TestEje No errors.
App\Entity\TestCriterio No errors.
App\Entity\TestPregunta No errors.