Время запроса: 17.28 ms После последнего запроса: 0.23 ms Память запроса: 0.653 MB Память до запроса: 42.747 MB Выбрано строк: 699
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, 23, 22, 810, 459, 1272, 971, 15, 59, 18, 7655, 21, 61, 724, 62, 52, 1065, 60, 170, 29899, 16, 4635, 1067, 1530, 29897, 29853, 143, 1849, 7651, 1178, 25, 910, 458, 20, 4640, 12, 7002, 4287, 29855, 334, 24480, 74, 2021, 811, 2356, 1527, 645, 134, 7001, 2849, 25002, 1162, 1770, 17, 2427, 98, 29896, 97, 1165, 128, 54, 8757, 6739, 518, 63, 1164, 1068, 24, 58, 15143, 7652, 1070, 23804, 23768, 7534, 24752, 4631, 29069, 822, 21344, 7533, 8099, 26, 51, 1161, 1835, 911, 329, 4628, 978, 201, 1281, 1280, 869, 4697, 902, 133, 86, 4644, 56, 57, 23770, 88, 265, 42, 4634, 175, 23697, 4641, 138, 132, 23767, 689, 24730, 1268, 979, 1066, 7537, 23756, 1384, 7531, 4611, 24518, 23984, 142, 172, 29856, 240, 2367, 77, 75, 7004, 330, 6741, 1343, 20883, 3036, 4834, 328, 179, 29854, 690, 3022, 23962, 705, 137, 126, 342, 1643, 1620, 69, 23769, 229, 1816, 1073, 29800, 1833, 23982, 31484, 2426, 828, 241, 903, 400, 99, 27115, 1610, 152, 977, 775, 24442, 29851, 24703, 19, 7478, 4647, 708, 6834, 881, 324, 332, 1355, 84, 4649, 1359, 1431, 135, 1522, 1817, 4620, 7381, 139, 2097, 1383, 1819, 24431, 6824, 4630, 1704, 43, 1699, 181, 83, 826, 24996, 24257, 323, 234, 793, 805, 4615, 27128, 640, 174, 1267, 754, 24691, 18181, 78, 29823, 23807, 8792, 5160, 176, 81, 23809, 519, 301, 1736, 1578, 30068, 148, 702, 4605, 423, 6822, 1169, 4642, 804, 405, 6823, 144, 1836, 3035, 327, 1373, 24478, 1350, 516, 2358, 4643, 964, 1105, 1832, 2429, 904, 1655, 13883, 1683, 1616, 311, 899, 1614, 1630, 1551, 279, 413, 1865, 4629, 253, 1342, 29642, 6962, 371, 1639, 905, 1869, 31555, 29493, 29811, 29495, 41, 29496, 147, 4636, 4639, 29895, 25015, 1638, 1818, 771, 1636, 2315, 2171, 8102, 2370, 773, 4617, 4845, 8458, 1650, 2430, 8604, 5077, 96, 4600, 517, 1523, 337, 6457, 1533, 7654, 27134, 2698, 678, 23698, 275, 23806, 1548, 677, 23765, 4881, 27133, 27135, 2080, 23792, 8843, 767, 27140, 281, 4632, 27144, 2375, 976, 15172, 693, 2028, 282, 683, 136, 310, 141, 243, 1385, 5143, 173, 1828, 831, 247, 177, 29802, 27863, 27136, 794, 27119, 28929, 29484, 27114, 23771, 24447, 24977, 232, 23976, 27108, 1561, 463, 82, 1216, 1266, 2439, 4837, 1698, 331, 24488, 1593, 3292, 44, 1124, 495, 19452, 23977, 278, 1432, 898, 1517, 13393, 4609, 87, 900, 268, 23808, 1351, 1379, 2308, 23760, 19357, 24456, 3073, 659, 965, 808, 8813, 8602, 18155, 675, 29818, 3324, 140, 29480, 2893, 29603, 1218, 10873, 29894, 2449, 7956, 427, 1592, 685, 1185, 2129, 6921, 1181, 23974, 1526, 3110, 2364, 29664, 8104, 95, 5033, 1734, 5004, 7164, 2073, 1800, 1560, 24322, 5038, 3037, 908, 23998, 694, 3014, 1583, 15142, 237, 4857, 8824, 2039, 24487, 29640, 29641, 2428, 5010, 29880, 709, 2102, 29485, 1861, 528, 725, 24760, 29643, 31469, 79, 6554, 24973, 24700, 24972, 25016, 1071, 29639, 1246, 29594, 29494, 23994, 2376, 171, 4880, 29636, 5013, 643, 2082, 1184, 24486, 966, 203, 4850, 2451, 2838, 679, 698, 6918, 2072, 4599, 886, 7445, 333, 701, 1552, 1374, 210, 981, 672, 23988, 1264, 4633, 15108, 8365, 15110, 4638, 231, 8544, 703, 1235, 3296, 3086, 1256, 5184, 1345, 4156, 829, 23997, 1631, 8156, 1628, 70, 3257, 896, 4859, 309, 13864, 284, 3094, 4598, 2799, 1180, 4612, 2977, 1822, 863, 2369, 2802, 1609, 8005, 6816, 5125, 273, 2440, 30979, 7096, 7108, 7110, 901, 7186, 8329, 27846, 10504, 29648, 1705, 1635, 23990, 8002, 1558, 14248, 1656, 483, 101, 426, 1587, 2768, 1742, 671, 906, 1532, 726, 2794, 2711, 1651, 1331, 1684, 1213, 76, 283, 1644, 439, 3119, 1629, 2099, 2901, 1679, 691, 580, 2457, 24720, 15168, 24440, 24441, 108, 849, 233, 7529, 1387, 3102, 959, 476, 130, 198, 314, 505, 1591, 7093, 12163, 1626, 450, 29898, 24740, 8643, 19835, 24738, 24731, 118, 3093, 4877, 1192, 29884, 8758, 777, 29881, 30024, 26969, 24690, 1214, 5188, 30028, 682, 40, 8823, 4646, 26973, 298, 2515, 290, 4662, 686, 630, 1624, 1441, 1594, 761, 1525, 797, 438, 1465, 19830, 12223, 8313, 7675, 21348, 30015, 1380, 1381, 1352, 8097, 7678, 24998, 4743, 1547, 820, 29852, 8572, 29153, 24094, 2703, 880, 6821, 26611, 1746, 1820, 5064, 1582, 8098, 23794, 28934, 28982, 1618, 8550, 29607, 19836, 13456, 1676, 3064, 24729, 733, 215, 8631, 8165, 29810)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 699| 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 | 699 | 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.33 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.16 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 4.13 ms |
| preparing | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 12.29 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 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 |