Query Metrics

5 Database Queries
5 Different statements
12.90 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.33 ms
(25.79%)
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:
[]
3.25 ms
(25.19%)
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:
[
  54
]
2.95 ms
(22.89%)
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:
[
  "54"
]
2.21 ms
(17.14%)
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:
[
  1387
]
1.16 ms
(8.99%)
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:
[]

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.