Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
8.32 ms
(34.70%)
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.31 ms
(13.79%)
1
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 INNER JOIN centro_movilizacion_instruccion ON t0.id = centro_movilizacion_instruccion.centro_movilizacion WHERE centro_movilizacion_instruccion.centro_instruccion = ?
Parameters:
[
  34
]
3.24 ms
(13.50%)
1
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:
[]
2.77 ms
(11.55%)
1
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:
[
  "34"
]
2.22 ms
(9.25%)
1
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:
[
  729
]
1.45 ms
(6.03%)
1
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
1.24 ms
(5.16%)
2
SELECT CURRENT_DATABASE()
Parameters:
[]
1.15 ms
(4.79%)
1
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.geometria AS geometria_3, c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4, c0_.activo AS activo_5, c0_.localizacion AS localizacion_6, c0_.jefe AS jefe_7 FROM centro_movilizacion c0_
Parameters:
[]
0.30 ms
(1.23%)
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\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.
App\Entity\UnidadMilitar No errors.