125 |
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc1.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac USE INDEX (PRIMARY)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (678,679,680,681,682,684,685,687,689,690,691,692,693,694,695,696,697,700,701,702,703,704,706,708,710,712,713,714,716,720,723,724,725,729,731,862,863,865,867,869,870,871,872,873,874,875,876,878,879,880,881,883,884,886,888,890,891,892,893,894,895,896,897,898,899,901,902,903,904,906,907,909,910,911,912,913,914,915,916,917,918,919,920,921,923,928,930,931,932,933,935,937,939,941,943,944,947,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,965,966,967,968,970,972,973,974,975,976,977,979,980,981,983,985,986,987,988,991,1006,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1026,1027,1028,1029,1030,1032,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1056,1057,1058,1059,1060,1068,1088,1108,1113,1114,1116,1128,1129,1136,1137,1140,1143,1144,1145,1146,1147,1148,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1179,1180,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1219,1220,1222,1223,1224,1225,1226,1227,1229,1230,1231,1233,1234,1235,1236,1237,1238,1239,1240,1243,1244,1245,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1261,1263,1264,1265,1267,1268,1270,1271,1272,1275,1277,1280,1281,1282,1284,1285,1286,1287,1288,1289,1290,1291,1292,1294,1295,1297,1298,1299,1300,1302,1304,1305,1306,1308,1309,1310,1311,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1343,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1360,1361,1362,1363,1364,1366,1367,1369,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1387,1388,1389,1390,1391,1392,1393,1394,1395,1397,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1415,1416,1417,1418,1420,1421,1422,1423,1425,1426,1427,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1449,1450,1451,1452,1453,1454,1455,1458,1460,1461,1463,1464,1466,1467,1468,1469,1470,1471,1473,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1500,1502,1503,1504,1505,1506,1508,1510,1511,1513,1514,1515,1516,1518,1520,1521,1522,1523,1524,1525,1526,1528,1529,1530,1531,1534,1536,1537,1538,1539,1540,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1562,1563,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1580,1581,1582,1583,1584,1585,1586,1588,1590,1591,1592,1593,1594,1595,1597,1599,1600,1603,1604,1605,1606,1609,1610,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1630,1631,1633,1635,1637,1638,1639,1641,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1656,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1676,1677,1678,1679,1680,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1701,1702,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1768,1771,1772,1774,1776,1778,1781,1782,1783,1784,1785,1787,1788,1792,1794,1795,1797,1798,1800,1801,1802,1803,1804,1805,1807,1808,1809,1810,1812,1813,1814,1815,1816,1817,1819,1821,1822,1824,1826,1828,1830,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1848,1850,1853,1854,1855,1856,1858,1859,1860,1861,1862,1863,1864,1866,1867,1868,1869,1872,1873,1875,1876,1877,1878,1880,1881,1882,1883,1884,1885,1886,1888,1889,1891,1893,1895,1896,1898,1901,1904,1905,1908,1910,1911,1912,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1928,1929,1930,1931,1932,1933,1934,1936,1945,1946,1947,1948)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc1 ON ( acp.`id_cache_product` = acpc1.`id_cache_product` AND acpc1.`id_criterion` IN (370))
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (678,679,680,681,682,684,685,687,689,690,691,692,693,694,695,696,697,700,701,702,703,704,706,708,710,712,713,714,716,720,723,724,725,729,731,862,863,865,867,869,870,871,872,873,874,875,876,878,879,880,881,883,884,886,888,890,891,892,893,894,895,896,897,898,899,901,902,903,904,906,907,909,910,911,912,913,914,915,916,917,918,919,920,921,923,928,930,931,932,933,935,937,939,941,943,944,947,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,965,966,967,968,970,972,973,974,975,976,977,979,980,981,983,985,986,987,988,991,1006,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1026,1027,1028,1029,1030,1032,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1056,1057,1058,1059,1060,1068,1088,1108,1113,1114,1116,1128,1129,1136,1137,1140,1143,1144,1145,1146,1147,1148,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1179,1180,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1219,1220,1222,1223,1224,1225,1226,1227,1229,1230,1231,1233,1234,1235,1236,1237,1238,1239,1240,1243,1244,1245,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1261,1263,1264,1265,1267,1268,1270,1271,1272,1275,1277,1280,1281,1282,1284,1285,1286,1287,1288,1289,1290,1291,1292,1294,1295,1297,1298,1299,1300,1302,1304,1305,1306,1308,1309,1310,1311,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1343,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1360,1361,1362,1363,1364,1366,1367,1369,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1387,1388,1389,1390,1391,1392,1393,1394,1395,1397,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1415,1416,1417,1418,1420,1421,1422,1423,1425,1426,1427,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1449,1450,1451,1452,1453,1454,1455,1458,1460,1461,1463,1464,1466,1467,1468,1469,1470,1471,1473,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1500,1502,1503,1504,1505,1506,1508,1510,1511,1513,1514,1515,1516,1518,1520,1521,1522,1523,1524,1525,1526,1528,1529,1530,1531,1534,1536,1537,1538,1539,1540,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1562,1563,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1580,1581,1582,1583,1584,1585,1586,1588,1590,1591,1592,1593,1594,1595,1597,1599,1600,1603,1604,1605,1606,1609,1610,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1630,1631,1633,1635,1637,1638,1639,1641,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1656,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1676,1677,1678,1679,1680,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1701,1702,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1768,1771,1772,1774,1776,1778,1781,1782,1783,1784,1785,1787,1788,1792,1794,1795,1797,1798,1800,1801,1802,1803,1804,1805,1807,1808,1809,1810,1812,1813,1814,1815,1816,1817,1819,1821,1822,1824,1826,1828,1830,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1848,1850,1853,1854,1855,1856,1858,1859,1860,1861,1862,1863,1864,1866,1867,1868,1869,1872,1873,1875,1876,1877,1878,1880,1881,1882,1883,1884,1885,1886,1888,1889,1891,1893,1895,1896,1898,1901,1904,1905,1908,1910,1911,1912,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1928,1929,1930,1931,1932,1933,1934,1936,1945,1946,1947,1948)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
AND ac.`id_criterion_group` = 6
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC |
2.494
ms
|
6 |
Yes
|
|
/modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
/modules/pm_advancedsearch4/classes/SearchEngineUtils.php:1374 (query)
/modules/pm_advancedsearch4/pm_advancedsearch4.php:2618 (getCriterionsForSearchBloc)
/modules/pm_advancedsearch4/pm_advancedsearch4.php:2909 (getCriterionsGroupsAndCriterionsForSearch)
/modules/pm_advancedsearch4/pm_advancedsearch4.php:3033 (assignSearchVar)
/classes/Hook.php:1043 (hookDisplayHeader)
/tools/profiling/Hook.php:35 (coreCallHook)
/classes/Hook.php:418 (coreCallHook)
/classes/Hook.php:981 (callHookOn)
/classes/controller/FrontController.php:580 (exec)
/controllers/front/listing/ManufacturerController.php:86 (initContent)
/tools/profiling/Controller.php:60 (initContent)
/classes/Dispatcher.php:510 (run)
/index.php:40 (dispatch)
|
128 |
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc1.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac USE INDEX (PRIMARY)
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,676,698,709,711,715,718,719,722,730,882,908,922,924,925,926,927,929,934,936,938,940,942,946,964,969,971,978,982,984,989,990,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1034,1035,1036,1037,1038,1039,1040,1063,1065,1066,1076,1077,1079,1093,1095,1097,1101,1102,1104,1105,1107,1120,1125,1126,1130,1132,1134,1139,1141,1142,1149,1181,1217,1218,1221,1228,1232,1242,1246,1260,1273,1274,1276,1278,1279,1283,1301,1303,1307,1312,1342,1344,1386,1396,1414,1448,1465,1474,1499,1501,1509,1527,1533,1535,1587,1589,1602,1612,1632,1634,1640,1642,1655,1657,1681,1700,1735,1736,1737,1752,1767,1769,1770,1773,1777,1780,1790,1909,1913,1914,1935,1937,1938,1939,1940,1941,1942,1943,1944,3132,3137,3138,3139,3141,3143,3153,3154,3155,3156,3157,3159,3161,3166)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc1 ON ( acp.`id_cache_product` = acpc1.`id_cache_product` AND acpc1.`id_criterion` IN (370))
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,676,698,709,711,715,718,719,722,730,882,908,922,924,925,926,927,929,934,936,938,940,942,946,964,969,971,978,982,984,989,990,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1034,1035,1036,1037,1038,1039,1040,1063,1065,1066,1076,1077,1079,1093,1095,1097,1101,1102,1104,1105,1107,1120,1125,1126,1130,1132,1134,1139,1141,1142,1149,1181,1217,1218,1221,1228,1232,1242,1246,1260,1273,1274,1276,1278,1279,1283,1301,1303,1307,1312,1342,1344,1386,1396,1414,1448,1465,1474,1499,1501,1509,1527,1533,1535,1587,1589,1602,1612,1632,1634,1640,1642,1655,1657,1681,1700,1735,1736,1737,1752,1767,1769,1770,1773,1777,1780,1790,1909,1913,1914,1935,1937,1938,1939,1940,1941,1942,1943,1944,3132,3137,3138,3139,3141,3143,3153,3154,3155,3156,3157,3159,3161,3166)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
AND ac.`id_criterion_group` = 8
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC |
1.367
ms
|
6 |
Yes
|
|
/modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
/modules/pm_advancedsearch4/classes/SearchEngineUtils.php:1374 (query)
/modules/pm_advancedsearch4/pm_advancedsearch4.php:2618 (getCriterionsForSearchBloc)
/modules/pm_advancedsearch4/pm_advancedsearch4.php:2909 (getCriterionsGroupsAndCriterionsForSearch)
/modules/pm_advancedsearch4/pm_advancedsearch4.php:3033 (assignSearchVar)
/classes/Hook.php:1043 (hookDisplayHeader)
/tools/profiling/Hook.php:35 (coreCallHook)
/classes/Hook.php:418 (coreCallHook)
/classes/Hook.php:981 (callHookOn)
/classes/controller/FrontController.php:580 (exec)
/controllers/front/listing/ManufacturerController.php:86 (initContent)
/tools/profiling/Controller.php:60 (initContent)
/classes/Dispatcher.php:510 (run)
/index.php:40 (dispatch)
|