Query Time: 0.38 ms Query memory: 0.025 MB Memory before query: 3.711 MB Rows returned: 0
SELECT `data`
FROM `xvd3l_session`
WHERE `session_id` = '180e8328e5c881000f4dab5363c4a560'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| System lock | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Same as call in the line below. |
| 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 |
Query Time: 0.25 ms After last query: 1.68 ms Query memory: 0.022 MB Memory before query: 3.875 MB Rows returned: 0
SELECT `session_id`
FROM `xvd3l_session`
WHERE `session_id` = '180e8328e5c881000f4dab5363c4a560'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 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 |
Query Time: 2.70 ms After last query: 0.11 ms Query memory: 0.004 MB Memory before query: 3.881 MB
INSERT INTO `xvd3l_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('180e8328e5c881000f4dab5363c4a560', 1, 1614508667, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `xvd3l_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('180e8328e5c881000f4dab5363c4a560', 1, 1614508667, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| update | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| update | 0.01 ms |
| end | 0.00 ms |
| query end | 2.44 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 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 |
Query Time: 0.61 ms After last query: 3.51 ms Query memory: 0.060 MB Memory before query: 4.092 MB Rows returned: 49
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xvd3l_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_extensions | ref | extension | extension | 82 | const | 49 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.32 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
| 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 |
Query Time: 0.21 ms After last query: 3.09 ms Query memory: 0.023 MB Memory before query: 4.330 MB Rows returned: 5
SELECT id, rules
FROM `xvd3l_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 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 |
Query Time: 0.37 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.342 MB Rows returned: 2
SELECT b.id
FROM xvd3l_usergroups AS a
LEFT JOIN xvd3l_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.06 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 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 |
Query Time: 1.32 ms After last query: 0.83 ms Query memory: 0.041 MB Memory before query: 4.409 MB Rows returned: 181
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM xvd3l_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 293 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.40 ms |
| Sending data | 0.61 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
| 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 |
Query Time: 0.86 ms After last query: 14.53 ms Query memory: 0.024 MB Memory before query: 5.641 MB Rows returned: 0
SELECT `manifest_cache`
FROM `xvd3l_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_extensions | ref | extension | extension | 82 | const | 49 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| System lock | 0.02 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.33 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/fof30/Container/Container.php:787 |
| 12 | FOF30\Container\Container->getDefaultMediaVersion() | JROOT/libraries/fof30/Container/Container.php:675 |
| 11 | FOF30\Container\Container->__construct() | JROOT/libraries/fof30/Container/Container.php:159 |
| 10 | FOF30\Container\Container::makeInstance() | JROOT/libraries/fof30/Container/Container.php:140 |
| 9 | FOF30\Container\Container::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:813 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.83 ms After last query: 6.14 ms Query memory: 0.024 MB Memory before query: 5.937 MB Rows returned: 0
SELECT `manifest_cache`
FROM `xvd3l_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_extensions | ref | extension | extension | 82 | const | 49 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.36 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/fof30/Container/Container.php:787 |
| 12 | FOF30\Container\Container->getDefaultMediaVersion() | JROOT/libraries/fof30/Container/Container.php:675 |
| 11 | FOF30\Container\Container->__construct() | JROOT/libraries/fof30/Container/Container.php:290 |
| 10 | FOF30\Container\Container::makeInstance() | JROOT/libraries/fof30/Container/Container.php:140 |
| 9 | FOF30\Container\Container::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:813 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.44 ms After last query: 0.36 ms Query memory: 0.024 MB Memory before query: 5.953 MB Rows returned: 1
SELECT `value`
FROM `xvd3l_admintools_storage`
WHERE `key` = 'cparams'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_admintools_storage | const | PRIMARY | PRIMARY | 402 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.15 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 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.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_admintools/Helper/Storage.php:123 |
| 12 | Akeeba\AdminTools\Admin\Helper\Storage->load() | JROOT/administrator/components/com_admintools/Helper/Storage.php:53 |
| 11 | Akeeba\AdminTools\Admin\Helper\Storage->__construct() | JROOT/administrator/components/com_admintools/Helper/Storage.php:41 |
| 10 | Akeeba\AdminTools\Admin\Helper\Storage::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:278 |
| 9 | plgSystemAdmintools->loadComponentParameters() | JROOT/plugins/system/admintools/admintools/main.php:831 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.27 ms After last query: 2.88 ms Query memory: 0.024 MB Memory before query: 6.414 MB Rows returned: 0
SELECT *
FROM `xvd3l_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_admintools_wafexceptions | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/admintools/admintools/main.php:549 |
| 10 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT/plugins/system/admintools/admintools/main.php:460 |
| 9 | plgSystemAdmintools->loadWAFExceptions() | JROOT/plugins/system/admintools/admintools/main.php:843 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:110 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 1.25 ms After last query: 38.84 ms Query memory: 0.040 MB Memory before query: 9.071 MB Rows returned: 18
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 xvd3l_menu AS m
LEFT JOIN xvd3l_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 18 | Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | adityaic_joomla_test.m.component_id | 1 | |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| System lock | 0.02 ms |
| init | 0.06 ms |
| optimizing | 0.03 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.19 ms |
| Sending data | 0.47 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 20 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
| 19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 17 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 16 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 15 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 14 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 13 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 12 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
| 11 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 10 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
| 9 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 8 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/wbamp/wbamp.php:210 |
| 7 | plgSystemWbamp->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.46 ms After last query: 46.00 ms Query memory: 0.023 MB Memory before query: 11.374 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"
| Status | Duration |
|---|
| starting | 0.03 ms |
| Opening tables | 0.04 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.20 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.00 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 12 | JDatabaseDriver->loadObject() | JROOT/libraries/joomla/database/driver/mysqli.php:342 |
| 11 | JDatabaseDriverMysqli->getCollation() | JROOT/plugins/system/admintools/feature/utf8mb4.php:28 |
| 10 | AtsystemFeatureUtf8mb4->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:710 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:135 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.52 ms After last query: 0.65 ms Query memory: 0.024 MB Memory before query: 11.409 MB Rows returned: 0
SELECT *
FROM `xvd3l_admintools_ipautoban`
WHERE `ip` = '3.235.11.178'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 12 | JDatabaseDriver->loadObject() | JROOT/plugins/system/admintools/feature/autoipfiltering.php:74 |
| 11 | AtsystemFeatureAutoipfiltering->isIPBlocked() | JROOT/plugins/system/admintools/feature/autoipfiltering.php:23 |
| 10 | AtsystemFeatureAutoipfiltering->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:710 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:135 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.48 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 11.414 MB Rows returned: 0
SELECT `ip`
FROM `xvd3l_admintools_ipblock`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_admintools_ipblock | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| System lock | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 12 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/admintools/feature/ipblacklist.php:139 |
| 11 | AtsystemFeatureIpblacklist->isIPBlocked() | JROOT/plugins/system/admintools/feature/ipblacklist.php:33 |
| 10 | AtsystemFeatureIpblacklist->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:710 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:135 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.51 ms After last query: 0.78 ms Query memory: 0.023 MB Memory before query: 11.440 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `xvd3l_admintools_redirects`
WHERE ((`dest` = 'hikashop-menu-for-categories-listing/category/16-kids') OR (`dest` = 'hikashop-menu-for-categories-listing/category/16-kids') OR ('hikashop-menu-for-categories-listing/category/16-kids' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_admintools_redirects | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.02 ms |
| init | 0.05 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.07 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1767 |
| 11 | JDatabaseDriver->loadRow() | JROOT/plugins/system/admintools/feature/urlredir.php:89 |
| 10 | AtsystemFeatureUrlredir->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:710 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:135 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.35 ms After last query: 17.53 ms Query memory: 0.028 MB Memory before query: 12.861 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xvd3l_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 20 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 19 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 16 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 15 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 14 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 11 | Joomla\CMS\Factory::getDocument() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2755 |
| 10 | include_once JROOT/administrator/components/com_hikashop/helpers/helper.php | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168 |
| 9 | plgSystemHikashopgeolocation->process() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57 |
| 8 | plgSystemHikashopgeolocation->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 2.80 ms After last query: 0.21 ms Query memory: 0.007 MB Memory before query: 12.855 MB
UPDATE `xvd3l_extensions`
SET `params` = '{\"mediaversion\":\"7fb38c55e8366269097ec87e7d5b684f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `xvd3l_extensions`
SET `params` = '{\"mediaversion\":\"7fb38c55e8366269097ec87e7d5b684f\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.06 ms |
| Updating | 0.07 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.01 ms |
| query end | 2.47 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 15 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 14 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 11 | Joomla\CMS\Factory::getDocument() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2755 |
| 10 | include_once JROOT/administrator/components/com_hikashop/helpers/helper.php | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168 |
| 9 | plgSystemHikashopgeolocation->process() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57 |
| 8 | plgSystemHikashopgeolocation->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.45 ms After last query: 6.23 ms Query memory: 0.050 MB Memory before query: 13.526 MB Rows returned: 318
SELECT *
FROM xvd3l_hikashop_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 318 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.22 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/config.php:16 |
| 12 | hikashopConfigClass->load() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1071 |
| 11 | hikashop_config() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2774 |
| 10 | include_once JROOT/administrator/components/com_hikashop/helpers/helper.php | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168 |
| 9 | plgSystemHikashopgeolocation->process() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57 |
| 8 | plgSystemHikashopgeolocation->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.34 ms After last query: 8.05 ms Query memory: 0.028 MB Memory before query: 14.620 MB Rows returned: 2
SELECT *
FROM xvd3l_languages
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_sh404sef/helpers/language.php:215 |
| 12 | Sh404sefHelperLanguage::getAllContentLanguages() | JROOT/administrator/components/com_sh404sef/helpers/language.php:167 |
| 11 | Sh404sefHelperLanguage::getUrlCodeFromTag() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84 |
| 10 | Sh404sefClassPageinfo->setCurrentLanguage() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100 |
| 9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:63 |
| 8 | plgSystemSh404sef->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 0.71 ms After last query: 10.87 ms Query memory: 0.024 MB Memory before query: 15.414 MB Rows returned: 1
SELECT `params`
FROM xvd3l_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.07 ms |
| optimizing | 0.01 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687 |
| 14 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377 |
| 13 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
| 12 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/general.php:160 |
| 11 | Sh404sefHelperGeneral::getComponentParams() | JROOT/administrator/components/com_sh404sef/classes/config.php:653 |
| 10 | Sh404sefClassConfig->__construct() | JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121 |
| 9 | Sh404sefFactory::getConfig() | JROOT/plugins/system/sh404sef/sh404sef.php:86 |
| 8 | plgSystemSh404sef->onAfterInitialise() | 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:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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 |
Query Time: 1.80 ms After last query: 31.35 ms Query memory: 0.026 MB Memory before query: 17.364 MB Rows returned: 1
SELECT *
FROM `xvd3l_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('','com_hikashop')
AND `view` IN('')
AND `task` IN('','listing','.listing')
AND `enabled` = '1'
GROUP BY `query`
ORDER BY `query` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_admintools_wafblacklists | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.06 ms |
| optimizing | 0.03 ms |
| statistics | 0.02 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.76 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.20 ms |
| Sorting result | 0.06 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| removing tmp table | 0.17 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/admintools/feature/wafblacklist.php:87 |
| 10 | AtsystemFeatureWafblacklist->onAfterRoute() | JROOT/plugins/system/admintools/admintools/main.php:710 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:145 |
| 8 | plgSystemAdmintools->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:1122 |
| 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 |
Query Time: 0.59 ms After last query: 3.90 ms Query memory: 0.025 MB Memory before query: 17.524 MB Rows returned: 1
SELECT *
FROM xvd3l_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.02 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sorting result | 0.06 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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 |
Query Time: 0.87 ms After last query: 0.33 ms Query memory: 0.021 MB Memory before query: 17.545 MB Rows returned: 2
SELECT id, home, template, s.params
FROM xvd3l_template_styles as s
LEFT JOIN xvd3l_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | adityaic_joomla_test.s.template,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| System lock | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.16 ms |
| end | 0.08 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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 |
Query Time: 0.61 ms After last query: 5.82 ms Query memory: 0.033 MB Memory before query: 17.934 MB Rows returned: 1
SELECT *
FROM xvd3l_menu
WHERE id = '999'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_menu | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2069 |
| 17 | hikashopClass->get() | JROOT/administrator/components/com_hikashop/classes/menus.php:20 |
| 16 | hikashopMenusClass->get() | JROOT/administrator/components/com_hikashop/helpers/module.php:229 |
| 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:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 0.47 ms Query memory: 0.008 MB Memory before query: 17.982 MB
REPLACE INTO xvd3l_hikashop_config (config_namekey,config_value)
VALUES ('menu_999','YTozNDp7czoxNDoiYm9yZGVyX3Zpc2libGUiO3M6MToiMiI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoxMjoiY29udGVudF90eXBlIjtzOjg6ImNhdGVnb3J5IjtzOjExOiJsYXlvdXRfdHlwZSI7czozOiJkaXYiO3M6NzoiY29sdW1ucyI7aTozO3M6NToibGltaXQiO3M6MjoiMjEiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE1OiJtb2R1bGVjbGFzc19zZngiO3M6MDoiIjtzOjc6Im1vZHVsZXMiO3M6MDoiIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTU6InVzZV9tb2R1bGVfbmFtZSI7czoxOiIwIjtzOjEzOiJwcm9kdWN0X29yZGVyIjtzOjg6Im9yZGVyaW5nIjtzOjY6InJhbmRvbSI7czoxOiIwIjtzOjE5OiJwcm9kdWN0X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTA6InNob3dfcHJpY2UiO3M6MToiMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMSI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIxIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6MTc6ImNhdGVnb3J5X29yZGVyaW5nIjtzOjE4OiJjaGlsZF9kaXNwbGF5X3R5cGUiO3M6Nzoibm9jaGlsZCI7czoxMToiY2hpbGRfbGltaXQiO3M6MDoiIjtzOjIwOiJkaXZfaXRlbV9sYXlvdXRfdHlwZSI7czo5OiJpbWdfdGl0bGUiO3M6MTc6ImRpdl9jdXN0b21fZmllbGRzIjtzOjA6IiI7czo2OiJoZWlnaHQiO3M6MzoiMTUwIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjc6IiNGRkZGRkYiO3M6NjoibWFyZ2luIjtzOjI6IjEwIjtzOjE1OiJyb3VuZGVkX2Nvcm5lcnMiO3M6MToiMSI7czoxMToidGV4dF9jZW50ZXIiO3M6MToiMSI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjE6IjAiO3M6MjA6ImxpbmtfdG9fcHJvZHVjdF9wYWdlIjtzOjE6IjEiO3M6MTQ6ImRpc3BsYXlfYmFkZ2VzIjtzOjE6IjEiO30=')
EXPLAIN not possible on query: REPLACE INTO xvd3l_hikashop_config (config_namekey,config_value) VALUES ('menu_999','YTozNDp7czoxNDoiYm9yZGVyX3Zpc2libGUiO3M6MToiMiI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoxMjoiY29udGVudF90eXBlIjtzOjg6ImNhdGVnb3J5IjtzOjExOiJsYXlvdXRfdHlwZSI7czozOiJkaXYiO3M6NzoiY29sdW1ucyI7aTozO3M6NToibGltaXQiO3M6MjoiMjEiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE1OiJtb2R1bGVjbGFzc19zZngiO3M6MDoiIjtzOjc6Im1vZHVsZXMiO3M6MDoiIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTU6InVzZV9tb2R1bGVfbmFtZSI7czoxOiIwIjtzOjEzOiJwcm9kdWN0X29yZGVyIjtzOjg6Im9yZGVyaW5nIjtzOjY6InJhbmRvbSI7czoxOiIwIjtzOjE5OiJwcm9kdWN0X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTA6InNob3dfcHJpY2UiO3M6MToiMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMSI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIxIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6MTc6ImNhdGVnb3J5X29yZGVyaW5nIjtzOjE4OiJjaGlsZF9kaXNwbGF5X3R5cGUiO3M6Nzoibm9jaGlsZCI7czoxMToiY2hpbGRfbGltaXQiO3M6MDoiIjtzOjIwOiJkaXZfaXRlbV9sYXlvdXRfdHlwZSI7czo5OiJpbWdfdGl0bGUiO3M6MTc6ImRpdl9jdXN0b21fZmllbGRzIjtzOjA6IiI7czo2OiJoZWlnaHQiO3M6MzoiMTUwIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjc6IiNGRkZGRkYiO3M6NjoibWFyZ2luIjtzOjI6IjEwIjtzOjE1OiJyb3VuZGVkX2Nvcm5lcnMiO3M6MToiMSI7czoxMToidGV4dF9jZW50ZXIiO3M6MToiMSI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjE6IjAiO3M6MjA6ImxpbmtfdG9fcHJvZHVjdF9wYWdlIjtzOjE6IjEiO3M6MTQ6ImRpc3BsYXlfYmFkZ2VzIjtzOjE6IjEiO30=')
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| update | 0.20 ms |
| Waiting for query cache lock | 0.01 ms |
| update | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.05 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_hikashop/classes/config.php:131 |
| 17 | hikashopConfigClass->save() | JROOT/administrator/components/com_hikashop/classes/menus.php:468 |
| 16 | hikashopMenusClass->createMenuOption() | JROOT/administrator/components/com_hikashop/helpers/module.php:234 |
| 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:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.57 ms After last query: 3.03 ms Query memory: 0.033 MB Memory before query: 18.160 MB Rows returned: 1
SELECT *
FROM xvd3l_hikashop_category
WHERE category_id = '16'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2069 |
| 15 | hikashopClass->get() | JROOT/administrator/components/com_hikashop/classes/category.php:38 |
| 14 | hikashopCategoryClass->get() | JROOT/components/com_hikashop/views/category/view.html.php:142 |
| 13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.56 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 18.174 MB Rows returned: 1
SELECT category_id
FROM xvd3l_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
AND category_type='product'
AND category_id IN ('16')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_hikashop/views/category/view.html.php:173 |
| 13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.38 ms After last query: 36.64 ms Query memory: 0.032 MB Memory before query: 20.868 MB Rows returned: 0
SELECT a.*
FROM xvd3l_hikashop_category AS a
WHERE a.category_parent_id = 16
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
ORDER BY a.category_ordering ASC
LIMIT 0, 21
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 36 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.06 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:569 |
| 14 | hikashopCategoryClass->getChildren() | JROOT/components/com_hikashop/views/category/view.html.php:268 |
| 13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.30 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 20.875 MB Rows returned: 1
SELECT COUNT(*)
FROM xvd3l_hikashop_category AS a
WHERE a.category_parent_id = 16
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 36 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_hikashop/views/category/view.html.php:273 |
| 13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.43 ms After last query: 2.73 ms Query memory: 0.037 MB Memory before query: 21.164 MB Rows returned: 1
SELECT a.*,b.*
FROM xvd3l_hikashop_category AS a
LEFT JOIN xvd3l_hikashop_file AS b
ON a.category_id = b.file_ref_id
AND b.file_type = 'category'
WHERE a.category_id = 16
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | ref | file_type | file_type | 767 | const | 13 | |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/category.php:35 |
| 14 | hikashopCategoryClass->get() | JROOT/components/com_hikashop/views/category/view.html.php:345 |
| 13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.97 ms After last query: 6.88 ms Query memory: 0.035 MB Memory before query: 21.706 MB Rows returned: 4
SELECT hk_parent.*
FROM xvd3l_hikashop_category AS hk_cat
LEFT JOIN xvd3l_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 = 16
GROUP BY hk_parent.category_id
ORDER BY hk_parent.category_left
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hk_cat | const | PRIMARY | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | hk_parent | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 36 | |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.35 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.14 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| removing tmp table | 0.08 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:725 |
| 16 | hikashopCategoryClass->getParents() | JROOT/administrator/components/com_hikashop/classes/field.php:408 |
| 15 | hikashopFieldClass->getCategories() | JROOT/administrator/components/com_hikashop/classes/field.php:145 |
| 14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/category/view.html.php:349 |
| 13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.50 ms After last query: 0.12 ms Query memory: 0.032 MB Memory before query: 21.736 MB Rows returned: 0
SELECT *
FROM xvd3l_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 '%,16,%'))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 '%,12,%' OR field_categories LIKE '%,16,%')))
ORDER BY a.`field_ordering` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 54 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.08 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/field.php:126 |
| 15 | hikashopFieldClass->getData() | JROOT/administrator/components/com_hikashop/classes/field.php:146 |
| 14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/category/view.html.php:349 |
| 13 | CategoryViewCategory->listing() | JROOT/components/com_hikashop/views/category/view.html.php:25 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.54 ms After last query: 3.20 ms Query memory: 0.034 MB Memory before query: 21.910 MB Rows returned: 1
SELECT *
FROM xvd3l_hikashop_category
WHERE category_id = '2'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2069 |
| 16 | hikashopClass->get() | JROOT/administrator/components/com_hikashop/classes/category.php:38 |
| 15 | hikashopCategoryClass->get() | JROOT/administrator/components/com_hikashop/classes/category.php:697 |
| 14 | hikashopCategoryClass->getParents() | 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:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 0.09 ms Query memory: 0.033 MB Memory before query: 21.923 MB Rows returned: 3
SELECT hk_parent.*
FROM xvd3l_hikashop_category AS hk_cat
LEFT JOIN xvd3l_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 = 16
AND hk_parent.category_left >= 2
AND hk_parent.category_right <= 29
GROUP BY hk_parent.category_id
ORDER BY hk_parent.category_left
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hk_cat | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | hk_parent | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 36 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sorting result | 0.09 ms |
| Sending data | 0.11 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:725 |
| 14 | hikashopCategoryClass->getParents() | 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:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.91 ms After last query: 26.12 ms Query memory: 0.029 MB Memory before query: 23.748 MB Rows returned: 0
SELECT cart.cart_id
FROM xvd3l_hikashop_cart AS cart
WHERE (cart.cart_type = 'cart')
AND (cart.session_id = '180e8328e5c881000f4dab5363c4a560')
ORDER BY cart.cart_current DESC, cart.cart_modified DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cart | ref | session_id | session_id | 767 | const | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.30 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sorting result | 0.11 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 24 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_hikashop/classes/cart.php:68 |
| 23 | hikashopCartClass->getCurrentCartId() | JROOT/administrator/components/com_hikashop/classes/cart.php:91 |
| 22 | hikashopCartClass->get() | JROOT/administrator/components/com_hikashop/helpers/helper.php:447 |
| 21 | hikashop_getZone() | JROOT/components/com_hikashop/views/product/view.html.php:499 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.49 ms After last query: 0.13 ms Query memory: 0.028 MB Memory before query: 23.759 MB Rows returned: 1
SELECT category_id
FROM xvd3l_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
AND category_id IN ('16')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 21 | JDatabaseDriver->loadColumn() | JROOT/components/com_hikashop/views/product/view.html.php:520 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.49 ms After last query: 6.71 ms Query memory: 0.033 MB Memory before query: 24.327 MB Rows returned: 0
SELECT *
FROM xvd3l_hikashop_filter
WHERE filter_published = 1
AND (filter_access = 'all' OR filter_access LIKE '%,9,%')
ORDER BY filter_ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.06 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/filter.php:293 |
| 22 | hikashopFilterClass->getFilters() | JROOT/components/com_hikashop/views/product/view.html.php:139 |
| 21 | ProductViewProduct->filter() | JROOT/components/com_hikashop/views/product/view.html.php:543 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.87 ms After last query: 0.16 ms Query memory: 0.041 MB Memory before query: 24.339 MB Rows returned: 1
SELECT a.*,b.*
FROM xvd3l_hikashop_category AS a
LEFT JOIN xvd3l_hikashop_file AS b
ON a.category_id = b.file_ref_id
AND b.file_type = 'category'
WHERE a.category_id = 16
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | ref | file_type | file_type | 767 | const | 13 | |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.06 ms |
| optimizing | 0.04 ms |
| statistics | 0.17 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.17 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 22 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/category.php:35 |
| 21 | hikashopCategoryClass->get() | JROOT/components/com_hikashop/views/product/view.html.php:546 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.85 ms After last query: 0.33 ms Query memory: 0.029 MB Memory before query: 24.357 MB Rows returned: 1
SELECT a.id
FROM xvd3l_menu AS a
INNER JOIN `xvd3l_menu_types` as b
on a.menutype = b.menutype
WHERE a.type='component'
AND a.published=1
AND b.title IS NOT NULL
AND a.access IN (1,1,5)
AND a.client_id=0
AND a.link='index.php?option=com_hikashop&view=checkout&layout=show'
AND a.language IN ('*', '', 'en-GB')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_client_id_parent_id_alias_language,idx_menutype,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 19 | Using where |
| 1 | SIMPLE | b | ALL | idx_menutype | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where; Using join buffer |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| System lock | 0.02 ms |
| init | 0.07 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.06 ms |
| executing | 0.01 ms |
| Sending data | 0.22 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_hikashop/classes/menus.php:276 |
| 23 | hikashopMenusClass->loadAMenuItemId() | JROOT/administrator/components/com_hikashop/classes/menus.php:206 |
| 22 | hikashopMenusClass->getCheckoutURL() | JROOT/administrator/components/com_hikashop/helpers/cart.php:254 |
| 21 | hikashopCartHelper->getJS() | JROOT/components/com_hikashop/views/product/view.html.php:719 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.69 ms After last query: 0.48 ms Query memory: 0.060 MB Memory before query: 24.371 MB Rows returned: 12
SELECT DISTINCT b.*
FROM xvd3l_hikashop_product_category AS a
LEFT JOIN xvd3l_hikashop_product AS b
ON a.product_id=b.product_id
WHERE (b.product_published = 1)
AND (b.product_type = 'main')
AND (a.category_id IN (16))
AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%'))
ORDER BY a.ordering ASC
LIMIT 0, 21
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | category_id,product_id | category_id | 4 | const | 7 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | b | eq_ref | PRIMARY,product_main_index | PRIMARY | 4 | adityaic_joomla_test.a.product_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.09 ms |
| optimizing | 0.03 ms |
| statistics | 0.22 ms |
| preparing | 0.05 ms |
| Creating tmp table | 1.43 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.77 ms |
| Sorting result | 0.08 ms |
| Sending data | 0.41 ms |
| end | 0.01 ms |
| removing tmp table | 0.18 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/view.html.php:800 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.84 ms After last query: 0.59 ms Query memory: 0.033 MB Memory before query: 24.491 MB Rows returned: 12
SELECT *
FROM xvd3l_hikashop_file
WHERE file_ref_id IN (18,19,20,21,22,23,24,25,26,27,28,29)
AND file_type IN ('product','file')
ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_file | ALL | file_type | NO INDEX KEY COULD BE USED | NULL | NULL | 146 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.02 ms |
| init | 0.05 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sorting result | 0.16 ms |
| Sending data | 0.18 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/product.php:1721 |
| 21 | hikashopProductClass->loadProductsListingData() | JROOT/components/com_hikashop/views/product/view.html.php:817 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.45 ms After last query: 0.17 ms Query memory: 0.028 MB Memory before query: 24.524 MB Rows returned: 0
SELECT variant_product_id
FROM xvd3l_hikashop_variant
WHERE variant_product_id IN (18,19,20,21,22,23,24,25,26,27,28,29)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_variant | range | variant_product_id | variant_product_id | 4 | NULL | 12 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| System lock | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/product.php:1742 |
| 21 | hikashopProductClass->loadProductsListingData() | JROOT/components/com_hikashop/views/product/view.html.php:817 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.55 ms After last query: 0.07 ms Query memory: 0.028 MB Memory before query: 24.535 MB Rows returned: 0
SELECT product_id
FROM xvd3l_hikashop_product_related
WHERE product_related_type = 'options'
AND product_id IN (18,19,20,21,22,23,24,25,26,27,28,29)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_product_related | index | PRIMARY | PRIMARY | 775 | NULL | 17 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| System lock | 0.03 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.18 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/product.php:1758 |
| 21 | hikashopProductClass->loadProductsListingData() | JROOT/components/com_hikashop/views/product/view.html.php:817 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.19 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 24.548 MB Rows returned: 0
SELECT product_parent_id, product_id
FROM xvd3l_hikashop_product
WHERE product_parent_id IN ('18','19','20','21','22','23','24','25','26','27','28','29')
AND product_published = 1
AND product_type = 'variant'
AND product_sale_start < 1614508668
AND (product_sale_end > 1614508668 OR product_sale_end = 0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_product | ref | product_parent_id,product_main_index | product_main_index | 767 | const | 41 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.02 ms |
| init | 0.05 ms |
| optimizing | 0.03 ms |
| statistics | 0.20 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.61 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/currency.php:948 |
| 24 | hikashopCurrencyClass->_loadProductVariants() | JROOT/administrator/components/com_hikashop/classes/currency.php:509 |
| 23 | hikashopCurrencyClass->getProductsPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:471 |
| 22 | hikashopCurrencyClass->getListingPrices() | JROOT/administrator/components/com_hikashop/classes/product.php:1773 |
| 21 | hikashopProductClass->loadProductsListingData() | JROOT/components/com_hikashop/views/product/view.html.php:817 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 0.32 ms Query memory: 0.041 MB Memory before query: 24.566 MB Rows returned: 0
SELECT *
FROM xvd3l_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND (discount_quota > discount_used_times OR discount_quota = 0)
AND discount_start < 1614508668
AND (discount_end > 1614508668 OR discount_end = 0)
AND ( (discount_product_id IN ('','0','18','19','20','21','22','23','24','25','26','27','28','29')) OR (discount_product_id LIKE '%,18,%') OR (discount_product_id LIKE '%,19,%') OR (discount_product_id LIKE '%,20,%') OR (discount_product_id LIKE '%,21,%') OR (discount_product_id LIKE '%,22,%') OR (discount_product_id LIKE '%,23,%') OR (discount_product_id LIKE '%,24,%') OR (discount_product_id LIKE '%,25,%') OR (discount_product_id LIKE '%,26,%') OR (discount_product_id LIKE '%,27,%') OR (discount_product_id LIKE '%,28,%') OR (discount_product_id LIKE '%,29,%') )
AND (discount_flat_amount != 0 OR discount_percent_amount != 0)
AND (discount_flat_amount = 0 OR discount_currency_id =6)
AND (discount_access = 'all' OR discount_access LIKE '%,9,%')
AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.07 ms |
| optimizing | 0.02 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/currency.php:551 |
| 23 | hikashopCurrencyClass->getProductsPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:471 |
| 22 | hikashopCurrencyClass->getListingPrices() | JROOT/administrator/components/com_hikashop/classes/product.php:1773 |
| 21 | hikashopProductClass->loadProductsListingData() | JROOT/components/com_hikashop/views/product/view.html.php:817 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 |
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:92 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 0.19 ms Query memory: 0.029 MB Memory before query: 24.578 MB Rows returned: 3
SELECT currency_id
FROM xvd3l_hikashop_currency
WHERE currency_published=1 OR currency_id = 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xvd3l_hikashop_currency | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 182 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 25 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_hikashop/classes/currency.php:466 |
| 24 | hikashopCurrencyClass->publishedCurrencies() | JROOT/administrator/components/com_hikashop/classes/currency.php:559 |
| 23 | hikashopCurrencyClass->getProductsPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:471 |
| 22 | hikashopCurrencyClass->getListingPrices() | JROOT/administrator/components/com_hikashop/classes/product.php:1773 |
| 21 | hikashopProductClass->loadProductsListingData() | JROOT/components/com_hikashop/views/product/view.html.php:817 |
| 20 | ProductViewProduct->listing() | JROOT/components/com_hikashop/views/product/view.html.php:28 |
| 19 | ProductViewProduct->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:756 |
| 18 | hikashop_getLayout() | JROOT/components/com_hikashop/views/category/tmpl/listing.php:129 |
| 17 | include JROOT/components/com_hikashop/views/category/tmpl/listing.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2186 |
| 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:2169 |
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/category/view.html.php:26 |
| 12 | CategoryViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1907 |
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1644 |
| 9 | hikashopController->listing() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 | </
