Query Metrics
5
Database Queries
5
Different statements
11.83 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.10 ms (26.21%) |
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:
[
40
]
|
3.07 ms (25.93%) |
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.75 ms (23.23%) |
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:
[
"40"
]
|
1.79 ms (15.08%) |
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:
[
950
]
|
1.13 ms (9.54%) |
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. |