Query Metrics
210
Database Queries
25
Different statements
78.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
43.29 ms (55.44%) |
1 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.products_status = 1 ORDER BY p0_.products_id ASC
Parameters:
[ 706 999 1016 1000 1020 1007 1017 1015 526 707 669 720 1362 708 1824 761 1324 892 1329 1389 491 1391 1501 1103 1390 891 1748 1652 614 1069 1004 519 1799 616 445 628 630 629 1403 632 756 636 522 757 1743 1018 634 528 935 870 1742 523 444 1835 668 671 1392 670 673 739 1486 1485 1804 1429 521 765 1401 525 1432 617 426 1649 465 467 468 469 911 1414 1803 470 1415 1416 1058 1417 682 1418 524 391 1746 1745 1747 1466 946 1110 714 716 715 1376 679 1729 1730 1816 1818 1828 520 1001 693 1031 1032 1033 1034 1100 437 1101 1728 1044 704 436 705 441 1002 913 1836 1419 908 439 776 766 1552 988 934 1487 635 1096 527 1825 ] |
|
14.98 ms (19.19%) |
136 |
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
706
]
|
|
2.71 ms (3.47%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 745 734 778 767 2038 299 2025 1477 2042 1476 429 1365 1679 504 1354 552 1680 1736 551 1166 1168 1169 1167 921 894 935 893 965 1443 1141 735 2155 2152 680 2044 1474 1356 1366 1358 1355 505 2013 2007 2006 1838 971 1170 1722 1671 1672 478 477 1723 1627 1629 1628 1664 1663 544 1013 214 2065 1589 1292 2029 2031 2041 1467 1980 1470 1673 509 1553 1739 1554 2156 1479 2157 2153 2154 960 1171 959 939 958 957 693 498 2230 2064 1556 2063 218 2090 2089 2088 2091 2021 1555 2020 870 754 756 723 539 483 286 2146 2148 1150 547 548 549 550 372 371 503 928 1175 1172 1174 1173 1081 1178 1179 929 1300 1303 711 1755 1964 1391 1392 1393 1394 1153 1154 1055 1977 777 1937 1936 1939 1938 2144 1865 1866 1878 2105 1966 1965 2173 2172 2175 2174 2033 1957 1955 253 101 411 321 2054 2055 2056 1468 1626 1601 1602 340 1533 1584 1585 264 341 1552 1534 265 1631 1701 1632 1702 1700 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 120 1511 1512 1513 1751 106 1346 1269 1280 1291 1335 1562 1698 1563 1796 1797 1798 2098 2077 2097 1801 1802 1803 2099 2101 2085 1522 1523 1789 1788 1790 1791 1793 1519 1743 1683 1682 2022 2024 2058 2057 1711 1621 287 1942 1983 1943 1984 2313 2302 1852 1853 1854 1855 1531 1532 1260 1259 1275 1177 1314 1315 1312 1317 290 40 105 29 72 61 94 50 204 2008 2059 2019 406 225 236 849 246 2170 543 537 37 1063 1064 1078 713 1925 1935 1946 1893 1904 1849 1860 1871 1915 1882 1371 1372 1373 1374 1376 1377 89 1703 1648 541 1890 1891 1473 1892 1894 1895 1896 1559 1560 1448 911 1446 1445 1444 1447 1749 1750 1452 251 45 2084 2130 2131 2132 2133 1690 1691 1588 1165 1176 1157 1733 1187 1198 1209 1734 1220 1735 1231 1032 1590 1591 1592 1593 1594 1681 1595 1596 312 350 1826 1834 1597 1598 1599 1600 317 1616 1542 1704 1705 1543 1561 178 1535 1536 1537 1538 1539 1540 1357 1364 1375 1378 1386 1397 1408 1417 1458 1469 1509 1510 1480 1485 1486 1491 1497 1506 1507 1508 1684 1744 1745 1746 1651 1653 1686 1657 1658 1659 1692 1693 2324 1678 1152 1732 404 405 351 180 1302 1313 1324 103 320 370 409 408 516 410 1911 1920 1934 1784 1785 1786 1787 1764 1765 1766 1767 1768 1514 1515 1546 1516 1517 1518 121 1756 1757 1758 1759 1760 1761 1762 1763 1242 1253 1264 1883 2074 1884 1885 1886 1887 1888 1889 1654 1557 1558 1655 531 536 440 2128 1958 1959 1956 383 2015 378 519 379 354 467 468 469 475 347 324 389 224 226 227 460 2159 1967 1650 1649 1726 1926 2163 164 168 170 165 2151 1997 1979 1620 1583 1699 2108 2150 1950 2093 1859 1665 1724 1457 1737 1861 2096 1862 135 132 1794 1795 495 494 496 209 1577 1578 1741 1740 210 534 540 538 461 2224 1729 44 1974 1753 1730 1731 1752 1754 223 237 2073 1483 1873 1484 188 385 1547 1548 1675 212 375 376 1461 1879 1880 2160 386 507 1644 1645 1710 1646 203 187 189 197 380 391 462 463 1874 1881 1455 1858 1954 1975 1953 1545 1456 1685 215 219 220 221 222 1669 1670 2086 2126 2169 1640 1550 484 2046 1488 2171 304 1642 1641 1674 1551 2053 1489 2127 345 339 1643 305 2047 318 308 431 433 1624 1625 1706 1707 1490 1630 1960 1459 1460 1867 1869 1870 1872 1482 309 922 896 955 930 914 968 1304 1301 1299 961 962 942 944 947 899 900 901 902 943 946 907 966 2211 2212 2214 2216 2217 2218 2219 2213 2215 1402 1403 1404 1405 1406 1407 1409 1395 1396 1398 1399 1400 1401 2220 2221 2222 1410 1411 1412 1413 1414 2235 2236 1385 1387 1388 1389 1390 1380 1381 1382 1383 1384 788 171 925 895 885 879 874 875 83 116 967 945 956 694 702 972 970 695 1367 1370 1368 1369 2161 2168 546 545 403 515 12 33 38 35 271 280 2075 2023 2167 2102 2104 34 1667 2165 2166 1271 1270 1008 1238 1239 1240 1241 1243 1244 1245 1449 923 897 1804 1805 1806 1524 1525 1526 1574 1527 1528 892 1450 1451 691 374 1065 1837 1839 1840 1921 1922 1923 1940 1941 2129 208 454 933 2223 2225 2226 1912 1913 1914 1916 1917 1918 2134 1919 256 1569 1570 1571 998 1606 1607 1603 2227 2228 2229 2231 1074 1067 1076 1075 1139 2070 2051 1049 1047 749 159 161 964 969 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1199 1200 289 2026 2027 2028 2106 2107 2109 1572 1573 1586 1587 1048 2191 1808 1809 1810 1822 1823 1824 1825 1827 1828 1829 1830 1831 1832 1833 2278 2279 2280 2282 2283 1010 1009 1012 2255 2256 2257 186 423 425 424 1054 1844 1845 1846 1847 1848 1850 1851 480 490 511 2232 2233 2234 995 1066 1068 1564 1442 1718 1719 1961 1962 1963 437 448 459 829 426 948 1246 1247 1252 2048 2049 2050 2052 1428 1429 298 1856 1857 1454 1727 1728 1090 1951 1952 301 1033 865 470 838 2125 2114 721 722 796 724 725 726 727 728 729 976 977 917 918 978 1058 1059 2194 2193 2202 2203 2204 2205 2206 1924 973 1505 1504 1999 2000 2001 2002 2003 2004 2005 160 1228 1232 1233 1234 1235 1229 1230 1236 1237 908 1255 1257 951 1219 1218 1221 1222 1223 1224 1225 1227 1226 940 1034 1035 2092 2103 1604 1605 1608 1898 1899 1900 1901 1902 1903 1905 1906 1565 1566 1567 1568 1907 1908 1909 1910 1927 1928 1929 1930 1931 1932 1933 2209 2210 1430 1431 497 41 1694 1695 1472 2298 2299 2300 2301 1072 1162 1163 1609 1610 1611 1612 1613 1614 1615 1487 327 325 1250 1254 1248 1249 1251 1262 1263 1265 1266 1267 1268 1811 1812 1813 1814 1815 1816 1817 1633 1634 1635 1636 1637 1638 1639 1465 361 2238 2249 2260 2270 2281 2291 53 1716 1713 1714 1717 1841 1842 1843 293 1709 1708 2262 2258 2259 2261 2303 1807 706 707 1783 1060 1069 1715 1712 1434 1435 1073 2265 2284 2266 2263 2264 708 709 809 1647 807 847 696 806 1521 419 2304 2305 2306 2307 2308 2309 2310 1453 2207 2208 1792 1877 1875 1863 2140 2010 2011 2009 1944 1947 1945 1876 1996 466 1998 2141 1580 1581 1582 418 2267 2268 2269 2327 2328 2329 2330 2331 2311 2312 2314 2315 2319 2320 2321 2322 2323 2316 2317 2318 1039 1041 1520 1799 1800 2034 2035 2037 2040 2060 2061 2062 996 368 367 369 311 414 415 416 1819 1820 1529 1530 1821 1818 1155 1052 1001 1000 1156 1158 1159 1160 1161 2066 2068 1478 2071 2111 2067 2069 2072 2076 2082 2083 2087 1481 1436 1437 1438 1439 1440 1441 1297 1295 1294 1293 1296 1298 1208 1207 1217 1216 1214 1212 1211 1210 1213 1215 1379 1288 1287 1286 1285 1284 1283 1282 1281 1279 1278 1277 1276 1541 2237 2239 2240 2241 2242 2243 1004 2244 564 571 582 593 604 637 648 659 670 615 626 703 704 27 28 1083 2245 2246 2247 2248 1432 1433 1005 177 179 1544 1151 867 868 1023 2290 1071 1070 2292 2287 2288 2289 2293 2294 2295 2296 2297 2285 2286 1415 1416 2333 481 2110 482 476 393 2045 485 2043 2113 2116 2112 2115 306 2094 2095 2100 2014 1077 2018 1464 2149 42 401 1091 1696 1747 1046 1721 1697 2332 937 2271 2272 2273 2274 2275 2276 2277 1987 1463 49 2195 2196 2197 2198 2199 2200 2201 1084 502 506 2325 2326 1289 1290 1652 2137 1985 1948 1949 2012 1986 2145 2162 1107 1105 1106 1976 1978 523 2138 2135 1687 1688 1689 1656 1981 1982 1988 1989 1738 1549 524 525 526 527 528 530 1725 2164 1273 2016 2017 1272 1864 1575 1666 1622 1576 1668 1579 1623 1660 446 447 127 149 1661 1662 1677 449 1897 1462 1720 2032 1471 2036 1973 500 522 2039 458 1305 1310 1307 1306 1309 1311 1308 1180 1185 1183 1182 1181 1184 1186 1203 1202 1201 1204 1206 1205 ] |
|
2.50 ms (3.21%) |
17 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"VV"
]
|
|
2.00 ms (2.57%) |
1 |
SELECT r0_.id AS id_0, r0_.redirect_url AS redirect_url_1, r0_.target_path AS target_path_2, r0_.target_url AS target_url_3, r0_.redirect_product_id AS redirect_product_id_4, r0_.redirect_category_id AS redirect_category_id_5, r0_.target_product_id AS target_product_id_6, r0_.target_category_id AS target_category_id_7 FROM redirections r0_ WHERE r0_.redirect_product_id = ? OR r0_.redirect_url LIKE ? LIMIT 1
Parameters:
[ 24116 "%product_info.php?products_id=24116&%" ] |
|
1.73 ms (2.21%) |
7 |
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ WHERE m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.type = ? AND m0_.active = 1
Parameters:
[ "2026-10-08 20:17:03" "2026-10-08 20:17:03" "percent-soleil" ] |
|
1.52 ms (1.94%) |
8 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
6936
]
|
|
1.51 ms (1.94%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 39 39 43 43 46 46 48 48 48 51 52 52 52 52 52 52 54 54 54 54 55 55 55 55 56 56 56 56 57 57 57 57 58 58 59 59 59 59 59 60 60 60 60 60 62 62 63 63 63 63 64 64 64 64 65 65 65 98 98 98 98 98 99 99 99 99 100 100 100 100 100 102 102 102 104 104 107 107 107 107 107 107 107 107 111 111 111 111 111 112 112 113 113 113 113 113 113 113 113 114 114 115 115 115 115 115 117 117 118 118 119 119 119 122 122 122 131 131 131 131 133 133 133 133 133 134 134 134 136 136 136 137 137 139 139 139 140 140 140 140 141 141 141 141 142 142 142 143 143 143 143 144 144 144 144 145 145 145 145 146 146 147 147 147 148 148 148 148 148 148 148 150 150 151 151 152 152 153 153 153 153 153 154 154 154 155 155 155 155 155 157 157 157 158 158 158 162 162 162 162 162 162 162 163 163 167 167 169 169 169 172 172 172 173 173 175 175 175 175 175 175 176 176 176 176 176 181 181 181 182 182 183 183 184 184 184 185 185 185 185 185 190 190 190 191 191 191 191 192 192 192 193 194 194 194 195 195 195 195 196 196 198 198 198 198 198 199 199 199 199 200 200 200 202 202 202 202 205 205 206 206 207 207 207 213 213 213 213 216 216 216 217 217 228 228 228 228 229 229 229 229 229 230 230 230 230 231 231 231 231 231 232 232 232 233 233 234 234 234 235 235 247 247 247 247 248 248 248 248 249 249 249 249 250 250 250 250 252 252 252 254 254 254 254 255 255 255 255 258 258 258 259 259 259 259 260 260 260 260 262 262 262 262 263 263 263 263 263 263 263 269 269 269 270 270 272 272 272 273 273 273 274 274 274 275 275 275 275 276 276 276 276 277 277 277 278 278 279 279 281 281 281 282 282 282 282 283 283 283 284 284 284 285 285 288 288 292 292 294 294 294 295 295 295 296 296 296 300 300 302 303 303 310 310 313 313 313 313 313 313 313 313 313 314 314 314 314 314 315 316 319 319 323 323 323 323 323 323 323 326 326 326 326 326 326 326 326 330 330 336 337 337 337 337 337 337 337 338 338 346 346 346 348 348 348 349 349 353 353 353 353 353 355 355 355 357 358 358 358 359 359 359 359 360 362 362 362 362 362 364 364 364 364 364 364 364 364 365 365 365 365 365 366 366 377 377 381 381 382 382 382 387 387 387 388 388 388 390 390 390 390 392 392 392 392 394 394 394 394 396 396 396 396 396 396 396 402 402 407 407 412 412 412 412 413 413 413 413 413 417 417 417 417 420 420 420 420 421 421 421 421 422 422 427 427 427 428 428 430 430 432 434 434 434 434 434 435 435 435 436 436 436 436 436 438 438 441 441 441 441 441 441 442 442 443 443 444 444 444 450 452 452 452 452 453 453 453 453 453 455 455 456 456 457 457 464 464 465 465 471 471 471 472 472 473 473 473 474 474 479 479 479 486 486 487 487 493 493 493 499 499 501 508 508 510 510 514 514 514 517 517 518 518 518 518 518 518 520 520 529 529 532 532 533 533 535 535 535 542 542 542 542 542 553 553 553 554 554 555 555 556 556 697 697 697 697 697 697 697 699 699 701 839 839 839 839 866 866 890 890 890 890 891 891 898 898 898 898 898 898 898 903 903 903 903 903 903 904 904 904 904 904 904 905 905 906 906 909 909 910 910 910 910 910 912 912 912 913 913 913 913 915 915 915 915 915 915 916 916 916 916 916 916 919 919 919 919 919 919 919 920 920 920 920 920 920 920 924 926 927 927 927 927 927 927 931 932 932 932 932 932 932 932 932 932 934 934 934 934 934 934 936 938 938 938 938 938 938 938 938 941 941 941 941 949 949 949 949 949 949 949 949 949 950 950 952 952 952 952 952 952 952 952 952 953 953 953 953 953 953 954 954 954 954 963 963 963 963 963 963 975 979 979 980 980 980 980 980 980 980 981 981 982 982 983 984 984 985 985 986 986 986 986 986 986 986 986 986 987 987 987 987 987 987 988 988 988 989 989 989 990 990 990 990 990 991 991 991 991 991 991 991 992 992 992 992 993 993 994 997 997 997 997 997 999 999 1002 1002 1002 1002 1002 1003 1003 1006 1006 1006 1006 1011 1011 1011 1014 1014 1014 1014 1015 1015 1015 1016 1016 1016 1017 1017 1017 1018 1018 1018 1018 1018 1019 1019 1019 1019 1019 1019 1019 1020 1020 1020 1020 1020 1021 1021 1022 1022 1024 1024 1024 1025 1025 1026 1026 1026 1026 1026 1027 1027 1028 1028 1029 1029 1029 1030 1030 1030 1031 1036 1036 1036 1036 1037 1037 1037 1038 1038 1038 1038 1038 1040 1040 1042 1042 1042 1042 1042 1043 1044 1044 1045 1045 1045 1050 1050 1050 1050 1051 1051 1053 1053 1056 1056 1057 1057 1061 1061 1062 1062 1079 1079 1094 1095 1095 1095 1095 1095 1096 1096 1096 1142 1142 ] |
|
1.42 ms (1.82%) |
7 |
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
15499
]
|
|
1.40 ms (1.80%) |
7 |
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters:
[ 15499 "2026-10-08 20:17:03" "2026-10-08 20:17:03" ] |
|
1.07 ms (1.36%) |
7 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.products_id AS products_id_3, t0.price_group_id AS price_group_id_4 FROM product_prices t0 WHERE t0.products_id = ?
Parameters:
[
15499
]
|
|
0.62 ms (0.80%) |
2 |
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.is_default_variant AS is_default_variant_66, t0.products_parent_id AS products_parent_id_67, t0.products_model_id AS products_model_id_68, t0.manufacturers_id AS manufacturers_id_69, t0.products_tax_class_id AS products_tax_class_id_70 FROM products t0 WHERE t0.products_id = ?
Parameters:
[
"24116"
]
|
|
0.44 ms (0.57%) |
1 |
SELECT p0_.products_id AS products_id_0, p0_.products_quantity AS products_quantity_1, p0_.products_model AS products_model_2, p0_.products_model_sap AS products_model_sap_3, p0_.products_ean AS products_ean_4, p0_.products_image AS products_image_5, p0_.products_image_med AS products_image_med_6, p0_.products_image_lrg AS products_image_lrg_7, p0_.products_image_sm_1 AS products_image_sm_1_8, p0_.products_image_xl_1 AS products_image_xl_1_9, p0_.products_image_sm_2 AS products_image_sm_2_10, p0_.products_image_xl_2 AS products_image_xl_2_11, p0_.products_image_sm_3 AS products_image_sm_3_12, p0_.products_image_xl_3 AS products_image_xl_3_13, p0_.products_image_sm_4 AS products_image_sm_4_14, p0_.products_image_xl_4 AS products_image_xl_4_15, p0_.products_image_sm_5 AS products_image_sm_5_16, p0_.products_image_xl_5 AS products_image_xl_5_17, p0_.products_image_sm_6 AS products_image_sm_6_18, p0_.products_image_xl_6 AS products_image_xl_6_19, p0_.products_price AS products_price_20, p0_.products_ecotax AS products_ecotax_21, p0_.products_date_added AS products_date_added_22, p0_.products_last_modified AS products_last_modified_23, p0_.products_date_available AS products_date_available_24, p0_.products_weight AS products_weight_25, p0_.products_status AS products_status_26, p0_.products_ordered AS products_ordered_27, p0_.products_price1 AS products_price1_28, p0_.products_price2 AS products_price2_29, p0_.products_price3 AS products_price3_30, p0_.products_price4 AS products_price4_31, p0_.products_price5 AS products_price5_32, p0_.products_price6 AS products_price6_33, p0_.products_price7 AS products_price7_34, p0_.products_price8 AS products_price8_35, p0_.products_price9 AS products_price9_36, p0_.products_price10 AS products_price10_37, p0_.products_price11 AS products_price11_38, p0_.products_price1_qty AS products_price1_qty_39, p0_.products_price2_qty AS products_price2_qty_40, p0_.products_price3_qty AS products_price3_qty_41, p0_.products_price4_qty AS products_price4_qty_42, p0_.products_price5_qty AS products_price5_qty_43, p0_.products_price6_qty AS products_price6_qty_44, p0_.products_price7_qty AS products_price7_qty_45, p0_.products_price8_qty AS products_price8_qty_46, p0_.products_price9_qty AS products_price9_qty_47, p0_.products_price10_qty AS products_price10_qty_48, p0_.products_price11_qty AS products_price11_qty_49, p0_.products_qty_blocks AS products_qty_blocks_50, p0_.products_soleil AS products_soleil_51, p0_.products_limite_panier AS products_limite_panier_52, p0_.products_page AS products_page_53, p0_.products_garantie AS products_garantie_54, p0_.products_cat AS products_cat_55, p0_.products_index AS products_index_56, p0_.products_mvente AS products_mvente_57, p0_.products_strategique AS products_strategique_58, p0_.products_reappro_non AS products_reappro_non_59, p0_.products_multiple AS products_multiple_60, p0_.products_origin AS products_origin_61, p0_.products_gift AS products_gift_62, p0_.products_type AS products_type_63, p0_.products_welcome AS products_welcome_64, p0_.is_default_variant AS is_default_variant_65, p0_.products_parent_id AS products_parent_id_66, p0_.products_model_id AS products_model_id_67, p0_.manufacturers_id AS manufacturers_id_68, p0_.products_tax_class_id AS products_tax_class_id_69 FROM products p0_ WHERE p0_.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 152 210 227 275 279 283 301 303 339 347 ] |
|
0.37 ms (0.48%) |
2 |
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
24116
]
|
|
0.34 ms (0.44%) |
1 |
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.is_default_variant AS is_default_variant_66, t0.products_parent_id AS products_parent_id_67, t0.products_model_id AS products_model_id_68, t0.manufacturers_id AS manufacturers_id_69, t0.products_tax_class_id AS products_tax_class_id_70 FROM products t0 WHERE t0.products_model_id = ?
Parameters:
[
178
]
|
|
0.28 ms (0.36%) |
2 |
SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.languages_id = ?
Parameters:
[
4
]
|
|
0.28 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[] |
|
0.27 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_label AS products_label_4, t0.products_heading_title AS products_heading_title_5, t0.products_short_description AS products_short_description_6, t0.products_description AS products_description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_teaser AS products_teaser_13, t0.products_op AS products_op_14, t0.products_top AS products_top_15, t0.products_new AS products_new_16, t0.products_video AS products_video_17, t0.products_video2 AS products_video2_18, t0.products_conseil1 AS products_conseil1_19, t0.products_conseil2 AS products_conseil2_20, t0.products_conseil_cat AS products_conseil_cat_21, t0.products_notice AS products_notice_22, t0.products_notice2 AS products_notice2_23, t0.doofinder_boost AS doofinder_boost_24, t0.doofinder_indexed_text AS doofinder_indexed_text_25, t0.products_categorie AS products_categorie_26, t0.products_tags AS products_tags_27, t0.products_id AS products_id_28, t0.language_id AS language_id_29 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
24116
]
|
|
0.25 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3, t0.label AS label_4, t0.heading_title AS heading_title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_video AS products_video_13, t0.products_conseil1 AS products_conseil1_14, t0.products_notice AS products_notice_15, t0.products_tags AS products_tags_16, t0.products_models_id AS products_models_id_17, t0.language_id AS language_id_18 FROM products_models_description t0 WHERE t0.products_models_id = ?
Parameters:
[
178
]
|
|
0.22 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = ?
Parameters:
[
706
]
|
|
0.19 ms (0.24%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.date_added AS date_added_3, t0.last_modified AS last_modified_4, t0.status AS status_5, t0.parent_id AS parent_id_6, t0.manufacturers_id AS manufacturers_id_7, t0.variant_id AS variant_id_8 FROM products_models t0 WHERE t0.parent_id = ?
Parameters:
[
178
]
|
|
0.17 ms (0.22%) |
1 |
SELECT p0_.id AS id_0, p0_.products_id AS products_id_1, p0_.categories_id AS categories_id_2 FROM products_to_categories p0_ INNER JOIN products p1_ ON p0_.products_id = p1_.products_id WHERE p0_.products_id = ?
Parameters:
[
24116
]
|
|
0.17 ms (0.22%) |
1 |
SELECT t0.manufacturers_id AS manufacturers_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.manufacturers_name AS manufacturers_name_3, t0.manufacturers_image AS manufacturers_image_4, t0.date_added AS date_added_5, t0.last_modified AS last_modified_6, t0.manufacturers_statuts AS manufacturers_statuts_7, t0.manufacturers_order AS manufacturers_order_8, t0.manufacturers_locked_price AS manufacturers_locked_price_9, t0.manufacturers_welcome AS manufacturers_welcome_10, t0.manufacturers_export AS manufacturers_export_11, t0.manufacturers_no_soleil AS manufacturers_no_soleil_12 FROM manufacturers t0 WHERE t0.manufacturers_id = ?
Parameters:
[
192
]
|
|
0.17 ms (0.21%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.date_added AS date_added_3, t0.last_modified AS last_modified_4, t0.status AS status_5, t0.parent_id AS parent_id_6, t0.manufacturers_id AS manufacturers_id_7, t0.variant_id AS variant_id_8 FROM products_models t0 WHERE t0.id = ?
Parameters:
[
178
]
|
|
0.14 ms (0.18%) |
1 |
SELECT p0_.id AS id_0, p0_.sort_order AS sort_order_1, p0_.products_id AS products_id_2, p0_.xsell_id AS xsell_id_3 FROM products_xsell p0_ INNER JOIN products p1_ ON p0_.xsell_id = p1_.products_id WHERE p0_.products_id = ? AND p1_.products_status = 1 ORDER BY p0_.sort_order ASC
Parameters:
[
24116
]
|
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.