Время запроса: 11.98 ms После последнего запроса: 0.24 ms Память запроса: 0.571 MB Память до запроса: 42.615 MB Выбрано строк: 587
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 (1267, 1578, 2444, 1266, 1268, 1265, 2348, 2426, 2442, 790, 1272, 775, 1541, 1597, 1579, 1540, 23, 2375, 1585, 871, 3111, 1777, 1731, 768, 1067, 1577, 894, 2439, 6837, 1551, 1705, 2355, 2443, 792, 1548, 3, 1634, 419, 1538, 848, 4635, 1712, 1549, 2376, 1582, 5195, 1594, 8757, 660, 22, 888, 4598, 6825, 630, 1542, 2425, 685, 1163, 945, 8287, 751, 2441, 891, 3264, 1679, 873, 2102, 8105, 1580, 1158, 1169, 6922, 29800, 6881, 6921, 958, 788, 1387, 8823, 1581, 836, 2065, 1142, 662, 134, 789, 7652, 880, 849, 1068, 971, 6960, 1891, 328, 447, 2079, 59, 1354, 1793, 1264, 4838, 7967, 2381, 2422, 8843, 794, 3360, 24642, 31529, 1332, 31537, 1253, 86, 2466, 2315, 24257, 769, 869, 51, 7381, 643, 684, 2446, 810, 956, 4120, 2424, 890, 1133, 8364, 7665, 18089, 14630, 7002, 1825, 658, 1855, 24972, 1165, 8017, 152, 2064, 833, 337, 901, 24758, 876, 1162, 1545, 7928, 882, 6823, 3038, 24751, 30063, 791, 198, 1588, 679, 1355, 31302, 31075, 6811, 556, 30064, 249, 784, 19830, 14643, 29359, 1161, 1493, 27144, 29402, 29899, 30004, 29360, 4600, 3589, 2066, 3591, 1174, 3521, 2798, 1143, 1178, 834, 4564, 176, 1352, 52, 2377, 217, 7978, 3199, 638, 941, 1784, 4992, 344, 20995, 4888, 1796, 677, 605, 8613, 1168, 4649, 25013, 2105, 24552, 650, 23804, 24550, 7282, 2980, 12135, 8131, 22263, 3590, 1126, 23698, 1890, 6828, 1139, 653, 174, 8642, 4113, 4628, 782, 1536, 3016, 331, 2465, 1737, 5042, 1313, 1620, 644, 841, 8371, 642, 1558, 1532, 2129, 1535, 14684, 8048, 98, 2787, 3605, 1741, 3310, 902, 136, 666, 2672, 1857, 2991, 1856, 2661, 172, 1250, 4904, 1140, 1224, 1156, 1628, 5148, 6904, 110, 655, 8538, 24542, 27178, 874, 892, 10749, 4886, 6834, 3805, 3119, 4468, 2938, 1671, 1740, 898, 897, 31607, 6793, 8754, 3046, 6990, 652, 1802, 2367, 5028, 5144, 8091, 27128, 3193, 3808, 1208, 23801, 23800, 23796, 29304, 29361, 8042, 7164, 2510, 917, 397, 23833, 3361, 23790, 24441, 618, 30132, 24054, 4154, 2344, 706, 4699, 30256, 2449, 1104, 1369, 24748, 440, 311, 1530, 24566, 3622, 8363, 24569, 1647, 24555, 2430, 24544, 1653, 1826, 24565, 24564, 2436, 8013, 24761, 2343, 8014, 2383, 247, 4889, 29354, 682, 10519, 24703, 29355, 26971, 1704, 15144, 3732, 4278, 8007, 454, 1166, 947, 6827, 1501, 7436, 694, 1200, 3888, 8688, 4887, 180, 960, 63, 1591, 31110, 2701, 8096, 20883, 2417, 659, 7606, 7982, 2883, 1703, 24365, 813, 8808, 1066, 4836, 14681, 14685, 8824, 1681, 6822, 18155, 1365, 2258, 15108, 1385, 635, 7449, 4834, 28995, 7767, 139, 27180, 25046, 30336, 7716, 689, 7795, 7792, 7715, 428, 23952, 7794, 3073, 171, 1643, 683, 3624, 10551, 1805, 1122, 4693, 8211, 797, 3491, 4595, 24348, 8825, 24572, 10547, 1239, 6794, 23961, 8002, 118, 2507, 6833, 4959, 3638, 1892, 2838, 1503, 7456, 23695, 24439, 1766, 7001, 2520, 24431, 24353, 840, 2022, 1065, 905, 14786, 95, 143, 23959, 15172, 3302, 2462, 2764, 6824, 24452, 505, 3601, 4726, 1651, 811, 6838, 24281, 1779, 3068, 14828, 29640, 29384, 843, 1070, 2519, 7189, 7110, 8687, 26607, 26612, 29415, 1587, 29344, 13374, 27140, 323, 24973, 24749, 24750, 26603, 8887, 3410, 10973, 18095, 24658, 6826, 29345, 1484, 22319, 2369, 2512, 863, 6875, 955, 4915, 3035, 864, 517, 1916, 61, 2427, 3196, 952, 1709, 835, 1188, 8044, 2078, 837, 2423, 1894, 942, 24694, 1173, 29406, 30979, 31107, 31106, 31108, 31109, 1374, 31112, 31105, 31069, 31040, 31071, 31038, 31103, 31064, 31066, 31113, 531, 1525, 7771, 29403, 3467, 2482, 29399, 31104, 24570, 100, 8313, 964, 2347, 7605, 1854, 3036, 24451, 913, 3717, 11719, 2692, 4846, 30001, 6835, 275, 1758, 4617, 1195, 19836, 487, 3632, 29383, 1373, 23802)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 587| 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 | 587 | 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.34 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.14 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 1.54 ms |
| preparing | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 9.60 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 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 |