Query Metrics
13
Database Queries
12
Different statements
29.88 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
9.82 ms (32.86%) |
1 |
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 = 2 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:
[] |
7.00 ms (23.43%) |
1 |
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"
]
|
3.60 ms (12.06%) |
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 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
"ROLE_COORDINADOR_CENTRO"
]
|
1.47 ms (4.92%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
1.42 ms (4.75%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
1.40 ms (4.68%) |
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_
Parameters:
[] |
1.06 ms (3.55%) |
1 |
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"
]
|
0.95 ms (3.18%) |
1 |
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_cargo n0_
Parameters:
[] |
0.95 ms (3.17%) |
1 |
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:
[] |
0.93 ms (3.10%) |
1 |
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:
[] |
0.91 ms (3.04%) |
1 |
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:
[] |
0.38 ms (1.27%) |
1 |
SHOW search_path
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\Notificacion | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\SeguridadConfiguracion | No errors. |
App\Entity\SeguridadFortalezaContrasena | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |