Symfony Profiler

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

Response: 200 OK
Referer: Browse referrer URL
IP: 34.66.4.43
Profiled on: Thu, 03 Sep 2026 03:08:55 -0500
Token: d17599

Query Metrics

13 Database Queries

10 Different statements

265.78 ms Query time

2 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
196.44 ms (73.91%)	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: [`"fjXm"`] 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 = 'fjXm';
22.13 ms (8.33%)	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" "11" "15" "19" "26" "28" "30" "32" "34" "35" "36" "37" "38" "39" "41" "43" "45" "47" "49" "51" "53" "55" "57" "59" "61" "64" "66" "68" "70" "72" "74" "76" "78" "80" "82" "84" "86" "88" "90" "92" "94" "96" "98" "100" "102" "104" "106" "108" "112" "114" "117" "120" "122" "124" "125" "126" "128" "130" "132" "140" "146" "148" "150" "155" "157" "159" "162" "165" "167" "169" "180" "182" "184" "186" "188" "192" "197" "199" "201" "203" "244" "246" "258" "260" "268" "269" "292" "297" "299" "301" "333" "335" "336" "337" "339" "341" "342" "343" "344" "346" "414" "416" "417" "418" "421" "425" "430" "436" "447" "451" "472" "486" "491" "492" "497" "502" "503" "507" "508" "518" "525" "536" "539" "540" "550" "553" "557" "561" "645" "647" "648" "832" "1384" "1386" "1399" "1401" "1403" "1440" "1450" "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"] 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', '11', '15', '19', '26', '28', '30', '32', '34', '35', '36', '37', '38', '39', '41', '43', '45', '47', '49', '51', '53', '55', '57', '59', '61', '64', '66', '68', '70', '72', '74', '76', '78', '80', '82', '84', '86', '88', '90', '92', '94', '96', '98', '100', '102', '104', '106', '108', '112', '114', '117', '120', '122', '124', '125', '126', '128', '130', '132', '140', '146', '148', '150', '155', '157', '159', '162', '165', '167', '169', '180', '182', '184', '186', '188', '192', '197', '199', '201', '203', '244', '246', '258', '260', '268', '269', '292', '297', '299', '301', '333', '335', '336', '337', '339', '341', '342', '343', '344', '346', '414', '416', '417', '418', '421', '425', '430', '436', '447', '451', '472', '486', '491', '492', '497', '502', '503', '507', '508', '518', '525', '536', '539', '540', '550', '553', '557', '561', '645', '647', '648', '832', '1384', '1386', '1399', '1401', '1403', '1440', '1450', '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') ORDER BY p0_.id ASC, d2_.posicion ASC;
17.41 ms (6.55%)	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: [`"fjXm"`] 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 = 'fjXm';
9.77 ms (3.68%)	1	SELECT count(p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.status_eCommerce = 1 AND p0_.status_infor = 1 Parameters: [] View formatted query View runnable query Explain query SELECT count(p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.status_eCommerce = 1 AND p0_.status_infor = 1 SELECT count(p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.status_eCommerce = 1 AND p0_.status_infor = 1;
6.74 ms (2.54%)	1	SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["5" "9" "11" "15" "19" "26" "28" "30" "32" "34" "35" "36" "37" "38" "39" "41" "43" "45" "47" "49" "51" "53" "55" "57" "59" "61" "64" "66" "68" "70" "72" "74" "76" "78" "80" "82" "84" "86" "88" "90" "92" "94" "96" "98" "100" "102" "104" "106" "108" "112" "114" "117" "120" "122" "124" "125" "126" "128" "130" "132" "140" "146" "148" "150" "155" "157" "159" "162" "165" "167" "169" "180" "182" "184" "186" "188" "192" "197" "199" "201" "203" "244" "246" "258" "260" "268" "269" "292" "297" "299" "301" "333" "335" "336" "337" "339" "341" "342" "343" "344" "346" "414" "416" "417" "418" "421" "425" "430" "436" "447" "451" "472" "486" "491" "492" "497" "502" "503" "507" "508" "518" "525" "536" "539" "540" "550" "553" "557" "561" "645" "647" "648" "832" "1384" "1386" "1399" "1401" "1403" "1440" "1450" "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"] 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', '11', '15', '19', '26', '28', '30', '32', '34', '35', '36', '37', '38', '39', '41', '43', '45', '47', '49', '51', '53', '55', '57', '59', '61', '64', '66', '68', '70', '72', '74', '76', '78', '80', '82', '84', '86', '88', '90', '92', '94', '96', '98', '100', '102', '104', '106', '108', '112', '114', '117', '120', '122', '124', '125', '126', '128', '130', '132', '140', '146', '148', '150', '155', '157', '159', '162', '165', '167', '169', '180', '182', '184', '186', '188', '192', '197', '199', '201', '203', '244', '246', '258', '260', '268', '269', '292', '297', '299', '301', '333', '335', '336', '337', '339', '341', '342', '343', '344', '346', '414', '416', '417', '418', '421', '425', '430', '436', '447', '451', '472', '486', '491', '492', '497', '502', '503', '507', '508', '518', '525', '536', '539', '540', '550', '553', '557', '561', '645', '647', '648', '832', '1384', '1386', '1399', '1401', '1403', '1440', '1450', '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');
4.99 ms (1.88%)	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"`] 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';
3.02 ms (1.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`] 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;
2.23 ms (0.84%)	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"`] 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;
1.62 ms (0.61%)	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"`] 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;
1.43 ms (0.54%)	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`] 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\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\Producto	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\Caracteristica_valor	No errors.
App\Entity\Caracteristica	No errors.
App\Entity\DetalleFamiliaCaracteristica	No errors.
App\Entity\ImgSeccionSeo	No errors.