Symfony Profiler

Query Metrics

12 Database Queries

9 Different statements

48.86 ms Query time

2 Invalid entities

32 Managed entities

Queries


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 = ?
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
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 = ?
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 = ?
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
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
SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = ?
SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = ?
SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC, d2_.posicion ASC
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
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 = ?

#▲	Time	Info
1	3.22 ms	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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'PRINCIPAL' AND t0.estado = 'A';
2	2.07 ms	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`] View formatted query View runnable query Explain query 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 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 = 15 ORDER BY t0.posicion ASC;
3	1.27 ms	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: [`"SECCION1" "A"`] View formatted query View runnable query Explain query 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 = ? 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 = 'SECCION1' AND t0.estado = 'A';
4	1.02 ms	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: [`"SECCION2" "A"`] View formatted query View runnable query Explain query 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 = ? 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 = 'SECCION2' AND t0.estado = 'A';
5	1.13 ms	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: [`16`] View formatted query View runnable query Explain query 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 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 = 16 ORDER BY t0.posicion ASC;
6	2.28 ms	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"`] View formatted query View runnable query Explain query 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 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 = 'A' AND s0_.mostrar = 1 AND t1_.id_tipo = 'P' LIMIT 1;
7	13.46 ms	SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = ? Parameters: [`""`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = ? SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = '';
8	4.25 ms	SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = ? Parameters: [`""`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = ? SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = '';
9	3.75 ms	SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["5" "9" "15" "19" "26" "28" "30" "32" "38" "39" "41" "45" "47" "49" "51" "53" "55" "59" "61" "64" "66" "68" "70" "72" "74" "76" "78" "80" "84" "86" "88" "90" "92" "94" "96" "98" "100" "102" "104" "106" "108" "112" "114" "117" "120" "122" "124" "125" "126" "128" "130" "132" "150" "155" "157" "159" "165" "167" "180" "182" "184" "186" "188" "192" "197" "199" "201" "203" "244" "258" "269" "292" "297" "333" "335" "336" "337" "339" "341" "416" "417" "418" "421" "425" "430" "436" "447" "451" "486" "491" "492" "497" "502" "503" "507" "518" "525" "536" "539" "540" "561" "645" "1399" "1440" "1450" "1454" "1463" "1465" "1520" "1529" "1555" "1559" "1577" "1579" "1588" "1602" "1603" "1605" "1607" "1608" "1609" "1616" "1623" "1641" "1643" "1645" "1650" "1652" "1654" "1655" "1656" "1663" "1672" "1674" "1676" "1678" "1679" "1680" "1681" "1682" "1687" "1689" "1690" "1691" "1693" "1694" "1698" "1699" "1700" "1701" "1702" "1707" "1709" "1710" "1712" "1713" "1714" "1715" "1716" "1718" "1720" "1721" "1722" "1723" "1724" "1725" "1726" "1728" "1729" "1731" "1733" "1734" "1736" "1737" "1740" "1743" "1745" "1746" "1751" "1755" "1756" "1757" "1758" "1760" "1762" "1764" "1765" "1767" "1775" "1777" "1778" "1779" "1780" "1783" "1785" "1788" "1790" "1791" "1794" "1797" "1798" "1803" "1804" "1805" "1808" "1809" "1810" "1811" "1813" "1814" "1815" "1816" "1817" "1818" "1820" "1821" "1822" "1823" "1825" "1827" "1828" "1829" "1830" "1831" "1833" "1835" "1837" "1838" "1839" "1842" "1844" "1845" "1848" "1849" "1850" "1851" "1852" "1859" "1860" "1862" "1863" "1864" "1865" "1867" "1869" "1874" "1875" "1876" "1877" "1879"] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN ('5', '9', '15', '19', '26', '28', '30', '32', '38', '39', '41', '45', '47', '49', '51', '53', '55', '59', '61', '64', '66', '68', '70', '72', '74', '76', '78', '80', '84', '86', '88', '90', '92', '94', '96', '98', '100', '102', '104', '106', '108', '112', '114', '117', '120', '122', '124', '125', '126', '128', '130', '132', '150', '155', '157', '159', '165', '167', '180', '182', '184', '186', '188', '192', '197', '199', '201', '203', '244', '258', '269', '292', '297', '333', '335', '336', '337', '339', '341', '416', '417', '418', '421', '425', '430', '436', '447', '451', '486', '491', '492', '497', '502', '503', '507', '518', '525', '536', '539', '540', '561', '645', '1399', '1440', '1450', '1454', '1463', '1465', '1520', '1529', '1555', '1559', '1577', '1579', '1588', '1602', '1603', '1605', '1607', '1608', '1609', '1616', '1623', '1641', '1643', '1645', '1650', '1652', '1654', '1655', '1656', '1663', '1672', '1674', '1676', '1678', '1679', '1680', '1681', '1682', '1687', '1689', '1690', '1691', '1693', '1694', '1698', '1699', '1700', '1701', '1702', '1707', '1709', '1710', '1712', '1713', '1714', '1715', '1716', '1718', '1720', '1721', '1722', '1723', '1724', '1725', '1726', '1728', '1729', '1731', '1733', '1734', '1736', '1737', '1740', '1743', '1745', '1746', '1751', '1755', '1756', '1757', '1758', '1760', '1762', '1764', '1765', '1767', '1775', '1777', '1778', '1779', '1780', '1783', '1785', '1788', '1790', '1791', '1794', '1797', '1798', '1803', '1804', '1805', '1808', '1809', '1810', '1811', '1813', '1814', '1815', '1816', '1817', '1818', '1820', '1821', '1822', '1823', '1825', '1827', '1828', '1829', '1830', '1831', '1833', '1835', '1837', '1838', '1839', '1842', '1844', '1845', '1848', '1849', '1850', '1851', '1852', '1859', '1860', '1862', '1863', '1864', '1865', '1867', '1869', '1874', '1875', '1876', '1877', '1879');
10	13.42 ms	SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC, d2_.posicion ASC Parameters: ["5" "9" "15" "19" "26" "28" "30" "32" "38" "39" "41" "45" "47" "49" "51" "53" "55" "59" "61" "64" "66" "68" "70" "72" "74" "76" "78" "80" "84" "86" "88" "90" "92" "94" "96" "98" "100" "102" "104" "106" "108" "112" "114" "117" "120" "122" "124" "125" "126" "128" "130" "132" "150" "155" "157" "159" "165" "167" "180" "182" "184" "186" "188" "192" "197" "199" "201" "203" "244" "258" "269" "292" "297" "333" "335" "336" "337" "339" "341" "416" "417" "418" "421" "425" "430" "436" "447" "451" "486" "491" "492" "497" "502" "503" "507" "518" "525" "536" "539" "540" "561" "645" "1399" "1440" "1450" "1454" "1463" "1465" "1520" "1529" "1555" "1559" "1577" "1579" "1588" "1602" "1603" "1605" "1607" "1608" "1609" "1616" "1623" "1641" "1643" "1645" "1650" "1652" "1654" "1655" "1656" "1663" "1672" "1674" "1676" "1678" "1679" "1680" "1681" "1682" "1687" "1689" "1690" "1691" "1693" "1694" "1698" "1699" "1700" "1701" "1702" "1707" "1709" "1710" "1712" "1713" "1714" "1715" "1716" "1718" "1720" "1721" "1722" "1723" "1724" "1725" "1726" "1728" "1729" "1731" "1733" "1734" "1736" "1737" "1740" "1743" "1745" "1746" "1751" "1755" "1756" "1757" "1758" "1760" "1762" "1764" "1765" "1767" "1775" "1777" "1778" "1779" "1780" "1783" "1785" "1788" "1790" "1791" "1794" "1797" "1798" "1803" "1804" "1805" "1808" "1809" "1810" "1811" "1813" "1814" "1815" "1816" "1817" "1818" "1820" "1821" "1822" "1823" "1825" "1827" "1828" "1829" "1830" "1831" "1833" "1835" "1837" "1838" "1839" "1842" "1844" "1845" "1848" "1849" "1850" "1851" "1852" "1859" "1860" "1862" "1863" "1864" "1865" "1867" "1869" "1874" "1875" "1876" "1877" "1879"] View formatted query View runnable query Explain query SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY p0_.id ASC, d2_.posicion ASC SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN ('5', '9', '15', '19', '26', '28', '30', '32', '38', '39', '41', '45', '47', '49', '51', '53', '55', '59', '61', '64', '66', '68', '70', '72', '74', '76', '78', '80', '84', '86', '88', '90', '92', '94', '96', '98', '100', '102', '104', '106', '108', '112', '114', '117', '120', '122', '124', '125', '126', '128', '130', '132', '150', '155', '157', '159', '165', '167', '180', '182', '184', '186', '188', '192', '197', '199', '201', '203', '244', '258', '269', '292', '297', '333', '335', '336', '337', '339', '341', '416', '417', '418', '421', '425', '430', '436', '447', '451', '486', '491', '492', '497', '502', '503', '507', '518', '525', '536', '539', '540', '561', '645', '1399', '1440', '1450', '1454', '1463', '1465', '1520', '1529', '1555', '1559', '1577', '1579', '1588', '1602', '1603', '1605', '1607', '1608', '1609', '1616', '1623', '1641', '1643', '1645', '1650', '1652', '1654', '1655', '1656', '1663', '1672', '1674', '1676', '1678', '1679', '1680', '1681', '1682', '1687', '1689', '1690', '1691', '1693', '1694', '1698', '1699', '1700', '1701', '1702', '1707', '1709', '1710', '1712', '1713', '1714', '1715', '1716', '1718', '1720', '1721', '1722', '1723', '1724', '1725', '1726', '1728', '1729', '1731', '1733', '1734', '1736', '1737', '1740', '1743', '1745', '1746', '1751', '1755', '1756', '1757', '1758', '1760', '1762', '1764', '1765', '1767', '1775', '1777', '1778', '1779', '1780', '1783', '1785', '1788', '1790', '1791', '1794', '1797', '1798', '1803', '1804', '1805', '1808', '1809', '1810', '1811', '1813', '1814', '1815', '1816', '1817', '1818', '1820', '1821', '1822', '1823', '1825', '1827', '1828', '1829', '1830', '1831', '1833', '1835', '1837', '1838', '1839', '1842', '1844', '1845', '1848', '1849', '1850', '1851', '1852', '1859', '1860', '1862', '1863', '1864', '1865', '1867', '1869', '1874', '1875', '1876', '1877', '1879') ORDER BY p0_.id ASC, d2_.posicion ASC;
11	1.55 ms	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"`] View formatted query View runnable query Explain query 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 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 = 'A' AND s0_.mostrar = 1 AND t1_.id_tipo = 'P' LIMIT 1;
12	1.44 ms	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`] View formatted query View runnable query Explain query 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 = ? 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 = 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\CrossReferences_ES	12
App\Entity\Producto_ES	9
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\Producto_ES	The mappings App\Entity\Producto_ES#crossreferenceses and App\Entity\CrossReferences_ES#producto are inconsistent with each other.
App\Entity\Marca_ES	No errors.
App\Entity\Familia_ES	No errors.
App\Entity\Estructura_ecommerce_ES	No errors.
App\Entity\CrossReferences_ES	The association App\Entity\CrossReferences_ES#producto refers to the inverse side field App\Entity\Producto_ES#crossReferences which does not exist.
App\Entity\Producto	No errors.
App\Entity\Caracteristica_valor	No errors.
App\Entity\Caracteristica	No errors.
App\Entity\DetalleFamiliaCaracteristica	No errors.
App\Entity\ImgSeccionSeo	No errors.

GET https://52.201.159.119/_fragment?_path=_format%3Dhtml%26_locale%3Des%26_controller%3DApp%255CFrontend%255CController%255CSeoViewComponentController%253A%253Aind…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping