https://integral.dirmov.mil.ec/reclutaproceso/cargar/centros/8/47?p=reclutaproceso%2Fcargar%2Fcentros%2F8%2F47

Query Metrics

3 Database Queries
3 Different statements
12.10 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.78 ms
(47.81%)
1
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.geometria AS geometria_3, c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4, c0_.activo AS activo_5, c0_.localizacion AS localizacion_6, c0_.jefe AS jefe_7 FROM centro_movilizacion c0_ INNER JOIN centro_movilizacion_instruccion c2_ ON c0_.id = c2_.centro_movilizacion INNER JOIN centro_instruccion c1_ ON c1_.id = c2_.centro_instruccion WHERE (c0_.id IN (SELECT c3_.id FROM proceso_reclutamiento_lugar_base p4_ INNER JOIN proceso_reclutamiento p5_ ON p4_.proceso = p5_.id INNER JOIN base_movilizacion b6_ ON p4_.base = b6_.id INNER JOIN centro_movilizacion c3_ ON p4_.lugar = c3_.id WHERE p5_.id = 47 AND b6_.id = 8)) AND c1_.id = 14 ORDER BY c0_.nombre ASC
Parameters:
[]
4.21 ms
(34.77%)
1
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:
[
  5367
]
2.11 ms
(17.42%)
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:
[
  5367
]

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\ReclutaProceso No errors.
App\Entity\ProcesoReclutamientoCentro No errors.
App\Entity\ProcesoReclutamiento No errors.
App\Entity\NmclDominioLocalizacion No errors.