https://guiayipao.co/home/sitio_individual/8

Query Metrics

15 Database Queries
10 Different statements
5.78 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.96 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:
[
  "8"
]
2 0.32 ms
"START TRANSACTION"
Parameters:
[]
3 0.38 ms
UPDATE sitios SET visitas = ? WHERE id = ?
Parameters:
[
  145
  8
]
4 0.20 ms
"COMMIT"
Parameters:
[]
5 0.64 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:
[
  "8"
]
6 0.49 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:
[
  "8"
]
7 0.61 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:
[
  "8"
  "Activo"
]
8 0.41 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:
[
  21
  "Activo"
]
9 0.47 ms
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.21 ms
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
  2
]
11 0.18 ms
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
  11
]
12 0.15 ms
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
  10
]
13 0.15 ms
SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = ?
Parameters:
[
  14
]
14 0.36 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
]
15 0.24 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:
[
  296
]

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
  • The association App\Entity\SitiosGaleria#id_sitio refers to the inverse side field App\Entity\Sitios#sitiosGalerias which does not exist.
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.