Время запроса: 22.97 ms После последнего запроса: 0.32 ms Память запроса: 0.911 MB Память до запроса: 42.625 MB Выбрано строк: 1010
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 (3, 22, 13, 170, 971, 459, 1272, 21, 18, 59, 810, 20, 15, 1067, 60, 25, 7655, 61, 63, 4635, 143, 134, 1178, 29853, 7002, 62, 7652, 1530, 16, 12, 29899, 724, 7001, 1070, 334, 7651, 86, 17, 74, 1527, 1068, 24, 25002, 83, 458, 58, 29897, 1849, 4647, 78, 52, 229, 45, 518, 128, 26, 201, 265, 51, 4834, 84, 6739, 175, 97, 98, 811, 29855, 23770, 1359, 4628, 6834, 138, 910, 1835, 4631, 8757, 332, 328, 1065, 329, 979, 4640, 29854, 240, 1384, 911, 133, 517, 1816, 24480, 331, 2426, 23768, 519, 23804, 4634, 1066, 179, 142, 2348, 337, 1268, 4629, 19, 177, 135, 29896, 125, 1833, 172, 54, 1620, 7004, 24518, 56, 57, 75, 42, 343, 330, 25015, 323, 29856, 4649, 4641, 1522, 176, 516, 2431, 174, 41, 23962, 1266, 46, 81, 4611, 24431, 24478, 4644, 2427, 20883, 173, 23767, 689, 2367, 4598, 136, 283, 77, 4605, 130, 243, 43, 6833, 139, 400, 132, 690, 29824, 23769, 137, 88, 247, 428, 4846, 964, 900, 126, 659, 701, 1162, 829, 4612, 1683, 79, 40, 691, 5160, 2355, 1622, 1517, 99, 1705, 69, 826, 1577, 4992, 1677, 436, 1824, 1631, 281, 662, 23771, 8104, 4643, 23697, 3035, 23982, 1820, 4632, 29898, 267, 7381, 506, 259, 1830, 7942, 2440, 6741, 7932, 4642, 1209, 1518, 978, 147, 8458, 23743, 2429, 1815, 29823, 1717, 905, 6835, 965, 447, 242, 7939, 1169, 1383, 683, 327, 4619, 1560, 1703, 1591, 178, 23976, 144, 675, 7933, 29802, 31469, 977, 1587, 141, 1373, 23781, 24257, 1218, 23806, 140, 24161, 1578, 1200, 1616, 2764, 1166, 1541, 4852, 1233, 644, 1533, 25004, 4608, 24972, 29484, 324, 31554, 898, 1827, 663, 14749, 5077, 678, 407, 231, 18098, 1165, 1352, 1073, 754, 1532, 1343, 24750, 1593, 24752, 292, 1836, 2097, 638, 4881, 705, 1481, 2439, 1822, 24730, 87, 4849, 7654, 3264, 26272, 2883, 1726, 4630, 1610, 1350, 8031, 643, 23824, 24715, 8792, 775, 1104, 44, 901, 171, 23765, 282, 5195, 790, 709, 8175, 1625, 867, 23990, 706, 2258, 1731, 21364, 23809, 1581, 3022, 3016, 661, 1525, 664, 1819, 4616, 2366, 4850, 20879, 1862, 244, 23673, 1869, 278, 24720, 182, 1540, 4675, 1832, 827, 1431, 4601, 1714, 685, 4880, 152, 682, 903, 1695, 29488, 4645, 15172, 48, 7648, 725, 24986, 24973, 27144, 30138, 30015, 25016, 253, 692, 29851, 1330, 24207, 5082, 891, 890, 31526, 1115, 279, 5188, 2428, 1204, 371, 2309, 4837, 679, 1072, 1529, 695, 1222, 4845, 1353, 23772, 6740, 1105, 23957, 4857, 5143, 4633, 8097, 640, 15143, 108, 761, 5107, 1267, 1265, 1549, 694, 427, 1785, 25000, 23961, 6811, 4646, 4625, 23756, 1658, 24749, 2376, 1183, 29698, 1526, 13287, 1633, 6767, 268, 406, 24703, 2133, 409, 23792, 1559, 2039, 474, 677, 6798, 2079, 8642, 1743, 5076, 29607, 4843, 29771, 1355, 813, 204, 1630, 1264, 8823, 697, 819, 1614, 1626, 8182, 966, 791, 25035, 433, 4606, 1385, 10519, 241, 1558, 639, 904, 1548, 4875, 5013, 13286, 29359, 3288, 200, 1422, 15119, 29476, 1521, 1608, 23820, 7450, 20881, 4873, 1702, 29360, 300, 19830, 1201, 794, 2347, 1582, 567, 2057, 25150, 273, 5004, 505, 1709, 2581, 2442, 693, 6822, 1747, 647, 637, 432, 1202, 5038, 1623, 4648, 29406, 981, 8253, 6900, 25965, 14669, 18155, 6960, 8843, 6899, 29403, 1643, 8824, 676, 23807, 23794, 1171, 1580, 3181, 2082, 23963, 18094, 1777, 1328, 29880, 1331, 6812, 15137, 290, 301, 1684, 27122, 2346, 27138, 24978, 2705, 23760, 205, 12122, 21344, 24014, 5121, 23619, 5014, 5088, 6784, 15106, 29831, 5081, 5079, 4996, 4980, 831, 1386, 1624, 23763, 18140, 29884, 19736, 1699, 15117, 2099, 47, 707, 3029, 5036, 1193, 270, 3196, 1734, 726, 2571, 1712, 2132, 454, 3197, 3190, 24733, 23698, 568, 1594, 8387, 2135, 1219, 96, 658, 632, 2076, 732, 5010, 5009, 4978, 4638, 3028, 29408, 24975, 3490, 21703, 3298, 1342, 14705, 8604, 3171, 26971, 25075, 653, 3083, 1744, 314, 8610, 1079, 2311, 23699, 3063, 3247, 5133, 24997, 654, 23984, 2579, 2371, 1424, 3037, 15102, 2902, 948, 101, 652, 4863, 722, 2698, 28724, 31615, 304, 2349, 27099, 24690, 2441, 18078, 10751, 23977, 322, 31613, 23987, 333, 908, 1187, 23978, 24691, 4971, 19831, 225, 2449, 8612, 668, 27128, 27143, 1071, 25034, 19835, 1660, 1659, 10873, 24760, 8103, 15110, 3173, 2568, 8563, 150, 24742, 25155, 10728, 1561, 4983, 1621, 6451, 18752, 167, 293, 3111, 1374, 6736, 3174, 982, 10627, 8762, 24266, 1892, 21348, 25995, 975, 310, 10465, 4653, 29318, 24976, 894, 438, 24759, 4599, 700, 1873, 1354, 3292, 5000, 29490, 1118, 4609, 2065, 6754, 1886, 641, 4841, 1196, 13883, 2430, 945, 1818, 6959, 1035, 3513, 1828, 3403, 2368, 680, 3185, 2083, 28541, 27113, 4998, 2369, 1784, 537, 672, 893, 311, 3036, 3038, 8126, 490, 1638, 6561, 15120, 906, 24761, 2080, 2792, 232, 29056, 29384, 684, 25010, 24031, 29432, 1585, 24738, 25029, 233, 5087, 1956, 29079, 673, 2361, 24731, 1644, 4959, 13374, 27140, 29402, 24751, 26603, 24755, 26204, 26202, 26256, 2375, 10504, 18095, 29415, 24740, 24970, 15139, 5134, 8046, 1713, 19836, 8006, 6827, 7585, 23808, 24754, 217, 1249, 3110, 1814, 6785, 26607, 26004, 671, 295, 493, 1804, 1220, 4614, 5057, 421, 210, 940, 2253, 260, 789, 4877, 272, 1805, 5075, 284, 5130, 1332, 4861, 842, 24685, 1723, 6962, 1579, 24737, 630, 76, 127, 4310, 8763, 2583, 10485, 90, 25023, 868, 7697, 25148, 249, 8098, 15112, 1542, 2070, 688, 2567, 1848, 28982, 1821, 1679, 2838, 823, 902, 5147, 4617, 7643, 1435, 1347, 2165, 28934, 342, 442, 26612, 8687, 471, 822, 1732, 1107, 974, 1106, 1213, 429, 18128, 6457, 24428, 18733, 30028, 29478, 5191, 3334, 1519, 699, 1883, 1150, 777, 29881, 30024, 27855, 1671, 29990, 8758, 24162, 4859, 1735, 6991, 828, 24636, 29362, 6829, 1124, 5033, 1914, 463, 297, 1182, 12135, 1692, 15105, 2433, 25055, 631, 5135, 1341, 121, 1863, 1691, 3266, 1861, 6790, 825, 5140, 8764, 306, 3034, 1535, 287, 2011, 5070, 335, 26614, 7110, 8264, 25033, 25032, 7445, 8812, 29811, 28523, 24164, 3146, 3641, 8002, 28271, 8572, 23681, 23994, 339, 10776, 29810, 27642, 29864, 24442, 26611, 5095, 24094, 6823, 6826, 29344, 29345, 2519, 7189, 26615, 926, 1103, 26070, 24599, 24203, 397, 2444, 24449, 18091, 1868, 3024, 1817, 5074, 2434, 414, 25012, 2370, 1727, 29581, 1653, 4600, 841, 303, 1242, 2706, 667, 22945, 12223, 7666, 8101, 29493, 29637, 23723, 6915)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 1010| 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 | 1010 | 65.97 | 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.51 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.21 ms |
| System lock | 0.02 ms |
| optimizing | 0.06 ms |
| statistics | 2.59 ms |
| preparing | 0.10 ms |
| executing | 0.01 ms |
| Sending data | 19.11 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 |