Query Metrics

10 Database Queries
9 Different statements
46.37 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.09 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.direccion_acuartelamiento AS direccion_acuartelamiento_5, t0.activo AS activo_6, t0.localizacion AS localizacion_7, t0.jefe AS jefe_8 FROM centro_movilizacion t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
2 0.70 ms
"START TRANSACTION"
Parameters:
[]
3 1.18 ms
DELETE FROM centro_movilizacion_instruccion WHERE centro_movilizacion = ?
Parameters:
[
  9
]
4 28.49 ms
DELETE FROM centro_movilizacion WHERE id = ?
Parameters:
[
  9
]
5 0.54 ms
"ROLLBACK"
Parameters:
[]
6 0.99 ms
SELECT CURRENT_DATABASE()
Parameters:
[]
7 8.61 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.60 ms
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
9 0.62 ms
SHOW search_path
Parameters:
[]
10 0.54 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\CentroMovilizacion No errors.
App\Entity\NmclDominioLocalizacion No errors.
App\Entity\SeguridadUsuario 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\NmclNivelLocalizacion No errors.
App\Entity\NmclLocalizacion No errors.
App\Entity\SeguridadRol No errors.
App\Entity\Notificacion No errors.