Query Metrics
9
Database Queries
8
Different statements
20.21 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.34 ms (41.29%) |
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.75 ms (18.56%) |
1 |
DELETE FROM unidad_militar WHERE id = ?
Parameters:
[
293
]
|
3.38 ms (16.71%) |
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:
[
"293"
]
|
1.50 ms (7.41%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
1.40 ms (6.92%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
0.79 ms (3.89%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.61 ms (3.02%) |
1 |
SHOW search_path
Parameters:
[] |
0.44 ms (2.19%) |
1 |
"ROLLBACK"
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. |