Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
8.96 ms
(45.96%)
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"
]
2.39 ms
(12.23%)
1
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_cargo n0_
Parameters:
[]
2.04 ms
(10.43%)
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:
[]
1.53 ms
(7.84%)
1
SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.direccion AS direccion_2, b0_.geometria AS geometria_3, b0_.activo AS activo_4, b0_.localizacion AS localizacion_5, b0_.jefe AS jefe_6 FROM base_movilizacion b0_
Parameters:
[]
1.49 ms
(7.64%)
1
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
1.39 ms
(7.11%)
2
SELECT CURRENT_DATABASE()
Parameters:
[]
1.30 ms
(6.68%)
1
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1, n0_.id_dir_mov AS id_dir_mov_2 FROM nmcl_grado n0_
Parameters:
[]
0.41 ms
(2.11%)
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\SeguridadUsuario No errors.
App\Entity\NmclCargo No errors.
App\Entity\NmclGrado No errors.
App\Entity\BaseMovilizacion No errors.
App\Entity\CentroMovilizacion No errors.
App\Entity\NmclDominioLocalizacion No errors.
App\Entity\CentroInstruccion No errors.
App\Entity\SeguridadRol No errors.
App\Entity\Notificacion No errors.
App\Entity\Adjunto No errors.
App\Entity\UnidadMilitar No errors.
App\Entity\NmclNivelLocalizacion No errors.
App\Entity\NmclLocalizacion No errors.