Query Metrics

9 Database Queries
8 Different statements
18.22 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.48 ms
(46.56%)
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.46 ms
(18.97%)
1
DELETE FROM unidad_militar WHERE id = ?
Parameters:
[
  79
]
2.80 ms
(15.36%)
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:
[
  "79"
]
1.18 ms
(6.45%)
1
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
1.12 ms
(6.15%)
2
SELECT CURRENT_DATABASE()
Parameters:
[]
0.60 ms
(3.32%)
1
"START TRANSACTION"
Parameters:
[]
0.30 ms
(1.65%)
1
SHOW search_path
Parameters:
[]
0.28 ms
(1.54%)
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.