Время запроса: 0.22 ms Память запроса: 0.020 MB. Память перед запросом: 1.063 MB Возвращено строк: 0
SELECT `session_id`
FROM `flu_session`
WHERE `session_id` = X'3163363635323662306431303831363963333866366431386638346662356339'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_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:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.15 ms После последнего запроса: 0.16 ms Память запроса: 0.004 MB. Память перед запросом: 1.068 MB
INSERT INTO `flu_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3163363635323662306431303831363963333866366431386638346662356339', 1, 1728636566, 0, '', 0)
EXPLAIN недоступен для INSERT INTO `flu_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3163363635323662306431303831363963333866366431386638346662356339', 1, 1728636566, 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:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.14 ms После последнего запроса: 6.90 ms Память запроса: 0.021 MB. Память перед запросом: 1.152 MB Возвращено строк: 5
SELECT id, rules
FROM `flu_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_viewlevels | NULL | ALL | NULL | INDEX KEY не используется | 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:318 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 0.19 ms Память запроса: 0.021 MB. Память перед запросом: 1.164 MB Возвращено строк: 2
SELECT b.id
FROM flu_usergroups AS a
LEFT JOIN flu_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:318 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.32 ms После последнего запроса: 82.48 ms Память запроса: 0.023 MB. Память перед запросом: 3.491 MB Возвращено строк: 3
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM flu_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_fluent'
ORDER BY s.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | index | idx_template,idx_client_id,idx_client_id_home | PRIMARY | 4 | NULL | 7 | 30.61 | Using where |
Нет SHOW PROFILE (возможно, потому что более 100 запросов)
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 |
14 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 |
13 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 |
12 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 |
11 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 |
10 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:319 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:112 |
8 | plgSystemGantry5->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 11.40 ms Память запроса: 0.005 MB. Память перед запросом: 3.580 MB
UPDATE `flu_extensions`
SET `params` = '{\"mediaversion\":\"db9d542442559ba6ad97c4795891752c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | flu_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.04 ms |
updating | 0.04 ms |
end | 0.00 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
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:1137 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.32 ms После последнего запроса: 13.69 ms Память запроса: 0.096 MB. Память перед запросом: 3.783 MB Возвращено строк: 374
SELECT *
FROM flu_hikashop_config
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_config | NULL | ALL | NULL | INDEX KEY не используется | NULL | NULL | 374 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 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.17 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:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/config.php:16 |
9 | hikashopConfigClass->load() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1429 |
8 | hikashop_config() | JROOT/administrator/components/com_hikashop/helpers/helper.php:3471 |
7 | include_once JROOT/administrator/components/com_hikashop/helpers/helper.php | JROOT/components/com_hikashop/hikashop.php:16 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 6.55 ms Память запроса: 0.025 MB. Память перед запросом: 4.538 MB Возвращено строк: 1
SELECT *
FROM flu_menu
WHERE id = '296'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_menu | 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.02 ms |
System lock | 0.00 ms |
optimizing | 0.00 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.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2728 |
17 | hikashopClass->get() | JROOT/administrator/components/com_hikashop/classes/menus.php:20 |
16 | hikashopMenusClass->get() | JROOT/administrator/components/com_hikashop/helpers/module.php:233 |
15 | hikashopModuleHelper->_getParams() | JROOT/administrator/components/com_hikashop/helpers/module.php:14 |
14 | hikashopModuleHelper->initialize() | JROOT/components/com_hikashop/views/category/view.html.php:37 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.17 ms После последнего запроса: 0.83 ms Память запроса: 0.025 MB. Память перед запросом: 4.562 MB Возвращено строк: 1
SELECT *
FROM flu_hikashop_category
WHERE category_id = '62'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_category | 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.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 |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2728 |
15 | hikashopClass->get() | JROOT/administrator/components/com_hikashop/classes/category.php:37 |
14 | hikashopCategoryClass->get() | JROOT/components/com_hikashop/views/category/view.html.php:84 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.12 ms После последнего запроса: 0.10 ms Память запроса: 0.024 MB. Память перед запросом: 4.572 MB Возвращено строк: 1
SELECT *
FROM flu_hikashop_category
WHERE category_id = '62'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_category | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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.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 |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2728 |
15 | hikashopClass->get() | JROOT/administrator/components/com_hikashop/classes/category.php:37 |
14 | hikashopCategoryClass->get() | JROOT/components/com_hikashop/views/category/view.html.php:151 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.13 ms Память запроса: 0.023 MB. Память перед запросом: 4.584 MB Возвращено строк: 1
SELECT category_id
FROM flu_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
AND category_type='product'
AND category_id IN ('62')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_category | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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.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 |
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
14 | JDatabaseDriver->loadColumn() | JROOT/components/com_hikashop/views/category/view.html.php:185 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.15 ms После последнего запроса: 10.49 ms Память запроса: 0.025 MB. Память перед запросом: 4.885 MB Возвращено строк: 1
SELECT *
FROM flu_hikashop_category
WHERE category_id = '62'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_category | 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.01 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 |
# | Вызывающий объект | Файл и номер строки |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2728 |
16 | hikashopClass->get() | JROOT/administrator/components/com_hikashop/classes/category.php:37 |
15 | hikashopCategoryClass->get() | JROOT/administrator/components/com_hikashop/classes/category.php:536 |
14 | hikashopCategoryClass->getChildren() | JROOT/components/com_hikashop/views/category/view.html.php:301 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.25 ms После последнего запроса: 0.11 ms Память запроса: 0.027 MB. Память перед запросом: 4.897 MB Возвращено строк: 9
SELECT a.*
FROM flu_hikashop_category AS a
WHERE a.category_left > 152
AND a.category_right < 171
AND (a.category_type = 'product' OR a.category_type = 'vendor')
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
ORDER BY a.category_ordering ASC
LIMIT 0, 50
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | NULL | INDEX KEY не используется | NULL | NULL | 128 | 0.78 | Using where; Используется сортировка файлов |
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.01 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.11 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:612 |
14 | hikashopCategoryClass->getChildren() | JROOT/components/com_hikashop/views/category/view.html.php:301 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.56 ms После последнего запроса: 0.11 ms Память запроса: 0.025 MB. Память перед запросом: 4.923 MB Возвращено строк: 9
SELECT *
FROM flu_hikashop_file
WHERE file_type='category'
AND file_ref_id IN (63,64,65,66,67,68,69,159,160)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_file | NULL | ref | file_type | file_type | 767 | const | 78 | 50.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.09 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.26 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:632 |
14 | hikashopCategoryClass->getChildren() | JROOT/components/com_hikashop/views/category/view.html.php:301 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB. Память перед запросом: 4.941 MB Возвращено строк: 1
SELECT COUNT(*)
FROM flu_hikashop_category AS a
WHERE a.category_left > 152
AND a.category_right < 171
AND (a.category_type = 'product' OR a.category_type = 'vendor')
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | NULL | INDEX KEY не используется | NULL | NULL | 128 | 0.78 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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.07 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 |
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/components/com_hikashop/views/category/view.html.php:306 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 5.17 ms Память запроса: 0.023 MB. Память перед запросом: 5.539 MB Возвращено строк: 9
SELECT category_left,category_right
FROM flu_hikashop_category
WHERE category_id IN (63,64,65,66,67,68,69,159,160)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_category | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 9 | 100.00 | Using index condition |
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.05 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:516 |
14 | hikashopCategoryClass->getChildren() | JROOT/components/com_hikashop/views/category/view.html.php:333 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.25 ms После последнего запроса: 0.05 ms Память запроса: 0.024 MB. Память перед запросом: 5.557 MB Возвращено строк: 0
SELECT a.*
FROM flu_hikashop_category AS a
WHERE ((a.category_left > 153
AND a.category_right < 154) OR (a.category_left > 155
AND a.category_right < 156) OR (a.category_left > 157
AND a.category_right < 158) OR (a.category_left > 159
AND a.category_right < 160) OR (a.category_left > 161
AND a.category_right < 162) OR (a.category_left > 163
AND a.category_right < 164) OR (a.category_left > 165
AND a.category_right < 166) OR (a.category_left > 167
AND a.category_right < 168) OR (a.category_left > 169
AND a.category_right < 170))
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
ORDER BY a.category_ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | NULL | INDEX KEY не используется | NULL | NULL | 128 | 1.31 | 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.01 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.09 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:612 |
14 | hikashopCategoryClass->getChildren() | JROOT/components/com_hikashop/views/category/view.html.php:333 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.93 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB. Память перед запросом: 5.557 MB Возвращено строк: 9
SELECT count(pc.product_id) AS number_of_products, pc.category_id
FROM flu_hikashop_product_category AS pc
INNER JOIN flu_hikashop_product AS p
ON pc.product_id = p.product_id
AND p.product_published > 0
AND (p.product_access = 'all' OR p.product_access LIKE '%,9,%')
AND p.product_parent_id = 0
WHERE pc.category_id IN (63,64,65,66,67,68,69,159,160)
GROUP BY pc.category_id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | pc | NULL | range | category_id,product_id | category_id | 4 | NULL | 441 | 100.00 | Using where; Using index |
1 | SIMPLE | p | NULL | eq_ref | PRIMARY,product_parent_id | PRIMARY | 4 | khanalex_slav1.pc.product_id | 1 | 6.66 | Using where |
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.00 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 1.70 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:366 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.47 ms После последнего запроса: 0.81 ms Память запроса: 0.024 MB. Память перед запросом: 5.570 MB Возвращено строк: 1
Повторяющиеся запросы:
#34 #79SELECT a.*,b.*
FROM flu_hikashop_category AS a
LEFT JOIN flu_hikashop_file AS b
ON a.category_id = b.file_ref_id
AND b.file_type = 'category'
WHERE a.category_id = 62
LIMIT 1
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 | ref | file_type | file_type | 767 | const | 78 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.16 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.12 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/category.php:35 |
14 | hikashopCategoryClass->get() | JROOT/components/com_hikashop/views/category/view.html.php:384 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.57 ms После последнего запроса: 1.33 ms Память запроса: 0.026 MB. Память перед запросом: 5.620 MB Возвращено строк: 4
SELECT hk_parent.*
FROM flu_hikashop_category AS hk_cat
LEFT JOIN flu_hikashop_category AS hk_parent
ON (hk_parent.category_left <= hk_cat.category_left
AND hk_parent.category_right >= hk_cat.category_right)
WHERE hk_cat.category_id = 62
GROUP BY hk_parent.category_id
ORDER BY hk_parent.category_left
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | hk_cat | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Используется сортировка файлов |
1 | SIMPLE | hk_parent | NULL | ALL | PRIMARY | INDEX KEY не используется | NULL | NULL | 128 | 100.00 | Using where |
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.02 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.27 ms |
Creating sort index | 0.06 ms |
end | 0.00 ms |
query end | 0.00 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 |
# | Вызывающий объект | Файл и номер строки |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:771 |
16 | hikashopCategoryClass->getParents() | JROOT/administrator/components/com_hikashop/classes/field.php:495 |
15 | hikashopFieldClass->getCategories() | JROOT/administrator/components/com_hikashop/classes/field.php:188 |
14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/category/view.html.php:388 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.35 ms После последнего запроса: 0.11 ms Память запроса: 0.024 MB. Память перед запросом: 5.640 MB Возвращено строк: 0
SELECT *
FROM flu_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='category'
AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')
AND ((field_with_sub_categories = 0
AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,62,%'))OR (field_with_sub_categories = 1
AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,62,%')))
ORDER BY a.`field_ordering` ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | NULL | INDEX KEY не используется | NULL | NULL | 57 | 1.75 | Using where; Используется сортировка файлов |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.07 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 |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/field.php:167 |
15 | hikashopFieldClass->getData() | JROOT/administrator/components/com_hikashop/classes/field.php:189 |
14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/category/view.html.php:388 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.31 ms После последнего запроса: 3.93 ms Память запроса: 0.023 MB. Память перед запросом: 5.723 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,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.01 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.16 ms После последнего запроса: 0.14 ms Память запроса: 0.023 MB. Память перед запросом: 5.730 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.13 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB. Память перед запросом: 5.738 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.00 ms |
executing | 0.00 ms |
Sending data | 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.15 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB. Память перед запросом: 5.745 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB. Память перед запросом: 5.753 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.00 ms |
executing | 0.00 ms |
Sending data | 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 |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.15 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB. Память перед запросом: 5.760 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.16 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB. Память перед запросом: 5.767 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.14 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB. Память перед запросом: 5.775 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.14 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB. Память перед запросом: 5.782 MB Возвращено строк: 0
SELECT a.id as itemid
FROM `flu_menu` as a
WHERE a.client_id=0
AND a.parent_id=296
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | const,const | 1 | 100.00 | Using index |
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.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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/category/view.html.php:498 |
14 | CategoryViewCategory->getLink() | JROOT/components/com_hikashop/views/category/view.html.php:469 |
13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.46 ms После последнего запроса: 20.84 ms Память запроса: 0.027 MB. Память перед запросом: 5.970 MB Возвращено строк: 0
Повторяющиеся запросы:
#75 #76SELECT cart.cart_id
FROM flu_hikashop_cart AS cart
WHERE (cart.cart_type = 'cart')
AND (cart.session_id = '1c66526b0d108169c38f6d18f84fb5c9')
ORDER BY cart.cart_current DESC, cart.cart_modified DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cart | NULL | ref | session_id | session_id | 767 | const | 1 | 10.00 | Using index condition; 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.00 ms |
optimizing | 0.01 ms |
statistics | 0.29 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.02 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 |
# | Вызывающий объект | Файл и номер строки |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
24 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_hikashop/classes/cart.php:69 |
23 | hikashopCartClass->getCurrentCartId() | JROOT/administrator/components/com_hikashop/classes/cart.php:165 |
22 | hikashopCartClass->get() | JROOT/administrator/components/com_hikashop/helpers/helper.php:568 |
21 | hikashop_getZone() | JROOT/components/com_hikashop/views/product/view.html.php:649 |
20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:934 |
18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:141 |
17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2894 |
15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2848 |
13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.11 ms Память запроса: 0.026 MB. Память перед запросом: 5.983 MB Возвращено строк: 1
SELECT category_id
FROM flu_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
AND category_id IN ('62')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | flu_hikashop_category | 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 |
# | Вызывающий объект | Файл и номер строки |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
21 | JDatabaseDriver->loadColumn() | JROOT/components/com_hikashop/views/product/view.html.php:673 |
20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:934 |
18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:141 |
17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2894 |
15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2848 |
13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2557 |
10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2266 |
9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2535 |
7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 |
6 | require_once JROOT/components/com_hikashop/hikashop.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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.17 ms После последнего запроса: 1.82 ms Память запроса: 0.029 MB. Память перед запросом: 6.041 MB Возвращено строк: 3
Повторяющиеся запросы:
#78SELECT *
FROM flu_hikashop_filter
WHERE filter_published = 1
AND (