https://integral.dirmov.mil.ec/_fragment?_path=_format%3Dhtml%26_locale%3Des%26_controller%3DApp%255CController%255CMenuSubController%253A%253AshowMenuSubAction

Method
GET
HTTP Status
200
IP
10.103.7.9
Profiled on
Token
76dfdb

Query Metrics

25 Database Queries
9 Different statements
33.02 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 4.41 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: 
[
  3630
]
View formatted query    View runnable query    Explain query
2 2.39 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: 
[
  3630
]
View formatted query    View runnable query    Explain query
3 1.81 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.activo = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
4 5.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, p0_.unidad AS unidad_10, p0_.lugar AS lugar_11, p0_.proceso AS proceso_12 FROM proceso_reclutamiento_unidad_lugar p0_ LEFT JOIN proceso_reclutamiento p1_ ON p0_.proceso = p1_.id INNER JOIN centro_movilizacion c2_ ON p0_.lugar = c2_.id INNER JOIN centro_movilizacion_instruccion c4_ ON c2_.id = c4_.centro_movilizacion INNER JOIN centro_instruccion c3_ ON c3_.id = c4_.centro_instruccion WHERE p1_.id = 47 AND c3_.id = 25 ORDER BY p0_.proceso ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 1.12 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_
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 1.33 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  92
]
View formatted query    View runnable query    Explain query
7 0.97 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.activo AS activo_5, t0.localizacion AS localizacion_6, t0.jefe AS jefe_7 FROM base_movilizacion t0 WHERE t0.id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
8 0.66 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.direccion_acuartelamiento AS direccion_acuartelamiento_5, t0.activo AS activo_6, t0.localizacion AS localizacion_7, t0.jefe AS jefe_8 FROM centro_movilizacion t0 WHERE t0.id = ?
Parameters: 
[
  92
]
View formatted query    View runnable query    Explain query
9 0.73 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  92
]
View formatted query    View runnable query    Explain query
10 0.77 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  92
]
View formatted query    View runnable query    Explain query
11 0.78 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
12 0.64 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.activo AS activo_5, t0.localizacion AS localizacion_6, t0.jefe AS jefe_7 FROM base_movilizacion t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
13 0.52 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.direccion_acuartelamiento AS direccion_acuartelamiento_5, t0.activo AS activo_6, t0.localizacion AS localizacion_7, t0.jefe AS jefe_8 FROM centro_movilizacion t0 WHERE t0.id = ?
Parameters: 
[
  39
]
View formatted query    View runnable query    Explain query
14 0.67 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
15 0.73 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
16 0.65 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
17 0.73 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
18 0.67 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
19 0.69 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
20 0.57 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
21 1.38 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
22 0.86 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
23 0.81 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
24 0.79 ms 
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.proceso = ? AND t0.lugar = ? LIMIT 1
Parameters: 
[
  47
  39
]
View formatted query    View runnable query    Explain query
25 2.74 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 = 3630 ORDER BY n0_.asunto ASC, n0_.fecha_ingreso DESC
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\SeguridadUsuario No errors.
App\Entity\NmclCargo No errors.
App\Entity\NmclGrado No errors.
App\Entity\Adjunto 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\ProcesoReclutamiento No errors.
App\Entity\Curso No errors.
App\Entity\ProcesoReclutamientoUnidad No errors.
App\Entity\ReclutaProceso No errors.
App\Entity\ProcesoReclutamientoCentro No errors.
App\Entity\NmclDominioLocalizacion No errors.