191 |
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`,
IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-04 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `psgh_product` p
INNER JOIN psgh_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psgh_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN psgh_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
LEFT JOIN `psgh_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1
)
LEFT JOIN `psgh_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `psgh_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `psgh_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND p.`id_product` IN (53, 54, 56, 57, 62, 63, 624, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 806, 808, 809, 810, 807, 893, 895, 943, 341, 460, 344, 345, 348, 359, 365, 488, 373, 377, 378, 963, 976, 459, 467, 468, 354, 355, 472, 474, 358, 478, 363, 366, 367, 368, 369, 480, 482, 483, 484, 485, 486, 491, 492, 493, 496, 499, 500, 464, 476, 353, 351, 352, 376, 469, 360, 364, 498, 1041, 974, 814, 395, 539, 538, 531, 1030, 1031, 1032, 837, 732, 736, 737, 734, 865, 838, 722, 269, 293, 297, 242, 240, 235, 236, 249, 237, 239, 312, 257, 259, 238, 258, 553, 552, 972, 971, 995, 266, 559, 560, 251, 311, 254, 260, 999, 1000, 983, 982, 979, 577, 576, 1003, 954, 953, 966, 989, 1002, 567, 564, 562, 556, 546, 545, 542, 541, 945, 1017, 1023, 573, 519, 951, 289, 965, 1019, 361, 596, 569, 547, 1025, 831, 842, 927, 1033, 852, 823, 307, 287, 267, 231, 224, 568, 572, 233, 849, 864, 718, 856, 729, 717, 932, 931, 438, 390, 869, 898, 1039, 305, 490, 385, 291, 292, 325, 268, 304, 265, 939, 313, 320, 321, 316, 263, 317, 262, 290, 296, 941, 443, 415, 392, 393, 410, 405, 1010, 510, 511, 524, 513, 522, 1021, 247, 270, 275, 967, 309, 310, 726, 725, 881, 873, 894, 874, 853, 836, 847, 867, 868, 738, 741, 835, 827, 721, 733, 323, 324, 329, 331, 876, 714, 897, 1026, 299, 300, 566, 565, 830, 1042, 889, 1053, 1048, 743, 888, 1050, 829, 926, 828, 846, 841, 716, 840, 1051, 504, 505, 1056, 1055, 1058, 1059, 1057, 294, 942, 544, 581, 579, 603, 261, 248, 264, 246, 245, 525, 521, 520, 528, 518, 502, 503, 526, 507, 523, 540, 600, 599, 598, 543, 877, 1061, 857, 1060, 833, 880, 862, 272, 302, 243, 306, 271, 301, 244, 1012, 1014, 452, 425, 550, 549, 548, 551, 990, 981, 980, 1022, 461, 315, 563, 597, 537, 561, 570, 571, 1005, 322, 347, 349, 962, 988, 985, 994, 949, 948, 997, 996, 282, 283, 284, 285, 255, 234, 362, 527, 530, 515, 938, 534, 532, 314, 574, 225, 991, 375, 328, 391, 382, 436, 454, 414, 396, 388, 412, 409, 394, 446, 420, 453, 407, 397, 399, 437, 426, 444, 447, 418, 403, 433, 430, 419, 428, 380, 417, 401, 411, 386, 432, 379, 422, 398, 400, 431, 402, 424, 423, 429, 221, 860, 434, 1064, 334, 337, 723, 1067, 555, 731, 295, 487, 298, 1035, 413, 845, 455, 1001, 339, 928, 1086, 1082, 1083, 516, 1071, 230, 824, 1043, 356, 383, 494, 892, 1007, 1028, 1027, 343, 509, 947, 992, 859, 937, 883, 851, 848, 495, 843, 318, 319, 875, 448, 371, 372, 227, 1040, 929, 557, 960, 968, 613, 959, 958, 961, 957, 993, 223, 956, 955, 984, 977, 252, 303, 253, 387, 389, 969, 870, 1093, 1092, 514, 241, 933, 844, 1090, 1089, 1088, 1087, 1013, 1011, 1020, 442, 441, 439, 863, 501, 866, 1085, 1122, 1096, 1099, 602, 1137, 1136, 1134, 1129, 1128, 1127, 1126, 1124, 1119, 1116, 1114, 1112, 1111, 1110, 1108, 1107, 1105, 1103, 1101, 1063, 1097, 445, 1102, 964, 882, 1004, 232, 335, 890, 855, 854, 950, 1034, 281, 256, 250, 1155, 1156, 1157, 1161, 1162, 1163, 1166, 1176, 1175, 1185, 1184, 1183, 1182, 1181, 1180, 1179, 1177, 1077, 1173, 1174, 1160, 1158, 1170, 1074, 536, 1131, 1148, 998, 1094, 1095, 1188, 1207, 1211, 1212, 1213, 1214, 1218, 1189, 1192, 1195, 1198, 1200, 1201, 1199, 1228, 1224, 1226, 1144, 1225, 1146, 1109, 1209, 1132, 1229, 1143, 1150, 1133, 1135, 1106, 1164, 1104, 1186, 1142, 1113, 1230, 1231, 1149, 946, 1215, 1221, 1217, 1222, 1220, 529, 1049, 1172, 1169, 370, 222, 1046, 1219, 1147, 1145, 1232, 1281, 1285, 1238, 1288, 1289, 1247, 1293, 1297, 1299, 1300, 1301, 1303, 1304, 1305, 1306, 1262, 1264, 1265, 1266, 1268, 1269, 1307, 1308, 1271, 1272, 1274, 1275, 1276, 1309, 1263, 1314, 1315, 1317, 1319, 1072, 1167, 1310, 1292, 1291, 1287, 1284, 1318, 517, 987, 1321, 449, 450, 1330, 1335, 1336, 1337, 1332, 1334, 1333, 470, 1331, 578, 1037, 475, 346, 1141, 462, 805, 978, 1130, 1384, 1387, 1388, 1395, 1398, 1399, 1400, 1401, 1407, 1408, 1412, 1413, 1415, 1416, 1417, 1418, 1419, 1421, 1423, 1425, 1426, 1427, 1428, 1429, 1431, 1432, 1433, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1445, 1446, 1447, 1448, 1459, 1452, 1458, 1457, 1454, 1451, 1422, 1404, 1402, 1397, 1391, 1420, 1194, 1081, 1410, 1409, 1411, 1178, 826, 1405, 1196, 1462, 1461, 1460, 575, 1386, 1472, 1471, 1475, 1473, 1140, 813, 1392, 1477, 1479, 887, 1480, 1076, 896, 986, 479, 456, 1241, 1024, 1478, 1484, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1450, 381, 1312, 338, 944, 1152, 473, 1491, 1492, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1505, 1506, 1507, 1503, 936, 1511, 1512, 1514, 1515, 489, 850, 1283, 1513, 1518, 1282, 1338, 858, 404, 1519, 1520, 1521, 1524, 1531, 1532, 1534, 1536, 1538, 1523, 1529, 1530, 1525, 1526, 1527, 1528, 1313, 416, 1540, 477, 1522, 1396, 1029, 1091, 720, 458, 735, 1009, 497, 1541, 1208, 925, 1080, 1539, 1424, 839, 975, 1543, 1493, 1544, 1545, 1547, 1548, 1504, 1550, 1551, 1553, 1554, 1555, 1556, 1557, 1558, 1560, 1561, 1562, 1565, 1115, 327, 288, 1568, 1069, 1569, 1570, 1571, 1572, 1517, 1316, 1573, 533, 1294, 1574, 226, 1066, 1575, 1015, 1577, 228, 970, 1047, 340, 1490, 229, 1455, 558, 1223, 1476, 330, 1566, 1390, 1068, 1197, 1403, 1537, 719, 1552, 336, 1621, 1622, 1623, 1624, 1625, 1626, 1627, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1636, 1637, 1639, 1640, 1642, 1646, 1647, 1648, 1649, 1651, 1652, 1653, 1654, 1655, 1656, 1657, 1658, 1661, 1662, 1663, 1650, 1385, 1664, 1290, 1008, 878, 1564, 1682, 1692, 1697, 1698, 1693, 1683, 1691, 1688, 1689, 1690, 1036, 1474, 1193, 1659, 1685, 1684, 1695, 1696, 1707, 1708, 1711, 1710, 1470, 1227, 952, 812, 357, 273, 1073, 1298, 1302, 1430, 1078, 728, 508, 1206, 1714, 1715, 1716, 1718, 1719, 1720, 1717, 1722, 1723, 1641, 973, 834, 1638, 1311, 1694, 1725, 1726, 1727, 1724, 1016, 1644, 1645, 832, 1295, 825, 1729, 1533, 1686, 1123, 1389, 1406, 1205, 715, 1508, 1509, 1495, 342, 466, 1139, 1100, 1713, 935, 595, 471, 1730, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 884, 1168, 481, 1153, 1154, 1125, 1210, 274, 333, 23, 1709, 1660, 1204, 1414, 1054, 1191, 308, 740, 1151, 1394, 1202, 1393, 1567, 1203, 934, 427, 506, 1118, 374, 1117, 861, 594, 1171, 535, 554, 1449, 1062, 1434, 1286, 1643, 1563, 1740, 1741, 1742, 1743, 1751, 1756, 1757, 1758, 1759, 1760, 1761, 1762, 1763, 1764, 1765, 1766, 1767, 1768, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1750, 1749, 1748, 1747, 1746, 1745, 1535, 1744, 1098, 451, 435, 879, 384, 440, 1456, 886, 872, 871, 1778, 326, 739, 1065, 1006, 1296, 1687, 1052, 457, 730, 1752, 1753, 1755, 1754, 1084, 421, 463, 1728, 1559, 286, 1038, 940, 1159, 744, 350, 1165, 885, 1045, 1044, 1079, 891, 1780, 1781, 1782, 1783, 1784, 1785, 1786, 1787, 1788, 1542, 1779, 727, 406, 1510, 1070, 465, 724, 1138, 601, 1546, 580, 512, 1721, 1018, 1121, 1120, 1216, 1453)
AND EXISTS(SELECT 1 FROM `psgh_category_product` cp
JOIN `psgh_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1)
WHERE cp.`id_product` = p.`id_product`) |
70.230
ms
|
2512458 |
|
|
/classes/Product.php:3393
/modules/ps_specials/ps_specials.php:230 (getPricesDrop)
/modules/ps_specials/ps_specials.php:213 (getSpecialProducts)
/modules/ps_specials/ps_specials.php:199 (getWidgetVariables)
/classes/Hook.php:1054 (renderWidget)
/tools/profiling/Hook.php:64 (coreRenderWidget)
/classes/Hook.php:1000 (coreRenderWidget)
/controllers/front/IndexController.php:40 (exec)
/tools/profiling/Controller.php:60 (initContent)
/classes/Dispatcher.php:510 (run)
/override/classes/Dispatcher.php:40 (dispatch)
/index.php:28 (dispatch)
|