Query Metrics
14
Database Queries
10
Different statements
8.22 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.81 ms |
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:
[
"14"
]
|
2 | 0.23 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.35 ms |
UPDATE sitios SET visitas = ? WHERE id = ?
Parameters:
[ 160 14 ] |
4 | 0.21 ms |
"COMMIT"
Parameters:
[] |
5 | 3.25 ms |
SELECT t0.id AS id_1, t0.imagen AS imagen_2, t0.estado AS estado_3, t0.posicion AS posicion_4, t0.id_sitio_id AS id_sitio_id_5 FROM sitios_galeria t0 WHERE t0.id_sitio_id = ?
Parameters:
[
"14"
]
|
6 | 0.51 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3, t0.id_sitio_id AS id_sitio_id_4, t0.id_icono_id AS id_icono_id_5 FROM sitios_comodidades t0 WHERE t0.id_sitio_id = ?
Parameters:
[
"14"
]
|
7 | 0.73 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.color AS color_3, t0.enlace AS enlace_4, t0.estado AS estado_5, t0.id_sitio_id AS id_sitio_id_6, t0.id_icono_id AS id_icono_id_7 FROM sitios_redes_sociales t0 WHERE t0.id_sitio_id = ? AND t0.estado = ?
Parameters:
[ "14" "Activo" ] |
8 | 0.46 ms |
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_categoria_id = ? AND t0.estado = ?
Parameters:
[ 17 "Activo" ] |
9 | 0.42 ms |
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
2
]
|
10 | 0.19 ms |
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
11
]
|
11 | 0.15 ms |
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
10
]
|
12 | 0.15 ms |
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
14
]
|
13 | 0.49 ms |
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:
[
63
]
|
14 | 0.28 ms |
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\SitiosGaleria |
|
App\Entity\SitiosComodidades | No errors. |
App\Entity\SitiosRedesSociales | No errors. |
App\Entity\CategoriaSitio | No errors. |
App\Entity\Ciudades | No errors. |
App\Entity\Departamentos | No errors. |
App\Entity\Paises | No errors. |
App\Entity\Iconos | No errors. |