Query Metrics
6
Database Queries
6
Different statements
17.49 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.53 ms (25.89%) |
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.31 ms (24.64%) |
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"
]
|
2.87 ms (16.39%) |
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
]
|
2.75 ms (15.74%) |
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
]
|
1.67 ms (9.57%) |
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"
]
|
1.36 ms (7.76%) |
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:
[] |
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. |