Время запроса: 13.69 ms После последнего запроса: 0.33 ms Память запроса: 0.598 MB Память до запроса: 30.188 MB Выбрано строк: 624
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, 1164, 1161, 1770, 2021, 13, 1777, 2356, 2849, 4287, 645, 1159, 4697, 2520, 1281, 1163, 1280, 869, 1126, 1116, 724, 1758, 3, 1155, 1158, 1499, 1115, 2446, 1702, 23, 4691, 1114, 1794, 15112, 8017, 1760, 1268, 1501, 3092, 1122, 1253, 25033, 18109, 8813, 2442, 4676, 25023, 1156, 1795, 1142, 22, 7196, 4510, 1783, 3574, 1535, 1634, 2432, 18110, 1118, 23981, 1160, 2344, 1141, 2976, 2064, 1805, 11439, 1793, 2355, 1157, 1128, 1723, 24475, 455, 848, 1787, 2441, 24977, 1759, 1167, 1166, 7458, 1886, 1354, 1492, 1784, 1891, 1582, 500, 128, 6957, 1171, 1127, 24825, 1125, 4671, 1150, 1117, 24760, 2358, 14667, 7488, 1534, 2438, 1235, 2439, 971, 1147, 1169, 3133, 454, 937, 849, 536, 2431, 3489, 24693, 2766, 1121, 24627, 7995, 1884, 24486, 1530, 8685, 5017, 7164, 1997, 2802, 29983, 510, 7665, 1359, 24636, 3975, 1894, 3465, 533, 1176, 24761, 1807, 1786, 1248, 4220, 2785, 1101, 1107, 1624, 4898, 2676, 1245, 2078, 839, 1132, 8563, 1525, 1809, 1238, 24032, 1790, 19738, 1138, 538, 3491, 8453, 7400, 403, 1806, 4591, 1148, 217, 4673, 1785, 6913, 28296, 1172, 20883, 29415, 935, 12139, 24703, 2377, 8362, 2376, 170, 1259, 1993, 1263, 4693, 27170, 86, 7944, 889, 539, 3632, 2460, 133, 1103, 3356, 24078, 1728, 1824, 23808, 96, 1099, 4628, 14357, 24149, 530, 815, 664, 8834, 458, 15166, 1885, 24641, 10775, 15134, 7078, 1146, 274, 24091, 1782, 2544, 1538, 4946, 2440, 29346, 7399, 15102, 7532, 2070, 1673, 1540, 4641, 126, 2768, 3979, 2086, 1596, 1112, 1135, 2227, 4716, 1009, 3062, 2366, 14750, 567, 7891, 1002, 7979, 24151, 2125, 4702, 6811, 5045, 1266, 1355, 751, 6827, 706, 4598, 6828, 2423, 1318, 2017, 1870, 2656, 2519, 7896, 457, 4992, 1240, 1792, 402, 1857, 1332, 2672, 2659, 813, 2512, 1762, 660, 1996, 442, 2368, 7996, 1267, 3505, 1865, 1725, 8753, 31348, 1622, 4699, 7445, 24440, 6931, 30985, 8686, 8581, 7107, 2788, 24092, 399, 15171, 24441, 2020, 7648, 7651, 30524, 30541, 2703, 449, 3612, 3590, 3516, 1255, 24487, 24628, 1887, 14949, 30693, 23986, 2555, 24126, 1630, 1175, 8811, 504, 509, 14961, 512, 31656, 25642, 24446, 27176, 28942, 24682, 6812, 7699, 30282, 1585, 18095, 25034, 30033, 1597, 1796, 1037, 411, 7112, 8014, 27153, 644, 2421, 3093, 3717, 2667, 2883, 1168, 1174, 7980, 8836, 1738, 4887, 1131, 3171, 97, 24691, 4629, 918, 8185, 7666, 18155, 24624, 7939, 3767, 679, 3053, 2461, 8201, 717, 4647, 7890, 652, 1272, 632, 1892, 518, 8007, 4435, 642, 568, 1079, 456, 1265, 556, 62, 3419, 29354, 2375, 27502, 6921, 24282, 2001, 3499, 15879, 247, 2039, 605, 553, 1496, 4286, 24610, 7030, 2364, 6920, 4391, 899, 767, 487, 3633, 1233, 630, 4632, 24281, 10776, 7533, 1681, 3144, 1143, 2809, 7978, 14631, 1789, 4527, 24284, 1256, 1262, 555, 25013, 1034, 30227, 26612, 6960, 1731, 29634, 24714, 2726, 27143, 2424, 1149, 24195, 560, 28363, 8179, 15701, 430, 14643, 2462, 3433, 3641, 1234, 2614, 3496, 24637, 1109, 398, 23777, 420, 564, 4653, 4595, 19809, 2000, 1733, 1812, 4155, 1217, 4589, 19820, 863, 7976, 4704, 1195, 835, 28382, 8051, 1264, 343, 21364, 8610, 529, 24021, 7544, 7542, 1767, 19810, 1771, 2993, 3404, 278, 1249, 2535, 905, 1124, 5042, 1252, 3193, 4859, 284, 3111, 14630, 1729, 8689, 0, 431, 404, 181, 3980, 21, 833, 713, 135, 24103, 26312, 1077, 840, 2353, 2968, 3492, 4921, 4612, 3091, 283, 817, 334, 680, 1658, 1295, 29484, 2765, 410, 1711, 1620, 1704, 1173, 1594, 1581, 2782, 1579, 14699, 3077, 7807, 328, 2079, 2798, 198, 3409, 1781, 2764, 1742, 810, 1682, 432, 444, 29896, 25004, 697, 29856, 26272, 10770, 24093, 8510, 8291, 29454, 18085, 29641, 2433, 141, 29853, 28475, 176, 177, 2985, 24756, 29915, 2658, 7658, 4645, 25020, 8103, 1236, 23675, 4696, 1533, 4569, 4834, 6834, 475, 244, 254, 19811, 24448, 2425, 1768, 8843, 148, 562, 23695, 4237, 1523, 412, 19808, 486, 511, 1712, 1551, 7808, 2668, 466, 3004)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 624| 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 | 624 | 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.38 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.45 ms |
| preparing | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 11.28 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 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 |