Время запроса: 16.63 ms После последнего запроса: 0.26 ms Память запроса: 0.766 MB Память до запроса: 42.548 MB Выбрано строк: 845
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 (23, 3, 13, 971, 1272, 810, 459, 21, 170, 18, 59, 724, 62, 25, 63, 7655, 29899, 1067, 134, 15, 60, 20, 4635, 7001, 4600, 1068, 29432, 16, 143, 29425, 27109, 27135, 57, 58, 61, 1070, 334, 4647, 25002, 12, 29855, 229, 29896, 15143, 52, 83, 86, 4834, 51, 1849, 1527, 910, 1178, 1835, 1530, 133, 518, 822, 7652, 24752, 7002, 4631, 26, 175, 7651, 136, 332, 517, 29853, 23770, 147, 21344, 7534, 979, 29069, 7533, 8099, 84, 140, 1268, 74, 29854, 23768, 690, 179, 23808, 1065, 45, 4629, 2427, 142, 4628, 1525, 1373, 56, 19, 42, 328, 519, 323, 1705, 24480, 29897, 254, 88, 240, 138, 7531, 516, 1620, 705, 2440, 172, 7537, 811, 265, 98, 259, 458, 23962, 6833, 24, 911, 78, 75, 17, 8458, 329, 659, 27143, 243, 1532, 2367, 31554, 141, 1359, 4640, 4644, 139, 4992, 23792, 331, 249, 41, 901, 4641, 683, 29824, 29636, 23982, 1816, 1355, 1265, 1817, 7004, 6739, 977, 24700, 23767, 2097, 7654, 1162, 174, 691, 6741, 394, 343, 1822, 7478, 1631, 900, 2426, 25015, 23984, 29800, 679, 1591, 132, 24691, 24730, 702, 1677, 1384, 8072, 23756, 18155, 128, 29856, 2373, 709, 704, 1622, 118, 327, 23804, 135, 1821, 54, 2348, 689, 965, 975, 23977, 1169, 5160, 79, 5195, 23697, 2431, 69, 1827, 4643, 247, 4859, 1582, 24431, 46, 301, 1374, 3035, 4605, 1579, 275, 663, 695, 23769, 1699, 694, 1836, 4843, 7929, 1350, 696, 2065, 1644, 6835, 640, 2449, 24703, 1343, 1216, 173, 904, 2358, 828, 699, 664, 1587, 1266, 44, 902, 7930, 643, 337, 700, 3288, 4634, 23824, 5140, 324, 4632, 5107, 754, 217, 23809, 1365, 1215, 1610, 29493, 964, 1341, 1379, 20883, 30068, 18181, 815, 23990, 6469, 2132, 4619, 3016, 1551, 4612, 309, 293, 241, 439, 176, 81, 371, 1548, 125, 653, 966, 831, 630, 4875, 4630, 8102, 19835, 1746, 342, 8757, 1608, 662, 126, 27885, 24809, 23675, 2374, 281, 2133, 2443, 1559, 903, 1553, 1383, 1105, 24322, 400, 29476, 1220, 15172, 23978, 31555, 978, 1704, 2424, 23820, 3264, 849, 398, 2439, 40, 1353, 1594, 644, 3022, 23806, 6767, 5076, 1560, 228, 825, 13883, 108, 1267, 201, 253, 1618, 1578, 2129, 767, 945, 2355, 1213, 4837, 1720, 15102, 27115, 178, 4646, 43, 4881, 684, 3083, 282, 1592, 1626, 693, 23957, 6834, 1558, 80, 1633, 23805, 1222, 1166, 2466, 1625, 1714, 2838, 152, 1819, 1066, 813, 908, 99, 1522, 4598, 297, 449, 23743, 1540, 678, 4959, 4642, 2311, 25024, 1670, 29811, 3111, 4611, 24977, 708, 658, 697, 4649, 23994, 29637, 4633, 671, 8615, 1800, 3024, 29851, 24447, 661, 77, 1658, 24203, 906, 1077, 181, 4870, 2083, 1638, 1009, 276, 269, 823, 1682, 3404, 1865, 761, 2080, 5038, 444, 2883, 3403, 673, 2104, 19740, 231, 7666, 19833, 672, 10768, 4873, 8563, 918, 5129, 1538, 6786, 24761, 29395, 471, 29831, 29823, 675, 2430, 268, 4849, 789, 1085, 3063, 958, 48, 2227, 1612, 1861, 28320, 24456, 290, 339, 654, 2039, 291, 1627, 703, 245, 5059, 826, 23867, 946, 29492, 1124, 1702, 1422, 1180, 1246, 6798, 4438, 2360, 1832, 24739, 4637, 1830, 1586, 893, 948, 4716, 70, 7174, 171, 1744, 1264, 2064, 3110, 2701, 1676, 8365, 3062, 1643, 827, 797, 47, 8022, 15127, 23619, 29490, 10519, 150, 6899, 907, 15130, 1614, 1193, 1581, 841, 1541, 4852, 5188, 335, 1679, 2370, 676, 8764, 4599, 232, 279, 24760, 28724, 4661, 96, 330, 29894, 29594, 5127, 670, 29763, 1071, 2801, 1661, 24986, 24595, 1703, 812, 29456, 413, 31613, 29898, 1218, 1351, 8812, 2450, 5087, 5033, 1828, 255, 1542, 2018, 2021, 1656, 6921, 29762, 2698, 24738, 8824, 15120, 24720, 3018, 1103, 8097, 24731, 905, 447, 2079, 15118, 3292, 1126, 1815, 677, 8185, 144, 177, 474, 6958, 14749, 1171, 82, 29381, 408, 24996, 2575, 1788, 755, 5136, 2368, 6448, 6962, 427, 888, 258, 8610, 6815, 25010, 23766, 4673, 4653, 300, 24993, 5005, 3290, 24997, 8843, 6900, 1367, 23748, 1235, 3093, 3247, 1159, 8253, 23674, 4702, 314, 4609, 6758, 242, 433, 1528, 681, 1535, 3266, 3086, 891, 305, 6457, 2433, 2347, 2764, 24972, 1623, 1616, 12135, 631, 2346, 1848, 23789, 7647, 8032, 8823, 24757, 11045, 8760, 24442, 29810, 30979, 1204, 23995, 25016, 1628, 880, 238, 1824, 2802, 21364, 1712, 23772, 24715, 701, 2571, 6959, 8551, 1158, 1073, 431, 4841, 500, 3194, 3193, 762, 1732, 273, 1094, 6822, 1286, 2376, 1825, 1234, 430, 1354, 820, 688, 1106, 960, 14720, 1868, 3175, 344, 5003, 440, 24733, 23727, 15134, 24729, 25004, 5091, 2768, 10776, 7643, 10775, 204, 947, 6988, 3037, 1206, 15119, 1331, 1709, 14658, 24018, 2125, 3284, 1517, 8070, 27139, 2441, 1201, 308, 1630, 3013, 2011, 794, 638, 2442, 244, 1316, 1200, 1533, 490, 5106, 29495, 29496, 97, 2369, 777, 24750, 24749, 1814, 8762, 210, 220, 5081, 397, 1295, 1521, 729, 0, 1147, 1437, 432, 1770, 1125, 3245, 1209, 1117, 1735, 4877, 3241, 1256, 399, 23807, 127, 24975, 692, 7381, 1352, 1202, 426, 29403, 24751, 27120, 1833, 29485, 322, 872, 976, 1431, 29484, 29488, 30015, 27122, 31469, 6764, 24014, 31363, 24740, 31484, 1385, 25887, 19736, 27855, 22945, 27642, 3075, 5002, 3027, 24257, 29440, 2804, 1983, 23998, 2444, 1195, 28297, 28282, 28770, 682, 23988, 5082, 668, 23676, 24719, 15101, 137, 4836, 1673, 29881, 775, 1356, 685, 1185, 1730)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 845| 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 | 845 | 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.44 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.16 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 2.02 ms |
| preparing | 0.08 ms |
| executing | 0.01 ms |
| Sending data | 13.64 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 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 |