Query Metrics
6
Database Queries
6
Different statements
15.79 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.10 ms (25.93%) |
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:
[
122
]
|
3.71 ms (23.51%) |
1 |
SELECT u0_.id AS id_0, u0_.siglas_unidad AS siglas_unidad_1, u0_.nombre AS nombre_2, u0_.fuerza AS fuerza_3, u0_.cupo_masculino AS cupo_masculino_4, u0_.adicional_masculino AS adicional_masculino_5, u0_.cupo_femenino AS cupo_femenino_6, u0_.adicional_femenino AS adicional_femenino_7, u0_.direccion AS direccion_8, u0_.geometria AS geometria_9, u0_.activo AS activo_10, u0_.centro_instruccion AS centro_instruccion_11, u0_.localizacion AS localizacion_12 FROM unidad_militar u0_ ORDER BY u0_.siglas_unidad ASC, u0_.nombre ASC, u0_.centro_instruccion ASC, u0_.fuerza ASC, u0_.localizacion ASC, u0_.direccion ASC, u0_.geometria ASC, u0_.activo ASC
Parameters:
[] |
3.11 ms (19.67%) |
1 |
SELECT n0_.id AS id_0, n0_.valor AS valor_1, n0_.nivel_localizacion AS nivel_localizacion_2, n0_.padre AS padre_3 FROM nmcl_dominio_localizacion n0_
Parameters:
[] |
2.13 ms (13.48%) |
1 |
SELECT n0_.id AS id_0, n0_.fecha_ingreso AS fecha_ingreso_1, n0_.asunto AS asunto_2, n0_.leida AS leida_3, n0_.fecha_leida AS fecha_leida_4, n0_.texto AS texto_5, n0_.accion AS accion_6, n0_.usuario AS usuario_7 FROM notificacion n0_ INNER JOIN seg_usuario s1_ ON n0_.usuario = s1_.id WHERE n0_.leida = false AND s1_.id = 122 ORDER BY n0_.asunto ASC, n0_.fecha_ingreso DESC
Parameters:
[] |
1.48 ms (9.40%) |
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.26 ms (8.01%) |
1 |
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:
[] |
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\NmclDominioLocalizacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |