Query Metrics
3
Database Queries
3
Different statements
3.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.83 ms (55.37%) |
1 |
SELECT s0_.id AS id_0, s0_.valor AS valor_1, s0_.estado AS estado_2, s0_.locacion AS locacion_3, s0_.direccion AS direccion_4, s0_.calificacion AS calificacion_5, s0_.imagen_principal AS imagen_principal_6, s0_.longitud AS longitud_7, s0_.latitud AS latitud_8, s0_.nombre AS nombre_9, s0_.descripcion AS descripcion_10, s0_.visitas AS visitas_11, s0_.palabras_clave AS palabras_clave_12, s0_.horario_atencion AS horario_atencion_13, s0_.id_categoria_id AS id_categoria_id_14, s0_.id_ciudad_id AS id_ciudad_id_15 FROM sitios s0_ ORDER BY s0_.id ASC
Parameters:
[] |
|
0.98 ms (29.64%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_departamento_id AS id_departamento_id_3 FROM ciudades t0 WHERE t0.id_departamento_id = ? ORDER BY t0.nombre ASC
Parameters:
[
26
]
|
|
0.50 ms (14.99%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_departamento_id AS id_departamento_id_3 FROM ciudades t0 WHERE t0.id = ?
Parameters:
[
1003
]
|
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\Sitios | No errors. |
| App\Entity\Ciudades | No errors. |
| App\Entity\CategoriaSitio | No errors. |
| App\Entity\Departamentos | No errors. |