Read more: Kick-off ceremony for Caring and Blessing
.JPG) |
The Joint Thanksgiving Banquet was held on June 21. The 17 tables were filled by chaplains, chaplaincy committee members, directors of AHKHCCM as well as senior executives from hospitals. We were honored to have Dr. Joseph Lui (CCE of Kowloon East) presenting certificates to our registered chaplains. In addition, CPE certificates were presented by Dr. Raymond C.I.Chen (Consultant for Professional Development, AHKHCCM), Dr Felix HW Chan, JP (HK West Cluster Service Director forPrimary & Community Health care) and Dr Steve C K Chan (New Territories West Cluster General Manager forAdministrative Services) respectively. Rev. P K Li, Consultant of AHKHCCM presented certificate to Grace Leung, Clinical Pastoral Education Supervisor, AHKHCCM.
|
Read more: Joint Thanksgiving Banquet
.jpg) |
The 9th Chaplains’ Day was smoothly held at Tsimshatsui Baptist Church on June 21, 2013. There were over 100 chaplains participating this year. Dr. Philemon Y.W. Choi spoke on the topic “Setting the boundary for chaplains?”. Group discussions were followed addressing the role and functional boundary for chaplains.
|
Read more: The 9th Chaplains’Day
.JPG) |
The 6th Hospital Pastoral Day for Seminary Students was successfully held on January 25, 2012 at Yan Fook Church of EFCC. The event was co-organized by 14 seminary schools with over 200 students participated. Rev. Luke Cheung (Dean of China Graduate School of Theology) was invited to speak on the topic “Who needs a physician? ”. In addition, eight workshops were held by chaplains who shared their clinical experience with seminary students.
|
Read more: The 6th Pastoral Day for Seminarians
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1618332011,
"last": 1618332011,
"now": 1618332011
},
"client": {
"forwarded": "3.227.235.183"
},
"token": "Xfi7dJfiRZc1F7bnlZ5v8ClwMwLAAaJq"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
8.95 MB (9,388,264 Bytes) 45 Queries Logged 665.63 msQuery Time: 0.57 ms Query memory: 0.019 MB Memory before query: 1.515 MB Rows returned: 0 SELECT `data`
FROM `en2012_session`
WHERE `session_id` = '3pb0n7m0q525bhqfmtnjv8cg01' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.12 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.08 ms | | Preparing | 0.02 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 | | 14 | JSessionStorageDatabase->read() | Same as call in the line below. | | 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 | | 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 | | 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 | | 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 | | 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 | | 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 | | 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 | | 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:764 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:144 | | 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:352 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.44 ms After last query: 0.80 ms Query memory: 0.011 MB Memory before query: 1.569 MB Rows returned: 0 SELECT `session_id`
FROM `en2012_session`
WHERE `session_id` = '3pb0n7m0q525bhqfmtnjv8cg01'
LIMIT 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| Starting | 0.07 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 | | 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:161 | | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:766 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:144 | | 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:352 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 2.23 ms After last query: 0.21 ms Query memory: 0.010 MB Memory before query: 1.586 MB INSERT INTO `en2012_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('3pb0n7m0q525bhqfmtnjv8cg01', 1, '1618332011', 0, '', 0) EXPLAIN not possible on query: INSERT INTO `en2012_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('3pb0n7m0q525bhqfmtnjv8cg01', 1, '1618332011', 0, '', 0) | Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init for update | 0.02 ms | | Update | 0.10 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 1.74 ms | | Closing tables | 0.03 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 | | 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:161 | | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:766 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:144 | | 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:352 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.07 ms After last query: 1.60 ms Query memory: 0.014 MB Memory before query: 1.663 MB Rows returned: 49 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `en2012_extensions`
WHERE `type` = 'component' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_extensions | ref | extension | extension | 82 | const | 49 | 100.00 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.10 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.05 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.52 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 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:423 | | 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:431 | | 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.52 ms After last query: 1.72 ms Query memory: 0.013 MB Memory before query: 1.782 MB Rows returned: 3 SELECT id, rules
FROM `en2012_viewlevels` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.62 ms After last query: 0.21 ms Query memory: 0.014 MB Memory before query: 1.805 MB Rows returned: 1 SELECT b.id
FROM en2012_usergroups AS a
LEFT JOIN en2012_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | | | 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.06 ms | | Preparing | 0.02 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.30 ms After last query: 0.50 ms Query memory: 0.013 MB Memory before query: 1.843 MB Rows returned: 198 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM en2012_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_extensions | ref | extension | extension | 82 | const | 217 | 100.00 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.11 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.05 ms | | Preparing | 0.04 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 1.63 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.02 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.02 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.50 ms After last query: 39.44 ms Query memory: 0.013 MB Memory before query: 3.164 MB Rows returned: 1 SELECT count(*)
FROM `en2012_cwgears_schedule` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Select tables optimized away |
| Status | Duration |
|---|
| Starting | 0.13 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.02 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.02 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.02 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:85 | | 9 | plgSystemCwgears->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:632 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.49 ms After last query: 0.19 ms Query memory: 0.013 MB Memory before query: 3.179 MB Rows returned: 1 SELECT count(*)
FROM `en2012_cwgears_schedule`
WHERE time + '86400'<'1618332011' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:128 | | 9 | plgSystemCwgears->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:632 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.50 ms After last query: 0.19 ms Query memory: 0.013 MB Memory before query: 3.193 MB Rows returned: 1 SELECT count(1)
FROM `en2012_session`
WHERE `session_id` = ''
AND client_id = 1
AND guest = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.03 ms | | Statistics | 0.05 ms | | Preparing | 0.02 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/arktypography/arktypography.php:53 | | 9 | plgSystemARKtypography->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:632 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.76 ms After last query: 33.38 ms Query memory: 0.023 MB Memory before query: 3.763 MB Rows returned: 53 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 en2012_menu AS m
LEFT JOIN en2012_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 57 | 100.00 | Using index condition; Using where; Using filesort | | 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.18 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.02 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.06 ms | | Preparing | 0.04 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 1.02 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 | | 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. | | 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 | | 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 | | 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 | | 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 | | 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:383 | | 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:497 | | 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:1079 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 8.94 ms Query memory: 0.023 MB Memory before query: 4.286 MB Rows returned: 1 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `en2012_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.10 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.07 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 | | 19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 | | 18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. | | 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 | | 15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 | | 14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 | | 13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 | | 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/routerreplacer/routerreplacer.php:88 | | 9 | plgSystemRouterReplacer->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 19.98 ms After last query: 0.47 ms Query memory: 0.018 MB Memory before query: 4.294 MB UPDATE `en2012_extensions`
SET `params` = '{\"mediaversion\":\"9b270fa316622b10f95639b57db7ca33\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init for update | 0.07 ms | | Updating | 0.08 ms | | End of update loop | 0.02 ms | | Query end | 0.02 ms | | Commit | 19.42 ms | | Closing tables | 0.04 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 | | 14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 | | 13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 | | 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/routerreplacer/routerreplacer.php:88 | | 9 | plgSystemRouterReplacer->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.90 ms After last query: 1.46 ms Query memory: 0.014 MB Memory before query: 4.377 MB Rows returned: 7 SELECT id, home, template, s.params
FROM en2012_template_styles as s
LEFT JOIN en2012_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 100.00 | Using where | | 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | hospwxsg_engweb2018.s.template,const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.07 ms | | Preparing | 0.04 ms | | Executing | 0.01 ms | | Sending data | 0.28 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 | | 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/routerreplacer/routerreplacer.php:89 | | 9 | plgSystemRouterReplacer->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.44 ms After last query: 2.16 ms Query memory: 0.013 MB Memory before query: 4.412 MB Rows returned: 0 SELECT ip
FROM `en2012_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 | | 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:131 | | 9 | plgSystemCwtrafficCount->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.43 ms After last query: 0.19 ms Query memory: 0.013 MB Memory before query: 4.426 MB Rows returned: 0 SELECT botname
FROM `en2012_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.07 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 | | 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:161 | | 9 | plgSystemCwtrafficCount->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 0.25 ms Query memory: 0.013 MB Memory before query: 4.441 MB Rows returned: 1 SELECT count(*)
FROM `en2012_cwtraffic`
WHERE iphash = UNHEX(SHA1('3.227.235.183'))
AND tm + '3600'>'1618332011' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_cwtraffic | ref | idx_iphash,idx_iphashtm | idx_iphashtm | 20 | const | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.02 ms | | Statistics | 0.08 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:217 | | 9 | plgSystemCwtrafficCount->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 67.70 ms After last query: 3.42 ms Query memory: 0.014 MB Memory before query: 5.273 MB Rows returned: 507 SELECT id, ip
FROM `en2012_cwtraffic`
WHERE country_code = "" OR country_code is null | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_cwtraffic | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 166056 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 67.07 ms | | End of update loop | 0.06 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.07 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:64 | | 10 | CoalawebtrafficHelperLocation::location_update() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:288 | | 9 | plgSystemCwtrafficCount->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 543.26 ms After last query: 34.92 ms Query memory: 0.013 MB Memory before query: 5.343 MB UPDATE en2012_cwtraffic
SET city = NULL
WHERE city = "" | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_cwtraffic | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 166056 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init for update | 0.04 ms | | Updating | 542.70 ms | | End of update loop | 0.07 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.02 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.07 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:105 | | 10 | CoalawebtrafficHelperLocation::location_update() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:288 | | 9 | plgSystemCwtrafficCount->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.63 ms After last query: 0.80 ms Query memory: 0.014 MB Memory before query: 5.361 MB Rows returned: 1 SELECT count(*)
FROM `en2012_extensions`
WHERE `element` = 'cwgears'
AND `extension_id` = '' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.12 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.06 ms | | Preparing | 0.02 ms | | Executing | 0.03 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.02 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.02 ms | | Freeing items | 0.08 ms | | Updating status | 0.03 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 11 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:971 | | 10 | plgSystemCwgears->updateDownloadKeySub() | JROOT/plugins/system/cwgears/cwgears.php:188 | | 9 | plgSystemCwgears->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.58 ms After last query: 0.20 ms Query memory: 0.013 MB Memory before query: 5.376 MB Rows returned: 1 SELECT params
FROM `en2012_extensions`
WHERE `element` = 'com_arkeditor'
AND `type` = 'component' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.02 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.07 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.05 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/arktypography/arktypography.php:127 | | 9 | plgSystemARKtypography->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:1089 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.65 ms After last query: 1.11 ms Query memory: 0.009 MB Memory before query: 5.410 MB Rows returned: 1 SELECT *
FROM en2012_languages
WHERE published=1
ORDER BY ordering ASC | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.07 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 0.17 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 | | 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 | | 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 | | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.56 ms After last query: 4.99 ms Query memory: 0.025 MB Memory before query: 5.742 MB Rows returned: 48 SELECT `id`,`name`,`rules`,`parent_id`
FROM `en2012_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_arkeditor','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_fpss','com_fwgallery','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_jsecure','com_languages','com_login','com_m2c','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ngmenu','com_ose_firewall','com_pagebuilderck','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_responsivizer','com_search','com_swmenufree','com_tags','com_templates','com_users','com_webfonts','com_weblinks','com_wrapper') | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_assets | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 21.59 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.08 ms | | Optimizing | 0.02 ms | | Statistics | 0.18 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.82 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | | 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.97 ms After last query: 0.52 ms Query memory: 0.025 MB Memory before query: 5.842 MB Rows returned: 136 SELECT `id`,`name`,`rules`,`parent_id`
FROM `en2012_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.17 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.34 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 | | 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.59 ms After last query: 2.34 ms Query memory: 0.021 MB Memory before query: 6.095 MB Rows returned: 3 SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `en2012_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `en2012_categories` AS `s`
INNER JOIN `en2012_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 20
ORDER BY c.lft | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | | | 1 | PRIMARY | c | ALL | cat_idx,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 29 | 68.97 | Using where; Using filesort | | 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | hospwxsg_engweb2018.c.id | 2 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.19 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.05 ms | | After opening tables | 0.02 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.07 ms | | Optimizing | 0.04 ms | | Statistics | 1.00 ms | | Preparing | 0.05 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.15 ms | | Preparing | 0.05 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 0.13 ms | | Executing | 0.02 ms | | Sending data | 0.10 ms | | Executing | 0.02 ms | | Sending data | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.16 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.02 ms | | Freeing items | 0.01 ms | | Removing tmp table | 0.02 ms | | Freeing items | 0.08 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 | | 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 | | 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 | | 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.57 ms After last query: 2.14 ms Query memory: 0.022 MB Memory before query: 6.215 MB Rows returned: 5 SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM en2012_content AS a
LEFT JOIN en2012_categories AS c
ON c.id = a.catid
LEFT JOIN en2012_users AS ua
ON ua.id = a.created_by
LEFT JOIN en2012_users AS uam
ON uam.id = a.modified_by
LEFT JOIN en2012_categories as parent
ON parent.id = c.parent_id
LEFT JOIN en2012_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 20
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-13 16:40:12')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-13 16:40:12')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 9 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | | | 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 5 | 100.00 | Using where; Using filesort | | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.created_by | 1 | 100.00 | Using where | | 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.modified_by | 1 | 100.00 | Using where | | 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where | | 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.25 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.06 ms | | After opening tables | 0.02 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.09 ms | | Optimizing | 0.06 ms | | Statistics | 0.18 ms | | Preparing | 0.02 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.05 ms | | Sorting result | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | Creating sort index | 0.39 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.05 ms | | Starting cleanup | 0.02 ms | | Freeing items | 0.07 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:559 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.91 ms After last query: 1.15 ms Query memory: 0.021 MB Memory before query: 6.340 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `en2012_contentitem_tag_map` AS m
INNER JOIN `en2012_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 79
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hospwxsg_engweb2018.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.02 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.04 ms | | Optimizing | 0.03 ms | | Statistics | 0.22 ms | | Preparing | 0.04 ms | | Executing | 0.01 ms | | Sending data | 0.14 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.07 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 0.46 ms Query memory: 0.021 MB Memory before query: 6.378 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `en2012_contentitem_tag_map` AS m
INNER JOIN `en2012_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 78
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hospwxsg_engweb2018.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.04 ms | | Optimizing | 0.03 ms | | Statistics | 0.06 ms | | Preparing | 0.04 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.02 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.60 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 6.416 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `en2012_contentitem_tag_map` AS m
INNER JOIN `en2012_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 77
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hospwxsg_engweb2018.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.04 ms | | Optimizing | 0.03 ms | | Statistics | 0.05 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.02 ms | | Query end | 0.02 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.07 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 0.45 ms Query memory: 0.021 MB Memory before query: 6.454 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `en2012_contentitem_tag_map` AS m
INNER JOIN `en2012_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 76
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hospwxsg_engweb2018.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.04 ms | | Optimizing | 0.03 ms | | Statistics | 0.05 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.05 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.65 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 6.492 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `en2012_contentitem_tag_map` AS m
INNER JOIN `en2012_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 54
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hospwxsg_engweb2018.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.04 ms | | Optimizing | 0.03 ms | | Statistics | 0.05 ms | | Preparing | 0.06 ms | | Executing | 0.02 ms | | Sending data | 0.06 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.77 ms After last query: 0.63 ms Query memory: 0.022 MB Memory before query: 6.527 MB Rows returned: 1 SELECT COUNT(*)
FROM en2012_content AS a
LEFT JOIN en2012_categories AS c
ON c.id = a.catid
LEFT JOIN en2012_users AS ua
ON ua.id = a.created_by
LEFT JOIN en2012_users AS uam
ON uam.id = a.modified_by
LEFT JOIN en2012_categories as parent
ON parent.id = c.parent_id
LEFT JOIN en2012_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 20
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-13 16:40:12')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-13 16:40:12') | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | | | 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 5 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.02 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.04 ms | | Optimizing | 0.05 ms | | Statistics | 0.10 ms | | Preparing | 0.02 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.04 ms | | Executing | 0.01 ms | | Sending data | 0.07 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 | | 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 | | 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 0.44 ms Query memory: 0.018 MB Memory before query: 6.538 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `en2012_contentitem_tag_map` AS m
INNER JOIN `en2012_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 20
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hospwxsg_engweb2018.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.04 ms | | Optimizing | 0.03 ms | | Statistics | 0.05 ms | | Preparing | 0.04 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.93 ms After last query: 4.68 ms Query memory: 0.026 MB Memory before query: 6.793 MB Rows returned: 3 SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `en2012_categories` AS `s`
INNER JOIN `en2012_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 20
ORDER BY c.lft | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | | | 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 29 | 68.97 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.14 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.05 ms | | Optimizing | 0.04 ms | | Statistics | 0.16 ms | | Preparing | 0.02 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.04 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 0.11 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.02 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 | | 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 | | 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 | | 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 | | 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | | 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:427 | | 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. | | 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.09 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 6.839 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 en2012_fields AS a
LEFT JOIN `en2012_languages` AS l
ON l.lang_code = a.language
LEFT JOIN en2012_users AS uc
ON uc.id=a.checked_out
LEFT JOIN en2012_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN en2012_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN en2012_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `en2012_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (20,0,9))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using filesort | | 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | hospwxsg_engweb2018.a.language | 1 | 100.00 | Using where | | 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.checked_out | 1 | 100.00 | | | 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.access | 1 | 100.00 | Using where | | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.created_user_id | 1 | 100.00 | Using where | | 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.group_id | 1 | 100.00 | Using where | | 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.16 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.06 ms | | After opening tables | 0.02 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.06 ms | | Optimizing | 0.05 ms | | Statistics | 0.30 ms | | Preparing | 0.06 ms | | Sorting result | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 0.04 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 | | 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 | | 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | | 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:427 | | 14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. | | 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 | | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 | | 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:204 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.31 ms After last query: 17.02 ms Query memory: 0.019 MB Memory before query: 7.299 MB Rows returned: 3 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM en2012_modules AS m
LEFT JOIN en2012_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN en2012_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 <= '2021-04-13 16:40:12')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-13 16:40:12')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 148 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 15 | 100.00 | Using index condition; Using where; Using filesort | | 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | hospwxsg_engweb2018.m.id | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | hospwxsg_engweb2018.m.module,const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.14 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.02 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.05 ms | | Optimizing | 0.05 ms | | Statistics | 0.19 ms | | Preparing | 0.06 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 0.43 ms | | End of update loop | 0.02 ms | | Query end | 0.02 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.07 ms | | Updating status | 0.03 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 15 | JDatabaseDriver->loadObjectList() | Same as call in the line below. | | 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 | | 12 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 | | 11 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | | 10 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 | | 9 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/ahkhccm_oct2012_eng/classes/ArtxPage.php:42 | | 8 | ArtxPage->containsModules() | JROOT/templates/ahkhccm_oct2012_eng/index.php:89 | | 7 | require JROOT/templates/ahkhccm_oct2012_eng/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:1036 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.48 ms After last query: 14.38 ms Query memory: 0.019 MB Memory before query: 7.751 MB Rows returned: 0 SELECT uikit
FROM `en2012_cwgears`
WHERE url = 'https://www.hospitalchap.org.hk/en/index.php?option=com_content&view=category&layout=blog&id=20&Itemid=148' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.11 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/helpers/loadcount.php:65 | | 14 | CwGearsHelperLoadcount::getCounts() | JROOT/plugins/system/cwgears/cwgears.php:398 | | 13 | plgSystemCwgears->onBeforeCompileHead() | Same as call in the line below. | | 12 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 | | 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 | | 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 | | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 | | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 | | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.40 ms After last query: 0.22 ms Query memory: 0.019 MB Memory before query: 7.772 MB Rows returned: 0 SELECT uikit_plus
FROM `en2012_cwgears`
WHERE url = 'https://www.hospitalchap.org.hk/en/index.php?option=com_content&view=category&layout=blog&id=20&Itemid=148' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.07 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/helpers/loadcount.php:65 | | 14 | CwGearsHelperLoadcount::getCounts() | JROOT/plugins/system/cwgears/cwgears.php:407 | | 13 | plgSystemCwgears->onBeforeCompileHead() | Same as call in the line below. | | 12 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 | | 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 | | 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 | | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 | | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 | | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.50 ms After last query: 0.89 ms Query memory: 0.022 MB Memory before query: 7.839 MB Rows returned: 0 SELECT f.id,f.family, m.id AS `mutantId`, m.mutant, m.type, m.inUse
FROM `en2012_webfonts_google` AS f
INNER JOIN `en2012_webfonts_google_mutant` AS m
ON(f.id = m.fk_fontId)
WHERE `inUse` = '1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.11 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.02 ms | | Init | 0.03 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_webfonts/models/google.php:220 | | 16 | WebfontsModelGoogle->getSelectedFonts() | JROOT/plugins/system/webfonts/handlers/google.php:24 | | 15 | PluginWebfontsGoogle->onBeforeCompileHead() | JROOT/plugins/system/webfonts/webfonts.php:44 | | 14 | plgSystemWebfonts->_fireActive() | JROOT/plugins/system/webfonts/webfonts.php:29 | | 13 | plgSystemWebfonts->onBeforeCompileHead() | Same as call in the line below. | | 12 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 | | 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 | | 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 | | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 | | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 | | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.46 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 7.860 MB Rows returned: 1 SELECT properties
FROM en2012_webfonts_vendor
WHERE `name` = 'Fonts.com' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_webfonts_vendor | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 18 | JDatabaseDriver->loadResult() | JROOT/plugins/system/webfonts/handlers/fontscom.php:46 | | 17 | PluginWebfontsFontscom->_getProjectKey() | JROOT/plugins/system/webfonts/handlers/fontscom.php:36 | | 16 | PluginWebfontsFontscom->_loadActiveProjectKey() | JROOT/plugins/system/webfonts/handlers/fontscom.php:21 | | 15 | PluginWebfontsFontscom->onBeforeCompileHead() | JROOT/plugins/system/webfonts/webfonts.php:44 | | 14 | plgSystemWebfonts->_fireActive() | JROOT/plugins/system/webfonts/webfonts.php:29 | | 13 | plgSystemWebfonts->onBeforeCompileHead() | Same as call in the line below. | | 12 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 | | 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 | | 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 | | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 | | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 | | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.46 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 7.882 MB Rows returned: 0 SELECT `fallBack`, `selector`, `family`
FROM en2012_webfonts AS f
INNER JOIN en2012_webfonts_fontscom AS w
ON (f.fontId = w.FontID)
WHERE w.ProjectID = '' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/webfonts/handlers/fontscom.php:70 | | 17 | PluginWebfontsFontscom->_getProjectFallbacks() | JROOT/plugins/system/webfonts/handlers/fontscom.php:62 | | 16 | PluginWebfontsFontscom->_insertFallbackDeclarations() | JROOT/plugins/system/webfonts/handlers/fontscom.php:22 | | 15 | PluginWebfontsFontscom->onBeforeCompileHead() | JROOT/plugins/system/webfonts/webfonts.php:44 | | 14 | plgSystemWebfonts->_fireActive() | JROOT/plugins/system/webfonts/webfonts.php:29 | | 13 | plgSystemWebfonts->onBeforeCompileHead() | Same as call in the line below. | | 12 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 | | 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 | | 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 | | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 | | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 | | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 0.92 ms Query memory: 0.015 MB Memory before query: 7.970 MB Rows returned: 0 SELECT `selector`, `fallBack`,`family`,`mutant`
FROM `en2012_webfonts` AS wf
INNER JOIN `en2012_webfonts_google_mutant` AS m
ON(wf.fontId = m.id)
INNER JOIN `en2012_webfonts_google` AS g
ON(m.fk_fontId = g.id)
WHERE `vendor` = 'google'
AND `inUse` = '1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.09 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/webfonts/handlers/google.php:56 | | 11 | PluginWebfontsGoogle->_getGoogleSelectorsWithFontInfo() | JROOT/plugins/system/webfonts/handlers/google.php:33 | | 10 | PluginWebfontsGoogle->onAfterRender() | JROOT/plugins/system/webfonts/webfonts.php:44 | | 9 | plgSystemWebfonts->_fireActive() | JROOT/plugins/system/webfonts/webfonts.php:34 | | 8 | plgSystemWebfonts->onAfterRender() | Same as call in the line below. | | 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1056 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.44 ms After last query: 0.12 ms Query memory: 0.017 MB Memory before query: 7.984 MB Rows returned: 1 SELECT properties
FROM en2012_webfonts_vendor
WHERE `name` = 'Fonts.com' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_webfonts_vendor | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.05 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 13 | JDatabaseDriver->loadResult() | JROOT/plugins/system/webfonts/handlers/fontscom.php:46 | | 12 | PluginWebfontsFontscom->_getProjectKey() | JROOT/plugins/system/webfonts/handlers/fontscom.php:36 | | 11 | PluginWebfontsFontscom->_loadActiveProjectKey() | JROOT/plugins/system/webfonts/handlers/fontscom.php:27 | | 10 | PluginWebfontsFontscom->onAfterRender() | JROOT/plugins/system/webfonts/webfonts.php:44 | | 9 | plgSystemWebfonts->_fireActive() | JROOT/plugins/system/webfonts/webfonts.php:34 | | 8 | plgSystemWebfonts->onAfterRender() | Same as call in the line below. | | 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1056 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.45 ms After last query: 0.16 ms Query memory: 0.015 MB Memory before query: 8.003 MB Rows returned: 0 SELECT `selector`, `fallBack`,`family`,`mutant`
FROM `en2012_webfonts` AS wf
INNER JOIN `en2012_webfonts_google_mutant` AS m
ON(wf.fontId = m.id)
INNER JOIN `en2012_webfonts_google` AS g
ON(m.fk_fontId = g.id)
WHERE `vendor` = 'google'
AND `inUse` = '1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.08 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/webfonts/handlers/google.php:56 | | 11 | PluginWebfontsGoogle->_getGoogleSelectorsWithFontInfo() | JROOT/plugins/system/webfonts/handlers/google.php:33 | | 10 | PluginWebfontsGoogle->onAfterRender() | JROOT/plugins/system/webfonts/webfonts.php:44 | | 9 | plgSystemWebfonts->_fireActive() | JROOT/plugins/system/webfonts/webfonts.php:34 | | 8 | plgSystemWebfonts->onAfterRender() | Same as call in the line below. | | 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1056 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.44 ms After last query: 0.11 ms Query memory: 0.017 MB Memory before query: 8.017 MB Rows returned: 1 SELECT properties
FROM en2012_webfonts_vendor
WHERE `name` = 'Fonts.com' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | en2012_webfonts_vendor | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms | | Checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | Table lock | 0.01 ms | | Init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | Closing tables | 0.02 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.06 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 13 | JDatabaseDriver->loadResult() | JROOT/plugins/system/webfonts/handlers/fontscom.php:46 | | 12 | PluginWebfontsFontscom->_getProjectKey() | JROOT/plugins/system/webfonts/handlers/fontscom.php:36 | | 11 | PluginWebfontsFontscom->_loadActiveProjectKey() | JROOT/plugins/system/webfonts/handlers/fontscom.php:27 | | 10 | PluginWebfontsFontscom->onAfterRender() | JROOT/plugins/system/webfonts/webfonts.php:44 | | 9 | plgSystemWebfonts->_fireActive() | JROOT/plugins/system/webfonts/webfonts.php:34 | | 8 | plgSystemWebfonts->onAfterRender() | Same as call in the line below. | | 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 | | 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1056 | | 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:210 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
35 Query Types Logged, Sorted by Occurrences.SELECT Tables:6 × SELECT `m`.`tag_id`,`t`.*
FROM `en2012_contentitem_tag_map` AS m
INNER JOIN `en2012_tags` AS t
ON `m`.`tag_id` = `t`.`id` 3 × SELECT properties
FROM en2012_webfonts_vendor 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `en2012_extensions` 2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `en2012_assets` 2 × SELECT `selector`, `fallBack`,`family`,`mutant`
FROM `en2012_webfonts` AS wf
INNER JOIN `en2012_webfonts_google_mutant` AS m
ON(wf.fontId = m.id)
INNER JOIN `en2012_webfonts_google` AS g
ON(m.fk_fontId = g.id) 1 × SELECT COUNT(*)
FROM en2012_content AS a
LEFT JOIN en2012_categories AS c
ON c.id = a.catid
LEFT JOIN en2012_users AS ua
ON ua.id = a.created_by
LEFT JOIN en2012_users AS uam
ON uam.id = a.modified_by
LEFT JOIN en2012_categories as parent
ON parent.id = c.parent_id
LEFT JOIN en2012_content_rating AS v
ON a.id = v.content_id 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `en2012_content` AS `i` 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `en2012_categories` AS `s`
INNER JOIN `en2012_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt) 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM en2012_content AS a
LEFT JOIN en2012_categories AS c
ON c.id = a.catid
LEFT JOIN en2012_users AS ua
ON ua.id = a.created_by
LEFT JOIN en2012_users AS uam
ON uam.id = a.modified_by
LEFT JOIN en2012_categories as parent
ON parent.id = c.parent_id
LEFT JOIN en2012_content_rating AS v
ON a.id = v.content_id 1 × SELECT uikit
FROM `en2012_cwgears` 1 × SELECT f.id,f.family, m.id AS `mutantId`, m.mutant, m.type, m.inUse
FROM `en2012_webfonts_google` AS f
INNER JOIN `en2012_webfonts_google_mutant` AS m
ON(f.id = m.fk_fontId) 1 × SELECT `fallBack`, `selector`, `family`
FROM en2012_webfonts AS f
INNER JOIN en2012_webfonts_fontscom AS w
ON (f.fontId = w.FontID) 1 × SELECT uikit_plus
FROM `en2012_cwgears` 1 × SELECT *
FROM en2012_languages 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM en2012_modules AS m
LEFT JOIN en2012_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN en2012_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id 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 en2012_fields AS a
LEFT JOIN `en2012_languages` AS l
ON l.lang_code = a.language
LEFT JOIN en2012_users AS uc
ON uc.id=a.checked_out
LEFT JOIN en2012_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN en2012_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN en2012_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `en2012_fields_categories` AS fc
ON fc.field_id = a.id 1 × SELECT count(*)
FROM `en2012_extensions` 1 × SELECT count(*)
FROM `en2012_cwgears_schedule 1 × SELECT count(*)
FROM `en2012_cwgears_schedule` 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM en2012_extensions 1 × SELECT b.id
FROM en2012_usergroups AS a
LEFT JOIN en2012_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt 1 × SELECT `session_id`
FROM `en2012_session` 1 × SELECT id, rules
FROM `en2012_viewlevels 1 × SELECT count(1)
FROM `en2012_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 en2012_menu AS m
LEFT JOIN en2012_extensions AS e
ON m.component_id = e.extension_id 1 × SELECT id, ip
FROM `en2012_cwtraffic` 1 × SELECT `data`
FROM `en2012_session` 1 × SELECT count(*)
FROM `en2012_cwtraffic` 1 × SELECT botname
FROM `en2012_cwtraffic_knownips` 1 × SELECT id, home, template, s.params
FROM en2012_template_styles as s
LEFT JOIN en2012_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id 1 × SELECT ip
FROM `en2012_cwtraffic_knownips` 1 × SELECT params
FROM `en2012_extensions`
OTHER Tables:1 × UPDATE en2012_cwtraffic
SET city = NULL 1 × UPDATE `en2012_extensions`
SET `params` = '{\"mediaversion\":\"9b270fa316622b10f95639b57db7ca33\"}' 1 × INSERT INTO `en2012_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('3pb0n7m0q525bhqfmtnjv8cg01', 1, '1618332011', 0, '', 0
| | | |
.JPG)
.JPG)