POST https://52.201.159.119/shop

Query Metrics

25 Database Queries
18 Different statements
65.97 ms Query time
2 Invalid entities
45 Managed entities

Grouped Statements

Show all queries

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

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 No errors.
App\Entity\Caracteristica_valor No errors.
App\Entity\Caracteristica No errors.
App\Entity\DetalleFamiliaCaracteristica No errors.
App\Entity\ImgSeccionSeo No errors.
App\Entity\Marca No errors.
App\Entity\Adjuntos No errors.
App\Entity\DetalleProductoTipoRelacion No errors.
App\Entity\CrossReferences No errors.
App\Entity\DetalleProductoAplicacion No errors.
App\Entity\shopping_cart No errors.
App\Entity\DetalleOrden No errors.
App\Entity\Grupo No errors.
App\Entity\Familia No errors.
App\Entity\Estructura_ecommerce_ES 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\FooterColumn No errors.
App\Entity\FooterColumnTexto No errors.
App\Entity\FooterColumnImagen No errors.
App\Entity\MarcaItemHome No errors.
App\Entity\TipoDocumento No errors.
App\Entity\Aplicacion No errors.
App\Entity\Orden No errors.
App\Entity\Marca_ES No errors.
App\Entity\Familia_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\DetalleProductoAplicacion_ES No errors.
App\Entity\DetalleProductoTipoRelacion_ES No errors.
App\Entity\DetalleValorMarca_ES No errors.
App\Entity\Caracteristica_valor_ES No errors.
App\Entity\EstructuraAplicacion No errors.
App\Entity\Users No errors.
App\Entity\User_ecommerce No errors.
App\Entity\DatosFacturacion No errors.
App\Entity\DatosEntrega No errors.
App\Entity\TipoServicio No errors.
App\Entity\PuntoVenta No errors.
App\Entity\Pago No errors.
App\Entity\CanalContacto No errors.
App\Entity\EstadoOrden No errors.
App\Entity\EstadoServicio No errors.
App\Entity\DetalleFamiliaCaracteristica_ES No errors.
App\Entity\Aplicacion_ES No errors.
App\Entity\Caracteristica_ES No errors.