Query Metrics
25
Database Queries
19
Different statements
77.05 ms
Query time
2
Invalid entities
64
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.46 ms (17.47%) |
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 = ?
Parameters:
[ "" ] |
|
13.42 ms (17.42%) |
1 |
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" ] |
|
10.67 ms (13.85%) |
1 |
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND p1_.cat1 = e0_.id AND p1_.status_eCommerce = 1 AND p1_.status_infor = 1 ORDER BY e0_.Nombres ASC
Parameters:
[] |
|
5.51 ms (7.15%) |
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" ] |
|
4.25 ms (5.52%) |
1 |
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:
[ "" ] |
|
3.75 ms (4.87%) |
1 |
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" ] |
|
3.54 ms (4.60%) |
3 |
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = ?
Parameters:
[
2
]
|
|
3.19 ms (4.14%) |
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.28 ms (2.96%) |
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" ] |
|
2.25 ms (2.92%) |
1 |
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 199 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[] |
|
2.18 ms (2.83%) |
2 |
SELECT t0.id AS id_1, t0.imgNombreServidor AS imgnombreservidor_2, t0.imgNombreAlternativo AS imgnombrealternativo_3, t0.url AS url_4, t0.tipoAperturaUrl AS tipoaperturaurl_5, t0.texto_alternativo_imagen AS texto_alternativo_imagen_6, t0.footer_column_id AS footer_column_id_7 FROM footer_column_imagen t0 WHERE t0.footer_column_id = ?
Parameters:
[
5
]
|
|
1.92 ms (2.49%) |
1 |
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 198 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[] |
|
1.85 ms (2.40%) |
1 |
SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ?
Parameters:
[ "A" 1 ] |
|
1.70 ms (2.21%) |
1 |
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 200 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[] |
|
1.55 ms (2.02%) |
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.44 ms (1.86%) |
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
]
|
|
1.44 ms (1.86%) |
1 |
SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ? ORDER BY f0_.posicion ASC
Parameters:
[ "A" 1 ] |
|
1.42 ms (1.84%) |
1 |
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 201 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[] |
|
1.24 ms (1.61%) |
1 |
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 212 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\FooterColumnTexto | 21 |
| App\Entity\CrossReferences_ES | 12 |
| App\Entity\Producto_ES | 9 |
| App\Entity\Imagen | 6 |
| App\Entity\FooterColumnImagen | 6 |
| App\Entity\FooterColumn | 5 |
| App\Entity\Banner | 2 |
| App\Entity\SeccionSeo | 1 |
| App\Entity\TipoSeccionSeo | 1 |
| App\Entity\ImgSeccionSeo | 1 |