Время запроса: 16.96 ms После последнего запроса: 0.29 ms Память запроса: 0.805 MB Память до запроса: 42.991 MB Выбрано строк: 875
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 (96, 97, 6962, 1676, 98, 3, 458, 1272, 1835, 25, 23, 7651, 1381, 915, 13, 1200, 60, 61, 1196, 692, 29853, 20, 7002, 7652, 170, 459, 971, 15, 436, 12, 1380, 128, 201, 17, 148, 438, 7655, 74, 3013, 437, 8757, 6739, 29855, 29897, 180, 45, 1382, 1209, 21, 29899, 118, 913, 59, 22, 43, 810, 18, 888, 24264, 134, 928, 23768, 83, 24, 1815, 25002, 941, 7001, 891, 28797, 86, 1628, 52, 1202, 2485, 63, 940, 693, 69, 23766, 8814, 23764, 24518, 16, 181, 1618, 58, 29856, 1627, 501, 918, 332, 2422, 23753, 29823, 2423, 2425, 4640, 1355, 429, 62, 929, 1178, 99, 1198, 1201, 1067, 397, 920, 24974, 143, 23767, 18097, 29898, 751, 46, 24207, 1592, 1579, 29191, 81, 775, 1266, 18888, 29175, 919, 25952, 7654, 19, 23770, 8792, 889, 29197, 15172, 328, 1859, 2376, 2424, 24203, 394, 897, 1610, 1613, 1085, 342, 405, 1481, 1359, 1630, 41, 179, 1827, 1670, 107, 24009, 23769, 18128, 324, 977, 84, 6740, 265, 700, 7381, 2456, 793, 789, 1525, 2315, 114, 87, 500, 19830, 1268, 2348, 13883, 1070, 1523, 176, 724, 6834, 1383, 82, 24720, 23697, 23676, 6833, 125, 804, 1684, 4641, 1551, 1594, 665, 772, 450, 1122, 805, 463, 117, 1522, 2355, 1267, 2940, 1620, 24480, 7362, 42, 238, 3012, 15103, 5140, 822, 0, 23765, 1759, 8816, 130, 680, 3026, 2429, 2506, 76, 2803, 1773, 18094, 5017, 327, 18116, 1611, 343, 979, 768, 3199, 10771, 1582, 88, 57, 1626, 101, 1760, 411, 237, 764, 26761, 910, 19835, 803, 27159, 428, 18118, 31555, 31434, 1175, 54, 499, 1159, 976, 1162, 306, 175, 8033, 1715, 24431, 8604, 133, 2420, 811, 2439, 1710, 1232, 2039, 8206, 791, 1641, 1521, 664, 278, 792, 2426, 801, 790, 955, 224, 1214, 2375, 909, 2067, 2795, 13308, 7653, 4992, 15168, 1167, 1622, 136, 25818, 1777, 1824, 51, 819, 1818, 453, 8082, 1352, 921, 100, 23983, 1619, 132, 23984, 4851, 7500, 7605, 24993, 5082, 1648, 10851, 196, 29484, 2098, 1716, 1890, 8758, 21359, 2371, 1721, 244, 1819, 24093, 3022, 7261, 911, 15106, 773, 2430, 952, 29564, 1118, 44, 127, 283, 896, 2660, 23976, 222, 5145, 1606, 1833, 406, 29896, 29472, 1385, 1120, 1702, 251, 4834, 890, 1870, 1561, 1700, 253, 843, 483, 1865, 6460, 729, 828, 3262, 239, 311, 699, 1586, 447, 1340, 4647, 1560, 6830, 4606, 28588, 6902, 174, 1632, 1849, 240, 260, 1428, 8097, 4873, 6829, 5004, 2238, 630, 1876, 20923, 24195, 5084, 1354, 1535, 21881, 15100, 982, 19184, 2066, 18154, 8032, 1581, 241, 12223, 25017, 23725, 12221, 10630, 1782, 1374, 310, 1241, 6784, 4857, 8549, 7661, 5079, 4980, 29490, 898, 820, 8096, 4898, 1651, 243, 8254, 23782, 544, 2938, 713, 19681, 29880, 14786, 24478, 1769, 3264, 15117, 4996, 4611, 696, 7427, 4837, 10629, 18771, 5081, 5088, 697, 4872, 2372, 4635, 23677, 138, 831, 4977, 2440, 592, 497, 262, 21356, 28992, 7525, 908, 5014, 15101, 28558, 5191, 28620, 4836, 8115, 7530, 2370, 1330, 694, 13290, 29565, 29562, 1365, 8572, 25036, 2369, 708, 900, 685, 5046, 2457, 2093, 528, 2030, 2366, 709, 23804, 1746, 1519, 23982, 1322, 683, 2124, 292, 18444, 6448, 4617, 2507, 23783, 27182, 27738, 8077, 13310, 29642, 29495, 13413, 444, 29857, 1814, 7173, 1608, 8811, 2392, 23989, 28466, 513, 1673, 1182, 24487, 8532, 7164, 25019, 31108, 572, 24998, 31106, 31105, 31113, 31112, 3260, 8161, 7533, 23674, 403, 2379, 135, 6756, 400, 7105, 29984, 15143, 771, 112, 24283, 862, 4644, 6990, 1157, 8764, 126, 1501, 2702, 24629, 106, 1723, 2239, 1597, 4621, 2936, 2367, 229, 12303, 185, 8024, 346, 2100, 7645, 2442, 1065, 15108, 2099, 2084, 396, 7449, 4636, 7197, 744, 5121, 48, 121, 4609, 1712, 1534, 818, 3084, 682, 18098, 964, 1647, 1711, 28989, 6822, 3349, 10519, 29052, 2431, 1884, 838, 24257, 5144, 703, 6858, 7579, 1743, 2097, 407, 812, 10765, 1077, 4601, 105, 29498, 8044, 2361, 1264, 3196, 5093, 24017, 18129, 11605, 21360, 18976, 371, 1877, 1874, 4720, 15166, 23790, 150, 1751, 4846, 8793, 1617, 2796, 1631, 217, 23779, 1709, 1146, 4119, 7432, 23713, 23800, 7685, 28959, 7636, 29467, 279, 13755, 3258, 25199, 1585, 13880, 2356, 1758, 5005, 5040, 3044, 7609, 10790, 686, 24004, 3299, 1009, 482, 23746, 2505, 953, 6688, 1577, 24755, 1517, 1168, 5037, 2071, 3227, 646, 2021, 1713, 231, 79, 8160, 1242, 2790, 466, 2358, 3505, 3185, 1817, 1885, 603, 1075, 24596, 956, 6607, 7004, 2041, 7649, 8634, 642, 2427, 1139, 1163, 874, 1734, 15122, 1649, 26014, 1645, 269, 766, 2383, 2766, 7610, 401, 958, 442, 641, 1879, 8382, 2134, 677, 3190, 335, 242, 833, 848, 2094, 2798, 3245, 4631, 1578, 1265, 1731, 29961, 1243, 1262, 8800, 1753, 322, 12122, 4853, 4716, 80, 329, 4671, 1692, 3063, 4850, 8807, 8843, 1591, 1158, 3193, 1615, 24261, 4847, 25146, 24979, 2360, 4856, 1639, 2070, 1094, 3194, 326, 25014, 7648, 25964, 776, 1679, 8602, 24003, 398, 18166, 1331, 965, 287, 1318, 575, 927, 1536, 886, 334, 469, 1215, 116, 2772, 4598, 24715, 24013, 1156, 24641, 7698, 309, 404, 19739, 12139, 25142, 2801, 18122, 18123, 24738, 2852, 23962, 7487, 24162, 24388, 4653, 1218, 31333, 13643, 29643, 31364, 1612, 1520, 3261, 29488, 247, 140, 29493, 29594, 8484, 777, 29881, 24731, 30024, 8156, 1011, 249, 19736, 10541, 1524, 24739, 4970, 25000, 1690, 6827, 340, 25015, 28115, 761, 24690, 24005, 24011, 1660, 841, 1403, 808, 23807, 1068, 3873, 29884, 30028, 25418, 678, 29164, 1488, 1161, 10770, 24486, 15112, 24282, 8510, 8291, 10543)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 875| 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 | 875 | 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.41 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.18 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 1.89 ms |
| preparing | 0.08 ms |
| executing | 0.01 ms |
| Sending data | 14.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 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 |