Время запроса: 0.25 ms Память запроса: 0.023 MB Память до запроса: 1.033 MB Выбрано строк: 0
SELECT `data`
FROM `saqrs_session`
WHERE `session_id` = X'3931363137353038633137396235393964643065303536616461656363306165'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
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:758 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.20 ms После последнего запроса: 0.92 ms Память запроса: 0.020 MB Память до запроса: 1.047 MB Выбрано строк: 0
Повторяющиеся запросы:
#9SELECT `session_id`
FROM `saqrs_session`
WHERE `session_id` = X'3931363137353038633137396235393964643065303536616461656363306165'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.26 ms После последнего запроса: 0.12 ms Память запроса: 0.004 MB Память до запроса: 1.052 MB
INSERT INTO `saqrs_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3931363137353038633137396235393964643065303536616461656363306165', 1, 1679638742, 0, '', 0)
EXPLAIN не доступен для запроса: INSERT INTO `saqrs_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3931363137353038633137396235393964643065303536616461656363306165', 1, 1679638742, 0, '', 0)
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.56 ms После последнего запроса: 1.53 ms Память запроса: 0.040 MB Память до запроса: 1.083 MB Выбрано строк: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `saqrs_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_extensions | NULL | ref | extension | extension | 82 | const | 40 | 1.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
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:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
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:594 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.20 ms После последнего запроса: 2.18 ms Память запроса: 0.021 MB Память до запроса: 1.127 MB Выбрано строк: 5
SELECT id, rules
FROM `saqrs_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_viewlevels | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 5 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
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:321 |
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:604 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.33 ms После последнего запроса: 0.11 ms Память запроса: 0.021 MB Память до запроса: 1.139 MB Выбрано строк: 2
SELECT b.id
FROM saqrs_usergroups AS a
LEFT JOIN saqrs_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
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:321 |
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:604 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.95 ms После последнего запроса: 0.26 ms Память запроса: 0.031 MB Память до запроса: 1.161 MB Выбрано строк: 119
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM saqrs_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_extensions | NULL | ref | extension | extension | 82 | const | 146 | 0.60 | Using index condition; Using where; Используется filesort |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
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:359 |
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:604 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.27 ms После последнего запроса: 14.16 ms Память запроса: 0.043 MB Память до запроса: 1.820 MB Выбрано строк: 9
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 saqrs_menu AS m
LEFT JOIN saqrs_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.lft
id | 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 | 85 | 3.33 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | mebelpr_ksen.m.component_id | 1 | 100.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Так же, как вызов в строке ниже. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1073 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.23 ms После последнего запроса: 4.24 ms Память запроса: 0.024 MB Память до запроса: 2.038 MB Выбрано строк: 1
Повторяющиеся запросы:
#2SELECT `session_id`
FROM `saqrs_session`
WHERE `session_id` = X'3931363137353038633137396235393964643065303536616461656363306165'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
15 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
14 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
13 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
12 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
11 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/plugins/system/ksencore/core/helpers/common/system.php:547 |
10 | KSSystem::getShopItemid() | JROOT/components/com_ksenmart/router.php:518 |
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:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.62 ms После последнего запроса: 0.22 ms Память запроса: 0.021 MB Память до запроса: 2.047 MB Выбрано строк: 1
SELECT id
FROM saqrs_ksenmart_categories
WHERE alias='shkaf'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 313 | 10.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/components/com_ksenmart/router.php:585 |
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:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.45 ms После последнего запроса: 0.06 ms Память запроса: 0.021 MB Память до запроса: 2.052 MB Выбрано строк: 1
SELECT id
FROM saqrs_ksenmart_categories
WHERE alias='shkafy'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 313 | 10.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/components/com_ksenmart/router.php:585 |
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:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB Память до запроса: 2.057 MB Выбрано строк: 1
SELECT parent_id
FROM saqrs_ksenmart_categories
WHERE id=32
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/components/com_ksenmart/router.php:688 |
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:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.37 ms После последнего запроса: 0.16 ms Память запроса: 0.024 MB Память до запроса: 2.084 MB Выбрано строк: 12
SELECT *
FROM saqrs_ksen_seo_config
WHERE extension='com_ksenmart'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksen_seo_config | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 12 | 10.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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:111 |
12 | KSSystem::getSeoConfig() | JROOT/components/com_ksenmart/router.php:70 |
11 | KsenmartRouter->build() | JROOT/components/com_ksenmart/router.php:739 |
10 | KsenmartBuildRoute() | JROOT/components/com_ksenmart/router.php:702 |
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:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 0.17 ms Память запроса: 0.022 MB Память до запроса: 2.096 MB Выбрано строк: 1
SELECT alias,parent_id
FROM saqrs_ksenmart_categories
WHERE id=32
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_ksenmart/router.php:264 |
11 | KsenmartRouter->build() | JROOT/components/com_ksenmart/router.php:739 |
10 | KsenmartBuildRoute() | JROOT/components/com_ksenmart/router.php:702 |
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:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.12 ms После последнего запроса: 0.04 ms Память запроса: 0.022 MB Память до запроса: 2.102 MB Выбрано строк: 1
SELECT alias,parent_id
FROM saqrs_ksenmart_categories
WHERE id=31
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_ksenmart/router.php:264 |
11 | KsenmartRouter->build() | JROOT/components/com_ksenmart/router.php:739 |
10 | KsenmartBuildRoute() | JROOT/components/com_ksenmart/router.php:702 |
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:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.47 ms После последнего запроса: 0.96 ms Память запроса: 0.022 MB Память до запроса: 2.114 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `saqrs_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Так же, как вызов в строке ниже. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1130 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.40 ms После последнего запроса: 0.16 ms Память запроса: 0.005 MB Память до запроса: 2.106 MB
UPDATE `saqrs_extensions`
SET `params` = '{\"mediaversion\":\"88d081d6ad7ccae500e9afeb67ba3e4c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | saqrs_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1130 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.45 ms После последнего запроса: 1.43 ms Память запроса: 0.019 MB Память до запроса: 2.182 MB Выбрано строк: 1
SELECT *
FROM saqrs_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_languages | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 2 | 50.00 | Using where; Используется filesort |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.66 ms После последнего запроса: 0.28 ms Память запроса: 0.019 MB Память до запроса: 2.193 MB Выбрано строк: 3
SELECT id, home, template, s.params
FROM saqrs_template_styles as s
LEFT JOIN saqrs_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 = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | 1.00 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | mebelpr_ksen.e.element | 1 | 100.00 | Using index condition; Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.27 ms После последнего запроса: 24.67 ms Память запроса: 0.023 MB Память до запроса: 2.799 MB Выбрано строк: 0
SELECT *
FROM saqrs_ksenmart_discounts
WHERE enabled=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_discounts | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 1 | 100.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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:338 |
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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.23 ms После последнего запроса: 0.34 ms Память запроса: 0.022 MB Память до запроса: 2.824 MB Выбрано строк: 1
SELECT count(id)
FROM saqrs_ksenmart_currencies
WHERE cbrf_update < '2023-03-24'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_currencies | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 3 | 33.33 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.17 ms После последнего запроса: 4.28 ms Память запроса: 0.023 MB Память до запроса: 2.972 MB Выбрано строк: 1
SELECT
c.*,
f.filename,
f.folder,
f.params,
f.ordering as iordering
FROM saqrs_ksenmart_categories AS c
LEFT JOIN saqrs_ksenmart_files AS f
ON c.id=f.owner_id
AND f.owner_type='category'
WHERE c.published=1
AND c.id=32
ORDER BY f.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Используется filesort |
1 | SIMPLE | f | NULL | ref | owner_id,owner_type | owner_id | 4 | const | 2 | 100.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_ksenmart/models/catalog.php:1102 |
12 | KsenMartModelcatalog->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_ksenmart/views/catalog/view.html.php:51 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.27 ms После последнего запроса: 0.31 ms Память запроса: 0.025 MB Память до запроса: 2.990 MB Выбрано строк: 1
SELECT alias,parent_id
FROM saqrs_ksenmart_categories
WHERE id=32
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
19 | JDatabaseDriver->loadObject() | JROOT/components/com_ksenmart/router.php:264 |
18 | KsenmartRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:527 |
17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/components/com_ksenmart/models/catalog.php:1875 |
11 | KsenMartModelcatalog->setCategoryMetaData() | JROOT/components/com_ksenmart/views/catalog/view.html.php:59 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.26 ms После последнего запроса: 0.05 ms Память запроса: 0.025 MB Память до запроса: 3.000 MB Выбрано строк: 1
SELECT alias,parent_id
FROM saqrs_ksenmart_categories
WHERE id=31
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
19 | JDatabaseDriver->loadObject() | JROOT/components/com_ksenmart/router.php:264 |
18 | KsenmartRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:527 |
17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/components/com_ksenmart/models/catalog.php:1875 |
11 | KsenMartModelcatalog->setCategoryMetaData() | JROOT/components/com_ksenmart/views/catalog/view.html.php:59 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.08 ms После последнего запроса: 0.21 ms Память запроса: 0.022 MB Память до запроса: 3.009 MB Выбрано строк: 0
SELECT
c.*,
f.filename,
f.folder,
f.params,
f.ordering as iordering
FROM saqrs_ksenmart_categories AS c
LEFT JOIN saqrs_ksenmart_files AS f
ON c.id=f.owner_id
AND f.owner_type='category'
WHERE c.published=1
AND c.parent_id=32
ORDER BY c.ordering,f.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 313 | 1.00 | Using where; Using temporary; Используется filesort |
1 | SIMPLE | f | NULL | ref | owner_id,owner_type | owner_id | 4 | mebelpr_ksen.c.id | 3 | 100.00 | Using where |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_ksenmart/models/catalog.php:2027 |
11 | KsenMartModelcatalog->getCategories() | JROOT/components/com_ksenmart/views/catalog/view.html.php:63 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.19 ms После последнего запроса: 0.08 ms Память запроса: 0.022 MB Память до запроса: 3.013 MB Выбрано строк: 1
SELECT c.id,c.parent_id,c.title,c.alias
FROM saqrs_ksenmart_categories AS c
WHERE id=32
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_ksenmart/models/catalog.php:1643 |
12 | KsenMartModelcatalog->getCatalogPath() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_ksenmart/views/catalog/view.html.php:124 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.17 ms После последнего запроса: 0.08 ms Память запроса: 0.022 MB Память до запроса: 3.021 MB Выбрано строк: 1
SELECT c.id,c.parent_id,c.title,c.alias
FROM saqrs_ksenmart_categories AS c
WHERE id=31
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_ksenmart/models/catalog.php:1643 |
12 | KsenMartModelcatalog->getCatalogPath() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_ksenmart/views/catalog/view.html.php:124 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.17 ms После последнего запроса: 0.10 ms Память запроса: 0.025 MB Память до запроса: 3.032 MB Выбрано строк: 1
SELECT alias,parent_id
FROM saqrs_ksenmart_categories
WHERE id=31
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
20 | JDatabaseDriver->loadObject() | JROOT/components/com_ksenmart/router.php:264 |
19 | KsenmartRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:527 |
18 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
17 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/components/com_ksenmart/models/catalog.php:1644 |
12 | KsenMartModelcatalog->getCatalogPath() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_ksenmart/views/catalog/view.html.php:124 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 13.66 ms После последнего запроса: 0.38 ms Память запроса: 0.079 MB Память до запроса: 3.040 MB Выбрано строк: 1748
SELECT DISTINCT product_id
FROM saqrs_ksenmart_products_categories
WHERE (category_id IN (32))
GROUP BY product_id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | saqrs_ksenmart_products_categories | NULL | index | product_id | product_id | 12 | NULL | 39634 | 10.00 | Using where; Using index |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
18 | JDatabaseDriver->loadColumn() | JROOT/components/com_ksenmart/models/catalog.php:547 |
17 | KsenMartModelcatalog->getIdsByCategories() | JROOT/components/com_ksenmart/models/catalog.php:180 |
16 | KsenMartModelcatalog->getProductsIds() | JROOT/components/com_ksenmart/models/catalog.php:660 |
15 | KsenMartModelcatalog->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_ksenmart/views/catalog/view.html.php:138 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 36.77 ms После последнего запроса: 3.04 ms Память запроса: 0.069 MB Память до запроса: 3.213 MB Выбрано строк: 1476
SELECT p.id as id
FROM saqrs_ksenmart_products AS p
WHERE p.published=1
AND ((p.id BETWEEN 1237
AND 1246)OR(p.id BETWEEN 2592
AND 2600)OR(p.id BETWEEN 2615
AND 2622)OR(p.id BETWEEN 2681
AND 2688)OR(p.id BETWEEN 3808
AND 3815)OR(p.id BETWEEN 4440
AND 4447)OR(p.id BETWEEN 4724
AND 4731)OR(p.id BETWEEN 4852
AND 4859)OR(p.id BETWEEN 5365
AND 5374)OR(p.id BETWEEN 5401
AND 5410)OR(p.id BETWEEN 6012
AND 6025)OR(p.id BETWEEN 6761
AND 6768)OR(p.id BETWEEN 6788
AND 6795)OR(p.id BETWEEN 7995
AND 8002)OR(p.id BETWEEN 8047
AND 8061)OR(p.id BETWEEN 8083
AND 8090)OR(p.id BETWEEN 8153
AND 8161)OR(p.id BETWEEN 8615
AND 8623)OR(p.id BETWEEN 8958
AND 8965)OR(p.id BETWEEN 9567
AND 9575)OR(p.id BETWEEN 11761
AND 11780)OR(p.id BETWEEN 13154
AND 13161)OR(p.id BETWEEN 15119
AND 15126)OR(p.id BETWEEN 16730
AND 16742)OR(p.id BETWEEN 16805
AND 16817)OR(p.id BETWEEN 16879
AND 16886)OR(p.id BETWEEN 16925
AND 16932)OR(p.id BETWEEN 17059
AND 17067)OR(p.id BETWEEN 17130
AND 17145)OR(p.id BETWEEN 17148
AND 17156)OR(p.id BETWEEN 17251
AND 17268)OR(p.id BETWEEN 17336
AND 17343)OR(p.id BETWEEN 17450
AND 17457)OR(p.id BETWEEN 17498
AND 17505)OR(p.id BETWEEN 17570
AND 17577)OR(p.id BETWEEN 18777
AND 18784)OR(p.id BETWEEN 18802
AND 18811)OR(p.id BETWEEN 19089
AND 19096)OR(p.id BETWEEN 19301
AND 19308)OR(p.id BETWEEN 19629
AND 19637)OR(p.id BETWEEN 19894
AND 19906)OR(p.id BETWEEN 19938
AND 19945)OR(p.id BETWEEN 20547
AND 20555)OR(p.id BETWEEN 21207
AND 21218)OR(p.id BETWEEN 21237
AND 21248)OR(p.id BETWEEN 21277
AND 21284)OR(p.id BETWEEN 25712
AND 25720)OR(p.id BETWEEN 26183
AND 26198)OR(p.id BETWEEN 26401
AND 26411)OR(p.id BETWEEN 26418
AND 26426)OR(p.id IN (404,405,408,410,411,418,419,423,424,426,432,609,610,611,612,613,614,1210,1211,1212,1213,1259,1260,1269,1270,1271,1277,1278,1284,1285,1293,1294,1305,1306,1307,1372,1373,1390,1391,1392,1393,1398,1428,1429,1430,1441,1442,1443,1491,1492,1493,1501,1509,1521,1522,1523,1532,1537,1545,1546,1547,1558,1559,1572,1573,1574,1575,1592,1593,1613,1614,1923,1924,1930,1952,1953,1954,1955,1956,1957,2029,2030,2031,2120,2122,2124,2151,2152,2153,2154,2155,2156,2248,2251,2263,2657,2658,2659,2660,2661,2662,2663,2712,2713,2714,2772,2773,2776,2922,2931,2935,2936,2937,2938,2939,2940,2959,2960,2961,2962,2963,2964,2969,2970,2971,2983,2984,2992,2997,2998,3021,3022,3026,3030,3031,3032,3033,3037,3059,3060,3061,3062,3063,3064,3119,3123,3157,3185,3202,3203,3210,3211,3218,3219,3250,3251,3252,3253,3254,3641,3642,3643,3693,3694,3695,3696,3706,3707,3708,3718,3719,3720,3721,3748,3749,3750,3776,3778,3795,3847,3853,3859,3865,3872,3878,3885,3891,3941,3946,3947,3955,3965,3980,3981,3982,4005,4006,4007,4018,4019,4020,4040,4041,4042,4082,4083,4165,4166,4178,4179,4181,4355,4356,4357,4407,4507,4508,4509,4572,4573,4574,4648,4794,4795,4796,4826,4873,4874,4875,4876,4999,5000,5001,5002,5014,5015,5016,5017,5027,5030,5031,5032,5033,5043,5053,5066,5079,5087,5090,5096,5101,5111,5117,5122,5132,5151,5152,5153,5154,5155,5156,5157,5168,5176,5181,5197,5209,5210,5211,5212,5213,5215,5234,5256,5376,5377,5470,5471,5472,5473,5474,5493,5494,5496,5497,5517,5518,5669,5676,5678,5727,5728,5729,6462,6463,6469,6470,6476,6477,6483,6484,6490,6491,6512,6514,6534,6538,6539,6555,6556,6590,6639,6684,6685,6715,6716,6717,6718,6732,6733,6734,6735,6736,6737,6821,6822,6832,6833,6834,6835,6844,6845,6846,6858,6864,6870,6879,6880,6886,6893,6900,6906,6912,7172,7553,7554,7559,7701,7702,8006,8007,8008,8009,8012,8013,8016,8017,8019,8020,8021,8063,8065,8067,8069,8072,8074,8076,8077,8078,8116,8117,8118,8119,8120,8122,8124,8127,8128,8129,8130,8131,8132,8164,8165,8166,8167,8170,8171,8174,8175,8176,8177,8180,8362,8363,8364,8365,8366,8367,8378,8379,8437,8610,8611,8612,8613,8659,8660,8700,8701,8719,8720,8732,8733,8734,8735,8736,8737,8738,8764,8765,8766,8767,8768,8770,8787,8788,8789,8790,8791,8792,8794,8826,8827,8828,8829,8830,8831,8886,8972,9025,9026,9273,9287,9383,9384,9517,9518,9519,9547,9548,9694,9695,9829,9830,9842,9843,9844,9845,9846,9921,9929,9930,9937,9938,9944,9949,9954,9959,9964,9965,10002,10025,10036,10037,10038,10039,10040,10041,10061,10069,10070,10081,10082,10083,10092,10093,10094,10100,10101,10102,10113,10114,10115,10116,10140,10151,10215,10216,10222,10228,10235,10254,10269,10419,10420,10421,10427,10428,10429,10430,10437,10438,10447,10448,10449,10455,10456,10457,10458,10466,10472,10482,10483,10487,10492,10497,10505,10513,10522,10527,10528,10529,10530,10539,10545,10546,10547,10554,10558,10566,10567,10571,10589,10607,10626,10644,10662,10814,10815,10839,10840,10841,10842,10843,10844,10916,10917,10918,11045,11046,11052,11053,11067,11072,11079,11080,11083,11084,11377,11384,11386,11395,11401,11663,11665,11672,11673,11678,11682,11689,11697,11698,11793,11794,11795,11802,11812,11813,11814,11815,11816,11817,11827,11828,11838,11840,11854,11855,11889,11894,11995,11996,11997,11998,12060,12061,12084,12085,12095,12101,12121,12122,12123,12124,12125,12126,12141,12142,12152,12153,12154,12161,12170,12171,12173,12182,12183,12185,12191,12192,12198,12200,12244,12252,12255,12259,12260,12297,12299,12317,12318,12320,12321,12322,12466,12472,12482,12483,12489,12495,12501,12514,12515,12521,12529,12536,12543,12552,12553,12554,12560,12568,12574,12580,12581,12587,12594,12602,12780,12782,12786,12791,12792,13071,13072,13087,13088,13149,13150,13151,13152,13233,13234,13252,13253,13283,13284,13315,13333,13334,13335,13336,13359,13360,13375,13395,13396,13397,13422,13423,13434,13435,13449,13450,13462,13463,13472,13473,13474,13482,13507,13508,13509,13527,13596,13597,13598,13626,13627,13636,13695,13696,13706,13707,13714,13729,13730,14189,14190,14195,14196,14202,14203,14208,14209,14254,14255,14256,14284,14285,14290,14291,14292,14293,14294,14295,14296,14322,14370,14371,14380,14381,14398,14399,14400,14401,14432,14451,14452,14454,14455,14457,14459,14464,14465,14466,14467,14472,14473,14480,14481,14486,14493,14500,14501,14521,14522,14524,14633,14657,14661,14662,14696,14697,14698,14699,14701,14748,14749,14750,14751,14753,14793,14794,14795,14796,14797,15068,15069,15070,15071,15511,15512,15517,15522,15527,15532,15541,15547,15580,15581,15582,15583,15591,15592,15753,15757,15758,15764,15898,15900,15901,15915,15961,15966,15971,15977,15978,15988,15989,15994,16044,16045,16046,16060,16063,16067,16068,16082,16087,16088,16097,16098,16117,16118,16125,16140,16153,16154,16155,16156,16177,16178,16179,16180,16192,16193,16200,16206,16207,16208,16209,16221,16222,16223,16224,16236,16237,16238,16239,16249,16253,16270,16271,16272,16284,16285,16286,16287,16294,16308,16309,16310,16311,16318,16319,16324,16325,16329,16331,16332,16333,16350,16351,16352,16353,16376,16377,16389,16390,16403,16411,16419,16420,16428,16429,16556,16563,16564,16571,16572,16772,16773,16787,16788,16866,16888,16889,16890,16897,16906,16907,16934,16935,16936,16960,16961,16970,16971,16972,16974,16975,17035,17036,17072,17073,17074,17075,17081,17082,17083,17086,17087,17088,17158,17159,17160,17161,17162,17198,17199,17348,17349,17350,17351,17368,17369,17383,17399,17400,17403,17404,17422,17424,17459,17460,17461,17472,17475,17490,17491,17507,17508,17509,17540,17541,17562,17563,17579,17580,17581,17593,17594,17614,17781,17961,17963,17971,17972,17974,17982,17992,17995,18024,18025,18026,18037,18038,18054,18055,18058,18065,18081,18083,18090,18092,18094,18096,18108,18377,18378,18388,18389,18390,18392,18401,18402,18415,18419,18420,18421,18433,18437,18438,18439,18440,18441,18449,18451,18459,18463,18464,18476,18822,18823,18824,18825,18833,18834,18835,18836,19127,19128,19129,19130,19131,19132,19133,19178,19179,19180,19238,19239,19240,19241,19242,19265,19266,19267,19268,19269,19324,19325,19343,19344,19345,19359,19360,19361,19362,19370,19391,19426,19427,19464,19470,19489,19490,19491,19492,19493,19510,19514,19515,19533,19534,19554,19556,19557,19558,19575,19576,19577,19617,19618,19619,19781,19933,19934,19935,19936,20411,20433,20434,20435,20436,20437,20438,20440,20451,20453,20454,20455,20472,20473,20511,20512,20518,20524,20560,20561,20807,20808,20809,20871,20872,20873,20891,20892,20893,20903,20933,20947,20979,20992,21005,21016,21029,21043,21076,21077,21086,21087,21096,21097,21100,21111,21114,21124,21125,21128,21145,21146,21160,21161,21162,21163,21164,21165,21180,21181,21182,21183,21184,21185,21195,21199,21200,21225,21229,21230,22857,24224,24225,24332,24541,24542,24713,24715,24729,24731,24733,24735,24829,24830,24961,24963,24964,25017,25018,25647,25648,25649,25650,25684,25685,25697,25698,25704,25705,25727,25733,25734,26106,26116,26223,26224,26278,26279,26280,26281,26282,26283,26284,26397,26398,26413,26414,26415,26474,26529,26535,26814,26855,27223,27225,27689,27761,27827,28116,28368,28369,28387,28389,28390,28391,28392,28393,28394,28395,28400,28434,28604,28605,28606,28609,28610,28611,28612,28613,28615,28695)))
AND p.archived = 0
AND (p.parent_id=0)
GROUP BY p.id
ORDER BY p.type desc,p.in_stock > 0 desc,p.ordering asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | p | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 1792 | 0.10 | Using index condition; Using where; Используется filesort |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_ksenmart/views/catalog/view.html.php:138 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 24.02 ms После последнего запроса: 0.29 ms Память запроса: 0.023 MB Память до запроса: 3.214 MB Выбрано строк: 16
SELECT p.id as id
FROM saqrs_ksenmart_products AS p
WHERE p.published=1
AND ((p.id BETWEEN 1237
AND 1246)OR(p.id BETWEEN 2592
AND 2600)OR(p.id BETWEEN 2615
AND 2622)OR(p.id BETWEEN 2681
AND 2688)OR(p.id BETWEEN 3808
AND 3815)OR(p.id BETWEEN 4440
AND 4447)OR(p.id BETWEEN 4724
AND 4731)OR(p.id BETWEEN 4852
AND 4859)OR(p.id BETWEEN 5365
AND 5374)OR(p.id BETWEEN 5401
AND 5410)OR(p.id BETWEEN 6012
AND 6025)OR(p.id BETWEEN 6761
AND 6768)OR(p.id BETWEEN 6788
AND 6795)OR(p.id BETWEEN 7995
AND 8002)OR(p.id BETWEEN 8047
AND 8061)OR(p.id BETWEEN 8083
AND 8090)OR(p.id BETWEEN 8153
AND 8161)OR(p.id BETWEEN 8615
AND 8623)OR(p.id BETWEEN 8958
AND 8965)OR(p.id BETWEEN 9567
AND 9575)OR(p.id BETWEEN 11761
AND 11780)OR(p.id BETWEEN 13154
AND 13161)OR(p.id BETWEEN 15119
AND 15126)OR(p.id BETWEEN 16730
AND 16742)OR(p.id BETWEEN 16805
AND 16817)OR(p.id BETWEEN 16879
AND 16886)OR(p.id BETWEEN 16925
AND 16932)OR(p.id BETWEEN 17059
AND 17067)OR(p.id BETWEEN 17130
AND 17145)OR(p.id BETWEEN 17148
AND 17156)OR(p.id BETWEEN 17251
AND 17268)OR(p.id BETWEEN 17336
AND 17343)OR(p.id BETWEEN 17450
AND 17457)OR(p.id BETWEEN 17498
AND 17505)OR(p.id BETWEEN 17570
AND 17577)OR(p.id BETWEEN 18777
AND 18784)OR(p.id BETWEEN 18802
AND 18811)OR(p.id BETWEEN 19089
AND 19096)OR(p.id BETWEEN 19301
AND 19308)OR(p.id BETWEEN 19629
AND 19637)OR(p.id BETWEEN 19894
AND 19906)OR(p.id BETWEEN 19938
AND 19945)OR(p.id BETWEEN 20547
AND 20555)OR(p.id BETWEEN 21207
AND 21218)OR(p.id BETWEEN 21237
AND 21248)OR(p.id BETWEEN 21277
AND 21284)OR(p.id BETWEEN 25712
AND 25720)OR(p.id BETWEEN 26183
AND 26198)OR(p.id BETWEEN 26401
AND 26411)OR(p.id BETWEEN 26418
AND 26426)OR(p.id IN (404,405,408,410,411,418,419,423,424,426,432,609,610,611,612,613,614,1210,1211,1212,1213,1259,1260,1269,1270,1271,1277,1278,1284,1285,1293,1294,1305,1306,1307,1372,1373,1390,1391,1392,1393,1398,1428,1429,1430,1441,1442,1443,1491,1492,1493,1501,1509,1521,1522,1523,1532,1537,1545,1546,1547,1558,1559,1572,1573,1574,1575,1592,1593,1613,1614,1923,1924,1930,1952,1953,1954,1955,1956,1957,2029,2030,2031,2120,2122,2124,2151,2152,2153,2154,2155,2156,2248,2251,2263,2657,2658,2659,2660,2661,2662,2663,2712,2713,2714,2772,2773,2776,2922,2931,2935,2936,2937,2938,2939,2940,2959,2960,2961,2962,2963,2964,2969,2970,2971,2983,2984,2992,2997,2998,3021,3022,3026,3030,3031,3032,3033,3037,3059,3060,3061,3062,3063,3064,3119,3123,3157,3185,3202,3203,3210,3211,3218,3219,3250,3251,3252,3253,3254,3641,3642,3643,3693,3694,3695,3696,3706,3707,3708,3718,3719,3720,3721,3748,3749,3750,3776,3778,3795,3847,3853,3859,3865,3872,3878,3885,3891,3941,3946,3947,3955,3965,3980,3981,3982,4005,4006,4007,4018,4019,4020,4040,4041,4042,4082,4083,4165,4166,4178,4179,4181,4355,4356,4357,4407,4507,4508,4509,4572,4573,4574,4648,4794,4795,4796,4826,4873,4874,4875,4876,4999,5000,5001,5002,5014,5015,5016,5017,5027,5030,5031,5032,5033,5043,5053,5066,5079,5087,5090,5096,5101,5111,5117,5122,5132,5151,5152,5153,5154,5155,5156,5157,5168,5176,5181,5197,5209,5210,5211,5212,5213,5215,5234,5256,5376,5377,5470,5471,5472,5473,5474,5493,5494,5496,5497,5517,5518,5669,5676,5678,5727,5728,5729,6462,6463,6469,6470,6476,6477,6483,6484,6490,6491,6512,6514,6534,6538,6539,6555,6556,6590,6639,6684,6685,6715,6716,6717,6718,6732,6733,6734,6735,6736,6737,6821,6822,6832,6833,6834,6835,6844,6845,6846,6858,6864,6870,6879,6880,6886,6893,6900,6906,6912,7172,7553,7554,7559,7701,7702,8006,8007,8008,8009,8012,8013,8016,8017,8019,8020,8021,8063,8065,8067,8069,8072,8074,8076,8077,8078,8116,8117,8118,8119,8120,8122,8124,8127,8128,8129,8130,8131,8132,8164,8165,8166,8167,8170,8171,8174,8175,8176,8177,8180,8362,8363,8364,8365,8366,8367,8378,8379,8437,8610,8611,8612,8613,8659,8660,8700,8701,8719,8720,8732,8733,8734,8735,8736,8737,8738,8764,8765,8766,8767,8768,8770,8787,8788,8789,8790,8791,8792,8794,8826,8827,8828,8829,8830,8831,8886,8972,9025,9026,9273,9287,9383,9384,9517,9518,9519,9547,9548,9694,9695,9829,9830,9842,9843,9844,9845,9846,9921,9929,9930,9937,9938,9944,9949,9954,9959,9964,9965,10002,10025,10036,10037,10038,10039,10040,10041,10061,10069,10070,10081,10082,10083,10092,10093,10094,10100,10101,10102,10113,10114,10115,10116,10140,10151,10215,10216,10222,10228,10235,10254,10269,10419,10420,10421,10427,10428,10429,10430,10437,10438,10447,10448,10449,10455,10456,10457,10458,10466,10472,10482,10483,10487,10492,10497,10505,10513,10522,10527,10528,10529,10530,10539,10545,10546,10547,10554,10558,10566,10567,10571,10589,10607,10626,10644,10662,10814,10815,10839,10840,10841,10842,10843,10844,10916,10917,10918,11045,11046,11052,11053,11067,11072,11079,11080,11083,11084,11377,11384,11386,11395,11401,11663,11665,11672,11673,11678,11682,11689,11697,11698,11793,11794,11795,11802,11812,11813,11814,11815,11816,11817,11827,11828,11838,11840,11854,11855,11889,11894,11995,11996,11997,11998,12060,12061,12084,12085,12095,12101,12121,12122,12123,12124,12125,12126,12141,12142,12152,12153,12154,12161,12170,12171,12173,12182,12183,12185,12191,12192,12198,12200,12244,12252,12255,12259,12260,12297,12299,12317,12318,12320,12321,12322,12466,12472,12482,12483,12489,12495,12501,12514,12515,12521,12529,12536,12543,12552,12553,12554,12560,12568,12574,12580,12581,12587,12594,12602,12780,12782,12786,12791,12792,13071,13072,13087,13088,13149,13150,13151,13152,13233,13234,13252,13253,13283,13284,13315,13333,13334,13335,13336,13359,13360,13375,13395,13396,13397,13422,13423,13434,13435,13449,13450,13462,13463,13472,13473,13474,13482,13507,13508,13509,13527,13596,13597,13598,13626,13627,13636,13695,13696,13706,13707,13714,13729,13730,14189,14190,14195,14196,14202,14203,14208,14209,14254,14255,14256,14284,14285,14290,14291,14292,14293,14294,14295,14296,14322,14370,14371,14380,14381,14398,14399,14400,14401,14432,14451,14452,14454,14455,14457,14459,14464,14465,14466,14467,14472,14473,14480,14481,14486,14493,14500,14501,14521,14522,14524,14633,14657,14661,14662,14696,14697,14698,14699,14701,14748,14749,14750,14751,14753,14793,14794,14795,14796,14797,15068,15069,15070,15071,15511,15512,15517,15522,15527,15532,15541,15547,15580,15581,15582,15583,15591,15592,15753,15757,15758,15764,15898,15900,15901,15915,15961,15966,15971,15977,15978,15988,15989,15994,16044,16045,16046,16060,16063,16067,16068,16082,16087,16088,16097,16098,16117,16118,16125,16140,16153,16154,16155,16156,16177,16178,16179,16180,16192,16193,16200,16206,16207,16208,16209,16221,16222,16223,16224,16236,16237,16238,16239,16249,16253,16270,16271,16272,16284,16285,16286,16287,16294,16308,16309,16310,16311,16318,16319,16324,16325,16329,16331,16332,16333,16350,16351,16352,16353,16376,16377,16389,16390,16403,16411,16419,16420,16428,16429,16556,16563,16564,16571,16572,16772,16773,16787,16788,16866,16888,16889,16890,16897,16906,16907,16934,16935,16936,16960,16961,16970,16971,16972,16974,16975,17035,17036,17072,17073,17074,17075,17081,17082,17083,17086,17087,17088,17158,17159,17160,17161,17162,17198,17199,17348,17349,17350,17351,17368,17369,17383,17399,17400,17403,17404,17422,17424,17459,17460,17461,17472,17475,17490,17491,17507,17508,17509,17540,17541,17562,17563,17579,17580,17581,17593,17594,17614,17781,17961,17963,17971,17972,17974,17982,17992,17995,18024,18025,18026,18037,18038,18054,18055,18058,18065,18081,18083,18090,18092,18094,18096,18108,18377,18378,18388,18389,18390,18392,18401,18402,18415,18419,18420,18421,18433,18437,18438,18439,18440,18441,18449,18451,18459,18463,18464,18476,18822,18823,18824,18825,18833,18834,18835,18836,19127,19128,19129,19130,19131,19132,19133,19178,19179,19180,19238,19239,19240,19241,19242,19265,19266,19267,19268,19269,19324,19325,19343,19344,19345,19359,19360,19361,19362,19370,19391,19426,19427,19464,19470,19489,19490,19491,19492,19493,19510,19514,19515,19533,19534,19554,19556,19557,19558,19575,19576,19577,19617,19618,19619,19781,19933,19934,19935,19936,20411,20433,20434,20435,20436,20437,20438,20440,20451,20453,20454,20455,20472,20473,20511,20512,20518,20524,20560,20561,20807,20808,20809,20871,20872,20873,20891,20892,20893,20903,20933,20947,20979,20992,21005,21016,21029,21043,21076,21077,21086,21087,21096,21097,21100,21111,21114,21124,21125,21128,21145,21146,21160,21161,21162,21163,21164,21165,21180,21181,21182,21183,21184,21185,21195,21199,21200,21225,21229,21230,22857,24224,24225,24332,24541,24542,24713,24715,24729,24731,24733,24735,24829,24830,24961,24963,24964,25017,25018,25647,25648,25649,25650,25684,25685,25697,25698,25704,25705,25727,25733,25734,26106,26116,26223,26224,26278,26279,26280,26281,26282,26283,26284,26397,26398,26413,26414,26415,26474,26529,26535,26814,26855,27223,27225,27689,27761,27827,28116,28368,28369,28387,28389,28390,28391,28392,28393,28394,28395,28400,28434,28604,28605,28606,28609,28610,28611,28612,28613,28615,28695)))
AND p.archived = 0
AND (p.parent_id=0)
GROUP BY p.id
ORDER BY p.type desc,p.in_stock > 0 desc,p.ordering asc
LIMIT 16
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | p | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 1792 | 0.10 | Using index condition; Using where; Используется filesort |
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_ksenmart/models/catalog.php:1061 |
12 | KsenMartModelcatalog->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_ksenmart/views/catalog/view.html.php:139 |
10 | KsenMartViewCatalog->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |