Query Metrics
25
Database Queries
18
Different statements
65.97 ms
Query time
2
Invalid entities
45
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
16.22 ms (24.59%) |
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:
[] |
|
10.94 ms (16.58%) |
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:
[ "7143" "7218" "7226" "7243" "1453" "1454" "1455" "1456" "1458" "1459" "1460" "1462" "1463" "1464" "1465" "1467" "1470" "1471" "1473" "1474" "1476" "1477" "1478" "1481" "1482" "1483" "1484" "1485" "1486" "1487" "1489" "1490" "1491" "1493" "1494" "1497" "1498" "1502" "1503" "1504" "1506" "1507" "1508" "1509" "1510" "1513" "1516" "1518" "1520" "1523" "1524" "1525" "1527" "1529" "1531" "1532" "1534" "1537" "1539" "1541" "1543" "1545" "1547" "1549" "1550" "1552" "1554" "1555" "1558" "1559" "1560" "1562" "1563" "1564" "1565" "1566" "1567" "1568" "1570" "1571" "1572" "1573" "1575" "1576" "1577" "1579" "1580" "1581" "1582" "1584" "1586" "1587" "1588" "1590" "1592" "1593" "1597" "1598" "1599" "1601" "1602" "1603" "1604" "1605" "1606" "1607" "1608" "1609" "1610" "1611" "1612" "1613" "1615" "1616" "1617" "1618" "1619" "1620" "1621" "1622" "1623" "1624" "1625" "1626" "1629" "1630" "1632" "1633" "1634" "1637" "1638" "1639" "1641" "1642" "1643" "1645" "1648" "1649" "1650" "1652" "1654" "1655" "1656" "1658" "1663" "1664" "1667" "1672" "1674" "1675" "1676" "1677" "1678" "1679" "1680" "1681" "1682" "1683" "1686" "1687" "1689" "1690" "1691" "1693" "1694" "1695" "1696" "1697" "1698" "1699" "1700" "1701" "1702" "1703" "1704" "1706" "1707" "1709" "1710" "1711" "1712" "1713" "1714" "1715" "1716" "1718" "1720" "1721" "1722" "1723" "1724" "1725" "1726" "1727" "1728" "1729" "1730" "1731" "1732" "1733" "1734" "1735" "1736" "1737" "1740" "1741" "1742" "1743" "1745" "1746" "1750" "1751" "1752" "1755" "1756" "1757" "1758" "1759" "1760" "1762" "1764" "1765" "1767" "1770" "1773" "1775" "1777" "1778" "1779" "1780" "1781" "1783" "1784" "1785" "1787" "1788" "1790" "1791" "1793" "1794" "1796" "1797" "1798" "1800" "1801" "1802" "1803" "1804" "1805" "1806" ] |
|
5.19 ms (7.86%) |
4 |
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
]
|
|
4.86 ms (7.37%) |
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" ] |
|
3.67 ms (5.56%) |
1 |
SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "7143" "7218" "7226" "7243" "1453" "1454" "1455" "1456" "1458" "1459" "1460" "1462" "1463" "1464" "1465" "1467" "1470" "1471" "1473" "1474" "1476" "1477" "1478" "1481" "1482" "1483" "1484" "1485" "1486" "1487" "1489" "1490" "1491" "1493" "1494" "1497" "1498" "1502" "1503" "1504" "1506" "1507" "1508" "1509" "1510" "1513" "1516" "1518" "1520" "1523" "1524" "1525" "1527" "1529" "1531" "1532" "1534" "1537" "1539" "1541" "1543" "1545" "1547" "1549" "1550" "1552" "1554" "1555" "1558" "1559" "1560" "1562" "1563" "1564" "1565" "1566" "1567" "1568" "1570" "1571" "1572" "1573" "1575" "1576" "1577" "1579" "1580" "1581" "1582" "1584" "1586" "1587" "1588" "1590" "1592" "1593" "1597" "1598" "1599" "1601" "1602" "1603" "1604" "1605" "1606" "1607" "1608" "1609" "1610" "1611" "1612" "1613" "1615" "1616" "1617" "1618" "1619" "1620" "1621" "1622" "1623" "1624" "1625" "1626" "1629" "1630" "1632" "1633" "1634" "1637" "1638" "1639" "1641" "1642" "1643" "1645" "1648" "1649" "1650" "1652" "1654" "1655" "1656" "1658" "1663" "1664" "1667" "1672" "1674" "1675" "1676" "1677" "1678" "1679" "1680" "1681" "1682" "1683" "1686" "1687" "1689" "1690" "1691" "1693" "1694" "1695" "1696" "1697" "1698" "1699" "1700" "1701" "1702" "1703" "1704" "1706" "1707" "1709" "1710" "1711" "1712" "1713" "1714" "1715" "1716" "1718" "1720" "1721" "1722" "1723" "1724" "1725" "1726" "1727" "1728" "1729" "1730" "1731" "1732" "1733" "1734" "1735" "1736" "1737" "1740" "1741" "1742" "1743" "1745" "1746" "1750" "1751" "1752" "1755" "1756" "1757" "1758" "1759" "1760" "1762" "1764" "1765" "1767" "1770" "1773" "1775" "1777" "1778" "1779" "1780" "1781" "1783" "1784" "1785" "1787" "1788" "1790" "1791" "1793" "1794" "1796" "1797" "1798" "1800" "1801" "1802" "1803" "1804" "1805" "1806" ] |
|
3.00 ms (4.55%) |
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.72 ms (4.13%) |
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
]
|
|
2.58 ms (3.91%) |
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.13 ms (3.23%) |
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.06 ms (3.12%) |
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:
[] |
|
2.02 ms (3.06%) |
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.89 ms (2.87%) |
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.55 ms (2.35%) |
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.51 ms (2.29%) |
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:
[] |
|
1.51 ms (2.29%) |
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.43 ms (2.16%) |
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.35 ms (2.05%) |
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.34 ms (2.03%) |
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 = ? AND f0_.mostrar = ?
Parameters:
[ "A" "C" 1 ] |
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 | 22 |
| App\Entity\Imagen | 6 |
| App\Entity\FooterColumn | 6 |
| App\Entity\FooterColumnImagen | 6 |
| App\Entity\Banner | 2 |
| App\Entity\SeccionSeo | 1 |
| App\Entity\TipoSeccionSeo | 1 |
| App\Entity\ImgSeccionSeo | 1 |