Время запроса: 22.95 ms После последнего запроса: 0.29 ms Память запроса: 0.829 MB Память до запроса: 30.243 MB Выбрано строк: 847
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 (1162, 1777, 1116, 1148, 2355, 1115, 1788, 1163, 1758, 1597, 1164, 2021, 2356, 1158, 13, 2849, 4287, 1770, 645, 2438, 2441, 2446, 3086, 1125, 1161, 1354, 1501, 2520, 1117, 848, 4673, 1893, 1118, 869, 1160, 2442, 1280, 4697, 2097, 1281, 2367, 1267, 1892, 2443, 419, 1634, 569, 1885, 1582, 2544, 1126, 1253, 1879, 1155, 2433, 724, 1504, 2198, 834, 840, 1783, 1809, 1793, 6834, 3717, 1147, 2764, 1886, 1759, 1119, 1156, 134, 1785, 8562, 4676, 1157, 1159, 6908, 1128, 1235, 1544, 1121, 2417, 6833, 3003, 2347, 1114, 1141, 15100, 1784, 1787, 4660, 863, 1106, 1263, 3002, 1149, 1757, 1889, 1760, 1762, 1794, 197, 1827, 1130, 279, 1795, 1791, 1580, 507, 6990, 1890, 1150, 1891, 1166, 2078, 4898, 2787, 1808, 567, 1169, 6835, 2434, 839, 3499, 2672, 1805, 1120, 1541, 1172, 1780, 1731, 8634, 1035, 1238, 4653, 1779, 1540, 2659, 4120, 4436, 1789, 486, 1806, 1551, 1535, 1152, 3051, 502, 8689, 3264, 4806, 23, 957, 7457, 1173, 1536, 2349, 1140, 1167, 6794, 837, 1705, 498, 1713, 1883, 1236, 1581, 1811, 1137, 2079, 447, 86, 4220, 2012, 4714, 3414, 5148, 490, 1109, 1825, 630, 1168, 2970, 7381, 1174, 8631, 13800, 4591, 3402, 1176, 4586, 4671, 1127, 2416, 1256, 568, 1586, 1154, 2066, 1266, 855, 1237, 836, 24195, 150, 3145, 2656, 4647, 1680, 24627, 633, 1756, 2695, 1254, 14719, 2451, 3171, 2068, 5017, 1797, 2064, 2707, 1704, 6872, 880, 1146, 1246, 3409, 935, 6922, 4704, 761, 1542, 811, 792, 3, 6960, 3690, 3505, 1038, 1881, 1264, 874, 1240, 2344, 492, 849, 8018, 1884, 533, 309, 2016, 2019, 7444, 2346, 1807, 3178, 7996, 217, 1781, 2440, 1796, 1768, 4675, 2784, 2348, 3491, 27186, 3635, 3115, 1313, 2223, 1792, 7459, 4915, 1136, 2556, 1786, 7995, 701, 1255, 8222, 59, 15172, 2039, 403, 4716, 2135, 456, 867, 442, 1145, 2431, 2660, 13779, 833, 2426, 1738, 4691, 2775, 1272, 1534, 7421, 8793, 618, 934, 2427, 13770, 1769, 6792, 2527, 1234, 2447, 2444, 1139, 2766, 1993, 8103, 24626, 4693, 2676, 1171, 539, 1259, 2098, 15112, 1652, 291, 8362, 1898, 1107, 530, 7449, 3060, 2383, 4709, 665, 2675, 4631, 2379, 2123, 4286, 398, 1002, 2471, 4473, 2798, 1138, 1251, 7649, 4702, 4703, 937, 1242, 2710, 1260, 7429, 1596, 3318, 554, 2765, 879, 1079, 454, 1706, 713, 518, 7022, 1134, 1250, 1869, 1826, 2658, 1635, 1579, 532, 1083, 538, 7456, 1934, 515, 6923, 7976, 8602, 421, 1598, 15102, 7443, 2309, 4594, 4669, 2512, 3481, 1585, 7988, 325, 2535, 2013, 7650, 24102, 3036, 1359, 561, 644, 4677, 2439, 4725, 534, 965, 385, 3503, 510, 2038, 404, 945, 234, 3046, 137, 334, 198, 613, 2468, 1301, 15170, 1712, 2366, 4947, 1709, 1857, 2511, 512, 4708, 8371, 2378, 1810, 2373, 1943, 7680, 1856, 2368, 2992, 2210, 1547, 373, 7648, 7657, 663, 3133, 2000, 4315, 3317, 80, 4514, 1651, 1077, 3769, 24431, 281, 8081, 5147, 4701, 3940, 1742, 4729, 501, 4076, 3416, 63, 8685, 7993, 399, 3090, 1332, 2723, 8024, 8604, 2020, 7646, 7602, 2070, 3496, 2777, 5195, 4438, 21363, 12122, 24182, 24093, 838, 29983, 24624, 8096, 29459, 789, 4107, 30065, 26982, 29362, 23952, 5018, 564, 8441, 1723, 8836, 7112, 2436, 27153, 27502, 2782, 1764, 664, 632, 6874, 1916, 8295, 1725, 7939, 2082, 1312, 4705, 24347, 29349, 835, 1774, 499, 6930, 24604, 332, 24282, 493, 842, 3591, 1998, 7991, 901, 1123, 4323, 631, 3231, 4946, 4094, 6855, 4700, 4520, 4530, 2086, 4852, 13856, 8003, 1207, 2661, 6878, 1132, 2093, 29344, 138, 24703, 29354, 14699, 2375, 30007, 7971, 24281, 529, 605, 547, 3038, 3407, 1112, 18504, 310, 5146, 311, 14793, 20979, 1552, 10667, 1887, 8813, 1243, 1144, 247, 3771, 4721, 1802, 8360, 135, 3620, 1177, 15701, 25921, 4276, 3412, 1830, 4665, 6928, 563, 19809, 8287, 4308, 4726, 1340, 474, 1654, 10551, 8611, 18155, 2096, 4859, 271, 2976, 25128, 670, 2803, 1373, 24595, 3004, 7461, 2395, 2715, 3344, 24286, 1763, 3476, 7455, 30079, 20993, 927, 602, 10440, 1549, 4324, 2136, 655, 600, 7980, 4325, 1577, 3342, 2809, 1384, 1249, 3064, 1778, 2734, 3411, 4024, 1888, 23979, 23985, 4313, 7982, 2668, 100, 2703, 10450, 3130, 597, 2063, 15879, 1800, 2246, 3047, 4125, 8382, 2726, 179, 7432, 2534, 1493, 15166, 81, 3341, 8822, 1233, 11283, 3356, 13767, 11025, 3767, 1499, 7997, 8432, 7411, 3979, 1268, 1101, 2361, 4312, 7665, 3589, 1746, 6673, 2343, 8282, 1575, 8368, 7232, 7091, 7107, 8285, 2657, 584, 7407, 6683, 1265, 8283, 7085, 7181, 432, 585, 487, 427, 8823, 702, 3360, 8129, 371, 2792, 466, 505, 397, 660, 2538, 1682, 7408, 24991, 7082, 8533, 2795, 511, 1771, 1257, 6912, 328, 6957, 4718, 8761, 3184, 7451, 1548, 8587, 4927, 278, 1495, 1711, 967, 7103, 413, 1894, 2791, 3111, 4435, 773, 402, 2300, 2430, 3063, 15101, 3061, 1485, 2665, 4877, 24999, 7105, 269, 1942, 8843, 25147, 19813, 2652, 457, 2452, 24091, 24136, 14691, 24605, 2345, 25056, 13752, 7282, 1660, 20881, 1143, 2555, 543, 26933, 24473, 459, 2510, 30227, 8159, 30278, 4527, 2482, 1751, 2502, 430, 1262, 2706, 13378, 2614, 873, 23933, 1831, 8005, 2022, 30279, 3784, 2969, 2132, 24629, 24070, 24714, 2001, 30099, 8535, 8555, 4740, 570, 810, 3193, 4502, 8402, 480, 7412, 20992, 24075, 30275, 8267, 3092, 29443, 30145, 4933, 24284, 555, 503, 30387, 27143, 25013, 30276, 1034, 7978, 26612, 29634, 29460)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 847| 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 | 847 | 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.50 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.19 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 5.07 ms |
| preparing | 0.09 ms |
| executing | 0.01 ms |
| Sending data | 16.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 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 |