Query Metrics
1089
Database Queries
16
Different statements
752.11 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
285.83 ms (38.00%) |
198 |
"COMMIT"
Parameters:
[] |
119.33 ms (15.87%) |
197 |
SELECT t0.id AS id_1, t0.siglas_unidad AS siglas_unidad_2, t0.nombre AS nombre_3, t0.fuerza AS fuerza_4, t0.cupo_masculino AS cupo_masculino_5, t0.adicional_masculino AS adicional_masculino_6, t0.cupo_femenino AS cupo_femenino_7, t0.adicional_femenino AS adicional_femenino_8, t0.direccion AS direccion_9, t0.geometria AS geometria_10, t0.activo AS activo_11, t0.centro_instruccion AS centro_instruccion_12, t0.localizacion AS localizacion_13 FROM unidad_militar t0 WHERE t0.id = ?
Parameters:
[
109
]
|
110.27 ms (14.66%) |
197 |
UPDATE unidad_militar SET cupo_masculino = ?, adicional_masculino = ?, cupo_femenino = ?, adicional_femenino = ? WHERE id = ?
Parameters:
[ "30" "650" "0" "0" 109 ] |
100.83 ms (13.41%) |
197 |
UPDATE proceso_reclutamiento_unidad_lugar SET prioridad = ?, cupo_masculino = ?, cupo_femenino = ?, organico_masculino = ?, organico_femenino = ? WHERE id = ?
Parameters:
[ "6" 225.0 0.0 "30" "0" 2299 ] |
67.39 ms (8.96%) |
198 |
"START TRANSACTION"
Parameters:
[] |
20.74 ms (2.76%) |
25 |
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
]
|
15.91 ms (2.11%) |
28 |
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:
[
10
]
|
13.90 ms (1.85%) |
28 |
UPDATE proceso_reclutamiento_lugar_base SET cupo_masculino = ?, cupo_femenino = ? WHERE id = ?
Parameters:
[ 1087.0 0.0 276 ] |
4.26 ms (0.57%) |
9 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_dir_mov AS id_dir_mov_3 FROM nmcl_grado t0 WHERE t0.id = ?
Parameters:
[
20
]
|
2.51 ms (0.33%) |
4 |
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:
[
8
]
|
2.39 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.nombre_unidad AS nombre_unidad_2, t0.prioridad AS prioridad_3, t0.cupo_masculino AS cupo_masculino_4, t0.cupo_femenino AS cupo_femenino_5, t0.registrado_masculino AS registrado_masculino_6, t0.registrado_femenino AS registrado_femenino_7, t0.fuerza AS fuerza_8, t0.organico_masculino AS organico_masculino_9, t0.organico_femenino AS organico_femenino_10, t0.unidad AS unidad_11, t0.lugar AS lugar_12, t0.proceso AS proceso_13 FROM proceso_reclutamiento_unidad_lugar t0 WHERE t0.proceso = ?
Parameters:
[
47
]
|
2.28 ms (0.30%) |
1 |
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 = ?
Parameters:
[
47
]
|
2.02 ms (0.27%) |
1 |
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
]
|
1.63 ms (0.22%) |
3 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM nmcl_cargo t0 WHERE t0.id = ?
Parameters:
[
3
]
|
1.62 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.anno AS anno_2, t0.llamada AS llamada_3, t0.fecha_inicio_registro AS fecha_inicio_registro_4, t0.fecha_fin_registro AS fecha_fin_registro_5, t0.fecha_acuartelamiento AS fecha_acuartelamiento_6, t0.fecha_fin_dias AS fecha_fin_dias_7, t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8, t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9, t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10, t0.minutos_test AS minutos_test_11, t0.bajas_permitidas AS bajas_permitidas_12, t0.activo AS activo_13, t0.cant_cursos AS cant_cursos_14, t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15, t0.titulo_reporte_jockey AS titulo_reporte_jockey_16, t0.titulo_reporte_calzado AS titulo_reporte_calzado_17, t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18, t0.titulo_reporte_estudios AS titulo_reporte_estudios_19, t0.foto_uniforme AS foto_uniforme_20, t0.foto_jockey AS foto_jockey_21, t0.foto_calzado AS foto_calzado_22, t0.foto_camiseta AS foto_camiseta_23 FROM proceso_reclutamiento t0 WHERE t0.id = ?
Parameters:
[
"47"
]
|
1.19 ms (0.16%) |
1 |
SELECT t0.id AS id_1, t0.jefe_cedula AS jefe_cedula_2, t0.jefe_nombres AS jefe_nombres_3, t0.jefe_apellidos AS jefe_apellidos_4, t0.jefe_cargo AS jefe_cargo_5, t0.jefe_grado AS jefe_grado_6, t0.nombre_base AS nombre_base_7, t0.proceso AS proceso_8, t0.base AS base_9 FROM proceso_reclutamiento_bases t0 WHERE t0.proceso = ?
Parameters:
[
47
]
|
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\ProcesoReclutamientoCentro | No errors. |
App\Entity\ProcesoReclutamientoBase | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclLocalizacion | No errors. |