- +228 872 4444
- +775 872 4444
- contact@mail.ru
- Пн - Пт 8:00 - 17:30
Ваша корзина пуста
Категории
Фильтры (Ksenmart)
NES&WEST 2-2101-00-0
Характеристики:
- Застегивается на двустороннюю молнию и планку с внутренними кнопками
- Внешние карманы – 2 шт. на молнии
- В рукавах внутренние манжеты
- Декоративные пуговицы
Описание: короткая женская куртка с оригинальным воротником-стойкой приталенного покроя. Стильная молодежная модель.
СЭКОНОМЬ КУПИВ КОМПЛЕКТОМ
Куртки : похожие варианты
Другие варианты
CFMOTO 650 TK
| Охлаждение | Жидкостное |
| Рабочий объем | 649,3 см. куб |
| Мощность | 45 кВт/ 9000об/мин (61,2 л.с.) |
| Макс. крутящий момент | 56 Н·м (7000 об/мин) |
| Топливная система | впрыск (EFI) |
420 000 р.
Сопутствующие товары
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713491006,
"last": 1713491006,
"now": 1713491006
},
"token": "KdH5oE3lYNtyudDnSjQimj9VqWy5wDAh"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"com_ksenmart": {
"user_viewpages": 1,
"user_viewproducts": 1,
"utmtags": "{\"utm_source\":null,\"utm_medium\":null,\"utm_campaign\":null,\"utm_content\":null,\"utm_term\":null,\"source_type\":null,\"source\":null,\"position_type\":null,\"position\":null,\"keyword\":null}",
"referer": ""
}
}
}
Время
Память
Время: 5.76 ms / 5.76 ms Память: 0.477 MB / 0.82 MB Application: afterLoad
Время: 46.84 ms / 52.60 ms Память: 1.790 MB / 2.61 MB Application: afterInitialise
Время: 5.17 ms / 57.77 ms Память: 0.172 MB / 2.78 MB Application: afterRoute
Время: 2.11 ms / 59.88 ms Память: 0.163 MB / 2.94 MB Application: beforeRenderComponent com_ksenmart
Время: 28.55 ms / 88.43 ms Память: 0.557 MB / 3.50 MB Application: Before Access::preloadComponents (all components)
Время: 1.59 ms / 90.01 ms Память: 0.055 MB / 3.55 MB Application: After Access::preloadComponents (all components)
Время: 0.05 ms / 90.07 ms Память: 0.000 MB / 3.55 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.46 ms / 90.53 ms Память: 0.008 MB / 3.56 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 36.70 ms / 127.22 ms Память: 0.511 MB / 4.07 MB Application: afterRenderComponent com_ksenmart
Время: 0.68 ms / 127.91 ms Память: 0.005 MB / 4.08 MB Application: afterDispatch
Время: 31.32 ms / 159.22 ms Память: 0.234 MB / 4.31 MB Application: beforeRenderModule mod_search (Search)
Время: 0.95 ms / 160.17 ms Память: 0.024 MB / 4.34 MB Application: afterRenderModule mod_search (Search)
Время: 0.04 ms / 160.21 ms Память: 0.000 MB / 4.32 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)
Время: 1.41 ms / 161.61 ms Память: 0.033 MB / 4.36 MB Application: afterRenderModule mod_menu (Off Canvas Menu)
Время: 0.08 ms / 161.69 ms Память: 0.000 MB / 4.34 MB Application: beforeRenderModule mod_km_categories (Категории)
Время: 3.33 ms / 165.02 ms Память: 0.051 MB / 4.39 MB Application: afterRenderModule mod_km_categories (Категории)
Время: 0.05 ms / 165.07 ms Память: 0.000 MB / 4.39 MB Application: beforeRenderModule mod_km_filter (Фильтры (Ksenmart))
Время: 8.59 ms / 173.66 ms Память: 0.120 MB / 4.51 MB Application: afterRenderModule mod_km_filter (Фильтры (Ksenmart))
Время: 0.16 ms / 173.83 ms Память: 0.000 MB / 4.47 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 1.07 ms / 174.89 ms Память: 0.019 MB / 4.49 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.08 ms / 174.97 ms Память: 0.000 MB / 4.48 MB Application: beforeRenderModule mod_km_minicart (Миникорзина (Ksenmart))
Время: 2.03 ms / 177.00 ms Память: 0.091 MB / 4.57 MB Application: afterRenderModule mod_km_minicart (Миникорзина (Ksenmart))
Время: 2.27 ms / 179.27 ms Память: 0.138 MB / 4.71 MB Application: afterRender
Всего SQL-запросов: 33.18 ms
5.59 MB (5 858 584 Байт)
66 SQL-запросов зафиксировано 33.18 ms
- Время запроса: 0.74 ms Память запроса: 0.025 MB Память до запроса: 1.147 MB Выбрано строк: 0
SELECT `data`
FROM `maw13_session`
WHERE `session_id` = '5b75cac9f4095c26018dcfeac236d067'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.31 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.26 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Так же, как вызов в строке ниже. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:755 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.18 ms После последнего запроса: 0.55 ms Память запроса: 0.022 MB Память до запроса: 1.162 MB Выбрано строк: 0
SELECT `session_id`
FROM `maw13_session`
WHERE `session_id` = '5b75cac9f4095c26018dcfeac236d067'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.21 ms После последнего запроса: 0.09 ms Память запроса: 0.004 MB Память до запроса: 1.168 MB
INSERT INTO `maw13_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('5b75cac9f4095c26018dcfeac236d067', 1, '1713491006', 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `maw13_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5b75cac9f4095c26018dcfeac236d067', 1, '1713491006', 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.07 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.57 ms После последнего запроса: 0.91 ms Память запроса: 0.035 MB Память до запроса: 1.203 MB Выбрано строк: 36
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `maw13_extensions`
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_extensions NULL ref extension extension 82 const 36 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.19 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.14 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:423 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Так же, как вызов в строке ниже. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:431 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:497 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:596 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 0.84 ms Память запроса: 0.023 MB Память до запроса: 1.310 MB Выбрано строк: 5
SELECT id, rules
FROM `maw13_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_viewlevels NULL ALL NULL Индекс не используется NULL NULL 5 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.17 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.10 ms Память запроса: 0.022 MB Память до запроса: 1.322 MB Выбрано строк: 0
SELECT b.id
FROM maw13_usergroups AS a
LEFT JOIN maw13_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL Индекс не используется NULL NULL NULL NULL no matching row in const table Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.19 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.04 ms После последнего запроса: 0.23 ms Память запроса: 0.034 MB Память до запроса: 1.343 MB Выбрано строк: 106
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM maw13_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_extensions NULL ref extension extension 82 const 119 0.40 Using index condition; Using where; Используется filesort Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.75 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:348 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 5.18 ms Память запроса: 0.028 MB Память до запроса: 1.749 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `maw13_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 21 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 20 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 17 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 16 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 15 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 14 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 13 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 12 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ksencore/ksencore.php:23 11 plgSystemKsenCore->onLoadKsen() Так же, как вызов в строке ниже. 10 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 9 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 8 JEventDispatcher->trigger() JROOT/administrator/components/com_ksenmart/classes/kmplugin.php:17 7 KMPlugin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.30 ms После последнего запроса: 0.17 ms Память запроса: 0.008 MB Память до запроса: 1.743 MB
UPDATE `maw13_extensions`
SET `params` = '{\"mediaversion\":\"fde66f68a93d12ed1e5bb3523387b6f7\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE maw13_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.07 ms updating 0.06 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 16 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 15 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 14 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 13 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 12 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ksencore/ksencore.php:23 11 plgSystemKsenCore->onLoadKsen() Так же, как вызов в строке ниже. 10 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 9 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 8 JEventDispatcher->trigger() JROOT/administrator/components/com_ksenmart/classes/kmplugin.php:17 7 KMPlugin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.85 ms После последнего запроса: 2.86 ms Память запроса: 0.045 MB Память до запроса: 1.945 MB Выбрано строк: 20
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM maw13_menu AS m
LEFT JOIN maw13_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 22 3.33 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.m.component_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.26 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.29 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 33 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 32 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 31 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Так же, как вызов в строке ниже. 30 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 29 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 28 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 27 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 26 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 25 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:374 24 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 23 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:436 22 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 21 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 20 Joomla\CMS\HTML\HTMLHelper::script() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 18 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 17 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:91 16 JHtmlBehavior::core() JROOT/libraries/cms/html/behavior.php:712 15 JHtmlBehavior::keepalive() Так же, как вызов в строке ниже. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/ksencore/ksencore.php:43 11 plgSystemKsenCore->onLoadKsen() Так же, как вызов в строке ниже. 10 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 9 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 8 JEventDispatcher->trigger() JROOT/administrator/components/com_ksenmart/classes/kmplugin.php:17 7 KMPlugin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.51 ms После последнего запроса: 0.77 ms Память запроса: 0.040 MB Память до запроса: 2.023 MB Выбрано строк: 4
SELECT id, home, template, s.params
FROM maw13_template_styles as s
LEFT JOIN maw13_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template Индекс не используется NULL NULL 6 16.67 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 ldmco_demo.s.template,const 1 4.70 Using index condition; Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 22 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 21 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 20 Joomla\CMS\HTML\HTMLHelper::script() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 18 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 17 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:91 16 JHtmlBehavior::core() JROOT/libraries/cms/html/behavior.php:712 15 JHtmlBehavior::keepalive() Так же, как вызов в строке ниже. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/ksencore/ksencore.php:43 11 plgSystemKsenCore->onLoadKsen() Так же, как вызов в строке ниже. 10 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 9 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 8 JEventDispatcher->trigger() JROOT/administrator/components/com_ksenmart/classes/kmplugin.php:17 7 KMPlugin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.33 ms После последнего запроса: 25.15 ms Память запроса: 0.022 MB Память до запроса: 2.738 MB Выбрано строк: 0
SELECT id
FROM maw13_ksenmart_categories
WHERE alias='nes_amp_west_2_2101_00_0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_categories NULL ALL NULL Индекс не используется NULL NULL 12 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 10 JDatabaseDriver->loadResult() JROOT/components/com_ksenmart/router.php:553 9 KsenmartRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 2.743 MB Выбрано строк: 0
SELECT id
FROM maw13_ksenmart_manufacturers
WHERE alias='nes_amp_west_2_2101_00_0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_manufacturers NULL ALL NULL Индекс не используется NULL NULL 12 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 10 JDatabaseDriver->loadResult() JROOT/components/com_ksenmart/router.php:564 9 KsenmartRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.04 ms Память запроса: 0.022 MB Память до запроса: 2.748 MB Выбрано строк: 0
SELECT id
FROM maw13_ksenmart_countries
WHERE alias='nes_amp_west_2_2101_00_0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_countries NULL ALL NULL Индекс не используется NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 10 JDatabaseDriver->loadResult() JROOT/components/com_ksenmart/router.php:574 9 KsenmartRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.30 ms После последнего запроса: 0.04 ms Память запроса: 0.023 MB Память до запроса: 2.754 MB Выбрано строк: 1
SELECT id, parent_id
FROM maw13_ksenmart_products
WHERE alias='nes_amp_west_2_2101_00_0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products NULL ALL NULL Индекс не используется NULL NULL 59 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.10 ms init 0.02 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 10 JDatabaseDriver->loadObject() JROOT/components/com_ksenmart/router.php:584 9 KsenmartRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.65 ms После последнего запроса: 0.15 ms Память запроса: 0.027 MB Память до запроса: 2.780 MB Выбрано строк: 12
SELECT *
FROM maw13_ksen_seo_config
WHERE extension='com_ksenmart'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksen_seo_config NULL ALL NULL Индекс не используется NULL NULL 12 10.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() Так же, как вызов в строке ниже. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/ksencore/core/helpers/common/system.php:103 12 KSSystem::getSeoConfig() JROOT/components/com_ksenmart/router.php:69 11 KsenmartRouter->build() JROOT/components/com_ksenmart/router.php:708 10 KsenmartBuildRoute() JROOT/components/com_ksenmart/router.php:670 9 KsenmartRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.84 ms После последнего запроса: 0.45 ms Память запроса: 0.026 MB Память до запроса: 2.818 MB Выбрано строк: 2
SELECT *
FROM maw13_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_languages NULL ALL NULL Индекс не используется NULL NULL 2 50.00 Using where; Используется filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.52 ms После последнего запроса: 2.12 ms Память запроса: 0.030 MB Память до запроса: 3.018 MB Выбрано строк: 2
SELECT *
FROM maw13_ksenmart_discounts
WHERE enabled=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_discounts NULL ALL NULL Индекс не используется NULL NULL 3 33.33 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/administrator/components/com_ksenmart/helpers/common/price.php:56 11 KSMPrice::getDiscount() JROOT/plugins/kmdiscount/coupons/coupons.php:331 10 plgKMDiscountCoupons->onBeforeStartComponent() Так же, как вызов в строке ниже. 9 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/components/com_ksenmart/ksenmart.php:13 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.48 ms После последнего запроса: 0.39 ms Память запроса: 0.024 MB Память до запроса: 3.050 MB Выбрано строк: 1
SELECT count(id)
FROM maw13_ksenmart_currencies
WHERE cbrf_update < '2024-04-19'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_currencies NULL ALL NULL Индекс не используется NULL NULL 3 33.33 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 13 JDatabaseDriver->loadResult() Так же, как вызов в строке ниже. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/kmplugins/cbrf/cbrf.php:24 10 plgKMPluginsCbrf->onBeforeStartComponent() Так же, как вызов в строке ниже. 9 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/components/com_ksenmart/ksenmart.php:13 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.88 ms После последнего запроса: 5.73 ms Память запроса: 0.037 MB Память до запроса: 3.182 MB Выбрано строк: 1
SELECT (select f.filename
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as filename,(select f.folder
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as folder,(select f.params
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as params,`p`.*, pc.category_id,`m`.`title` AS `manufacturer_title`,`u`.`form1` AS `unit`
FROM `maw13_ksenmart_products` AS `p`
LEFT JOIN `maw13_ksenmart_products_categories` AS `pc`
ON `p`.`id`=`pc`.`product_id`
LEFT JOIN `maw13_ksenmart_manufacturers` AS `m`
ON `p`.`manufacturer`=`m`.`id`
LEFT JOIN `maw13_ksenmart_product_units` AS `u`
ON `p`.`product_unit`=`u`.`id`
WHERE `pc`.`is_default`='1'
AND `p`.`id`='1512'
GROUP BY `p`.`id`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY p NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY m NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 PRIMARY u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY pc NULL ref product_id product_id 4 const 1 10.00 Using where; Using index 4 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 3 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 2 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.60 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.05 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.06 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.07 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.05 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:91 12 KSMProducts::getProduct() JROOT/components/com_ksenmart/models/product.php:33 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.23 ms После последнего запроса: 0.19 ms Память запроса: 0.029 MB Память до запроса: 3.195 MB Выбрано строк: 3
select *
from maw13_ksenmart_currenciesid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_currencies NULL ALL NULL Индекс не используется NULL NULL 3 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/price.php:23 17 KSMPrice::getCurrencies() JROOT/administrator/components/com_ksenmart/helpers/common/price.php:36 16 KSMPrice::_getDefaultCurrency() JROOT/administrator/components/com_ksenmart/helpers/common/price.php:137 15 KSMPrice::getPriceInCurrentCurrency() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:337 14 KSMProducts::productPricesTransform() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:324 13 KSMProducts::prepareProduct() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:93 12 KSMProducts::getProduct() JROOT/components/com_ksenmart/models/product.php:33 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.92 ms После последнего запроса: 1.52 ms Память запроса: 0.025 MB Память до запроса: 3.215 MB Выбрано строк: 26
SELECT c.rate
FROM maw13_ksenmart_comments AS c
WHERE c.product_id=1512id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ALL NULL Индекс не используется NULL NULL 351 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.56 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:609 12 KSMProducts::getProductRate() JROOT/components/com_ksenmart/models/product.php:41 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.29 ms После последнего запроса: 0.17 ms Память запроса: 0.027 MB Память до запроса: 3.224 MB Выбрано строк: 0
SELECT `m`.`id`,`m`.`title`,`m`.`alias`,`m`.`content`,`m`.`introcontent`,`m`.`country`,`m`.`ordering`,`m`.`metatitle`,`m`.`metadescription`,`m`.`metakeywords`,`f`.`filename`,`f`.`folder`,`f`.`params`
FROM `maw13_ksenmart_manufacturers` AS `m`
LEFT JOIN `maw13_ksenmart_files` AS `f`
ON `m`.`id`=`f`.`owner_id`
AND`f`.`owner_type`='manufacturer'
WHERE `m`.`id`='0'
AND `m`.`published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL Индекс не используется NULL NULL NULL NULL no matching row in const table Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:653 12 KSMProducts::getProductManufacturer() JROOT/components/com_ksenmart/models/product.php:42 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.22 ms После последнего запроса: 0.12 ms Память запроса: 0.027 MB Память до запроса: 3.232 MB Выбрано строк: 0
SELECT c.id, c.user_id AS user, c.parent_id, c.product_id AS product, c.comment, c.name AS comment_name, c.good, c.bad, c.rate, c.date_add, uf.filename AS logo, u.name
FROM maw13_ksenmart_comments AS c
LEFT JOIN maw13_ksen_users AS kmu
ON kmu.id=c.user_id
LEFT JOIN maw13_users AS u
ON kmu.id=u.id
LEFT JOIN maw13_ksenmart_files AS uf
ON uf.owner_id=u.id
WHERE c.product_id=1512
AND c.published=1
AND c.parent_id=0
ORDER BY c.date_add DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ALL NULL Индекс не используется NULL NULL 351 0.28 Using where; Используется filesort 1 SIMPLE kmu NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.c.user_id 1 100.00 Using index 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.kmu.id 1 100.00 NULL 1 SIMPLE uf NULL ref owner_id owner_id 4 ldmco_demo.u.id 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.40 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.52 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/components/com_ksenmart/models/product.php:107 12 KsenMartModelProduct->getProductComments() JROOT/components/com_ksenmart/models/product.php:44 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.41 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB Память до запроса: 3.236 MB Выбрано строк: 1
SELECT product_id
FROM maw13_ksenmart_products_relations
WHERE relation_type='
set'
AND relative_id=1512id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products_relations NULL ref relative_id,relation_type relative_id 4 const 1 66.67 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 13 JDatabaseDriver->loadColumn() JROOT/components/com_ksenmart/models/product.php:71 12 KsenMartModelProduct->getProductRelations() JROOT/components/com_ksenmart/models/product.php:45 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.94 ms После последнего запроса: 0.18 ms Память запроса: 0.038 MB Память до запроса: 3.249 MB Выбрано строк: 1
SELECT (select f.filename
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as filename,(select f.folder
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as folder,(select f.params
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as params,`p`.*, pc.category_id,`m`.`title` AS `manufacturer_title`,`u`.`form1` AS `unit`
FROM `maw13_ksenmart_products` AS `p`
LEFT JOIN `maw13_ksenmart_products_categories` AS `pc`
ON `p`.`id`=`pc`.`product_id`
LEFT JOIN `maw13_ksenmart_manufacturers` AS `m`
ON `p`.`manufacturer`=`m`.`id`
LEFT JOIN `maw13_ksenmart_product_units` AS `u`
ON `p`.`product_unit`=`u`.`id`
WHERE `pc`.`is_default`='1'
AND `p`.`id`='1620'
GROUP BY `p`.`id`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY p NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY m NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 PRIMARY u NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 PRIMARY pc NULL ref product_id product_id 4 const 2 10.00 Using where; Using index 4 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 3 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 2 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.04 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Sorting result 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Sorting result 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.04 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.03 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.03 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:91 14 KSMProducts::getProduct() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:218 13 KSMProducts::getProducts() JROOT/components/com_ksenmart/models/product.php:73 12 KsenMartModelProduct->getProductRelations() JROOT/components/com_ksenmart/models/product.php:45 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.69 ms Память запроса: 0.006 MB Память до запроса: 3.257 MB
update maw13_ksenmart_products
set hits=hits+1
where id='1512'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE maw13_ksenmart_products NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.03 ms updating 0.07 ms end 0.01 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:679 12 KSMProducts::incProductHit() JROOT/components/com_ksenmart/models/product.php:48 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.86 ms После последнего запроса: 0.08 ms Память запроса: 0.032 MB Память до запроса: 3.268 MB Выбрано строк: 2
SELECT ppv.id, ppv.property_id, ppv.value_id, ppv.text, p.*
FROM maw13_ksenmart_properties AS p
LEFT JOIN maw13_ksenmart_product_properties_values AS ppv
ON p.id=ppv.property_id
WHERE ppv.product_id=1512
AND p.published=1
GROUP BY ppv.property_id
ORDER BY p.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p NULL ALL PRIMARY Индекс не используется NULL NULL 6 16.67 Using where; Using temporary; Используется filesort 1 SIMPLE ppv NULL ref product_id product_id 8 const,ldmco_demo.p.id 3 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.37 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.12 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:546 18 KSMProducts::getProperties() JROOT/administrator/components/com_ksenmart/classes/product.php:24 17 KSMProduct->__get() JROOT/plugins/kmplugins/propertypositions/propertypositions.php:90 16 plgKMPluginsPropertypositions->onAfterExecuteKSMProductgetProduct() Так же, как вызов в строке ниже. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/models/modelksform.php:42 12 JModelKSForm->onExecuteAfter() JROOT/components/com_ksenmart/models/product.php:50 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.63 ms После последнего запроса: 0.08 ms Память запроса: 0.030 MB Память до запроса: 3.288 MB Выбрано строк: 4
SELECT pv.*, ppv.property_id, ppv.price, ppv.text
FROM maw13_ksenmart_property_values AS pv
LEFT JOIN maw13_ksenmart_product_properties_values AS ppv
ON ppv.value_id=pv.id
WHERE ppv.product_id=1512
GROUP BY pv.id
ORDER BY pv.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ppv NULL ref product_id product_id 4 const 4 100.00 Using index condition; Using temporary; Используется filesort 1 SIMPLE pv NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.ppv.value_id 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.18 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.09 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:580 19 KSMProducts::getPropertiesChild() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:547 18 KSMProducts::getProperties() JROOT/administrator/components/com_ksenmart/classes/product.php:24 17 KSMProduct->__get() JROOT/plugins/kmplugins/propertypositions/propertypositions.php:90 16 plgKMPluginsPropertypositions->onAfterExecuteKSMProductgetProduct() Так же, как вызов в строке ниже. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/models/modelksform.php:42 12 JModelKSForm->onExecuteAfter() JROOT/components/com_ksenmart/models/product.php:50 11 KsenMartModelProduct->getProduct() JROOT/components/com_ksenmart/views/product/view.html.php:28 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.25 ms После последнего запроса: 0.11 ms Память запроса: 0.026 MB Память до запроса: 3.299 MB Выбрано строк: 1Повторяющиеся запросы: #39
SELECT pc.category_id
FROM maw13_ksenmart_products_categories AS pc
WHERE pc.product_id=1512
ORDER BY is_default DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pc NULL ref product_id product_id 4 const 1 100.00 Using where; Using index; Используется filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 16 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:830 15 KSMProducts::getProductCategories() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:847 14 KSMProducts::getProductCategory() JROOT/administrator/components/com_ksenmart/classes/product.php:60 13 KSMProduct->__get() JROOT/components/com_ksenmart/models/product.php:457 12 KsenMartModelProduct->getCategoriesPath() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_ksenmart/views/product/view.html.php:34 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.21 ms После последнего запроса: 0.10 ms Память запроса: 0.026 MB Память до запроса: 3.308 MB Выбрано строк: 1
SELECT t.id,t.parent_id
FROM `maw13_ksenmart_categories` AS `t`
WHERE (t.id IN (17))
AND t.published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 16 JDatabaseDriver->loadObject() JROOT/plugins/system/ksencore/core/helpers/common/system.php:773 15 KSSystem::getTableByIds() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:869 14 KSMProducts::getProductCategory() JROOT/administrator/components/com_ksenmart/classes/product.php:60 13 KSMProduct->__get() JROOT/components/com_ksenmart/models/product.php:457 12 KsenMartModelProduct->getCategoriesPath() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_ksenmart/views/product/view.html.php:34 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.17 ms После последнего запроса: 0.06 ms Память запроса: 0.026 MB Память до запроса: 3.317 MB Выбрано строк: 1
SELECT t.id,t.parent_id
FROM `maw13_ksenmart_categories` AS `t`
WHERE (t.id IN (36))
AND t.published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 16 JDatabaseDriver->loadObject() JROOT/plugins/system/ksencore/core/helpers/common/system.php:773 15 KSSystem::getTableByIds() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:869 14 KSMProducts::getProductCategory() JROOT/administrator/components/com_ksenmart/classes/product.php:60 13 KSMProduct->__get() JROOT/components/com_ksenmart/models/product.php:457 12 KsenMartModelProduct->getCategoriesPath() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_ksenmart/views/product/view.html.php:34 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.20 ms После последнего запроса: 0.05 ms Память запроса: 0.026 MB Память до запроса: 3.332 MB Выбрано строк: 2
SELECT t.title,t.id,t.alias
FROM `maw13_ksenmart_categories` AS `t`
WHERE (t.id IN (36, 17))id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/plugins/system/ksencore/core/helpers/common/system.php:777 13 KSSystem::getTableByIds() JROOT/components/com_ksenmart/models/product.php:459 12 KsenMartModelProduct->getCategoriesPath() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_ksenmart/views/product/view.html.php:34 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.37 ms После последнего запроса: 0.30 ms Память запроса: 0.026 MB Память до запроса: 3.345 MB Выбрано строк: 1
SELECT `f`.`id`,`f`.`owner_id`,`f`.`media_type`,`f`.`owner_type`,`f`.`folder`,`f`.`filename`,`f`.`mime_type`,`f`.`title`,`f`.`ordering`,`f`.`params`
FROM `maw13_ksenmart_files` AS `f`
WHERE `f`.`owner_id`='1512'
AND `f`.`owner_type`='product'
AND `f`.`media_type`='image'
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/components/com_ksenmart/models/product.php:424 11 KsenMartModelProduct->getImages() JROOT/components/com_ksenmart/views/product/view.html.php:42 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.33 ms После последнего запроса: 0.43 ms Память запроса: 0.024 MB Память до запроса: 3.353 MB Выбрано строк: 2
SELECT pr.relative_id
FROM maw13_ksenmart_products_relations AS pr
WHERE pr.relation_type="relation"
AND pr.product_id=1512id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pr NULL index_merge product_id,relation_type product_id,relation_type 4,1 NULL 1 100.00 Using intersect(product_id,relation_type); Using where Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 12 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:777 11 KSMProducts::getRelated() JROOT/components/com_ksenmart/views/product/view.html.php:43 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.09 ms После последнего запроса: 0.15 ms Память запроса: 0.038 MB Память до запроса: 3.366 MB Выбрано строк: 1
SELECT (select f.filename
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as filename,(select f.folder
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as folder,(select f.params
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as params,`p`.*, pc.category_id,`m`.`title` AS `manufacturer_title`,`u`.`form1` AS `unit`
FROM `maw13_ksenmart_products` AS `p`
LEFT JOIN `maw13_ksenmart_products_categories` AS `pc`
ON `p`.`id`=`pc`.`product_id`
LEFT JOIN `maw13_ksenmart_manufacturers` AS `m`
ON `p`.`manufacturer`=`m`.`id`
LEFT JOIN `maw13_ksenmart_product_units` AS `u`
ON `p`.`product_unit`=`u`.`id`
WHERE `pc`.`is_default`='1'
AND `p`.`id`='1524'
GROUP BY `p`.`id`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY p NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY m NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 PRIMARY u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY pc NULL ref product_id product_id 4 const 1 10.00 Using where; Using index 4 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 3 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 2 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.04 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.06 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.05 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.03 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:91 13 KSMProducts::getProduct() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:218 12 KSMProducts::getProducts() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:778 11 KSMProducts::getRelated() JROOT/components/com_ksenmart/views/product/view.html.php:43 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.10 ms После последнего запроса: 0.78 ms Память запроса: 0.038 MB Память до запроса: 3.383 MB Выбрано строк: 1
SELECT (select f.filename
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as filename,(select f.folder
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as folder,(select f.params
from maw13_ksenmart_files as f
where f.owner_id=p.id
and owner_type="product"
and media_type="image"
order by ordering
limit 1) as params,`p`.*, pc.category_id,`m`.`title` AS `manufacturer_title`,`u`.`form1` AS `unit`
FROM `maw13_ksenmart_products` AS `p`
LEFT JOIN `maw13_ksenmart_products_categories` AS `pc`
ON `p`.`id`=`pc`.`product_id`
LEFT JOIN `maw13_ksenmart_manufacturers` AS `m`
ON `p`.`manufacturer`=`m`.`id`
LEFT JOIN `maw13_ksenmart_product_units` AS `u`
ON `p`.`product_unit`=`u`.`id`
WHERE `pc`.`is_default`='1'
AND `p`.`id`='1525'
GROUP BY `p`.`id`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY p NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY m NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 PRIMARY u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY pc NULL ref product_id product_id 4 const 1 10.00 Using where; Using index 4 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 3 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort 2 DEPENDENT SUBQUERY f NULL ref owner_id,media_type,owner_type owner_id 4 const 1 90.07 Using index condition; Using where; Используется filesort Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.06 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.05 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.03 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:91 13 KSMProducts::getProduct() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:218 12 KSMProducts::getProducts() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:778 11 KSMProducts::getRelated() JROOT/components/com_ksenmart/views/product/view.html.php:43 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.12 ms После последнего запроса: 4.14 ms Память запроса: 0.033 MB Память до запроса: 3.501 MB Выбрано строк: 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `maw13_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_ksen','com_ksenmart','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_assets NULL ALL idx_asset_name Индекс не используется NULL NULL 190 19.47 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.01 ms executing 0.00 ms Sending data 0.41 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 23 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 22 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 21 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 20 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 19 Joomla\CMS\User\User->authorise() JROOT/components/com_ksenmart/views/product/tmpl/product_edit.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_edit.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:10 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 1.28 ms Память запроса: 0.029 MB Память до запроса: 3.569 MB Выбрано строк: 1Повторяющиеся запросы: #30
SELECT pc.category_id
FROM maw13_ksenmart_products_categories AS pc
WHERE pc.product_id=1512
ORDER BY is_default DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pc NULL ref product_id product_id 4 const 1 100.00 Using where; Using index; Используется filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 23 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:830 22 KSMProducts::getProductCategories() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:847 21 KSMProducts::getProductCategory() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:375 20 KSMProducts::getLinks() JROOT/administrator/components/com_ksenmart/classes/product.php:54 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:16 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.26 ms После последнего запроса: 0.16 ms Память запроса: 0.028 MB Память до запроса: 3.581 MB Выбрано строк: 1
SELECT product_id
FROM maw13_ksenmart_products_categories
WHERE product_id<'1512'
AND category_id='17'
ORDER BY product_id DESC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products_categories NULL range product_id product_id 4 NULL 2 10.00 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:387 20 KSMProducts::getLinks() JROOT/administrator/components/com_ksenmart/classes/product.php:54 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:16 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 0.10 ms Память запроса: 0.028 MB Память до запроса: 3.591 MB Выбрано строк: 1
SELECT product_id
FROM maw13_ksenmart_products_categories
WHERE product_id>'1512'
AND category_id='17'
ORDER BY product_id ASC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products_categories NULL range product_id product_id 4 NULL 62 10.00 Using where; Using index Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:411 20 KSMProducts::getLinks() JROOT/administrator/components/com_ksenmart/classes/product.php:54 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:16 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 0.12 ms Память запроса: 0.031 MB Память до запроса: 3.606 MB Выбрано строк: 1
SELECT pp.alias
FROM maw13_ksenmart_products as p
LEFT JOIN maw13_ksenmart_products as pp
on p.parent_id=pp.id
WHERE p.id=1511id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE pp NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 28 JDatabaseDriver->loadResult() JROOT/components/com_ksenmart/router.php:165 27 KsenmartRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 26 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 25 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 24 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 23 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 22 Joomla\CMS\Router\Route::_() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:437 21 KSMProducts::generateProductLink() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:427 20 KSMProducts::getLinks() JROOT/administrator/components/com_ksenmart/classes/product.php:54 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:16 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.13 ms После последнего запроса: 0.06 ms Память запроса: 0.031 MB Память до запроса: 3.622 MB Выбрано строк: 1
SELECT alias
FROM maw13_ksenmart_products
WHERE id='1511:'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 29 JDatabaseDriver->loadResult() JROOT/components/com_ksenmart/router.php:686 28 KsenmartRouter->getAlias() JROOT/components/com_ksenmart/router.php:175 27 KsenmartRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 26 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 25 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 24 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 23 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 22 Joomla\CMS\Router\Route::_() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:437 21 KSMProducts::generateProductLink() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:427 20 KSMProducts::getLinks() JROOT/administrator/components/com_ksenmart/classes/product.php:54 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:16 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.15 ms После последнего запроса: 0.15 ms Память запроса: 0.031 MB Память до запроса: 3.635 MB Выбрано строк: 1
SELECT pp.alias
FROM maw13_ksenmart_products as p
LEFT JOIN maw13_ksenmart_products as pp
on p.parent_id=pp.id
WHERE p.id=1513id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE pp NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 28 JDatabaseDriver->loadResult() JROOT/components/com_ksenmart/router.php:165 27 KsenmartRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 26 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 25 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 24 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 23 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 22 Joomla\CMS\Router\Route::_() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:437 21 KSMProducts::generateProductLink() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:428 20 KSMProducts::getLinks() JROOT/administrator/components/com_ksenmart/classes/product.php:54 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:16 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.16 ms После последнего запроса: 0.07 ms Память запроса: 0.031 MB Память до запроса: 3.650 MB Выбрано строк: 1
SELECT alias
FROM maw13_ksenmart_products
WHERE id='1513:'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 29 JDatabaseDriver->loadResult() JROOT/components/com_ksenmart/router.php:686 28 KsenmartRouter->getAlias() JROOT/components/com_ksenmart/router.php:175 27 KsenmartRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 26 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 25 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 24 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 23 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 22 Joomla\CMS\Router\Route::_() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:437 21 KSMProducts::generateProductLink() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:428 20 KSMProducts::getLinks() JROOT/administrator/components/com_ksenmart/classes/product.php:54 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php:10 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_toplinks.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:16 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.77 ms После последнего запроса: 0.74 ms Память запроса: 0.039 MB Память до запроса: 3.666 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `maw13_contentitem_tag_map` AS m
INNER JOIN `maw13_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_ksenmart.product'
AND `m`.`content_item_id` = 1512
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type Индекс не используется NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ldmco_demo.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.41 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 20 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/administrator/components/com_ksenmart/classes/product.php:42 19 KSMProduct->__get() JROOT/components/com_ksenmart/views/product/tmpl/product_info.php:39 18 include JROOT/components/com_ksenmart/views/product/tmpl/product_info.php JROOT/libraries/src/MVC/View/HtmlView.php:695 17 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:25 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.17 ms После последнего запроса: 9.33 ms Память запроса: 0.028 MB Память до запроса: 3.815 MB Выбрано строк: 1
SELECT title
FROM maw13_ksenmart_categories
WHERE id = 17id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 22 JDatabaseDriver->loadResult() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:119 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.41 ms После последнего запроса: 0.14 ms Память запроса: 0.028 MB Память до запроса: 3.827 MB Выбрано строк: 7
SELECT p.id
FROM maw13_ksenmart_products as p
INNER JOIN maw13_ksenmart_products_categories as pc
on pc.product_id = p.id
WHERE pc.category_id = 17
AND p.published = 1
AND p.parent_id = 0
AND p.id != 1512
ORDER BY RAND()
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p NULL ALL PRIMARY Индекс не используется NULL NULL 59 1.69 Using where; Using temporary; Используется filesort 1 SIMPLE pc NULL ref product_id product_id 8 ldmco_demo.p.id,const 1 100.00 Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.15 ms Creating sort index 0.02 ms end 0.00 ms query end 0.00 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 22 JDatabaseDriver->loadColumn() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:135 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.30 ms После последнего запроса: 0.33 ms Память запроса: 0.045 MB Память до запроса: 3.840 MB Выбрано строк: 7
SELECT *
FROM maw13_ksenmart_products
WHERE id IN (1513,1618,1623,1621,1511,1510,1619)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products NULL range PRIMARY PRIMARY 4 NULL 7 100.00 Using index condition Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 23 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:156 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:137 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.45 ms После последнего запроса: 0.23 ms Память запроса: 0.031 MB Память до запроса: 3.886 MB Выбрано строк: 7
SELECT owner_id, filename, folder, params
FROM maw13_ksenmart_files
WHERE owner_id IN (1513,1618,1623,1621,1511,1510,1619)
AND owner_type="product"
GROUP BY owner_id
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_files NULL range owner_id,owner_type owner_id 4 NULL 7 90.07 Using index condition; Using where; Using temporary; Используется filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms Creating tmp table 0.01 ms Sorting for group 0.00 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.16 ms Creating sort index 0.03 ms end 0.00 ms query end 0.00 ms removing tmp table 0.03 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:981 24 KSMProducts::getFiles() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:263 23 KSMProducts::getEagers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:158 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:137 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.15 ms После последнего запроса: 0.16 ms Память запроса: 0.030 MB Память до запроса: 3.902 MB Выбрано строк: 2
SELECT id, title
FROM maw13_ksenmart_manufacturers
WHERE id IN (3,0,12)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_manufacturers NULL range PRIMARY PRIMARY 4 NULL 3 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:926 24 KSMProducts::getManufacturers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:266 23 KSMProducts::getEagers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:158 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:137 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.13 ms После последнего запроса: 0.14 ms Память запроса: 0.029 MB Память до запроса: 3.915 MB Выбрано строк: 1
SELECT id, form1
FROM maw13_ksenmart_product_units
WHERE id IN (3,0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_product_units NULL range PRIMARY PRIMARY 4 NULL 2 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:950 24 KSMProducts::getUnits() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:272 23 KSMProducts::getEagers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:158 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:137 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.80 ms После последнего запроса: 7.10 ms Память запроса: 0.028 MB Память до запроса: 3.945 MB Выбрано строк: 10
SELECT p.id
FROM maw13_ksenmart_products as p
INNER JOIN maw13_ksenmart_products_categories as pc
on pc.product_id = p.id
WHERE pc.category_id != 17
AND p.published = 1
AND p.parent_id = 0
AND p.id != 1512
ORDER BY RAND()
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p NULL ALL PRIMARY Индекс не используется NULL NULL 59 1.69 Using where; Using temporary; Используется filesort 1 SIMPLE pc NULL ref product_id product_id 4 ldmco_demo.p.id 1 90.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.33 ms Creating sort index 0.05 ms end 0.00 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 22 JDatabaseDriver->loadColumn() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:163 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.46 ms После последнего запроса: 0.18 ms Память запроса: 0.049 MB Память до запроса: 3.959 MB Выбрано строк: 8
SELECT *
FROM maw13_ksenmart_products
WHERE id IN (1518,1520,1531,1532,1629,1532,1634,1631,1593)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products NULL range PRIMARY PRIMARY 4 NULL 8 100.00 Using index condition Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.21 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 23 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:156 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:165 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.66 ms После последнего запроса: 0.24 ms Память запроса: 0.031 MB Память до запроса: 4.015 MB Выбрано строк: 8
SELECT owner_id, filename, folder, params
FROM maw13_ksenmart_files
WHERE owner_id IN (1518,1520,1531,1532,1629,1532,1634,1631,1593)
AND owner_type="product"
GROUP BY owner_id
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_files NULL range owner_id,owner_type owner_id 4 NULL 8 90.07 Using index condition; Using where; Using temporary; Используется filesort Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms Creating tmp table 0.02 ms Sorting for group 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.26 ms Creating sort index 0.05 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:981 24 KSMProducts::getFiles() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:263 23 KSMProducts::getEagers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:158 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:165 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 0.31 ms Память запроса: 0.030 MB Память до запроса: 4.032 MB Выбрано строк: 5
SELECT id, title
FROM maw13_ksenmart_manufacturers
WHERE id IN (12,9,10,5,0,3)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_manufacturers NULL ALL PRIMARY Индекс не используется NULL NULL 12 50.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:926 24 KSMProducts::getManufacturers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:266 23 KSMProducts::getEagers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:158 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:165 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.25 ms После последнего запроса: 0.41 ms Память запроса: 0.029 MB Память до запроса: 4.047 MB Выбрано строк: 1
SELECT id, form1
FROM maw13_ksenmart_product_units
WHERE id IN (3)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_product_units NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:950 24 KSMProducts::getUnits() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:272 23 KSMProducts::getEagers() JROOT/administrator/components/com_ksenmart/helpers/common/product.php:158 22 KSMProducts::getProducts() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:165 21 plgKMPluginsSameProducts->getHtml() JROOT/plugins/kmplugins/sameproducts/sameproducts.php:51 20 plgKMPluginsSameProducts->onAfterDisplayKSMProductProduct_related() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 17 JEventDispatcher->trigger() JROOT/plugins/system/ksencore/core/views/viewks.php:79 16 JViewKS->loadTemplate() JROOT/components/com_ksenmart/views/product/tmpl/product.php:36 15 include JROOT/components/com_ksenmart/views/product/tmpl/product.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/ksencore/core/views/viewks.php:75 13 JViewKS->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/plugins/system/ksencore/core/views/viewks.php:31 11 JViewKS->display() JROOT/components/com_ksenmart/views/product/view.html.php:138 10 KsenMartViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_ksenmart/controller.php:53 8 KsenMartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_ksenmart/ksenmart.php:22 6 require_once JROOT/components/com_ksenmart/ksenmart.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.14 ms После последнего запроса: 23.59 ms Память запроса: 0.030 MB Память до запроса: 4.320 MB Выбрано строк: 13
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM maw13_modules AS m
LEFT JOIN maw13_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN maw13_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-19 01:43:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 01:43:26')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 530 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds published 1 const 43 1.64 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 ldmco_demo.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 ldmco_demo.m.id 1 40.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.34 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.42 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 14 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 13 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 12 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 11 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix3/core/helix3.php:508 10 Helix3::countModules() JROOT/plugins/system/helix3/core/helix3.php:455 9 Helix3::rowColumns() JROOT/plugins/system/helix3/core/helix3.php:264 8 Helix3::generatelayout() JROOT/templates/shaper_helix3/index.php:179 7 require JROOT/templates/shaper_helix3/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.19 ms После последнего запроса: 0.27 ms Память запроса: 0.027 MB Память до запроса: 4.328 MB Выбрано строк: 1
SELECT id
FROM maw13_ksenmart_products_categories
WHERE product_id=1512id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_products_categories NULL ref product_id product_id 4 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 19 JDatabaseDriver->loadColumn() JROOT/plugins/kmplugins/modules/modules.php:97 18 plgKMPluginsModules->onAfterModuleList() Так же, как вызов в строке ниже. 17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 14 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:366 13 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 12 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 11 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix3/core/helix3.php:508 10 Helix3::countModules() JROOT/plugins/system/helix3/core/helix3.php:455 9 Helix3::rowColumns() JROOT/plugins/system/helix3/core/helix3.php:264 8 Helix3::generatelayout() JROOT/templates/shaper_helix3/index.php:179 7 require JROOT/templates/shaper_helix3/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.57 ms После последнего запроса: 20.23 ms Память запроса: 0.028 MB Память до запроса: 4.394 MB Выбрано строк: 12
SELECT `kc`.`id`,`kc`.`title`,`kc`.`alias`,`kc`.`parent_id`,`kc`.`minprice`
FROM maw13_ksenmart_categories as kc
WHERE kc.published=1
ORDER BY kc.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kc NULL ALL NULL Индекс не используется NULL NULL 12 10.00 Using where; Используется filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_ksenmart/helpers/common/catalog.php:58 15 KSMCatalog::getCategoriesTree() JROOT/modules/mod_km_categories/helper.php:73 14 modKsenmartCategoriesHelper::view_tree() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:559 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_km_categories/mod_km_categories.php:40 10 include JROOT/modules/mod_km_categories/mod_km_categories.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 4.86 ms Память запроса: 0.024 MB Память до запроса: 4.437 MB Выбрано строк: 0
SELECT id
FROM maw13_ksenmart_categories
WHERE parent_id=17id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_categories NULL ALL NULL Индекс не используется NULL NULL 12 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 13 JDatabaseDriver->loadColumn() JROOT/modules/mod_km_filter/helper.php:264 12 modKMFilterHelper->getChildCats() JROOT/modules/mod_km_filter/helper.php:54 11 modKMFilterHelper->init() JROOT/modules/mod_km_filter/mod_km_filter.php:29 10 include JROOT/modules/mod_km_filter/mod_km_filter.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.51 ms После последнего запроса: 0.24 ms Память запроса: 0.024 MB Память до запроса: 4.446 MB Выбрано строк: 1
SELECT min(p.price/c.rate) as min, max(p.price/c.rate) as max
FROM maw13_ksenmart_products as p
INNER JOIN maw13_ksenmart_products_categories as pc
on p.id=pc.product_id
LEFT JOIN maw13_ksenmart_currencies as c
on p.price_type=c.id
WHERE p.published=1
and (pc.category_id in (17))id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pc NULL index product_id product_id 12 NULL 65 10.00 Using where; Using index 1 SIMPLE p NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.pc.product_id 1 10.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.p.price_type 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sending data 0.12 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/modules/mod_km_filter/helper.php:129 12 modKMFilterHelper->getPrices() JROOT/modules/mod_km_filter/helper.php:59 11 modKMFilterHelper->init() JROOT/modules/mod_km_filter/mod_km_filter.php:29 10 include JROOT/modules/mod_km_filter/mod_km_filter.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.69 ms После последнего запроса: 0.16 ms Память запроса: 0.027 MB Память до запроса: 4.453 MB Выбрано строк: 2
SELECT m.*
FROM maw13_ksenmart_manufacturers as m
INNER JOIN maw13_ksenmart_products as p
on p.manufacturer=m.id
INNER JOIN maw13_ksenmart_products_categories as pc
on p.id=pc.product_id
WHERE m.published=1
and (pc.category_id in (17))
GROUP BY m.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY Индекс не используется NULL NULL 12 10.00 Using where; Using temporary; Используется filesort 1 SIMPLE pc NULL index product_id product_id 12 NULL 65 10.00 Using where; Using index; Using join buffer (Block Nested Loop) 1 SIMPLE p NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.pc.product_id 1 10.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.30 ms Creating sort index 0.04 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_km_filter/helper.php:156 12 modKMFilterHelper->getManufacturers() JROOT/modules/mod_km_filter/helper.php:60 11 modKMFilterHelper->init() JROOT/modules/mod_km_filter/mod_km_filter.php:29 10 include JROOT/modules/mod_km_filter/mod_km_filter.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.16 ms Память запроса: 0.026 MB Память до запроса: 4.463 MB Выбрано строк: 0
SELECT c.*
FROM maw13_ksenmart_countries as c
INNER JOIN maw13_ksenmart_manufacturers as m
on m.country=c.id
WHERE c.published=1
and m.id IN (3,12)
GROUP BY c.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ALL PRIMARY Индекс не используется NULL NULL 1 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE m NULL range PRIMARY PRIMARY 4 NULL 2 10.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.12 ms Creating sort index 0.02 ms end 0.00 ms query end 0.01 ms removing tmp table 0.02 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_km_filter/helper.php:205 12 modKMFilterHelper->getCountries() JROOT/modules/mod_km_filter/helper.php:61 11 modKMFilterHelper->init() JROOT/modules/mod_km_filter/mod_km_filter.php:29 10 include JROOT/modules/mod_km_filter/mod_km_filter.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.34 ms После последнего запроса: 0.15 ms Память запроса: 0.029 MB Память до запроса: 4.477 MB Выбрано строк: 2
SELECT property_id
FROM maw13_ksenmart_product_categories_properties
WHERE category_id IN (17)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE maw13_ksenmart_product_categories_properties NULL ALL NULL Индекс не используется NULL NULL 17 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.19 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 13 JDatabaseDriver->loadColumn() JROOT/modules/mod_km_filter/helper.php:284 12 modKMFilterHelper::getProperties() JROOT/modules/mod_km_filter/helper.php:65 11 modKMFilterHelper->init() JROOT/modules/mod_km_filter/mod_km_filter.php:29 10 include JROOT/modules/mod_km_filter/mod_km_filter.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.10 ms После последнего запроса: 0.27 ms Память запроса: 0.036 MB Память до запроса: 4.492 MB Выбрано строк: 19
SELECT ppv.id, ppv.property_id, ppv.value_id, ppv.price, p.edit_price, p.range, p.title, p.type, p.view, p.default, p.prefix, p.suffix, pv.title as value_title, pv.image
FROM maw13_ksenmart_product_properties_values AS ppv
LEFT JOIN maw13_ksenmart_properties AS p
ON p.id=ppv.property_id
LEFT JOIN maw13_ksenmart_property_values AS pv
ON pv.id=ppv.value_id
WHERE p.published=1
AND p.id IN (11,5)
GROUP BY ppv.value_id
ORDER BY p.ordering,pv.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE p NULL range PRIMARY PRIMARY 4 NULL 2 16.67 Using where; Using temporary; Используется filesort 1 SIMPLE ppv NULL ALL product_id Индекс не используется NULL NULL 282 10.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE pv NULL eq_ref PRIMARY PRIMARY 4 ldmco_demo.ppv.value_id 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.75 ms Creating sort index 0.05 ms end 0.00 ms query end 0.01 ms removing tmp table 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_km_filter/helper.php:315 12 modKMFilterHelper::getProperties() JROOT/modules/mod_km_filter/helper.php:65 11 modKMFilterHelper->init() JROOT/modules/mod_km_filter/mod_km_filter.php:29 10 include JROOT/modules/mod_km_filter/mod_km_filter.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
51 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
4 × SELECT (select f.filename
from maw13_ksenmart_files as f2 × SELECT pc.category_id
FROM maw13_ksenmart_products_categories AS pc2 × SELECT id, form1
FROM maw13_ksenmart_product_units2 × SELECT product_id
FROM maw13_ksenmart_products_categories2 × SELECT pp.alias
FROM maw13_ksenmart_products as p
LEFT JOIN maw13_ksenmart_products as pp
on p.parent_id=pp.id2 × SELECT alias
FROM maw13_ksenmart_products2 × SELECT p.id
FROM maw13_ksenmart_products as p
INNER JOIN maw13_ksenmart_products_categories as pc
on pc.product_id = p.id2 × SELECT *
FROM maw13_ksenmart_products2 × SELECT owner_id, filename, folder, params
FROM maw13_ksenmart_files2 × SELECT t.id,t.parent_id
FROM `maw13_ksenmart_categories` AS `t`2 × SELECT id, title
FROM maw13_ksenmart_manufacturers2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `maw13_extensions`2 × SELECT id
FROM maw13_ksenmart_categories1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM maw13_modules AS m
LEFT JOIN maw13_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN maw13_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id
FROM maw13_ksenmart_products_categories1 × SELECT `kc`.`id`,`kc`.`title`,`kc`.`alias`,`kc`.`parent_id`,`kc`.`minprice`
FROM maw13_ksenmart_categories as kc1 × SELECT min(p.price/c.rate) as min, max(p.price/c.rate) as max
FROM maw13_ksenmart_products as p
INNER JOIN maw13_ksenmart_products_categories as pc
on p.id=pc.product_id
LEFT JOIN maw13_ksenmart_currencies as c
on p.price_type=c.id1 × SELECT m.*
FROM maw13_ksenmart_manufacturers as m
INNER JOIN maw13_ksenmart_products as p
on p.manufacturer=m.id
INNER JOIN maw13_ksenmart_products_categories as pc
on p.id=pc.product_id1 × SELECT title
FROM maw13_ksenmart_categories1 × SELECT `m`.`tag_id`,`t`.*
FROM `maw13_contentitem_tag_map` AS m
INNER JOIN `maw13_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT c.*
FROM maw13_ksenmart_countries as c
INNER JOIN maw13_ksenmart_manufacturers as m
on m.country=c.id1 × SELECT property_id
FROM maw13_ksenmart_product_categories_properties1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `maw13_assets`1 × SELECT pr.relative_id
FROM maw13_ksenmart_products_relations AS pr1 × SELECT `f`.`id`,`f`.`owner_id`,`f`.`media_type`,`f`.`owner_type`,`f`.`folder`,`f`.`filename`,`f`.`mime_type`,`f`.`title`,`f`.`ordering`,`f`.`params`
FROM `maw13_ksenmart_files` AS `f`1 × SELECT `data`
FROM `maw13_session`1 × SELECT t.title,t.id,t.alias
FROM `maw13_ksenmart_categories` AS `t`1 × SELECT *
FROM maw13_ksen_seo_config1 × SELECT id, rules
FROM `maw13_viewlevels1 × SELECT b.id
FROM maw13_usergroups AS a
LEFT JOIN maw13_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM maw13_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM maw13_menu AS m
LEFT JOIN maw13_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM maw13_template_styles as s
LEFT JOIN maw13_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT id
FROM maw13_ksenmart_manufacturers1 × SELECT id
FROM maw13_ksenmart_countries1 × SELECT id, parent_id
FROM maw13_ksenmart_products1 × SELECT *
FROM maw13_languages1 × SELECT `session_id`
FROM `maw13_session`1 × SELECT *
FROM maw13_ksenmart_discounts1 × SELECT count(id)
FROM maw13_ksenmart_currencies1 × select *
from maw13_ksenmart_currencie1 × SELECT c.rate
FROM maw13_ksenmart_comments AS c1 × SELECT `m`.`id`,`m`.`title`,`m`.`alias`,`m`.`content`,`m`.`introcontent`,`m`.`country`,`m`.`ordering`,`m`.`metatitle`,`m`.`metadescription`,`m`.`metakeywords`,`f`.`filename`,`f`.`folder`,`f`.`params`
FROM `maw13_ksenmart_manufacturers` AS `m`
LEFT JOIN `maw13_ksenmart_files` AS `f`
ON `m`.`id`=`f`.`owner_id`
AND`f`.`owner_type`='manufacturer'1 × SELECT c.id, c.user_id AS user, c.parent_id, c.product_id AS product, c.comment, c.name AS comment_name, c.good, c.bad, c.rate, c.date_add, uf.filename AS logo, u.name
FROM maw13_ksenmart_comments AS c
LEFT JOIN maw13_ksen_users AS kmu
ON kmu.id=c.user_id
LEFT JOIN maw13_users AS u
ON kmu.id=u.id
LEFT JOIN maw13_ksenmart_files AS uf
ON uf.owner_id=u.id1 × SELECT product_id
FROM maw13_ksenmart_products_relations1 × SELECT ppv.id, ppv.property_id, ppv.value_id, ppv.text, p.*
FROM maw13_ksenmart_properties AS p
LEFT JOIN maw13_ksenmart_product_properties_values AS ppv
ON p.id=ppv.property_id1 × SELECT pv.*, ppv.property_id, ppv.price, ppv.text
FROM maw13_ksenmart_property_values AS pv
LEFT JOIN maw13_ksenmart_product_properties_values AS ppv
ON ppv.value_id=pv.id1 × SELECT ppv.id, ppv.property_id, ppv.value_id, ppv.price, p.edit_price, p.range, p.title, p.type, p.view, p.default, p.prefix, p.suffix, pv.title as value_title, pv.image
FROM maw13_ksenmart_product_properties_values AS ppv
LEFT JOIN maw13_ksenmart_properties AS p
ON p.id=ppv.property_id
LEFT JOIN maw13_ksenmart_property_values AS pv
ON pv.id=ppv.value_id
Прочие SQL-запросы:
1 × INSERT INTO `maw13_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('5b75cac9f4095c26018dcfeac236d067', 1, '1713491006', 0, '', 01 × UPDATE `maw13_extensions`
SET `params` = '{\"mediaversion\":\"fde66f68a93d12ed1e5bb3523387b6f7\"}'1 × update maw13_ksenmart_products
set hits=hits+1
Нет отзывов