Query Metrics
8
Database Queries
7
Different statements
73.34 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
54.10 ms (73.76%) |
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_
Parameters:
[] |
8.75 ms (11.93%) |
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.78 ms (5.16%) |
1 |
SELECT c0_.id AS id_0, c0_.fecha_inicio AS fecha_inicio_1, c0_.fecha_fin AS fecha_fin_2, c0_.centro AS centro_3, c0_.jefe AS jefe_4 FROM centros_movilizacion_jefe c0_ ORDER BY c0_.fecha_inicio ASC, c0_.fecha_inicio ASC, c0_.fecha_fin ASC, c0_.fecha_fin ASC, c0_.centro ASC, c0_.jefe ASC
Parameters:
[] |
2.29 ms (3.12%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
1.98 ms (2.70%) |
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.83 ms (2.49%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
0.61 ms (0.83%) |
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\CentrosMovilizacionJefes | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\SeguridadUsuario | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\UnidadMilitar | No errors. |
App\Entity\SeguridadRol | No errors. |
App\Entity\Notificacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclLocalizacion | No errors. |