Query Metrics
10
Database Queries
9
Different statements
22.67 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.93 ms |
SELECT t0.id AS id_1, t0.siglas_unidad AS siglas_unidad_2, t0.nombre AS nombre_3, t0.fuerza AS fuerza_4, t0.cupo_masculino AS cupo_masculino_5, t0.adicional_masculino AS adicional_masculino_6, t0.cupo_femenino AS cupo_femenino_7, t0.adicional_femenino AS adicional_femenino_8, t0.direccion AS direccion_9, t0.geometria AS geometria_10, t0.activo AS activo_11, t0.centro_instruccion AS centro_instruccion_12, t0.localizacion AS localizacion_13 FROM unidad_militar t0 WHERE t0.id = ?
Parameters:
[
"109"
]
|
2 | 1.44 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.fuerza AS fuerza_3, t0.direccion AS direccion_4, t0.geometria AS geometria_5, t0.localizacion AS localizacion_6 FROM centro_instruccion t0 WHERE t0.id = ?
Parameters:
[
14
]
|
3 | 1.40 ms |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.nivel_localizacion AS nivel_localizacion_3, t0.padre AS padre_4 FROM nmcl_dominio_localizacion t0 WHERE t0.id = ?
Parameters:
[
454
]
|
4 | 0.95 ms |
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:
[] |
5 | 2.83 ms |
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:
[] |
6 | 0.99 ms |
SELECT CURRENT_DATABASE()
Parameters:
[] |
7 | 8.63 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"
]
|
8 | 1.29 ms |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
9 | 0.66 ms |
SHOW search_path
Parameters:
[] |
10 | 0.55 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\UnidadMilitar | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\SeguridadUsuario | No errors. |
App\Entity\NmclLocalizacion | No errors. |
App\Entity\SeguridadRol | No errors. |
App\Entity\Notificacion | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\BaseMovilizacion | No errors. |