Query Time: 0.50 ms Query memory: 0.021 MB Memory before query: 4.243 MB Rows returned: 0
SELECT `data`
FROM `w1hzg_session`
WHERE `session_id` = '8a762ad41ea7c8dc94e0f8345eb978e6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1730 |
| 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:831 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.49 ms After last query: 1.34 ms Query memory: 0.012 MB Memory before query: 4.395 MB Rows returned: 0
SELECT `session_id`
FROM `w1hzg_session`
WHERE `session_id` = '8a762ad41ea7c8dc94e0f8345eb978e6'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Application/CMSApplication.php:178 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:833 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 2.84 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 4.411 MB
INSERT INTO `w1hzg_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('8a762ad41ea7c8dc94e0f8345eb978e6', 1, '1506229930', 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `w1hzg_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('8a762ad41ea7c8dc94e0f8345eb978e6', 1, '1506229930', 0, '', 0)
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.03 ms |
| init | 0.02 ms |
| update | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| update | 0.02 ms |
| end | 0.00 ms |
| query end | 2.39 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Application/CMSApplication.php:218 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:833 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
| 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:415 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.24 ms After last query: 3.01 ms Query memory: 0.023 MB Memory before query: 4.737 MB Rows returned: 46
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `w1hzg_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_extensions | ref | extension | extension | 82 | const | 46 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.52 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.13 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:450 |
| 9 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{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/Component/ComponentHelper.php:458 |
| 6 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:46 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:114 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:596 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.28 ms After last query: 2.66 ms Query memory: 0.015 MB Memory before query: 5.052 MB Rows returned: 3
SELECT id, rules
FROM `w1hzg_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.25 ms After last query: 0.15 ms Query memory: 0.015 MB Memory before query: 5.076 MB Rows returned: 1
SELECT b.id
FROM w1hzg_usergroups AS a
LEFT JOIN w1hzg_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 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 | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 9 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.96 ms After last query: 0.73 ms Query memory: 0.020 MB Memory before query: 5.170 MB Rows returned: 120
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM w1hzg_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_extensions | ref | extension | extension | 82 | const | 144 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sorting result | 0.94 ms |
| Sending data | 1.16 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.20 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
| 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:348 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.25 ms After last query: 8.41 ms Query memory: 0.017 MB Memory before query: 6.287 MB Rows returned: 0
SELECT `path`
FROM w1hzg_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
| 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.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.02 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:685 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.27 ms After last query: 0.11 ms Query memory: 0.017 MB Memory before query: 6.304 MB Rows returned: 0
SELECT `file`
FROM w1hzg_rsfirewall_hashes
WHERE `type`='protect'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_rsfirewall_hashes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 31 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.02 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:685 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.31 ms After last query: 0.09 ms Query memory: 0.019 MB Memory before query: 6.319 MB Rows returned: 52
SELECT *
FROM w1hzg_rsfirewall_configuration
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_rsfirewall_configuration | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 52 | |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.04 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:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:685 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.10 ms After last query: 6.13 ms Query memory: 0.024 MB Memory before query: 7.031 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `w1hzg_rsfirewall_logs`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `w1hzg_rsfirewall_logs`
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.30 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.11 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 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:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 |
| 11 | RsfirewallTableLogs->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 |
| 9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:57 |
| 8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:50 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:685 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.81 ms After last query: 29.96 ms Query memory: 0.040 MB Memory before query: 9.750 MB Rows returned: 77
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 w1hzg_menu AS m
LEFT JOIN w1hzg_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 | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 87 | Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.m.component_id | 1 | |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.11 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| Sorting result | 0.40 ms |
| Sending data | 0.34 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 1.28 ms |
| Waiting for query cache lock | 0.03 ms |
| Sending data | 0.43 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.50 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:446 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:551 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1146 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.15 ms After last query: 15.16 ms Query memory: 0.025 MB Memory before query: 11.384 MB Rows returned: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM w1hzg_categories as c
LEFT JOIN w1hzg_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=227
ORDER BY c.lft
| 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.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.15 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.14 ms |
| init | 0.07 ms |
| optimizing | 0.03 ms |
| statistics | 0.11 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.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.58 ms After last query: 0.12 ms Query memory: 0.017 MB Memory before query: 11.400 MB Rows returned: 1
SELECT `alias`,`catid`
FROM `w1hzg_content`
WHERE `id` = 227
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1652 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.42 ms After last query: 0.24 ms Query memory: 0.016 MB Memory before query: 11.422 MB Rows returned: 4
SELECT *
FROM w1hzg_rsfirewall_hashes
WHERE (`type`='3.8.0' OR `type`='protect')
AND `flag`!='C'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_rsfirewall_hashes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 31 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.02 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1026 |
| 9 | plgSystemRSFirewall->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.33 ms After last query: 0.61 ms Query memory: 0.017 MB Memory before query: 11.480 MB Rows returned: 0
SELECT *
FROM w1hzg_rsfirewall_snapshots
WHERE `type`='protect'
| 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.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 |
| 10 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1049 |
| 9 | plgSystemRSFirewall->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.33 ms After last query: 0.18 ms Query memory: 0.018 MB Memory before query: 11.497 MB Rows returned: 0
SELECT `ip`,`reason`
FROM w1hzg_rsfirewall_lists
WHERE (`ip`='54.225.39.142' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_rsfirewall_lists | ref | published,type,ip | published | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.02 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:169 |
| 11 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:148 |
| 10 | plgSystemRSFirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1085 |
| 9 | plgSystemRSFirewall->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.31 ms After last query: 0.16 ms Query memory: 0.017 MB Memory before query: 11.513 MB Rows returned: 0
SELECT `ip`,`reason`
FROM w1hzg_rsfirewall_lists
WHERE (`ip`='54.225.39.142' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_rsfirewall_lists | ref | published,type,ip | published | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.02 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:169 |
| 11 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:138 |
| 10 | plgSystemRSFirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1089 |
| 9 | plgSystemRSFirewall->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.33 ms After last query: 6.87 ms Query memory: 0.019 MB Memory before query: 12.760 MB Rows returned: 0
SELECT *
FROM w1hzg_rsfirewall_exceptions
WHERE `published`='1'
| 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 |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:682 |
| 10 | plgSystemRSFirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1142 |
| 9 | plgSystemRSFirewall->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.60 ms After last query: 0.66 ms Query memory: 0.026 MB Memory before query: 12.820 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `w1hzg_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.12 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.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
| 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84 |
| 9 | plgSystemSL_ScrollToTop->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.48 ms After last query: 0.25 ms Query memory: 0.018 MB Memory before query: 12.827 MB
UPDATE `w1hzg_extensions`
SET `params` = '{\"mediaversion\":\"7348d6459da3b2281cccedba91261f3f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `w1hzg_extensions`
SET `params` = '{\"mediaversion\":\"7348d6459da3b2281cccedba91261f3f\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.10 ms |
| Updating | 0.08 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.16 ms |
| query end | 1.74 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84 |
| 9 | plgSystemSL_ScrollToTop->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 6.09 ms Query memory: 0.027 MB Memory before query: 13.726 MB Rows returned: 3
SELECT id, home, template, s.params
FROM w1hzg_template_styles as s
LEFT JOIN w1hzg_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 | 6 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | db501962145.s.template,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
| 20 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
| 19 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
| 18 | Joomla\CMS\HTML\HTMLHelper::script() | Same as call in the line below. |
| 17 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 16 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 15 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/behavior.php:63 |
| 14 | JHtmlBehavior::framework() | JROOT/libraries/cms/html/behavior.php:60 |
| 13 | JHtmlBehavior::framework() | Same as call in the line below. |
| 12 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 11 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 10 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:130 |
| 9 | plgSystemSL_ScrollToTop->onAfterRoute() | Same as call in the line below. |
| 8 | call_user_func_array() | 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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 3.68 ms Query memory: 0.014 MB Memory before query: 14.034 MB Rows returned: 1
SELECT *
FROM w1hzg_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.03 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 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:1691 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.45 ms After last query: 4.67 ms Query memory: 0.026 MB Memory before query: 14.495 MB Rows returned: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `w1hzg_assets`
WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joautofacebook','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_proforms','com_redirect','com_rsfirewall','com_search','com_sigpro','com_tags','com_tcpdf','com_templates','com_uniform','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_assets | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 267 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:248 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.90 ms After last query: 1.64 ms Query memory: 0.026 MB Memory before query: 14.699 MB Rows returned: 30
SHOW FULL COLUMNS
FROM `w1hzg_content`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `w1hzg_content`
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.85 ms |
| System lock | 0.04 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| Opening tables | 0.06 ms |
| checking permissions | 0.09 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.07 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.07 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.06 ms |
| Sending data | 0.27 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| removing tmp table | 0.61 ms |
| closing tables | 0.01 ms |
| freeing items | 0.09 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:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
| 11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:250 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 3.82 ms Query memory: 0.024 MB Memory before query: 15.085 MB Rows returned: 1
SELECT *
FROM w1hzg_content
WHERE `id` = '227'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 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:1455 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
| 10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.83 ms After last query: 0.22 ms Query memory: 0.014 MB Memory before query: 15.101 MB
UPDATE w1hzg_content
SET `hits` = (`hits` + 1)
WHERE `id` = '227'
EXPLAIN not possible on query: UPDATE w1hzg_content
SET `hits` = (`hits` + 1)
WHERE `id` = '227'
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.05 ms |
| Updating | 0.13 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.13 ms |
| query end | 1.20 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1241 |
| 10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:252 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.15 ms After last query: 2.12 ms Query memory: 0.028 MB Memory before query: 15.329 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM w1hzg_content AS a
INNER JOIN w1hzg_categories AS c
on c.id = a.catid
LEFT JOIN w1hzg_users AS u
on u.id = a.created_by
LEFT JOIN w1hzg_categories as parent
ON parent.id = c.parent_id
LEFT JOIN w1hzg_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 227
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 05:12:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 05:12:10')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | v | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.30 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.08 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1652 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:148 |
| 12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.28 ms After last query: 2.31 ms Query memory: 0.036 MB Memory before query: 15.527 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM w1hzg_categories as c
LEFT JOIN w1hzg_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=76
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 63 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 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:1691 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 21 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 20 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 19 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 18 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 17 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86 |
| 16 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 15 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 14 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 13 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 12 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 11 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.63 ms After last query: 1.26 ms Query memory: 0.025 MB Memory before query: 15.636 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `w1hzg_contentitem_tag_map` AS m
INNER JOIN `w1hzg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 227
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db501962145.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.04 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:180 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 277.34 ms Query memory: 0.032 MB Memory before query: 18.316 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM w1hzg_fields AS a
LEFT JOIN `w1hzg_languages` AS l
ON l.lang_code = a.language
LEFT JOIN w1hzg_users AS uc
ON uc.id=a.checked_out
LEFT JOIN w1hzg_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN w1hzg_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN w1hzg_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `w1hzg_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (76,0,61))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | db501962145.a.language | 1 | |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.a.access | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.a.created_user_id | 1 | |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | db501962145.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:190 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.27 ms After last query: 457.69 ms Query memory: 0.024 MB Memory before query: 19.708 MB Rows returned: 41
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM w1hzg_modules AS m
LEFT JOIN w1hzg_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN w1hzg_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-09-24 05:12:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-24 05:12:10')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 248 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | PRIMARY,published,newsfeeds | NO INDEX KEY COULD BE USED | NULL | NULL | 59 | Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | db501962145.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | db501962145.m.module,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.10 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.05 ms |
| optimizing | 0.03 ms |
| statistics | 0.07 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sorting result | 0.43 ms |
| Sending data | 0.76 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 1.16 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.15 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
| 11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
| 10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/whhr/index.php:51 |
| 7 | require JROOT/templates/whhr/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1103 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 8.37 ms Query memory: 0.026 MB Memory before query: 20.073 MB Rows returned: 1
SELECT *
FROM w1hzg_content
WHERE `id` = '227'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 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.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1455 |
| 13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
| 12 | Joomla\CMS\Table\Table->load() | JROOT/modules/mod_filterednews/helper.php:175 |
| 11 | modFilteredNewsHelper::getFN_List() | JROOT/modules/mod_filterednews/mod_filterednews.php:22 |
| 10 | include JROOT/modules/mod_filterednews/mod_filterednews.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.24 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 20.088 MB Rows returned: 3
SELECT a.*, cc.title AS catname,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
FROM w1hzg_content AS a
INNER JOIN w1hzg_categories AS cc
ON cc.id = a.catid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 05:12:10' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 05:12:10' )
AND a.access IN (1,1)
AND (cc.id=76)
AND (cc.id!=61
AND cc.id!=60
AND cc.id!=75
AND cc.id!=58
AND cc.id!=56
AND cc.id!=40
AND cc.id!=77
AND cc.id!=65
AND cc.id!=2
AND cc.id!=72
AND cc.id!=35
AND cc.id!=64
AND cc.id!=53
AND cc.id!=37
AND cc.id!=36
AND cc.id!=34)
AND cc.published = 1
ORDER BY a.ordering ASC
LIMIT 0, 25
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cc | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 3 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.24 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.10 ms |
| optimizing | 0.05 ms |
| statistics | 0.10 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sorting result | 0.08 ms |
| Sending data | 0.14 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 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:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_filterednews/helper.php:247 |
| 11 | modFilteredNewsHelper::getFN_List() | JROOT/modules/mod_filterednews/mod_filterednews.php:22 |
| 10 | include JROOT/modules/mod_filterednews/mod_filterednews.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.85 ms After last query: 4.41 ms Query memory: 0.033 MB Memory before query: 20.503 MB Rows returned: 6
SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM w1hzg_content AS a
LEFT JOIN w1hzg_categories AS c
ON c.id = a.catid
LEFT JOIN w1hzg_users AS ua
ON ua.id = a.created_by
LEFT JOIN w1hzg_users AS uam
ON uam.id = a.modified_by
LEFT JOIN w1hzg_categories as parent
ON parent.id = c.parent_id
LEFT JOIN w1hzg_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid IN (72)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 05:12:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 05:12:10')
ORDER BY a.ordering asc
LIMIT 12
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 22 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.a.created_by | 1 | |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.a.modified_by | 1 | Using index |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.a.id | 1 | |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.21 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.06 ms |
| init | 0.11 ms |
| optimizing | 0.03 ms |
| statistics | 0.11 ms |
| preparing | 0.07 ms |
| executing | 0.01 ms |
| Sorting result | 0.19 ms |
| Sending data | 0.37 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:554 |
| 13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:159 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.45 ms After last query: 0.49 ms Query memory: 0.028 MB Memory before query: 20.621 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `w1hzg_contentitem_tag_map` AS m
INNER JOIN `w1hzg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 289
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db501962145.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:680 |
| 13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:159 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 20.660 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `w1hzg_contentitem_tag_map` AS m
INNER JOIN `w1hzg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 288
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db501962145.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:680 |
| 13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:159 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.33 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 20.699 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `w1hzg_contentitem_tag_map` AS m
INNER JOIN `w1hzg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 286
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db501962145.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:680 |
| 13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:159 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.37 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 20.738 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `w1hzg_contentitem_tag_map` AS m
INNER JOIN `w1hzg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 263
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db501962145.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.05 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:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:680 |
| 13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:159 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.54 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 20.777 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `w1hzg_contentitem_tag_map` AS m
INNER JOIN `w1hzg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 216
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db501962145.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:680 |
| 13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:159 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 20.817 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `w1hzg_contentitem_tag_map` AS m
INNER JOIN `w1hzg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 218
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db501962145.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:680 |
| 13 | ContentModelArticles->getItems() | JROOT/modules/mod_bt_contentslider/classes/content.php:159 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 0.26 ms Query memory: 0.038 MB Memory before query: 20.831 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM w1hzg_categories as c
LEFT JOIN w1hzg_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=72
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 63 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 21 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86 |
| 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
| 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_bt_contentslider/classes/content.php:186 |
| 12 | BtContentDataSource->getList() | JROOT/modules/mod_bt_contentslider/helpers/helper.php:64 |
| 11 | modBtContentSliderHelper::getList() | JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21 |
| 10 | include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 11.38 ms Query memory: 0.025 MB Memory before query: 21.259 MB Rows returned: 1
SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM w1hzg_modules AS m
LEFT JOIN w1hzg_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.id = 142
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-09-24 05:12:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-24 05:12:10')
AND m.access IN (1,1)
AND m.client_id = 0
ORDER BY position, ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.05 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.03 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.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1652 |
| 17 | JDatabaseDriver->loadObject() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/modules/mod_jse_megamenu/helper.php:323 |
| 14 | Mod_JSE_MegaMenu->getModule() | JROOT/modules/mod_jse_megamenu/helper.php:229 |
| 13 | Mod_JSE_MegaMenu->loadModules() | JROOT/modules/mod_jse_megamenu/helper.php:107 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.74 ms After last query: 3.84 ms Query memory: 0.025 MB Memory before query: 21.472 MB Rows returned: 2
SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM w1hzg_modules AS m
LEFT JOIN w1hzg_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.id = 115
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-09-24 05:12:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-24 05:12:10')
AND m.access IN (1,1)
AND m.client_id = 0
ORDER BY position, ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | const | 2 | Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.10 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 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.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/modules/mod_jse_megamenu/helper.php:323 |
| 14 | Mod_JSE_MegaMenu->getModule() | JROOT/modules/mod_jse_megamenu/helper.php:229 |
| 13 | Mod_JSE_MegaMenu->loadModules() | JROOT/modules/mod_jse_megamenu/helper.php:107 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.68 ms After last query: 2.81 ms Query memory: 0.025 MB Memory before query: 21.613 MB Rows returned: 1
SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM w1hzg_modules AS m
LEFT JOIN w1hzg_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.id = 143
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-09-24 05:12:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-24 05:12:10')
AND m.access IN (1,1)
AND m.client_id = 0
ORDER BY position, ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 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:1652 |
| 17 | JDatabaseDriver->loadObject() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/modules/mod_jse_megamenu/helper.php:323 |
| 14 | Mod_JSE_MegaMenu->getModule() | JROOT/modules/mod_jse_megamenu/helper.php:229 |
| 13 | Mod_JSE_MegaMenu->loadModules() | JROOT/modules/mod_jse_megamenu/helper.php:107 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.53 ms After last query: 23.66 ms Query memory: 0.039 MB Memory before query: 24.694 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `w1hzg_jev_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `w1hzg_jev_users`
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.53 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.04 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.14 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 27 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 26 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 25 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 24 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_jevents/tables/jevuser.php:69 |
| 23 | TableUser->__construct() | JROOT/components/com_jevents/libraries/helper.php:2205 |
| 22 | JEVHelper::getAuthorisedUser() | JROOT/components/com_jevents/libraries/helper.php:1098 |
| 21 | JEVHelper::isEventCreator() | JROOT/components/com_jevents/libraries/filters/Published.php:50 |
| 20 | jevPublishedFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 19 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 18 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:908 |
| 17 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 16 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:31 |
| 15 | ExtModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 14 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/modules/mod_jse_megamenu/helper.php:125 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.36 ms After last query: 2.46 ms Query memory: 0.042 MB Memory before query: 25.141 MB Rows returned: 5
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM w1hzg_categories as c
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | range | cat_idx,idx_access | cat_idx | 207 | NULL | 5 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.04 ms |
| logging slow query | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
| 25 | Joomla\CMS\Categories\Categories->_load() | JROOT/components/com_jevents/helpers/category.php:47 |
| 24 | JEventsCategories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 23 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_jevents/libraries/dbmodel.php:90 |
| 22 | JEventsDBModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/datamodel.php:886 |
| 21 | JEventsDataModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/filters/Category.php:39 |
| 20 | jevCategoryFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 19 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 18 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:908 |
| 17 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 16 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:31 |
| 15 | ExtModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 14 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/modules/mod_jse_megamenu/helper.php:125 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.50 ms After last query: 0.40 ms Query memory: 0.032 MB Memory before query: 25.087 MB Rows returned: 4
SELECT c.id
FROM w1hzg_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('en-GB','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ref | cat_idx,idx_access,idx_language | cat_idx | 203 | const,const | 4 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 23 | JDatabaseDriver->loadColumn() | JROOT/components/com_jevents/libraries/dbmodel.php:172 |
| 22 | JEventsDBModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/datamodel.php:886 |
| 21 | JEventsDataModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/filters/Category.php:39 |
| 20 | jevCategoryFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:142 |
| 19 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:200 |
| 18 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:908 |
| 17 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 16 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:31 |
| 15 | ExtModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 14 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/modules/mod_jse_megamenu/helper.php:125 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.95 ms After last query: 1.13 ms Query memory: 0.047 MB Memory before query: 25.180 MB Rows returned: 0
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM w1hzg_jevents_repetition as rpt
INNER JOIN w1hzg_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN w1hzg_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN w1hzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN w1hzg_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN
w1hzg_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN
w1hzg_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2017-09-24 01:12:11'
AND rpt.startrepeat <= '2017-12-23 23:59:59'
AND (rpt.startrepeat >= '2017-06-26 00:00:00' OR det.multiday=1)
AND ev.state=1
AND catmap.catid IN(-1,73,74,78,79)
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat ASC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | icsf | system | PRIMARY,stateidx | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using filesort |
| 1 | SIMPLE | rpt | range | eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat | endrepeat | 8 | NULL | 1 | Using where |
| 1 | SIMPLE | ev | eq_ref | PRIMARY,icsid,stateidx,evaccess | PRIMARY | 4 | db501962145.rpt.eventid | 1 | Using where |
| 1 | SIMPLE | det | eq_ref | PRIMARY,multiday | PRIMARY | 4 | db501962145.rpt.eventdetail_id | 1 | Using where |
| 1 | SIMPLE | rr | ref | eventid | eventid | 4 | db501962145.ev.ev_id | 1 | |
| 1 | SIMPLE | catmap | ref | key_event_category,key_evid | key_event_category | 4 | db501962145.ev.ev_id | 1 | Using where; Using index |
| 1 | SIMPLE | catmapcat | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.catmap.catid | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.45 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| System lock | 0.15 ms |
| Waiting for query cache lock | 0.08 ms |
| init | 0.15 ms |
| optimizing | 0.03 ms |
| statistics | 0.14 ms |
| preparing | 0.08 ms |
| executing | 0.06 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.20 ms |
| end | 0.02 ms |
| removing tmp table | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 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:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/dbmodel.php:2569 |
| 20 | JEventsDBModel->_cachedlistIcalEvents() | Same as call in the line below. |
| 19 | call_user_func_array() | JROOT/components/com_jevents/libraries/jevCache.php:73 |
| 18 | jevCache->call() | JROOT/components/com_jevents/libraries/dbmodel.php:1408 |
| 17 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 16 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:31 |
| 15 | ExtModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 14 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/modules/mod_jse_megamenu/helper.php:125 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.68 ms After last query: 0.24 ms Query memory: 0.048 MB Memory before query: 25.210 MB Rows returned: 1
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM w1hzg_jevents_repetition as rpt
INNER JOIN w1hzg_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN w1hzg_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN w1hzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN w1hzg_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN
w1hzg_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN
w1hzg_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2017-06-26 00:00:00'
AND rpt.startrepeat <= '2017-09-24 01:12:11'
AND (rpt.startrepeat >= '2017-06-26 00:00:00' OR det.multiday=1)
AND ev.state=1
AND catmap.catid IN(-1,73,74,78,79)
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat desc
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | icsf | system | PRIMARY,stateidx | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using filesort |
| 1 | SIMPLE | rpt | range | eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat | endrepeat | 8 | NULL | 5 | Using where |
| 1 | SIMPLE | ev | eq_ref | PRIMARY,icsid,stateidx,evaccess | PRIMARY | 4 | db501962145.rpt.eventid | 1 | Using where |
| 1 | SIMPLE | det | eq_ref | PRIMARY,multiday | PRIMARY | 4 | db501962145.rpt.eventdetail_id | 1 | Using where |
| 1 | SIMPLE | rr | ref | eventid | eventid | 4 | db501962145.ev.ev_id | 1 | |
| 1 | SIMPLE | catmap | ref | key_event_category,key_evid | key_event_category | 4 | db501962145.ev.ev_id | 1 | Using where; Using index |
| 1 | SIMPLE | catmapcat | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.catmap.catid | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.24 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.07 ms |
| init | 0.12 ms |
| optimizing | 0.04 ms |
| statistics | 0.16 ms |
| preparing | 0.10 ms |
| executing | 0.07 ms |
| Sorting result | 0.07 ms |
| Sending data | 0.23 ms |
| end | 0.01 ms |
| removing tmp table | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 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:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/dbmodel.php:2569 |
| 20 | JEventsDBModel->_cachedlistIcalEvents() | Same as call in the line below. |
| 19 | call_user_func_array() | JROOT/components/com_jevents/libraries/jevCache.php:73 |
| 18 | jevCache->call() | JROOT/components/com_jevents/libraries/dbmodel.php:1451 |
| 17 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 16 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:31 |
| 15 | ExtModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 14 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/modules/mod_jse_megamenu/helper.php:125 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.77 ms After last query: 4.26 ms Query memory: 0.048 MB Memory before query: 25.978 MB Rows returned: 1
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM w1hzg_jevents_repetition as rpt
INNER JOIN w1hzg_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN w1hzg_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN w1hzg_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN w1hzg_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN
w1hzg_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN
w1hzg_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2017-06-26 00:00:00'
AND rpt.startrepeat <= '2017-09-24 01:12:11'
AND (rpt.startrepeat <= '2017-06-26 00:00:00'OR det.multiday=1)
AND ev.state=1
AND catmap.catid IN(-1,73,74,78,79)
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat asc
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | icsf | system | PRIMARY,stateidx | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using filesort |
| 1 | SIMPLE | rpt | range | eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat | endrepeat | 8 | NULL | 5 | Using where |
| 1 | SIMPLE | ev | eq_ref | PRIMARY,icsid,stateidx,evaccess | PRIMARY | 4 | db501962145.rpt.eventid | 1 | Using where |
| 1 | SIMPLE | det | eq_ref | PRIMARY,multiday | PRIMARY | 4 | db501962145.rpt.eventdetail_id | 1 | Using where |
| 1 | SIMPLE | rr | ref | eventid | eventid | 4 | db501962145.ev.ev_id | 1 | |
| 1 | SIMPLE | catmap | ref | key_event_category,key_evid | key_event_category | 4 | db501962145.ev.ev_id | 1 | Using where; Using index |
| 1 | SIMPLE | catmapcat | eq_ref | PRIMARY | PRIMARY | 4 | db501962145.catmap.catid | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.24 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.08 ms |
| init | 0.15 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.07 ms |
| executing | 0.07 ms |
| Sorting result | 0.06 ms |
| Sending data | 0.29 ms |
| end | 0.01 ms |
| removing tmp table | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.07 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:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/dbmodel.php:2569 |
| 20 | JEventsDBModel->_cachedlistIcalEvents() | Same as call in the line below. |
| 19 | call_user_func_array() | JROOT/components/com_jevents/libraries/jevCache.php:73 |
| 18 | jevCache->call() | JROOT/components/com_jevents/libraries/dbmodel.php:1493 |
| 17 | JEventsDBModel->listLatestIcalEvents() | JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398 |
| 16 | DefaultModLatestView->getLatestEventsData() | JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:31 |
| 15 | ExtModLatestView->displayLatestEvents() | JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 |
| 14 | include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/modules/mod_jse_megamenu/helper.php:125 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.23 ms After last query: 20.17 ms Query memory: 0.031 MB Memory before query: 27.773 MB Rows returned: 1
SHOW TABLES LIKE "w1hzg_virtuemart_configs"
EXPLAIN not possible on query: SHOW TABLES LIKE "w1hzg_virtuemart_configs"
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| checking permissions | 0.82 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 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:1730 |
| 23 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/models/config.php:499 |
| 22 | VirtueMartModelConfig::checkConfigTableExists() | JROOT/administrator/components/com_virtuemart/helpers/config.php:796 |
| 21 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:715 |
| 20 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:27 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 18 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_jse_megamenu/helper.php:175 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.40 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 27.804 MB Rows returned: 1
SELECT `config`
FROM `w1hzg_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_virtuemart_configs | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.14 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:1730 |
| 22 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/config.php:848 |
| 21 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:715 |
| 20 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:27 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 18 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_jse_megamenu/helper.php:175 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.35 ms After last query: 0.82 ms Query memory: 0.036 MB Memory before query: 27.897 MB Rows returned: 1
SELECT *
FROM `w1hzg_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "en-GB" )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_menu | ref | idx_client_id_parent_id_alias_language,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 88 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.04 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/components/com_virtuemart/router.php:1012 |
| 22 | vmrouterHelper->setMenuItemId() | JROOT/components/com_virtuemart/router.php:696 |
| 21 | vmrouterHelper->__construct() | JROOT/components/com_virtuemart/router.php:717 |
| 20 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:27 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 18 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 13 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_jse_megamenu/helper.php:175 |
| 12 | Mod_JSE_MegaMenu->loadMenu() | JROOT/modules/mod_jse_megamenu/helper.php:31 |
| 11 | Mod_JSE_MegaMenu->__construct() | JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php:57 |
| 10 | include JROOT/modules/mod_jse_megamenu/mod_jse_megamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.50 ms After last query: 19.79 ms Query memory: 0.020 MB Memory before query: 29.162 MB Rows returned: 129
SELECT *
FROM w1hzg_acymailing_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | w1hzg_acymailing_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 129 | |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.05 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
| 11 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:392 |
| 10 | acymailing_config() | JROOT/administrator/components/com_acymailing/helpers/helper.php:1369 |
| 9 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/plugins/system/regacymailing/regacymailing.php:139 |
| 8 | plgSystemRegacymailing->onAfterRender() | Same as call in the line below. |
| 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1123 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.76 ms After last query: 8.28 ms Query memory: 0.021 MB Memory before query: 29.455 MB Rows returned: 1
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
Click to open image!
