Query Metrics

13 Database Queries
12 Different statements
20.31 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.36 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_PSICOLOGO"
]
2 5.87 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 = 11 ORDER BY s0_.username ASC, s0_.cargo ASC, s0_.grado ASC, s0_.base ASC, s0_.centro ASC, s0_.activo ASC, s0_.fecha_acceso ASC, s0_.fecha_acceso ASC
Parameters:
[]
3 0.74 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 0.86 ms
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_cargo n0_
Parameters:
[]
5 0.85 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 0.82 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_
Parameters:
[]
7 1.16 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_
Parameters:
[]
8 0.88 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"
]
9 0.67 ms
SELECT CURRENT_DATABASE()
Parameters:
[]
10 4.33 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"
]
11 0.94 ms
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
12 0.39 ms
SHOW search_path
Parameters:
[]
13 0.44 ms
SELECT CURRENT_DATABASE()
Parameters:
[]

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\BaseMovilizacion No errors.
App\Entity\CentroMovilizacion No errors.
App\Entity\Adjunto No errors.
App\Entity\UnidadMilitar No errors.
App\Entity\CentroInstruccion No errors.
App\Entity\NmclDominioLocalizacion No errors.
App\Entity\SeguridadConfiguracion No errors.
App\Entity\SeguridadFortalezaContrasena No errors.
App\Entity\Notificacion No errors.
App\Entity\NmclNivelLocalizacion No errors.
App\Entity\NmclLocalizacion No errors.