Время запроса: 19.15 ms После последнего запроса: 0.22 ms Память запроса: 0.586 MB Память до запроса: 30.264 MB Выбрано строк: 595
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 (447, 490, 5017, 2355, 1165, 217, 2022, 1597, 15166, 1731, 4806, 23695, 1166, 4653, 4716, 1267, 4076, 2443, 2021, 7665, 7650, 4676, 2348, 1233, 1758, 1873, 4339, 3491, 1161, 1164, 24815, 849, 1890, 15101, 24472, 1536, 487, 1007, 2013, 1125, 13757, 6794, 2014, 1121, 874, 1162, 24645, 3093, 1163, 1257, 1885, 1122, 1886, 1942, 2518, 24115, 2444, 13856, 2583, 15100, 1770, 1997, 934, 2065, 3490, 488, 2017, 3166, 2020, 1158, 2451, 983, 7648, 1805, 1205, 421, 1777, 3690, 971, 389, 1855, 492, 4884, 1115, 29443, 1009, 3077, 1256, 7444, 2442, 8604, 4473, 385, 2125, 1582, 596, 2012, 4718, 8051, 1735, 380, 24281, 24151, 1501, 1544, 24700, 3465, 2803, 1029, 2431, 6872, 1268, 512, 1578, 2066, 839, 7567, 29354, 6922, 1142, 2417, 2018, 1116, 29093, 1825, 3171, 3717, 13754, 713, 964, 3634, 1159, 1260, 880, 790, 496, 1185, 14719, 935, 200, 1114, 2019, 24997, 3151, 3499, 2438, 27168, 15110, 3146, 8689, 1186, 1183, 4921, 2707, 7643, 4677, 1894, 25046, 7661, 201, 8416, 1137, 2764, 7470, 29107, 600, 29805, 2788, 4426, 3184, 702, 1023, 1266, 848, 2663, 1202, 4626, 8773, 23982, 24431, 8782, 381, 7666, 1771, 4692, 4840, 3479, 3407, 1144, 2904, 1541, 1182, 1156, 1869, 4725, 1373, 1795, 2135, 1129, 29472, 1551, 3363, 3160, 1868, 2433, 4888, 597, 4794, 3549, 1265, 2449, 4839, 420, 1494, 2089, 2063, 195, 4431, 25034, 3090, 4700, 3193, 7680, 7602, 8081, 23994, 5146, 1657, 2448, 2991, 1661, 2062, 4586, 4079, 368, 2440, 8563, 1827, 1747, 1870, 2993, 1173, 2393, 2550, 8104, 456, 22, 4893, 43, 1879, 8469, 8766, 1236, 1549, 3588, 837, 437, 969, 24633, 2990, 1783, 1143, 29461, 29460, 2710, 834, 7662, 28364, 411, 3162, 29867, 24088, 3037, 1150, 29899, 8103, 2997, 427, 170, 2078, 1038, 28853, 28271, 29824, 3, 23, 4441, 7037, 871, 14649, 27180, 14643, 2347, 29888, 24492, 8186, 1192, 409, 4342, 660, 24694, 8201, 30697, 24023, 4082, 4434, 1859, 1811, 24102, 2553, 1245, 4898, 1794, 42, 7979, 678, 3036, 126, 1705, 705, 750, 325, 1108, 8761, 676, 24752, 8024, 485, 4710, 1998, 4721, 318, 3099, 7646, 3053, 24993, 1238, 8295, 2488, 1750, 152, 63, 2521, 7992, 1097, 1540, 500, 1077, 3356, 4730, 19739, 2136, 2992, 7801, 2515, 603, 8017, 3190, 29430, 14630, 679, 2677, 2659, 4696, 683, 4647, 83, 8050, 24996, 3470, 15879, 375, 507, 2298, 14629, 6915, 432, 24682, 8562, 4886, 24078, 858, 486, 24174, 6988, 1884, 1107, 442, 1762, 925, 2544, 3444, 2986, 6920, 15701, 2805, 86, 7459, 1530, 4726, 135, 7642, 1940, 7487, 24976, 1481, 23980, 2726, 15161, 23948, 29458, 1138, 3641, 945, 8631, 1577, 1887, 2976, 6919, 1743, 3395, 4702, 2478, 24100, 29335, 1146, 5149, 7983, 2378, 7627, 24703, 1634, 1118, 15170, 7441, 4077, 2465, 1899, 1075, 4436, 7603, 3342, 7610, 897, 8843, 7608, 1247, 615, 3344, 1251, 7607, 840, 4850, 4863, 282, 7536, 499, 8428, 513, 2466, 1764, 4754, 1099, 2015, 3979, 2809, 25056, 386, 605, 24635, 4419, 4324, 1002, 1730, 426, 4006, 8776, 382, 8371, 24257, 7436, 269, 936, 2461, 2439, 4439, 2679, 13765, 4078, 25049, 1017, 1109, 2373, 98, 328, 1599, 6923, 7756, 709, 387, 2187, 910, 2441, 4477, 1804, 2703, 3785, 4951, 1084, 1160, 4438, 8098, 481, 2657, 1746, 1806, 4805, 1535, 4376, 2672, 617, 44, 47, 4739, 3038, 25057, 978, 1679, 4698, 2446, 915, 937, 1250, 1262, 4433, 96, 2420, 1807, 833, 2345, 3340, 29346, 7455, 24192, 3932, 3169, 2016, 7986, 7457, 24595, 29462, 29336, 4691, 30088, 3116, 30134, 26933, 30083, 30079, 2436, 14598, 29466, 868, 506, 501, 30135, 24183, 24282, 4784, 3496, 1698, 13751, 24026, 14732, 1342, 1546, 1128, 1124, 30078, 23789, 7454, 8003, 4780, 1723, 30314, 4704, 29356, 30147, 1562, 2975, 8760, 29983, 7984, 7985, 8375)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 595| 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 | 595 | 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.53 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.18 ms |
| System lock | 0.02 ms |
| optimizing | 0.07 ms |
| statistics | 2.51 ms |
| preparing | 0.09 ms |
| executing | 0.01 ms |
| Sending data | 15.02 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.04 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 |