Query Time: 0.52 ms Query memory: 0.008 MB Memory before query: 5.084 MB
DELETE
FROM `jml_session`
WHERE `time` < '1550545213'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | DELETE | jml_session | NULL | range | time | time | 59 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.03 ms |
System lock | 0.09 ms |
updating | 0.10 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Application/CMSApplication.php:824 |
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.80 ms After last query: 0.66 ms Query memory: 0.020 MB Memory before query: 5.118 MB Rows returned: 0
SELECT `data`
FROM `jml_session`
WHERE `session_id` = 'v06kcs6hnd6kim9djdt7r3en54'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.05 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
executing | 0.02 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.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.30 ms |
cleaning up | 0.02 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.61 ms After last query: 2.36 ms Query memory: 0.012 MB Memory before query: 5.304 MB Rows returned: 0
SELECT `session_id`
FROM `jml_session`
WHERE `session_id` = 'v06kcs6hnd6kim9djdt7r3en54'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.12 ms |
cleaning up | 0.02 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: 0.81 ms After last query: 0.27 ms Query memory: 0.009 MB Memory before query: 5.319 MB
INSERT INTO `jml_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('v06kcs6hnd6kim9djdt7r3en54', 1, '1550546113', 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `jml_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('v06kcs6hnd6kim9djdt7r3en54', 1, '1550546113', 0, '', 0)
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.02 ms |
update | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
update | 0.31 ms |
end | 0.02 ms |
query end | 0.06 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 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.00 ms After last query: 5.11 ms Query memory: 0.023 MB Memory before query: 5.719 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jml_extensions`
WHERE `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_extensions | NULL | ref | extension | extension | 82 | const | 40 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.03 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:422 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:430 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:496 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:596 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.19 ms After last query: 4.35 ms Query memory: 0.015 MB Memory before query: 6.096 MB Rows returned: 5
SELECT id, rules
FROM `jml_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.02 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.02 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.01 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.20 ms After last query: 0.27 ms Query memory: 0.015 MB Memory before query: 6.121 MB Rows returned: 2
SELECT b.id
FROM jml_usergroups AS a
LEFT JOIN jml_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.02 ms |
cleaning up | 0.01 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.05 ms After last query: 1.13 ms Query memory: 0.019 MB Memory before query: 6.228 MB Rows returned: 91
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jml_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_extensions | NULL | ref | extension | extension | 82 | const | 107 | 0.60 | Using index condition; Using where; Using filesort |
Status | Duration |
---|
starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 1.13 ms |
end | 0.06 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
Waiting for query cache lock | 0.02 ms |
freeing items | 0.05 ms |
Waiting for query cache lock | 0.02 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.02 ms |
cleaning up | 0.03 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.27 ms After last query: 29.40 ms Query memory: 0.019 MB Memory before query: 7.879 MB Rows returned: 1
SELECT template
FROM jml_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 20.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.02 ms |
checking privileges on cached | 0.04 ms |
checking permissions | 0.02 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:96 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
7 | plgSystemRokCommon->__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.25 ms After last query: 0.22 ms Query memory: 0.020 MB Memory before query: 7.898 MB Rows returned: 1
SELECT template
FROM jml_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 20.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.03 ms |
checking permissions | 0.03 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:96 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
7 | plgSystemRokCommon->__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.20 ms After last query: 8.96 ms Query memory: 0.015 MB Memory before query: 8.250 MB Rows returned: 2
SELECT extension, file, type
FROM jml_rokcommon_configs
ORDER BY priority
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_rokcommon_configs | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using filesort |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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 |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:132 |
8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:76 |
7 | plgSystemRokCommon->__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.51 ms After last query: 50.45 ms Query memory: 0.024 MB Memory before query: 10.532 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `jml_extensions`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jml_extensions`
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.33 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.03 ms |
executing | 0.03 ms |
Opening tables | 0.03 ms |
checking permissions | 0.07 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.06 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.04 ms |
Sending data | 0.12 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.07 ms |
closing tables | 0.01 ms |
freeing items | 0.03 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/Extension.php:32 |
11 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:46 |
9 | plgSystemRokSprocket->onAfterInitialise() | 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:686 |
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.09 ms After last query: 1.64 ms Query memory: 0.016 MB Memory before query: 10.623 MB Rows returned: 1
SELECT `extension_id`
FROM `jml_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.05 ms |
freeing items | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.28 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
11 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:121 |
10 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:50 |
9 | plgSystemRokSprocket->onAfterInitialise() | 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:686 |
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.71 ms After last query: 0.30 ms Query memory: 0.020 MB Memory before query: 10.641 MB Rows returned: 1
SELECT *
FROM jml_extensions
WHERE `extension_id` = '10068'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_extensions | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.07 ms |
optimizing | 0.02 ms |
statistics | 0.05 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.02 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.10 ms |
cleaning up | 0.02 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/plugins/system/roksprocket/roksprocket.php:55 |
9 | plgSystemRokSprocket->onAfterInitialise() | 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:686 |
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.71 ms After last query: 0.28 ms Query memory: 0.016 MB Memory before query: 10.655 MB Rows returned: 1
SELECT `extension_id`
FROM `jml_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.09 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
11 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:121 |
10 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:73 |
9 | plgSystemRokSprocket->onAfterInitialise() | 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:686 |
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.20 ms After last query: 0.26 ms Query memory: 0.020 MB Memory before query: 10.671 MB Rows returned: 1
SELECT *
FROM jml_extensions
WHERE `extension_id` = '10068'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_extensions | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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 |
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/plugins/system/roksprocket/roksprocket.php:77 |
9 | plgSystemRokSprocket->onAfterInitialise() | 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:686 |
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: 2.09 ms After last query: 56.19 ms Query memory: 0.038 MB Memory before query: 11.993 MB Rows returned: 65
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 jml_menu AS m
LEFT JOIN jml_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 71 | 10.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | indiakar_new.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.06 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.69 ms |
Waiting for query cache lock | 0.03 ms |
Creating sort index | 0.30 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.10 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 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: 0.89 ms After last query: 37.43 ms Query memory: 0.029 MB Memory before query: 14.394 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jml_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 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.02 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.21 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
23 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
22 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
21 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
20 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
19 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
18 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
17 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
16 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
15 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
14 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/cms/html/behavior.php:355 |
13 | JHtmlBehavior::modal() | 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/k2/k2.php:47 |
9 | plgSystemK2->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: 1.00 ms After last query: 0.43 ms Query memory: 0.022 MB Memory before query: 14.405 MB
UPDATE `jml_extensions`
SET `params` = '{\"mediaversion\":\"4a7932e068a0465c3b051ced798e4fb4\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | jml_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.08 ms |
updating | 0.10 ms |
end | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
end | 0.42 ms |
query end | 0.10 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
18 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
17 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
16 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
15 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
14 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/cms/html/behavior.php:355 |
13 | JHtmlBehavior::modal() | 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/k2/k2.php:47 |
9 | plgSystemK2->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.82 ms After last query: 5.24 ms Query memory: 0.028 MB Memory before query: 14.890 MB Rows returned: 3
SELECT id, home, template, s.params
FROM jml_template_styles as s
LEFT JOIN jml_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 20.00 | Using where |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | indiakar_new.s.template,const | 1 | 4.59 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.05 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.11 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.07 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
21 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
20 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
19 | Joomla\CMS\HTML\HTMLHelper::script() | Same as call in the line below. |
18 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
17 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
16 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/behavior.php:63 |
15 | JHtmlBehavior::framework() | JROOT/libraries/cms/html/behavior.php:60 |
14 | JHtmlBehavior::framework() | JROOT/libraries/cms/html/behavior.php:361 |
13 | JHtmlBehavior::modal() | 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/k2/k2.php:47 |
9 | plgSystemK2->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.23 ms After last query: 6.89 ms Query memory: 0.022 MB Memory before query: 15.160 MB Rows returned: 1
SELECT *
FROM jml_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.04 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.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
13 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
12 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:315 |
11 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:56 |
10 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:55 |
9 | plgSystemK2->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.22 ms After last query: 2.38 ms Query memory: 0.020 MB Memory before query: 15.282 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jml_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_jotcache','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_users','com_wrapper','com_zhgooglemap')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_assets | NULL | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 158 | 25.95 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.02 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/Access/Access.php:429 |
11 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
10 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
9 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
8 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
7 | Joomla\CMS\User\User->authorise() | JROOT/components/com_k2/k2.php:16 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.19 ms After last query: 20.42 ms Query memory: 0.019 MB Memory before query: 17.167 MB Rows returned: 8
SELECT id
FROM jml_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_k2_categories | NULL | ref | category,published,access,trash | category | 2 | const | 9 | 88.89 | Using where; Using index |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
13 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/helpers/permissions.php:261 |
12 | K2HelperPermissions::canAddItem() | JROOT/components/com_k2/views/item/view.html.php:36 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.86 ms After last query: 0.33 ms Query memory: 0.047 MB Memory before query: 17.186 MB Rows returned: 1
SELECT *
FROM jml_k2_items
WHERE id=33
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_k2_items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.03 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.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:36 |
12 | K2ModelItem->getData() | JROOT/components/com_k2/views/item/view.html.php:42 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.08 ms After last query: 1.76 ms Query memory: 0.028 MB Memory before query: 17.358 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `jml_k2_categories`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jml_k2_categories`
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.20 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Opening tables | 0.04 ms |
checking permissions | 0.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.04 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.05 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2category.php:34 |
14 | TableK2Category->__construct() | JROOT/libraries/src/Table/Table.php:312 |
13 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/models/item.php:74 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.22 ms After last query: 0.40 ms Query memory: 0.023 MB Memory before query: 17.407 MB Rows returned: 1
SELECT *
FROM jml_k2_categories
WHERE id = '2'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_k2_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:65 |
13 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:75 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.24 ms After last query: 64.22 ms Query memory: 0.020 MB Memory before query: 17.829 MB Rows returned: 1
SELECT extraFieldsGroup
FROM jml_k2_categories
WHERE id=2
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_k2_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.02 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.03 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
14 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1395 |
13 | K2ModelItem->getItemExtraFields() | JROOT/components/com_k2/models/item.php:184 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.20 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 17.849 MB Rows returned: 15
SELECT *
FROM jml_k2_extra_fields
WHERE `
group` = 2
AND published=1
AND (id IN (1,2,3,4,5,6,7,8,9,10,40,41,42,43,44) OR `type` = 'header')
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_k2_extra_fields | NULL | ref | PRIMARY,group,published | group | 4 | const | 15 | 55.00 | Using index condition; Using where; Using filesort |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1399 |
13 | K2ModelItem->getItemExtraFields() | JROOT/components/com_k2/models/item.php:184 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.21 ms After last query: 12.03 ms Query memory: 0.020 MB Memory before query: 17.891 MB Rows returned: 1
SELECT COUNT(*)
FROM jml_k2_comments
WHERE itemID=33
AND published=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_k2_comments | NULL | ref | itemID,published,latestComments | itemID | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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 |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
14 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1688 |
13 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:274 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.29 ms After last query: 18.04 ms Query memory: 0.034 MB Memory before query: 19.185 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 jml_fields AS a
LEFT JOIN `jml_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jml_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jml_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jml_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jml_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jml_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | indiakar_new.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | indiakar_new.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | indiakar_new.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | indiakar_new.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | indiakar_new.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | indiakar_new.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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 |
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 |
sending cached result to clien | 0.02 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/MVC/Model/BaseDatabaseModel.php:308 |
20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:400 |
16 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:645 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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: 4.13 ms After last query: 16.65 ms Query memory: 0.035 MB Memory before query: 20.030 MB Rows returned: 60
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jml_modules AS m
LEFT JOIN jml_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jml_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 <= '2019-02-19 03:15:14')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-19 03:15:14')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 244 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 77 | 1.60 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | indiakar_new.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | indiakar_new.m.id | 2 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.11 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.12 ms |
optimizing | 0.05 ms |
statistics | 0.17 ms |
preparing | 0.06 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 1.10 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.20 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.24 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.34 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.17 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.17 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.19 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.08 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 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.36 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
23 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
22 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
21 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
20 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
19 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
18 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/plugins/content/loadmodule/loadmodule.php:137 |
17 | PlgContentLoadmodule->_load() | JROOT/plugins/content/loadmodule/loadmodule.php:78 |
16 | PlgContentLoadmodule->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.19 ms After last query: 6.56 ms Query memory: 0.030 MB Memory before query: 20.686 MB Rows returned: 1
SELECT *
FROM jml_template_styles
WHERE home=1
AND client_id=0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_template_styles | NULL | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 20.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
22 | JDatabaseDriver->loadObject() | JROOT/modules/mod_jmslideshow/helper.php:370 |
21 | modJmSlideshowHelper::getTemplate() | JROOT/modules/mod_jmslideshow/mod_jmslideshow.php:36 |
20 | include JROOT/modules/mod_jmslideshow/mod_jmslideshow.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
19 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
18 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/content/loadmodule/loadmodule.php:143 |
17 | PlgContentLoadmodule->_load() | JROOT/plugins/content/loadmodule/loadmodule.php:78 |
16 | PlgContentLoadmodule->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.22 ms After last query: 5.49 ms Query memory: 0.061 MB Memory before query: 21.035 MB Rows returned: 1
SELECT h.*, c.title as category
FROM jml_zhgooglemaps_maps as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
WHERE h.id=30
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | h | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.10 ms |
System lock | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.07 ms |
optimizing | 0.02 ms |
statistics | 0.19 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 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.01 ms |
storing result in query cache | 0.14 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
19 | JDatabaseDriver->loadObject() | JROOT/components/com_zhgooglemap/helpers/map_data.php:30 |
18 | comZhGoogleMapData::getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:937 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.67 ms After last query: 0.46 ms Query memory: 0.067 MB Memory before query: 21.093 MB Rows returned: 5
SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
FROM jml_zhgooglemaps_markers as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
LEFT JOIN jml_zhgooglemaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN jml_zhgooglemaps_infobubbles as bub
ON h.tabid=bub.id
WHERE 1=1
and h.mapid=30
and h.published=1
AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2019-02-19 03:15:14')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2019-02-19 03:15:14')
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g | NULL | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | bub | NULL | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | h | NULL | ref | idx_mapid | idx_mapid | 4 | const | 5 | 1.60 | Using index condition; Using where; Using filesort |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | indiakar_new.h.catid | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.13 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 |
init | 0.14 ms |
System lock | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.04 ms |
optimizing | 0.05 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
Creating sort index | 0.38 ms |
end | 0.01 ms |
query end | 0.02 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.01 ms |
storing result in query cache | 0.11 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:275 |
18 | comZhGoogleMapData::getMarkers() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:942 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.76 ms After last query: 0.78 ms Query memory: 0.036 MB Memory before query: 21.255 MB Rows returned: 1
SELECT h.*, c.title as category
FROM jml_zhgooglemaps_paths as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=30
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | h | NULL | ref | idx_mapid | idx_mapid | 4 | const | 1 | 10.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | indiakar_new.h.catid | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.05 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.14 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 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.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:656 |
18 | comZhGoogleMapData::getPaths() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:943 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.69 ms After last query: 0.27 ms Query memory: 0.032 MB Memory before query: 21.288 MB Rows returned: 0
SELECT h.*, c.title as category
FROM jml_zhgooglemaps_routers as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=30
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.04 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
executing | 0.04 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.02 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.06 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:296 |
18 | comZhGoogleMapData::getRouters() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:944 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.23 ms After last query: 0.24 ms Query memory: 0.030 MB Memory before query: 21.313 MB Rows returned: 0
SELECT h.*, c.title as category
FROM jml_zhgooglemaps_maptypes as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
WHERE h.published=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:674 |
18 | comZhGoogleMapData::getMapTypes() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:945 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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: 0.30 ms Query memory: 0.029 MB Memory before query: 21.340 MB Rows returned: 0
SELECT h.*, c.title as category
FROM jml_zhgooglemaps_adsences as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=30
AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2019-02-19 03:15:14')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2019-02-19 03:15:14')
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.05 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.03 ms |
executing | 0.03 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 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.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:707 |
18 | comZhGoogleMapData::getAdSences() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:946 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.69 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 21.365 MB Rows returned: 0
SELECT h.*, c.title as category
FROM jml_zhgooglemaps_markergroups as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM jml_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=30
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-19 03:15:14')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-19 03:15:14'))
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:420 |
18 | comZhGoogleMapData::getMarkerGroups() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:948 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.68 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 21.391 MB Rows returned: 0
SELECT h.*, c.title as category
FROM jml_zhgooglemaps_markergroups as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM jml_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=30
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-19 03:15:14')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-19 03:15:14'))
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:636 |
18 | comZhGoogleMapData::getMarkerGroupsManage() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:949 |
17 | plgContentPlg_ZhGoogleMap->getMap() | JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:219 |
16 | plgContentPlg_ZhGoogleMap->onContentPrepare() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:868 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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: 2.97 ms After last query: 83.26 ms Query memory: 0.030 MB Memory before query: 24.865 MB Rows returned: 36
SHOW FULL COLUMNS
FROM `jml_k2_items`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jml_k2_items`
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
Opening tables | 0.38 ms |
init | 0.04 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
preparing | 0.04 ms |
executing | 0.04 ms |
Opening tables | 0.04 ms |
checking permissions | 0.09 ms |
checking permissions | 0.04 ms |
checking permissions | 0.08 ms |
checking permissions | 0.04 ms |
checking permissions | 0.04 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.06 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.06 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.05 ms |
Sending data | 0.24 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
removing tmp table | 0.09 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.04 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2item.php:56 |
14 | TableK2Item->__construct() | JROOT/libraries/src/Table/Table.php:312 |
13 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/models/item.php:895 |
12 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:135 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.55 ms After last query: 1.31 ms Query memory: 0.017 MB Memory before query: 24.960 MB
UPDATE jml_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '33'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | jml_k2_items | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.13 ms |
updating | 0.26 ms |
end | 0.02 ms |
Waiting for query cache lock | 0.02 ms |
end | 0.53 ms |
query end | 0.19 ms |
closing tables | 0.04 ms |
freeing items | 0.05 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1241 |
13 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_k2/models/item.php:896 |
12 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:135 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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.42 ms After last query: 15.80 ms Query memory: 0.017 MB Memory before query: 25.676 MB Rows returned: 1
SELECT *
FROM jml_template_styles
WHERE template = 'design_control';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_template_styles | NULL | ref | idx_template | idx_template | 202 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
Waiting for query cache lock | 0.02 ms |
starting | 0.02 ms |
checking query cache for query | 0.02 ms |
checking privileges on cached | 0.02 ms |
checking permissions | 0.02 ms |
sending cached result to clien | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
10 | JDatabaseDriver->loadAssocList() | JROOT/templates/design_control/vertex/parameters.php:19 |
9 | getTemplateName() | JROOT/templates/design_control/vertex/parameters.php:167 |
8 | require JROOT/templates/design_control/vertex/parameters.php | JROOT/templates/design_control/index.php:42 |
7 | require JROOT/templates/design_control/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: 1.31 ms After last query: 0.62 ms Query memory: 0.020 MB Memory before query: 25.694 MB Rows returned: 0
SELECT *
FROM jml_menu
WHERE template_style_id IN (9)
AND alias = 'golden-triangle-tour-with-khajuraho-
and-varanasi'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_menu | NULL | ref | idx_alias | idx_alias | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
Waiting for query cache lock | 0.02 ms |
starting | 0.01 ms |
checking query cache for query | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.03 ms |
Waiting for query cache lock | 0.02 ms |
System lock | 0.05 ms |
optimizing | 0.03 ms |
statistics | 0.16 ms |
preparing | 0.04 ms |
executing | 0.02 ms |
Sending data | 0.11 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
Waiting for query cache lock | 0.02 ms |
freeing items | 0.03 ms |
Waiting for query cache lock | 0.02 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.28 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
10 | JDatabaseDriver->loadAssocList() | JROOT/templates/design_control/vertex/parameters.php:40 |
9 | getTemplateName() | JROOT/templates/design_control/vertex/parameters.php:167 |
8 | require JROOT/templates/design_control/vertex/parameters.php | JROOT/templates/design_control/index.php:42 |
7 | require JROOT/templates/design_control/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.24 ms After last query: 44.47 ms Query memory: 0.017 MB Memory before query: 25.978 MB Rows returned: 0
SELECT menutype
FROM jml_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
checking query cache for query | 0.02 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.02 ms |
sending cached result to clien | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
11 | JDatabaseDriver->loadResult() | JROOT/templates/design_control/vertex/responsive/responsive_mobile_menu.php:139 |
10 | include JROOT/templates/design_control/vertex/responsive/responsive_mobile_menu.php | JROOT/templates/design_control/vertex/responsive/responsive_mobile_sidebar.php:70 |
9 | require JROOT/templates/design_control/vertex/responsive/responsive_mobile_sidebar.php | JROOT/templates/design_control/vertex/includes/vertex_includes_top.php:4 |
8 | require JROOT/templates/design_control/vertex/includes/vertex_includes_top.php | JROOT/templates/design_control/index.php:400 |
7 | require JROOT/templates/design_control/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.21 ms After last query: 34.26 ms Query memory: 0.015 MB Memory before query: 26.445 MB Rows returned: 0
SELECT menutype
FROM jml_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jml_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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 |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
9 | JDatabaseDriver->loadResult() | JROOT/templates/design_control/vertex/s5flex_menu/default.php:45 |
8 | include JROOT/templates/design_control/vertex/s5flex_menu/default.php | JROOT/templates/design_control/index.php:569 |
7 | require JROOT/templates/design_control/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 |
2 × SELECT template
FROM jml_template_styles as s
2 × SELECT *
FROM jml_extensions
2 × SELECT *
FROM jml_template_styles
2 × SELECT h.*, c.title as category
FROM jml_zhgooglemaps_markergroups as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
2 × SELECT `extension_id`
FROM `jml_extensions`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jml_extensions`
2 × SELECT menutype
FROM jml_menu
1 × SELECT h.*, c.title as category
FROM jml_zhgooglemaps_maps as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jml_modules AS m
LEFT JOIN jml_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jml_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT COUNT(*)
FROM jml_k2_comments
1 × 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 jml_fields AS a
LEFT JOIN `jml_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jml_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jml_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jml_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jml_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jml_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
FROM jml_zhgooglemaps_markers as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
LEFT JOIN jml_zhgooglemaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN jml_zhgooglemaps_infobubbles as bub
ON h.tabid=bub.id
1 × SELECT h.*, c.title as category
FROM jml_zhgooglemaps_paths as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
1 × SELECT *
FROM jml_menu
1 × SELECT h.*, c.title as category
FROM jml_zhgooglemaps_maptypes as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
1 × SELECT *
FROM jml_k2_extra_fields
1 × SELECT h.*, c.title as category
FROM jml_zhgooglemaps_routers as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM jml_zhgooglemaps_adsences as h
LEFT JOIN jml_categories as c
ON h.catid=c.id
1 × SELECT *
FROM jml_k2_items
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jml_extensions
1 × SELECT extension, file, type
FROM jml_rokcommon_configs
1 × SELECT b.id
FROM jml_usergroups AS a
LEFT JOIN jml_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `jml_viewlevels
1 × SELECT `session_id`
FROM `jml_session`
1 × 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 jml_menu AS m
LEFT JOIN jml_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params
FROM jml_template_styles as s
LEFT JOIN jml_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `data`
FROM `jml_session`
1 × SELECT *
FROM jml_k2_categories
1 × SELECT id
FROM jml_k2_categories
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jml_assets`
1 × SELECT *
FROM jml_languages
1 × SELECT extraFieldsGroup
FROM jml_k2_categories