https://integral.dirmov.mil.ec/es/admin/unidadmilitar/crud/plain/?p=es%2Fadmin%2Funidadmilitar%2Fcrud%2Fplain%2F

Query Metrics

11 Database Queries
10 Different statements
28.81 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.83 ms
(27.19%)
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"
]
4.17 ms
(14.46%)
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
(12.87%)
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.40 ms
(11.81%)
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.51 ms
(8.71%)
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
]
2.36 ms
(8.21%)
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.56 ms
(5.43%)
2
SELECT CURRENT_DATABASE()
Parameters:
[]
1.47 ms
(5.12%)
1
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
1.38 ms
(4.80%)
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:
[]
0.41 ms
(1.41%)
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\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.
App\Entity\NmclLocalizacion No errors.