https://guiayipao.co/

Query Metrics

6 Database Queries
6 Different statements
71.30 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
23.92 ms
(33.55%)
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
]
15.43 ms
(21.64%)
1
SELECT t0.id AS id_1, t0.servicio_enlace AS servicio_enlace_2, t0.servicio_titulo AS servicio_titulo_3, t0.servicio_subtitulo AS servicio_subtitulo_4, t0.estado AS estado_5, t0.logo AS logo_6, t0.id_icono_id AS id_icono_id_7 FROM home_servicios t0 WHERE t0.estado = ? ORDER BY t0.id DESC LIMIT 4
Parameters:
[
  "Activo"
]
11.96 ms
(16.78%)
1
SELECT t0.id AS id_1, t0.imagen AS imagen_2, t0.fecha_hora AS fecha_hora_3, t0.id_home_id AS id_home_id_4 FROM home_galeria t0
Parameters:
[]
7.74 ms
(10.86%)
1
SELECT t0.id AS id_1, t0.imagen_cabecera AS imagen_cabecera_2, t0.titulo_cabecera AS titulo_cabecera_3, t0.subtitulo_cabecera AS subtitulo_cabecera_4, t0.enlace_cabecera AS enlace_cabecera_5, t0.texto_enlace_cabecera AS texto_enlace_cabecera_6, t0.texto_mensaje AS texto_mensaje_7 FROM home t0 WHERE t0.id = ?
Parameters:
[
  1
]
7.54 ms
(10.57%)
1
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.imagen AS imagen_2 FROM categoria_sitio c0_ WHERE c0_.imagen IS NOT NULL ORDER BY c0_.id ASC LIMIT 10
Parameters:
[]
4.71 ms
(6.60%)
1
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.estado = ? ORDER BY t0.visitas ASC LIMIT 4
Parameters:
[
  "Activo"
]

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\Home No errors.
App\Entity\HomeServicios No errors.
App\Entity\Testimonios No errors.
App\Entity\HomeGaleria No errors.
App\Entity\Ciudades No errors.
App\Entity\Sitios No errors.
App\Entity\CategoriaSitio No errors.
App\Entity\Departamentos No errors.
App\Entity\Iconos No errors.