Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1726764510,
"last": 1726764510,
"now": 1726764510
}
},
"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": [
"13"
],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 8.09 ms / 8.09 ms Memory: 0.579 MB / 0.81 MB Application: afterLoad
Time: 109.96 ms / 118.05 ms Memory: 6.957 MB / 7.77 MB Application: afterInitialise
Time: 31.78 ms / 149.83 ms Memory: 3.440 MB / 11.21 MB Application: afterRoute
Time: 1.39 ms / 151.22 ms Memory: 0.080 MB / 11.29 MB Application: beforeRenderComponent com_content
Time: 252.42 ms / 403.64 ms Memory: 4.992 MB / 16.28 MB Application: afterRenderComponent com_content
Time: 23.10 ms / 426.74 ms Memory: 1.084 MB / 17.36 MB Application: afterDispatch
Time: 10.31 ms / 437.05 ms Memory: 0.565 MB / 17.93 MB Application: beforeRenderModule mod_custom (Logo)
Time: 1.50 ms / 438.55 ms Memory: 0.040 MB / 17.97 MB Application: afterRenderModule mod_custom (Logo)
Time: 0.26 ms / 438.81 ms Memory: 0.023 MB / 17.99 MB Application: beforeRenderModule mod_social_slider (Tautan Sosial Media)
Time: 1.26 ms / 440.06 ms Memory: 0.074 MB / 18.06 MB Application: afterRenderModule mod_social_slider (Tautan Sosial Media)
Time: 1.50 ms / 441.56 ms Memory: 0.000 MB / 18.03 MB Application: beforeRenderModule mod_search (Search)
Time: 1.65 ms / 443.21 ms Memory: 0.040 MB / 18.07 MB Application: afterRenderModule mod_search (Search)
Time: 1.24 ms / 444.44 ms Memory: 0.000 MB / 18.07 MB Application: beforeRenderModule mod_menu (Menu Utama)
Time: 45.99 ms / 490.43 ms Memory: 0.543 MB / 18.61 MB Application: afterRenderModule mod_menu (Menu Utama)
Time: 16.67 ms / 507.10 ms Memory: 0.251 MB / 18.86 MB Application: beforeRenderModule mod_custom (Selamat datang)
Time: 0.61 ms / 507.71 ms Memory: 0.007 MB / 18.87 MB Application: afterRenderModule mod_custom (Selamat datang)
Time: 0.95 ms / 508.66 ms Memory: 0.003 MB / 18.87 MB Application: beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs)
Time: 1.36 ms / 510.02 ms Memory: 0.037 MB / 18.91 MB Application: afterRenderModule mod_breadcrumbs_adv (Breadcrumbs)
Time: 1.34 ms / 511.37 ms Memory: 0.000 MB / 18.90 MB Application: beforeRenderModule mod_custom (Jam Kerja)
Time: 0.58 ms / 511.94 ms Memory: 0.007 MB / 18.91 MB Application: afterRenderModule mod_custom (Jam Kerja)
Time: 0.08 ms / 512.03 ms Memory: 0.000 MB / 18.91 MB Application: beforeRenderModule mod_custom (Lapor)
Time: 0.57 ms / 512.60 ms Memory: 0.007 MB / 18.92 MB Application: afterRenderModule mod_custom (Lapor)
Time: 0.09 ms / 512.68 ms Memory: 0.000 MB / 18.92 MB Application: beforeRenderModule mod_custom (Agenda Kegiatan)
Time: 0.94 ms / 513.63 ms Memory: 0.007 MB / 18.92 MB Application: afterRenderModule mod_custom (Agenda Kegiatan)
Time: 0.77 ms / 514.39 ms Memory: 0.078 MB / 19.00 MB Application: beforeRenderModule mod_zt_visitor_counter (Statistik Web)
Time: 317.71 ms / 832.10 ms Memory: 0.231 MB / 19.23 MB Application: afterRenderModule mod_zt_visitor_counter (Statistik Web)
Time: 0.14 ms / 832.24 ms Memory: 0.000 MB / 19.22 MB Application: beforeRenderModule mod_custom (Survey Kepuasan Publik dan Persepsi Korupsi)
Time: 0.64 ms / 832.88 ms Memory: 0.007 MB / 19.22 MB Application: afterRenderModule mod_custom (Survey Kepuasan Publik dan Persepsi Korupsi)
Time: 3.25 ms / 836.12 ms Memory: 0.015 MB / 19.24 MB Application: beforeRenderModule mod_custom (Hubungi Kami)
Time: 9.46 ms / 845.58 ms Memory: 0.934 MB / 20.17 MB Application: afterRenderModule mod_custom (Hubungi Kami)
Time: 0.17 ms / 845.75 ms Memory: 0.000 MB / 20.17 MB Application: beforeRenderModule mod_custom (Tautan Web)
Time: 1.40 ms / 847.15 ms Memory: 0.007 MB / 20.18 MB Application: afterRenderModule mod_custom (Tautan Web)
Time: 0.15 ms / 847.30 ms Memory: 0.000 MB / 20.18 MB Application: beforeRenderModule mod_custom (Info Perkara Wil. Kedu)
Time: 1.25 ms / 848.55 ms Memory: 0.007 MB / 20.19 MB Application: afterRenderModule mod_custom (Info Perkara Wil. Kedu)
Time: 3.61 ms / 852.16 ms Memory: 0.000 MB / 20.18 MB Application: beforeRenderModule mod_custom (Copyright)
Time: 1.15 ms / 853.32 ms Memory: 0.007 MB / 20.19 MB Application: afterRenderModule mod_custom (Copyright)
Time: 1.63 ms / 854.95 ms Memory: 0.000 MB / 20.19 MB Application: beforeRenderModule mod_custom (W3C HTML)
Time: 0.83 ms / 855.78 ms Memory: 0.007 MB / 20.20 MB Application: afterRenderModule mod_custom (W3C HTML)
Time: 1.43 ms / 857.20 ms Memory: 0.000 MB / 20.20 MB Application: beforeRenderModule mod_whatshelp (Chat Button by GetButton.io (ex. WhatsHelp))
Time: 0.51 ms / 857.71 ms Memory: 0.008 MB / 20.20 MB Application: afterRenderModule mod_whatshelp (Chat Button by GetButton.io (ex. WhatsHelp))
Time: 446.51 ms / 1304.22 ms Memory: 0.212 MB / 20.42 MB Application: afterRender
Database queries total: 480.20 ms
21.73 MB (22,782,944 Bytes)
55 Queries Logged 480.20 ms
- Query Time: 1.16 ms Query memory: 0.017 MB Memory before query: 2.695 MB Rows returned: 0
SELECT `data`
FROM `ydfui_session`
WHERE `session_id` = 'hpiop6rkurjsb6bknmmvn9c673'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_session const PRIMARY PRIMARY 766 const 1 100.00 Status Duration Starting 0.14 ms Waiting for query cache lock 0.03 ms starting 0.03 ms Checking query cache for query 0.06 ms checking permissions 0.05 ms Opening tables 0.04 ms After opening tables 0.04 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.03 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.09 ms Updating status 0.03 ms Waiting for query cache lock 0.03 ms Updating status 0.06 ms Waiting for query cache lock 0.03 ms Updating status 0.03 ms Storing result in query cache 0.03 ms Reset for next command 0.03 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:258 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:748 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.92 ms After last query: 2.94 ms Query memory: 0.010 MB Memory before query: 2.897 MB Rows returned: 0
SELECT `session_id`
FROM `ydfui_session`
WHERE `session_id` = 'hpiop6rkurjsb6bknmmvn9c673'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_session const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration Starting 0.09 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.09 ms Updating status 0.03 ms Waiting for query cache lock 0.03 ms Updating status 0.04 ms Waiting for query cache lock 0.05 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.03 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 1.07 ms After last query: 0.19 ms Query memory: 0.009 MB Memory before query: 2.910 MB
INSERT INTO `ydfui_session` (`session_id`, `client_id`, `time`)
VALUES ('hpiop6rkurjsb6bknmmvn9c673', 0, '1726764510')EXPLAIN not possible on query: INSERT INTO `ydfui_session` (`session_id`, `client_id`, `time`) VALUES ('hpiop6rkurjsb6bknmmvn9c673', 0, '1726764510')Status Duration Starting 0.15 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init for update 0.04 ms Update 0.13 ms Waiting for query cache lock 0.03 ms Update 0.03 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.18 ms closing tables 0.04 ms Unlocking tables 0.03 ms closing tables 0.04 ms Starting cleanup 0.03 ms Freeing items 0.10 ms Updating status 0.04 ms Reset for next command 0.03 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:208 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 1.29 ms After last query: 4.05 ms Query memory: 0.012 MB Memory before query: 3.281 MB Rows returned: 39
SELECT extension_id AS id, element AS "option", params, enabled
FROM ydfui_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_extensions ref extension extension 82 const 39 100.00 Using index condition Status Duration Starting 0.09 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.32 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.05 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.07 ms Reset for next command 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:584 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 1.65 ms Query memory: 0.012 MB Memory before query: 3.437 MB Rows returned: 2
SELECT b.id
FROM ydfui_usergroups AS a
LEFT JOIN ydfui_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13id 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 2 100.00 Using where; Using index Status Duration Starting 0.11 ms Waiting for query cache lock 0.03 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.03 ms Sending cached result to clien 0.07 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:1541 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:354 8 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:423 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.60 ms Query memory: 0.011 MB Memory before query: 3.493 MB Rows returned: 5
SELECT id, rules
FROM `ydfui_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 Status Duration Starting 0.07 ms Waiting for query cache lock 0.03 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1497 8 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:440 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.50 ms After last query: 0.20 ms Query memory: 0.009 MB Memory before query: 3.512 MB Rows returned: 75
SELECT folder AS type, element AS name, params
FROM ydfui_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 234 40.60 Using where; Using filesort Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.04 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.51 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.05 ms Reset for next command 0.02 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 15.90 ms Query memory: 0.017 MB Memory before query: 4.632 MB Rows returned: 1Duplicate queries: #9
SELECT template
FROM ydfui_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 7 100.00 Using where Status Duration Starting 0.15 ms Waiting for query cache lock 0.03 ms starting 0.03 ms Checking query cache for query 0.03 ms checking privileges on cached 0.03 ms checking permissions 0.03 ms Sending cached result to clien 0.08 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:96 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:54 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 4.651 MB Rows returned: 1Duplicate queries: #8
SELECT template
FROM ydfui_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 7 100.00 Using where Status Duration Starting 0.08 ms Waiting for query cache lock 0.05 ms starting 0.03 ms Checking query cache for query 0.03 ms checking privileges on cached 0.03 ms checking permissions 0.03 ms Sending cached result to clien 0.11 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:96 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:54 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 5.77 ms Query memory: 0.012 MB Memory before query: 4.967 MB Rows returned: 4
SELECT extension, file, type
FROM ydfui_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 Using filesort Status Duration Starting 0.10 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.08 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:1692 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:132 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:76 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.06 ms After last query: 16.29 ms Query memory: 0.014 MB Memory before query: 6.513 MB Rows returned: 1
SELECT timestamp
FROM ydfui_zt_visitor_counter
WHERE ipaddress = '3.238.227.73'
AND useragent LIKE "%other%"
ORDER BY timestamp DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_zt_visitor_counter index NULL timestamp 4 NULL 1 100.00 Using where Status Duration Starting 0.10 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.14 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.05 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 11 JDatabaseDriver->loadResult() JROOT/plugins/system/zt_visitor_counter/helper.php:65 10 plgZTVisitorCounterHelper::getLastVisit() JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42 9 plgSystemZT_Visitor_Counter->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 0.17 ms Query memory: 0.014 MB Memory before query: 6.525 MB
UPDATE ydfui_zt_visitor_counter
SET visits=visits + 1, guests=guests + 1, useragent = 'other'
WHERE timestamp = 1726768463
AND `ipaddress` = '3.238.227.73';id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_zt_visitor_counter range timestamp timestamp 4 NULL 1 100.00 Using where Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init for update 0.05 ms Updating 0.07 ms End of update loop 0.02 ms Waiting for query cache lock 0.02 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.33 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.02 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/database.php:33 11 JDatabase->query() JROOT/plugins/system/zt_visitor_counter/helper.php:43 10 plgZTVisitorCounterHelper::updateVisits() JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:52 9 plgSystemZT_Visitor_Counter->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.30 ms After last query: 2.23 ms Query memory: 0.019 MB Memory before query: 6.802 MB Rows returned: 17
SHOW FULL COLUMNS
FROM `ydfui_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ydfui_extensions`Status Duration Starting 0.10 ms checking permissions 0.02 ms closing tables 0.02 ms Opening tables 0.28 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms checking permissions 0.11 ms closing tables 0.02 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Removing tmp table 0.11 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 12 JTable->__construct() JROOT/libraries/joomla/table/extension.php:30 11 JTableExtension->__construct() JROOT/libraries/joomla/table/table.php:305 10 JTable::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 9 plgSystemRokSprocket->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.91 ms After last query: 0.99 ms Query memory: 0.014 MB Memory before query: 6.884 MB Rows returned: 1
SELECT `extension_id`
FROM `ydfui_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where; Using index Status Duration Starting 0.08 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.03 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 11 JDatabaseDriver->loadResult() JROOT/libraries/joomla/table/extension.php:108 10 JTableExtension->find() JROOT/plugins/system/roksprocket/roksprocket.php:49 9 plgSystemRokSprocket->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.85 ms After last query: 0.19 ms Query memory: 0.014 MB Memory before query: 6.902 MB Rows returned: 1Duplicate queries: #17
SELECT *
FROM ydfui_extensions
WHERE `extension_id` = '10117'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_extensions const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms Waiting for query cache lock 0.03 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.06 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.07 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1456 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:728 10 JTable->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 9 plgSystemRokSprocket->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 0.17 ms Query memory: 0.014 MB Memory before query: 6.916 MB Rows returned: 1
SELECT `extension_id`
FROM `ydfui_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where; Using index Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.06 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 11 JDatabaseDriver->loadResult() JROOT/libraries/joomla/table/extension.php:108 10 JTableExtension->find() JROOT/plugins/system/roksprocket/roksprocket.php:72 9 plgSystemRokSprocket->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.16 ms Query memory: 0.014 MB Memory before query: 6.932 MB Rows returned: 1Duplicate queries: #15
SELECT *
FROM ydfui_extensions
WHERE `extension_id` = '10117'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_extensions const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.05 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:1456 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:728 10 JTable->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 9 plgSystemRokSprocket->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.20 ms After last query: 26.64 ms Query memory: 0.019 MB Memory before query: 8.012 MB Rows returned: 149
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 ydfui_menu AS m
LEFT JOIN ydfui_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.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 325 79.38 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 patp8661_pa_website.m.component_id 1 100.00 Using where Status Duration Starting 0.10 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.42 ms Waiting for query cache lock 0.04 ms Creating sort index 0.16 ms Waiting for query cache lock 0.02 ms Creating sort index 0.12 ms Waiting for query cache lock 0.02 ms Creating sort index 0.10 ms Waiting for query cache lock 0.02 ms Creating sort index 0.13 ms Waiting for query cache lock 0.02 ms Creating sort index 0.11 ms Waiting for query cache lock 0.02 ms Creating sort index 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:86 14 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 13 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 12 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:133 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:435 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:57 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:196 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:531 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1097 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 16.68 ms Query memory: 0.016 MB Memory before query: 10.544 MB Rows returned: 1
SELECT a.rules
FROM ydfui_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.08 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 13 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 12 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:384 11 JUser->authorise() JROOT/plugins/system/sourcerer/helper.php:74 10 PlgSystemSourcererHelper->__construct() JROOT/plugins/system/sourcerer/sourcerer.php:92 9 PlgSystemSourcerer->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 0.75 ms Query memory: 0.018 MB Memory before query: 10.595 MB Rows returned: 1
SELECT b.rules
FROM ydfui_assets AS a
LEFT JOIN ydfui_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 1 100.00 Using where Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 13 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 12 JAccess::check() JROOT/libraries/joomla/user/user.php:393 11 JUser->authorise() JROOT/plugins/system/sourcerer/helper.php:74 10 PlgSystemSourcererHelper->__construct() JROOT/plugins/system/sourcerer/sourcerer.php:92 9 PlgSystemSourcerer->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.86 ms After last query: 1.13 ms Query memory: 0.022 MB Memory before query: 10.695 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM ydfui_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.05 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 18 JDatabaseDriver->loadObject() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 16 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 15 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 14 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 13 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 9 plgSystemJComments->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 0.30 ms Query memory: 0.017 MB Memory before query: 10.702 MB
UPDATE `ydfui_extensions`
SET `params` = '{\"mediaversion\":\"7283d752352914235909de08c9212a58\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_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.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.06 ms Updating 0.07 ms End of update loop 0.02 ms Waiting for query cache lock 0.02 ms End of update loop 0.07 ms Query end 0.02 ms Commit 0.12 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 14 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 13 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 9 plgSystemJComments->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 3.35 ms Query memory: 0.019 MB Memory before query: 11.061 MB Rows returned: 91
SELECT *
FROM `ydfui_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_jcomments_settings ref PRIMARY PRIMARY 214 const,const 91 100.00 Using where Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jcomments/classes/config.php:140 15 JCommentsCfg::_load() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 13 JCacheControllerCallback->get() JROOT/components/com_jcomments/classes/config.php:159 12 JCommentsCfg->load() JROOT/components/com_jcomments/classes/config.php:47 11 JCommentsCfg::getInstance() JROOT/components/com_jcomments/helpers/system.php:39 10 JCommentsSystemPluginHelper::getCSS() JROOT/plugins/system/jcomments/jcomments.php:139 9 plgSystemJComments->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.87 ms After last query: 0.61 ms Query memory: 0.015 MB Memory before query: 11.148 MB Rows returned: 4
SELECT id, home, template, s.params
FROM ydfui_template_styles as s
LEFT JOIN ydfui_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 = 1id 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 7 100.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 patp8661_pa_website.s.template,const 1 4.27 Using index condition; Using where Status Duration Starting 0.05 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 11 JApplicationSite->getTemplate() JROOT/components/com_jcomments/helpers/system.php:46 10 JCommentsSystemPluginHelper::getCSS() JROOT/plugins/system/jcomments/jcomments.php:139 9 plgSystemJComments->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.49 ms Query memory: 0.018 MB Memory before query: 11.189 MB Rows returned: 71
SELECT *
FROM ydfui_rokcandy
WHERE published=1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_rokcandy ALL NULL NO INDEX KEY COULD BE USED NULL NULL 79 100.00 Using where Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 14 RokCandyHelper::getUserMacros() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 12 JCacheControllerCallback->get() JROOT/libraries/joomla/cache/controller/callback.php:41 11 JCacheControllerCallback->call() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 10 RokCandyHelper::getMacros() JROOT/plugins/system/rokcandy/rokcandy.php:28 9 plgSystemRokCandy->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 1.31 ms Query memory: 0.009 MB Memory before query: 11.268 MB Rows returned: 1
SELECT *
FROM ydfui_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:329 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.84 ms After last query: 7.18 ms Query memory: 0.023 MB Memory before query: 12.051 MB Rows returned: 3
SELECT b.rules
FROM ydfui_assets AS a
LEFT JOIN ydfui_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.115')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 1043 36.24 Using where Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.69 ms Creating sort index 0.06 ms Removing tmp table 0.10 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 18 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 17 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 16 JAccess::check() JROOT/libraries/joomla/user/user.php:393 15 JUser->authorise() JROOT/components/com_content/models/category.php:137 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:439 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 1.69 ms Query memory: 0.022 MB Memory before query: 12.212 MB Rows returned: 2Duplicate queries: #33
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 ydfui_categories as c
LEFT JOIN (SELECT cat.id as id
FROM ydfui_categories AS cat JOIN ydfui_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN ydfui_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=115
GROUP BY 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
ORDER BY c.lftid 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 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 116 29.31 Using where 1 PRIMARY <derived2> ref key0 key0 5 patp8661_pa_website.c.id 2 100.00 Using where 2 LATERAL DERIVED cat eq_ref PRIMARY,idx_left_right PRIMARY 4 patp8661_pa_website.c.id 1 100.00 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 43 37.07 Using index condition; Using where Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 16 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 15 JCategories->get() JROOT/components/com_content/models/category.php:346 14 ContentModelCategory->getCategory() JROOT/components/com_content/models/category.php:223 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 1.63 ms Query memory: 0.027 MB Memory before query: 12.411 MB Rows returned: 2
SELECT b.rules
FROM ydfui_assets AS a
LEFT JOIN ydfui_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 43 100.00 Using where Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.02 ms checking privileges on cached 0.02 ms checking permissions 0.02 ms Sending cached result to clien 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 21 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 20 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 19 JAccess::check() JROOT/libraries/joomla/user/user.php:393 18 JUser->authorise() JROOT/components/com_content/models/articles.php:449 17 ContentModelArticles->getListQuery() JROOT/libraries/legacy/model/list.php:129 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:181 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:537 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 29.22 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 12.442 MB Rows returned: 15
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 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,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM ydfui_content AS a
LEFT JOIN ydfui_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ydfui_categories AS c
ON c.id = a.catid
LEFT JOIN ydfui_users AS ua
ON ua.id = a.created_by
LEFT JOIN ydfui_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ydfui_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ydfui_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ydfui_categories AS cat JOIN ydfui_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-19 16:48:30')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-19 16:48:30')
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 105, 15id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 PRIMARY a range idx_access,idx_catid idx_catid 4 NULL 495 100.00 Using index condition; Using where; Using filesort 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 patp8661_pa_website.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 patp8661_pa_website.a.modified_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 patp8661_pa_website.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 43 37.07 Using index condition; Using where Status Duration Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.03 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.18 ms Waiting for query cache lock 0.02 ms Sending data 0.04 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Waiting for query cache lock 0.02 ms Sending data 0.04 ms Executing 0.02 ms Sending data 0.19 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Waiting for query cache lock 0.02 ms Sending data 0.04 ms Executing 0.02 ms Sending data 0.19 ms Executing 0.02 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.17 ms Waiting for query cache lock 0.02 ms Sending data 0.06 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Waiting for query cache lock 0.02 ms Sending data 0.04 ms End of update loop 0.04 ms Query end 0.04 ms Commit 0.04 ms closing tables 0.03 ms Removing tmp table 0.03 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 16 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:537 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 95.62 ms After last query: 5.04 ms Query memory: 0.022 MB Memory before query: 13.062 MB Rows returned: 1
SELECT COUNT(*)
FROM ydfui_content AS a
LEFT JOIN ydfui_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ydfui_categories AS c
ON c.id = a.catid
LEFT JOIN ydfui_users AS ua
ON ua.id = a.created_by
LEFT JOIN ydfui_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ydfui_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ydfui_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ydfui_categories AS cat JOIN ydfui_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-19 16:48:30')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-19 16:48:30')id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 PRIMARY a ALL idx_access,idx_catid NO INDEX KEY COULD BE USED NULL NULL 539 91.84 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 43 37.07 Using index condition; Using where Status Duration Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.21 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.21 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.21 ms Executing 0.03 ms Sending data 0.19 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.02 ms Sending data 0.18 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Removing tmp table 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.08 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:235 14 JModelList->getPagination() JROOT/components/com_content/models/category.php:257 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.22 ms After last query: 4.41 ms Query memory: 0.017 MB Memory before query: 13.245 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `ydfui_contentitem_tag_map` AS m
INNER JOIN `ydfui_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 115
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 t ALL PRIMARY,tag_idx,idx_access NO INDEX KEY COULD BE USED NULL NULL 5 100.00 Using where 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 7 100.00 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.07 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.07 ms Executing 0.03 ms Sending data 0.12 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.08 ms Reset for next command 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 12 JHelperTags->getItemTags() JROOT/libraries/legacy/view/category.php:217 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 8.71 ms Query memory: 0.024 MB Memory before query: 14.025 MB Rows returned: 2Duplicate queries: #28
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 ydfui_categories as c
LEFT JOIN (SELECT cat.id as id
FROM ydfui_categories AS cat JOIN ydfui_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN ydfui_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=115
GROUP BY 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
ORDER BY c.lftid 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 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 116 29.31 Using where 1 PRIMARY <derived2> ref key0 key0 5 patp8661_pa_website.c.id 2 100.00 Using where 2 LATERAL DERIVED cat eq_ref PRIMARY,idx_left_right PRIMARY 4 patp8661_pa_website.c.id 1 100.00 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 43 37.07 Using index condition; Using where Status Duration Starting 0.14 ms Waiting for query cache lock 0.05 ms starting 0.03 ms Checking query cache for query 0.04 ms checking privileges on cached 0.03 ms checking permissions 0.04 ms Sending cached result to clien 0.09 ms Updating status 0.03 ms Reset for next command 0.03 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 18 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 17 JCategories->get() JROOT/components/com_content/helpers/route.php:45 16 ContentHelperRoute::getArticleRoute() JROOT/plugins/content/jcomments/jcomments.php:95 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.48 ms After last query: 4.49 ms Query memory: 0.021 MB Memory before query: 14.379 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 668
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.12 ms Waiting for query cache lock 0.03 ms starting 0.03 ms Checking query cache for query 0.08 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms Waiting for query cache lock 0.05 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.07 ms Executing 0.03 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.11 ms Updating status 0.03 ms Waiting for query cache lock 0.03 ms Updating status 0.06 ms Waiting for query cache lock 0.03 ms Updating status 0.03 ms Storing result in query cache 0.03 ms Reset for next command 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.43 ms After last query: 1.47 ms Query memory: 0.021 MB Memory before query: 14.418 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 667
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.12 ms Waiting for query cache lock 0.03 ms starting 0.03 ms Checking query cache for query 0.07 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms Waiting for query cache lock 0.04 ms init 0.05 ms Optimizing 0.06 ms Statistics 0.10 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.04 ms Starting cleanup 0.03 ms Freeing items 0.12 ms Updating status 0.05 ms Waiting for query cache lock 0.05 ms Updating status 0.05 ms Waiting for query cache lock 0.03 ms Updating status 0.03 ms Storing result in query cache 0.06 ms Reset for next command 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.20 ms After last query: 2.19 ms Query memory: 0.021 MB Memory before query: 14.454 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 666
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.11 ms Waiting for query cache lock 0.03 ms starting 0.03 ms Checking query cache for query 0.07 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms Waiting for query cache lock 0.04 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.10 ms Updating status 0.03 ms Waiting for query cache lock 0.03 ms Updating status 0.04 ms Waiting for query cache lock 0.03 ms Updating status 0.03 ms Storing result in query cache 0.06 ms Reset for next command 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.31 ms After last query: 1.40 ms Query memory: 0.021 MB Memory before query: 14.491 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 665
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.12 ms Waiting for query cache lock 0.03 ms starting 0.03 ms Checking query cache for query 0.07 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.04 ms table lock 0.03 ms Waiting for query cache lock 0.04 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.10 ms Updating status 0.03 ms Waiting for query cache lock 0.03 ms Updating status 0.06 ms Waiting for query cache lock 0.03 ms Updating status 0.03 ms Storing result in query cache 0.03 ms Reset for next command 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.83 ms After last query: 1.64 ms Query memory: 0.021 MB Memory before query: 14.530 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 664
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.03 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.04 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.78 ms After last query: 3.16 ms Query memory: 0.021 MB Memory before query: 14.568 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 663
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.78 ms After last query: 3.08 ms Query memory: 0.021 MB Memory before query: 14.606 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 662
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.77 ms After last query: 3.04 ms Query memory: 0.021 MB Memory before query: 14.644 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 661
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.78 ms After last query: 3.08 ms Query memory: 0.021 MB Memory before query: 14.683 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 660
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.79 ms After last query: 3.27 ms Query memory: 0.021 MB Memory before query: 14.725 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 659
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.79 ms After last query: 3.10 ms Query memory: 0.021 MB Memory before query: 14.767 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 658
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.85 ms After last query: 2.95 ms Query memory: 0.021 MB Memory before query: 14.806 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 657
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 3.04 ms Query memory: 0.021 MB Memory before query: 14.845 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 656
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.08 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.04 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.80 ms After last query: 2.64 ms Query memory: 0.021 MB Memory before query: 14.882 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 655
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.04 ms Reset for next command 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.88 ms After last query: 2.70 ms Query memory: 0.021 MB Memory before query: 14.919 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 654
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 100.00 Using where; Using index Status Duration Starting 0.07 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.05 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.03 ms Updating status 0.03 ms Storing result in query cache 0.05 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/components/com_jcomments/models/jcomments.php:35 16 JCommentsModel::getCommentsCount() JROOT/plugins/content/jcomments/jcomments.php:187 15 plgContentJComments->onPrepareContent() JROOT/plugins/content/jcomments/jcomments.php:309 14 plgContentJComments->onContentBeforeDisplay() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.89 ms After last query: 41.56 ms Query memory: 0.019 MB Memory before query: 16.380 MB Rows returned: 1
SELECT params
FROM ydfui_extensions AS e
WHERE e.element='com_widgetkit'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 402 const 1 100.00 Using index condition Status Duration Starting 0.12 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.05 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_widgetkit/helpers/system.php:264 14 SystemWidgetkitHelper->_getParams() JROOT/administrator/components/com_widgetkit/helpers/system.php:54 13 SystemWidgetkitHelper->__construct() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 12 Widgetkit->loadHelper() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 11 Widgetkit->getHelper() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 10 Widgetkit->offsetGet() JROOT/administrator/components/com_widgetkit/widgetkit.php:17 9 require_once JROOT/administrator/components/com_widgetkit/widgetkit.php JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 8 plgSystemWidgetkit_System->onAfterDispatch() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 4 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/site.php:196 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.96 ms After last query: 24.10 ms Query memory: 0.021 MB Memory before query: 17.746 MB Rows returned: 30
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ydfui_modules AS m
LEFT JOIN ydfui_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ydfui_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 <= '2024-09-19 16:48:30')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-19 16:48:30')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 545 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 60 42.55 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 patp8661_pa_website.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 patp8661_pa_website.m.id 2 100.00 Using where; Using index Status Duration Starting 0.11 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.09 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.70 ms Waiting for query cache lock 0.03 ms Creating sort index 0.15 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/module/helper.php:409 15 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:352 14 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 13 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:501 12 JDocumentHtml->countModules() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:49 11 ModulesWarpHelper->count() JROOT/templates/abana_j3/layouts/template.config.php:95 10 include JROOT/templates/abana_j3/layouts/template.config.php JROOT/templates/abana_j3/layouts/template.php:10 9 include JROOT/templates/abana_j3/layouts/template.php JROOT/templates/abana_j3/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/abana_j3/index.php:19 7 require JROOT/templates/abana_j3/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.16 ms After last query: 83.20 ms Query memory: 0.024 MB Memory before query: 19.159 MB Rows returned: 1
SELECT SUM(visits)
FROM ydfui_zt_visitor_counter
WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_zt_visitor_counter range timestamp timestamp 4 NULL 668 100.00 Using index condition Status Duration Starting 0.12 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.04 ms Executing 0.02 ms Sending data 1.31 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 18 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:32 17 modZTCounterHelper->getTodayVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:57 16 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:190 15 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 14 JDocumentRendererHtmlModule->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php JROOT/templates/abana_j3/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/abana_j3/layouts/template.php:155 9 include JROOT/templates/abana_j3/layouts/template.php JROOT/templates/abana_j3/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/abana_j3/index.php:19 7 require JROOT/templates/abana_j3/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 7.31 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 19.185 MB Rows returned: 1
SELECT SUM(visits)
FROM ydfui_zt_visitor_counter
WHERE timestamp BETWEEN 1726333200
AND 1726938000id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_zt_visitor_counter range timestamp timestamp 4 NULL 3586 100.00 Using index condition Status Duration Starting 0.05 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.02 ms Sending data 6.58 ms End of update loop 0.04 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.08 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 18 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:103 17 modZTCounterHelper->getWeekVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:74 16 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:190 15 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 14 JDocumentRendererHtmlModule->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php JROOT/templates/abana_j3/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/abana_j3/layouts/template.php:155 9 include JROOT/templates/abana_j3/layouts/template.php JROOT/templates/abana_j3/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/abana_j3/index.php:19 7 require JROOT/templates/abana_j3/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 34.40 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 19.209 MB Rows returned: 1
SELECT SUM(visits)
FROM ydfui_zt_visitor_counter
WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), '%Y-%m-01'))
AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-%m-01') + INTERVAL 1 MONTH)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_zt_visitor_counter range timestamp timestamp 4 NULL 29796 100.00 Using index condition Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.02 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.22 ms Preparing 0.03 ms Executing 0.02 ms Sending data 33.44 ms End of update loop 0.06 ms Query end 0.03 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 18 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:150 17 modZTCounterHelper->getMonthVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:94 16 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:190 15 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 14 JDocumentRendererHtmlModule->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php JROOT/templates/abana_j3/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/abana_j3/layouts/template.php:155 9 include JROOT/templates/abana_j3/layouts/template.php JROOT/templates/abana_j3/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/abana_j3/index.php:19 7 require JROOT/templates/abana_j3/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 269.53 ms After last query: 0.38 ms Query memory: 0.024 MB Memory before query: 19.234 MB Rows returned: 1
SELECT SUM(visits)
FROM ydfui_zt_visitor_counterid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_zt_visitor_counter ALL NULL NO INDEX KEY COULD BE USED NULL NULL 523403 100.00 Status Duration Starting 0.05 ms Waiting for query cache lock 0.03 ms starting 0.02 ms Checking query cache for query 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for query cache lock 0.03 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.03 ms Sending data 268.71 ms End of update loop 0.06 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.07 ms Updating status 0.03 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 18 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:187 17 modZTCounterHelper->getTotalVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:112 16 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:190 15 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 14 JDocumentRendererHtmlModule->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php JROOT/templates/abana_j3/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/abana_j3/layouts/template.php:155 9 include JROOT/templates/abana_j3/layouts/template.php JROOT/templates/abana_j3/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/abana_j3/index.php:19 7 require JROOT/templates/abana_j3/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.15 ms After last query: 0.29 ms Query memory: 0.024 MB Memory before query: 19.260 MB Rows returned: 50
SELECT guest, client_id
FROM ydfui_session
WHERE client_id = 0
AND `time` BETWEEN 1726763611
AND 1726764511id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ydfui_session ALL time NO INDEX KEY COULD BE USED NULL NULL 154 100.00 Using where Status Duration Starting 0.06 ms Waiting for query cache lock 0.02 ms starting 0.03 ms Checking query cache for query 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms Waiting for query cache lock 0.03 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.39 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Waiting for query cache lock 0.02 ms Updating status 0.04 ms Waiting for query cache lock 0.02 ms Updating status 0.02 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 18 JDatabaseDriver->loadObjectList() JROOT/modules/mod_zt_visitor_counter/helper.php:309 17 modZTCounterHelper->getOnline() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:139 16 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:190 15 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 14 JDocumentRendererHtmlModule->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:86 13 ModulesWarpHelper->load() JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php:10 12 include JROOT/templates/abana_j3/warp/systems/joomla/layouts/modules.php JROOT/templates/abana_j3/warp/helpers/template.php:49 11 TemplateWarpHelper->render() JROOT/templates/abana_j3/warp/systems/joomla/helpers/modules.php:64 10 ModulesWarpHelper->render() JROOT/templates/abana_j3/layouts/template.php:155 9 include JROOT/templates/abana_j3/layouts/template.php JROOT/templates/abana_j3/warp/helpers/template.php:49 8 TemplateWarpHelper->render() JROOT/templates/abana_j3/index.php:19 7 require JROOT/templates/abana_j3/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49
32 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
15 × SELECT count(*)
FROM ydfui_jcomments AS c3 × SELECT SUM(visits)
FROM ydfui_zt_visitor_counter3 × SELECT b.rules
FROM ydfui_assets AS a
LEFT JOIN ydfui_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM ydfui_extensions2 × 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 ydfui_categories as c
LEFT JOIN (SELECT cat.id as id
FROM ydfui_categories AS cat JOIN ydfui_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT *
FROM ydfui_extensions2 × SELECT `extension_id`
FROM `ydfui_extensions`2 × SELECT template
FROM ydfui_template_styles as s1 × SELECT COUNT(*)
FROM ydfui_content AS a
LEFT JOIN ydfui_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ydfui_categories AS c
ON c.id = a.catid
LEFT JOIN ydfui_users AS ua
ON ua.id = a.created_by
LEFT JOIN ydfui_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ydfui_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ydfui_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ydfui_categories AS cat JOIN ydfui_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × 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 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,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM ydfui_content AS a
LEFT JOIN ydfui_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ydfui_categories AS c
ON c.id = a.catid
LEFT JOIN ydfui_users AS ua
ON ua.id = a.created_by
LEFT JOIN ydfui_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ydfui_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ydfui_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ydfui_categories AS cat JOIN ydfui_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT guest, client_id
FROM ydfui_session1 × SELECT `m`.`tag_id`,`t`.*
FROM `ydfui_contentitem_tag_map` AS m
INNER JOIN `ydfui_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT params
FROM ydfui_extensions AS e1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ydfui_modules AS m
LEFT JOIN ydfui_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ydfui_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM ydfui_languages1 × SELECT `session_id`
FROM `ydfui_session`1 × SELECT SUM(visits)
FROM ydfui_zt_visitor_counte1 × SELECT id, home, template, s.params
FROM ydfui_template_styles as s
LEFT JOIN ydfui_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT timestamp
FROM ydfui_zt_visitor_counter1 × SELECT extension, file, type
FROM ydfui_rokcommon_configs1 × SELECT folder AS type, element AS name, params
FROM ydfui_extensions1 × SELECT id, rules
FROM `ydfui_viewlevels1 × 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 ydfui_menu AS m
LEFT JOIN ydfui_extensions AS e
ON m.component_id = e.extension_id1 × SELECT a.rules
FROM ydfui_assets AS a1 × SELECT b.id
FROM ydfui_usergroups AS a
LEFT JOIN