Время запроса: 12.57 ms После последнего запроса: 0.23 ms Память запроса: 0.641 MB Память до запроса: 30.136 MB Выбрано строк: 563
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 (1165, 1354, 1777, 1597, 1163, 1158, 1758, 2443, 4676, 447, 2441, 2442, 1634, 490, 1731, 1125, 848, 1161, 23, 4691, 2417, 1159, 837, 2431, 4704, 1142, 2079, 3002, 24281, 2438, 1169, 1145, 2358, 4673, 1113, 498, 2425, 1538, 849, 2446, 86, 1156, 2794, 569, 4436, 2793, 3499, 3413, 487, 1272, 1506, 1164, 1535, 1234, 897, 1116, 1143, 1162, 957, 1644, 2520, 2343, 2562, 1680, 597, 3491, 692, 835, 2348, 4653, 23695, 7444, 1827, 1530, 1160, 25046, 3771, 1705, 1885, 2518, 1166, 2377, 0, 5195, 3344, 886, 8793, 3465, 1176, 4726, 1141, 8013, 3402, 584, 552, 4677, 4699, 630, 1580, 1794, 2672, 5148, 1805, 2434, 2788, 1239, 420, 2976, 1112, 790, 1536, 863, 29443, 7022, 1779, 1253, 6960, 1997, 29483, 3172, 8563, 4927, 2556, 3516, 4271, 8364, 493, 4674, 1651, 8825, 22, 1114, 6922, 7114, 8017, 15100, 1268, 4739, 423, 1149, 8428, 6872, 5147, 1137, 23820, 1384, 3769, 1493, 1242, 13757, 3469, 7156, 29346, 880, 179, 1155, 7431, 1106, 1587, 2707, 874, 548, 15142, 2440, 24280, 512, 62, 901, 8453, 2656, 1130, 27168, 1998, 4951, 839, 6913, 3690, 1104, 14719, 971, 2451, 24703, 2016, 4316, 1883, 29472, 29983, 29805, 3114, 2022, 7643, 25029, 8756, 7956, 1147, 2063, 3003, 515, 2391, 4806, 2309, 2971, 1117, 281, 1274, 792, 5017, 1140, 4664, 7665, 1247, 15101, 1136, 2078, 7983, 8511, 8786, 3717, 2662, 2787, 3632, 1911, 2001, 1781, 6833, 23956, 2064, 23934, 15112, 3442, 1780, 3099, 4276, 6822, 6835, 8533, 4900, 2492, 24041, 2977, 24049, 2542, 4717, 3061, 14737, 15170, 24026, 29937, 2482, 23986, 1809, 4154, 617, 1681, 846, 3492, 965, 3108, 935, 1561, 3606, 4887, 4076, 1132, 25035, 6834, 3396, 4145, 15, 84, 24641, 513, 25055, 1073, 8830, 4675, 2512, 1598, 1118, 600, 30287, 29462, 4313, 2784, 1826, 3549, 4890, 4312, 15172, 2533, 1784, 1888, 1543, 1144, 7432, 403, 4708, 2360, 2657, 1916, 507, 1582, 1887, 23867, 1359, 2448, 30261, 3284, 30258, 30256, 24658, 30280, 30046, 31332, 24347, 31096, 30571, 29368, 29366, 29360, 29362, 30065, 8287, 2392, 868, 14987, 2416, 27875, 1795, 13767, 1341, 1792, 8016, 983, 3010, 11025, 59, 23804, 1126, 400, 3, 24638, 4697, 1768, 1762, 8829, 1884, 2986, 8827, 2766, 7652, 3310, 10769, 21363, 10773, 7535, 29431, 12360, 12358, 12356, 10775, 10771, 10778, 2791, 1037, 1766, 4921, 2667, 24094, 1540, 1577, 14793, 1260, 2347, 23833, 1745, 2023, 4837, 24271, 28475, 1796, 529, 28296, 4632, 8631, 7997, 840, 24288, 4693, 24045, 8560, 3482, 14629, 7461, 1831, 1992, 1122, 6794, 564, 449, 10415, 3334, 699, 1150, 3772, 1551, 24680, 24699, 23786, 1547, 5149, 3077, 6923, 14676, 1383, 24431, 8252, 2717, 8003, 1791, 11283, 7984, 2420, 2423, 2454, 24448, 28382, 3589, 24691, 3053, 4915, 4286, 3178, 2424, 28363, 2698, 1558, 4275, 834, 1738, 4626, 3111, 2636, 1578, 24743, 675, 6915, 24188, 24682, 4720, 4716, 7756, 3495, 6841, 8073, 8689, 4754, 7030, 3040, 7930, 1523, 7646, 1525, 1235, 2353, 2710, 7650, 4010, 3505, 1537, 7459, 3028, 2210, 2474, 430, 13754, 4463, 1492, 240, 547, 26983, 1782, 3366, 4694, 3410, 2439, 2631, 713, 1097, 488, 3689, 29437, 3133, 1123, 3996, 1115, 2511, 1788, 3422, 2437, 2444, 1785, 170, 4278, 13751, 1266, 2771, 2436, 3679, 28392, 6990, 4220, 486, 29349, 2344, 1879, 24150, 1802, 4700, 1250, 3336, 7986, 3486, 3475, 4591, 8610, 1656, 23979, 7441, 29930, 401, 1124, 29359, 2553, 217, 23790, 1167, 4006, 25057, 13765, 6984, 7078, 1774, 4893, 1534, 541, 1168, 1249, 1240, 2445, 1238, 4705, 7455, 2659, 3445, 4884, 3620, 4516, 29961, 4119, 2713, 24183, 30264)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 563| 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 | 563 | 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.30 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.13 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 1.34 ms |
| preparing | 0.06 ms |
| executing | 0.01 ms |
| Sending data | 10.44 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 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 |