Время запроса: 22.50 ms После последнего запроса: 0.33 ms Память запроса: 0.915 MB Память до запроса: 43.178 MB Выбрано строк: 1022
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name,
prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.image as image,
prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price,
prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits,
prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id,
prod.min_price, prod.product_quantity, prod.different_prices
FROM `smkrs_jshopping_products` AS prod
INNER JOIN `smkrs_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = prod.product_id
LEFT JOIN `smkrs_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE prod.product_publish = 1
AND cat.category_publish=1
AND prod.product_id IN (62, 459, 179, 63, 3, 7004, 141, 140, 23982, 23, 1384, 139, 170, 22, 13, 31469, 59, 971, 24257, 29639, 134, 7655, 60, 244, 18, 4635, 29495, 1530, 1070, 29496, 204, 810, 21, 1383, 29641, 143, 29594, 1067, 23804, 7651, 29636, 29899, 29637, 133, 86, 29640, 4834, 15, 29643, 7001, 29855, 29853, 29493, 240, 61, 84, 203, 29642, 7002, 12, 25, 132, 128, 1527, 25055, 23697, 458, 98, 24431, 23976, 16, 4634, 97, 23756, 29897, 7652, 334, 6739, 724, 25155, 135, 20, 81, 205, 4628, 74, 20883, 24480, 29494, 29852, 25002, 4631, 29851, 1068, 229, 138, 24, 982, 51, 6834, 83, 29896, 23977, 17, 8757, 15100, 88, 29762, 58, 2039, 247, 175, 1835, 23770, 4617, 52, 1578, 29802, 29690, 24015, 1265, 2431, 1819, 689, 265, 1551, 201, 29854, 206, 210, 137, 23978, 1675, 56, 241, 1065, 4640, 136, 1548, 23962, 1824, 1268, 977, 1178, 1816, 934, 1703, 337, 1815, 23760, 54, 1066, 31484, 792, 23995, 23768, 811, 904, 1726, 24186, 29771, 29647, 243, 29856, 19, 23808, 24518, 18155, 1225, 8458, 147, 26, 23792, 6962, 407, 4630, 1597, 215, 708, 7381, 1705, 782, 1267, 1714, 23996, 4846, 324, 3075, 176, 24265, 8098, 2097, 152, 447, 0, 4642, 77, 29779, 29800, 57, 4641, 231, 518, 23993, 1161, 29770, 775, 24478, 1777, 2669, 4647, 2013, 4881, 1676, 910, 19830, 8097, 6833, 1832, 1355, 82, 24270, 177, 78, 242, 659, 4644, 25015, 23994, 1634, 2427, 4611, 4649, 292, 4629, 327, 875, 126, 8761, 778, 773, 6835, 2315, 1352, 23805, 14, 6741, 87, 5082, 690, 29811, 142, 888, 25152, 30138, 2355, 23769, 1071, 24014, 1618, 8762, 2430, 2099, 1266, 23984, 791, 27891, 849, 29626, 29830, 24972, 29425, 1196, 8792, 99, 1849, 7665, 3725, 429, 1830, 2883, 1356, 27994, 24730, 1493, 7654, 19836, 23824, 8031, 29318, 347, 269, 45, 106, 437, 328, 1242, 24161, 8104, 1073, 29607, 1217, 685, 23781, 8047, 979, 181, 172, 4645, 1755, 676, 2100, 1624, 1522, 1785, 23690, 282, 268, 2829, 291, 24704, 249, 1424, 96, 19833, 107, 1192, 2444, 178, 95, 8549, 305, 19831, 440, 1341, 15149, 4633, 2367, 1542, 117, 911, 395, 13287, 405, 725, 1561, 2826, 957, 2079, 677, 29810, 29648, 789, 23767, 978, 29768, 18095, 1374, 24976, 4622, 75, 1373, 1862, 1343, 2659, 29354, 1120, 898, 3893, 8175, 644, 8182, 21348, 1670, 420, 108, 1620, 683, 13286, 254, 4898, 144, 42, 23743, 790, 831, 14682, 4632, 2137, 964, 672, 329, 341, 4857, 24188, 13883, 1359, 29360, 27884, 7642, 29667, 3111, 23983, 4605, 29668, 828, 18092, 397, 18098, 217, 1627, 2135, 4852, 702, 1072, 29480, 14686, 4981, 2416, 174, 25035, 1577, 643, 2376, 1695, 332, 4850, 29472, 2133, 1730, 4849, 23772, 41, 413, 396, 710, 826, 682, 2660, 8076, 1827, 270, 165, 15108, 25017, 118, 2711, 29763, 433, 25148, 29443, 8758, 924, 29596, 1385, 25125, 26193, 7487, 26615, 2375, 406, 1626, 29698, 29823, 1833, 1165, 2656, 330, 43, 427, 1181, 290, 1485, 6775, 1524, 3490, 8181, 1377, 4843, 899, 8115, 298, 3164, 121, 471, 70, 1215, 2888, 6991, 1582, 1431, 1822, 438, 8103, 2792, 26004, 12135, 3262, 24437, 1379, 301, 288, 21703, 3173, 7430, 770, 10465, 10736, 1643, 309, 8101, 28986, 2948, 1432, 969, 653, 1303, 1445, 24206, 8811, 907, 325, 23674, 1622, 1520, 23683, 812, 4880, 1257, 29766, 6960, 27121, 29397, 27140, 27106, 24993, 1526, 8610, 24682, 29895, 24599, 24687, 29880, 23765, 29884, 887, 79, 29395, 4854, 263, 568, 825, 180, 2764, 80, 1613, 29490, 1868, 8631, 76, 29611, 29618, 27846, 29406, 29390, 7460, 28430, 1911, 981, 25023, 1710, 4896, 23991, 5094, 4565, 3196, 10627, 435, 4286, 3753, 4895, 18733, 28464, 29413, 19834, 23748, 26219, 24825, 23764, 44, 23791, 1490, 965, 5130, 1540, 23990, 2777, 4004, 29056, 2670, 5133, 213, 6846, 130, 642, 4974, 23806, 673, 29776, 3082, 1872, 4879, 18123, 25118, 1869, 6990, 794, 1863, 29485, 3294, 632, 4646, 27870, 813, 29627, 505, 24451, 4863, 5047, 6764, 23708, 931, 7457, 1650, 575, 412, 1100, 23992, 2443, 29833, 31555, 867, 29492, 29666, 29674, 31363, 4992, 29684, 31612, 30985, 24714, 8099, 15101, 1861, 1009, 7106, 4877, 2424, 1658, 819, 1244, 29621, 8851, 399, 918, 920, 29484, 29454, 15132, 804, 948, 3084, 2601, 171, 2428, 8760, 29456, 18093, 1518, 19835, 1264, 2360, 26235, 497, 4601, 23698, 29462, 1633, 2165, 195, 20879, 3174, 29461, 772, 23794, 3259, 1214, 26221, 1598, 4774, 10749, 10408, 1743, 1560, 3717, 1742, 1529, 1243, 24009, 1037, 432, 18122, 343, 1438, 2015, 4838, 1436, 1820, 769, 1751, 7680, 680, 1817, 8165, 29460, 371, 29613, 1786, 273, 25143, 25142, 5038, 1364, 29702, 275, 29458, 1365, 2124, 2358, 26239, 454, 874, 3225, 25141, 8070, 2575, 2466, 8633, 3296, 1221, 664, 1162, 23807, 1892, 567, 1585, 1186, 28286, 1610, 8156, 1639, 894, 3198, 2084, 1579, 2439, 940, 19386, 8023, 426, 14749, 3755, 3290, 8832, 4397, 726, 3873, 1382, 2838, 27141, 1615, 1679, 29635, 29633, 25004, 8252, 27202, 27200, 29319, 25049, 29769, 24679, 29403, 29465, 297, 4995, 2370, 18080, 6811, 3034, 5139, 1200, 935, 4845, 7462, 1163, 2901, 4870, 1594, 25153, 3038, 1693, 24996, 4841, 2774, 1038, 1709, 2136, 5077, 516, 2011, 342, 3115, 803, 21364, 846, 2258, 283, 1533, 3284, 694, 1205, 832, 2103, 2381, 19740, 3235, 310, 1607, 709, 572, 2523, 173, 271, 1745, 2510, 1886, 26070, 4619, 13868, 1580, 697, 24703, 4599, 3018, 428, 431, 6812, 1107, 4608, 4648, 25995, 346, 25965, 411, 3292, 493, 3228, 500, 1558, 945, 1491, 4616, 7980, 5076, 3234, 1506, 1079, 24408, 490, 27144, 26983, 23771, 4859, 18109, 24028, 1226, 148, 1662, 24281, 662, 286, 601, 2429, 2227, 24691, 248, 400, 15119, 24685, 211, 1818, 232, 4839, 6988, 1606, 8763, 695, 1549, 23793, 398, 455, 234, 8765, 2132, 25016, 23784, 967, 913, 1698, 451, 112, 827, 1541, 661, 326, 15166, 700, 519, 966, 2449, 207, 2123, 1678, 25012, 2311, 1701, 2020, 25029, 6458, 8046, 24754, 3135, 48, 4600, 2080, 1625, 18096, 2059, 311, 2706, 28280, 23957, 768, 29649, 26607, 1731, 24709, 29700, 29606, 19827, 10777, 29619, 31333, 8441, 1157, 1345, 10521, 4308, 7675, 29489, 30028, 777, 29881, 30024, 24986, 1104, 26612, 24681, 10769, 2348, 12360, 24162, 10847, 29940, 1659, 2705, 637, 5010, 19101, 28407, 28282, 29463, 12329, 3110, 8764, 26500, 344, 636, 4310, 1499, 2104, 517, 29693, 28403, 24977, 26265, 430, 28699, 29359, 2425, 2423, 26266, 29476, 5078, 24759, 2131, 15120, 764, 886, 23730, 902)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 1022| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | prod | NULL | range | PRIMARY,product_publish,access | PRIMARY | 4 | NULL | 1022 | 76.23 | Using index condition; Using where |
| 1 | SIMPLE | pr_cat | NULL | ref | PRIMARY,category_id,product_id,product_id_2 | PRIMARY | 4 | demooz.prod.product_id | 6 | 100.00 | Using index |
| 1 | SIMPLE | cat | NULL | eq_ref | PRIMARY,category_publish,access,category_publish_2 | PRIMARY | 4 | demooz.pr_cat.category_id | 1 | 96.51 | Using where |
| Status | Duration |
|---|
| starting | 0.47 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.20 ms |
| System lock | 0.02 ms |
| optimizing | 0.06 ms |
| statistics | 3.24 ms |
| preparing | 0.09 ms |
| executing | 0.01 ms |
| Sending data | 18.07 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_jshopping_related_buy_product/helper.php:63 |
| 15 | ModJshoppingRelatedBuyProductHelper::getProducts() | JROOT/modules/mod_jshopping_related_buy_product/helper.php:20 |
| 14 | ModJshoppingRelatedBuyProductHelper::getRelatedBuyProducts() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:15 |
| 13 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code(1) : eval()'d code:1 |
| 12 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code:1 |
| 11 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php:1 |
| 10 | include JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |