Query Metrics
8
Database Queries
5
Different statements
13.04 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.65 ms (35.69%) |
3 |
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = ? AND t0.estado = ?
Parameters:
[ "PRINCIPAL" "A" ] |
|
2.99 ms (22.96%) |
2 |
SELECT t0.id AS id_1, t0.imagen_desktop AS imagen_desktop_2, t0.imagen_tablet AS imagen_tablet_3, t0.imagen_movil AS imagen_movil_4, t0.nombre_original_desktop AS nombre_original_desktop_5, t0.nombre_original_tablet AS nombre_original_tablet_6, t0.nombre_original_movil AS nombre_original_movil_7, t0.nombre_alterno AS nombre_alterno_8, t0.posicion AS posicion_9, t0.url_redirect AS url_redirect_10, t0.estado AS estado_11, t0.banner_id AS banner_id_12 FROM imagen t0 WHERE t0.banner_id = ? ORDER BY t0.posicion ASC
Parameters:
[
15
]
|
|
2.48 ms (19.00%) |
1 |
SELECT s0_.titulo AS titulo_0 FROM seccion_seo s0_ INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id WHERE s0_.estado = ? AND s0_.mostrar = ? AND t1_.id_tipo = ? LIMIT 1
Parameters:
[ "A" 1 "P" ] |
|
1.64 ms (12.57%) |
1 |
SELECT s0_.id AS id_0, s0_.titulo AS titulo_1, s0_.descripcion AS descripcion_2, s0_.keywords AS keywords_3, s0_.estado AS estado_4, s0_.mostrar AS mostrar_5, s0_.fechaCreacion AS fechacreacion_6, s0_.fechaActualizacion AS fechaactualizacion_7, s0_.header_principal AS header_principal_8, s0_.header_secundario AS header_secundario_9, s0_.tipo_seccion_seo_id AS tipo_seccion_seo_id_10 FROM seccion_seo s0_ INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id WHERE s0_.estado = ? AND s0_.mostrar = ? AND t1_.id_tipo = ? LIMIT 1
Parameters:
[ "A" 1 "P" ] |
|
1.27 ms (9.77%) |
1 |
SELECT t0.id AS id_1, t0.urlImagen AS urlimagen_2, t0.seccion_seo_id AS seccion_seo_id_3 FROM img_seccion_seo t0 WHERE t0.seccion_seo_id = ?
Parameters:
[
2
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Imagen | 6 |
| App\Entity\Banner | 2 |
| App\Entity\SeccionSeo | 1 |
| App\Entity\TipoSeccionSeo | 1 |
| App\Entity\ImgSeccionSeo | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Banner | No errors. |
| App\Entity\Imagen | No errors. |
| App\Entity\ClickBanner | No errors. |
| App\Entity\SeccionSeo | No errors. |
| App\Entity\TipoSeccionSeo | No errors. |
| App\Entity\ImgSeccionSeo | No errors. |