Query Metrics
9
Database Queries
8
Different statements
15.25 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.95 ms (39.02%) |
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.58 ms (23.45%) |
1 |
DELETE FROM unidad_militar WHERE id = ?
Parameters:
[
275
]
|
2.93 ms (19.23%) |
1 |
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:
[
"275"
]
|
0.84 ms (5.53%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
0.80 ms (5.24%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
0.55 ms (3.64%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.32 ms (2.08%) |
1 |
"ROLLBACK"
Parameters:
[] |
0.28 ms (1.81%) |
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\UnidadMilitar | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclLocalizacion | No errors. |
App\Entity\CentroMovilizacion | No errors. |