Query Metrics
6
Database Queries
3
Different statements
6.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.90 ms (42.63%) |
1 |
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.id_ruta_id AS id_ruta_id_3, t0.id_restaurante_id AS id_restaurante_id_4 FROM rutas_restaurantes t0 WHERE t0.id_ruta_id = ? AND t0.estado = ?
Parameters:
[ "3" "Activo" ] |
|
2.22 ms (32.65%) |
1 |
SELECT t0.id AS id_1, t0.nombre_ruta AS nombre_ruta_2, t0.google_maps AS google_maps_3 FROM rutas t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
|
1.68 ms (24.72%) |
4 |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.estado AS estado_3, t0.locacion AS locacion_4, t0.direccion AS direccion_5, t0.calificacion AS calificacion_6, t0.imagen_principal AS imagen_principal_7, t0.longitud AS longitud_8, t0.latitud AS latitud_9, t0.nombre AS nombre_10, t0.descripcion AS descripcion_11, t0.visitas AS visitas_12, t0.palabras_clave AS palabras_clave_13, t0.horario_atencion AS horario_atencion_14, t0.id_categoria_id AS id_categoria_id_15, t0.id_ciudad_id AS id_ciudad_id_16 FROM sitios t0 WHERE t0.id = ?
Parameters:
[
11
]
|
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\RutasRestaurantes | No errors. |
| App\Entity\Rutas | No errors. |
| App\Entity\Sitios | No errors. |
| App\Entity\CategoriaSitio | No errors. |
| App\Entity\Ciudades | No errors. |