Query Metrics

7 Database Queries
7 Different statements
18.84 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.55 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 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
  "ROLE_OPERADOR_INSTRUCCION"
]
2 10.06 ms
SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.nombres AS nombres_2, s0_.apellidos AS apellidos_3, s0_.telefono AS telefono_4, s0_.celular AS celular_5, s0_.email AS email_6, s0_.direccion AS direccion_7, s0_.fecha_registro AS fecha_registro_8, s0_.fecha_vigencia_password AS fecha_vigencia_password_9, s0_.causa_bloqueo AS causa_bloqueo_10, s0_.password AS password_11, s0_.eliminado AS eliminado_12, s0_.fecha_eliminacion AS fecha_eliminacion_13, s0_.intentos_fallidos AS intentos_fallidos_14, s0_.primer_ingreso AS primer_ingreso_15, s0_.activo AS activo_16, s0_.conectado AS conectado_17, s0_.fecha_acceso AS fecha_acceso_18, s0_.cargo AS cargo_19, s0_.grado AS grado_20, s0_.foto AS foto_21, s0_.base AS base_22, s0_.centro AS centro_23, s0_.unidad AS unidad_24, s0_.centro_instruccion AS centro_instruccion_25 FROM seg_usuario s0_ LEFT JOIN seg_usuario_rol s2_ ON s0_.id = s2_.usuario LEFT JOIN seg_rol s1_ ON s1_.id = s2_.rol WHERE s1_.id = 7 ORDER BY s0_.username ASC, s0_.cargo ASC, s0_.grado ASC, s0_.centro_instruccion ASC, s0_.activo ASC, s0_.fecha_acceso ASC, s0_.fecha_acceso ASC
Parameters:
[]
3 0.91 ms
SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.sistema AS sistema_2, s0_.descripcion AS descripcion_3, s0_.asignable AS asignable_4 FROM seg_rol s0_
Parameters:
[]
4 1.04 ms
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_cargo n0_
Parameters:
[]
5 1.01 ms
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1, n0_.id_dir_mov AS id_dir_mov_2 FROM nmcl_grado n0_
Parameters:
[]
6 1.00 ms
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.fuerza AS fuerza_2, c0_.direccion AS direccion_3, c0_.geometria AS geometria_4, c0_.localizacion AS localizacion_5 FROM centro_instruccion c0_
Parameters:
[]
7 1.27 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo_activacion AS codigo_activacion_3, t0.vigencia_codigo AS vigencia_codigo_4, t0.default_contrasena AS default_contrasena_5, t0.vigencia_contrasena AS vigencia_contrasena_6, t0.contrasenas_viejas AS contrasenas_viejas_7, t0.accesos_fallidos AS accesos_fallidos_8, t0.fortaleza_contrasena AS fortaleza_contrasena_9 FROM seg_configuracion t0 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
  "DEFAULT"
]

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\SeguridadRol No errors.
App\Entity\SeguridadUsuario No errors.
App\Entity\NmclCargo No errors.
App\Entity\NmclGrado No errors.
App\Entity\CentroInstruccion No errors.
App\Entity\Adjunto No errors.
App\Entity\BaseMovilizacion No errors.
App\Entity\CentroMovilizacion No errors.
App\Entity\UnidadMilitar No errors.
App\Entity\Notificacion No errors.
App\Entity\NmclDominioLocalizacion No errors.
App\Entity\SeguridadConfiguracion No errors.
App\Entity\SeguridadFortalezaContrasena No errors.