Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1763355803,
"last": 1763355803,
"now": 1763355803
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 8.94 ms / 8.94 ms Memory: 0.183 MB / 0.41 MB Application: afterLoad
Time: 129.30 ms / 138.24 ms Memory: 2.574 MB / 2.98 MB Application: afterInitialise
Time: 33.17 ms / 171.41 ms Memory: 2.431 MB / 5.41 MB Application: Start JAccess::getAssetRules Old (1)
Time: 1.31 ms / 172.72 ms Memory: 0.035 MB / 5.45 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.07 ms / 172.78 ms Memory: 0.000 MB / 5.44 MB Application: Start JAccess::getAssetRules Old (1)
Time: 0.77 ms / 173.55 ms Memory: 0.028 MB / 5.47 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 7.81 ms / 181.36 ms Memory: 0.266 MB / 5.73 MB Application: afterRoute
Time: 1.57 ms / 182.93 ms Memory: 0.053 MB / 5.79 MB Application: beforeRenderComponent com_content
Time: 3.06 ms / 185.99 ms Memory: 0.244 MB / 6.03 MB Application: New JAccess Preloading Process(com_content.category)
Time: 4.94 ms / 190.93 ms Memory: 1.171 MB / 7.20 MB Application: After preloadPermissionsParentIdMapping (com_content.category)
Time: 8.43 ms / 199.36 ms Memory: 1.671 MB / 8.87 MB Application: After preloadPermissions (com_content.category)
Time: 0.02 ms / 199.38 ms Memory: 0.002 MB / 8.87 MB Application: End New JAccess Preloading Process(com_content.category)
Time: 0.03 ms / 199.41 ms Memory: 0.002 MB / 8.88 MB Application: Start JAccess::getAssetRules New (com_content.category.115)
Time: 0.12 ms / 199.53 ms Memory: 0.011 MB / 8.89 MB Application: Finish JAccess::getAssetRules New (com_content.category.115)
Time: 6.34 ms / 205.87 ms Memory: 0.122 MB / 9.01 MB Application: Start JAccess::preload(components)
Time: 4.04 ms / 209.91 ms Memory: 0.591 MB / 9.60 MB Application: Finish JAccess::preload(components)
Time: 182.21 ms / 392.12 ms Memory: 1.611 MB / 11.21 MB Application: afterRenderComponent com_content
Time: 19.61 ms / 411.73 ms Memory: 0.388 MB / 11.60 MB Application: afterDispatch
Time: 12.12 ms / 423.85 ms Memory: 0.311 MB / 11.91 MB Application: beforeRenderModule mod_custom (Logo Blink)
Time: 1.87 ms / 425.72 ms Memory: 0.015 MB / 11.92 MB Application: afterRenderModule mod_custom (Logo Blink)
Time: 0.69 ms / 426.42 ms Memory: 0.001 MB / 11.93 MB Application: beforeRenderModule mod_search (Search)
Time: 1.60 ms / 428.02 ms Memory: 0.029 MB / 11.95 MB Application: afterRenderModule mod_search (Search)
Time: 1.02 ms / 429.05 ms Memory: 0.000 MB / 11.95 MB Application: beforeRenderModule mod_menu (Menu Utama)
Time: 57.77 ms / 486.81 ms Memory: 0.554 MB / 12.50 MB Application: afterRenderModule mod_menu (Menu Utama)
Time: 26.24 ms / 513.06 ms Memory: 0.113 MB / 12.62 MB Application: beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs)
Time: 1.58 ms / 514.64 ms Memory: 0.029 MB / 12.65 MB Application: afterRenderModule mod_breadcrumbs_adv (Breadcrumbs)
Time: 1.35 ms / 515.99 ms Memory: 0.000 MB / 12.64 MB Application: beforeRenderModule mod_custom (Agenda Bulan Ini)
Time: 1.91 ms / 517.90 ms Memory: 0.068 MB / 12.70 MB Application: beforeRenderModule mod_custom (Modul Agenda 2023)
Time: 0.90 ms / 518.80 ms Memory: 0.008 MB / 12.71 MB Application: afterRenderModule mod_custom (Modul Agenda 2023)
Time: 0.42 ms / 519.21 ms Memory: 0.000 MB / 12.68 MB Application: afterRenderModule mod_custom (Agenda Bulan Ini)
Time: 0.08 ms / 519.29 ms Memory: 0.000 MB / 12.68 MB Application: beforeRenderModule mod_custom (Statistik Web)
Time: 1.35 ms / 520.64 ms Memory: 0.077 MB / 12.75 MB Application: beforeRenderModule mod_zt_visitor_counter (Statistik Web Modul)
Time: 425.98 ms / 946.62 ms Memory: 0.237 MB / 12.99 MB Application: afterRenderModule mod_zt_visitor_counter (Statistik Web Modul)
Time: 0.66 ms / 947.28 ms Memory: 0.000 MB / 12.94 MB Application: afterRenderModule mod_custom (Statistik Web)
Time: 1.52 ms / 948.80 ms Memory: 0.013 MB / 12.95 MB Application: beforeRenderModule mod_custom (Hubungi Kami PA Sangatta)
Time: 5.59 ms / 954.39 ms Memory: 0.743 MB / 13.69 MB Application: afterRenderModule mod_custom (Hubungi Kami PA Sangatta)
Time: 0.09 ms / 954.48 ms Memory: 0.000 MB / 13.69 MB Application: beforeRenderModule mod_custom (Tautan Web Terkait)
Time: 0.75 ms / 955.23 ms Memory: 0.007 MB / 13.70 MB Application: afterRenderModule mod_custom (Tautan Web Terkait)
Time: 0.07 ms / 955.29 ms Memory: 0.000 MB / 13.70 MB Application: beforeRenderModule mod_custom (Tautan Web PA Se-Kaltim)
Time: 0.71 ms / 956.00 ms Memory: 0.007 MB / 13.71 MB Application: afterRenderModule mod_custom (Tautan Web PA Se-Kaltim)
Time: 0.10 ms / 956.10 ms Memory: 0.000 MB / 13.70 MB Application: beforeRenderModule mod_custom (Tautan Aplikasi Internal)
Time: 0.87 ms / 956.97 ms Memory: 0.007 MB / 13.71 MB Application: afterRenderModule mod_custom (Tautan Aplikasi Internal)
Time: 0.07 ms / 957.04 ms Memory: 0.000 MB / 13.71 MB Application: beforeRenderModule mod_custom (Tautan Aplikasi Eksternal)
Time: 0.73 ms / 957.77 ms Memory: 0.007 MB / 13.72 MB Application: afterRenderModule mod_custom (Tautan Aplikasi Eksternal)
Time: 2.25 ms / 960.02 ms Memory: 0.000 MB / 13.72 MB Application: beforeRenderModule mod_custom (Copyright)
Time: 0.75 ms / 960.77 ms Memory: 0.007 MB / 13.72 MB Application: afterRenderModule mod_custom (Copyright)
Time: 0.81 ms / 961.58 ms Memory: 0.000 MB / 13.72 MB Application: beforeRenderModule mod_custom (W3C HTML)
Time: 0.47 ms / 962.05 ms Memory: 0.007 MB / 13.73 MB Application: afterRenderModule mod_custom (W3C HTML)
Time: 638.61 ms / 1600.66 ms Memory: 0.146 MB / 13.88 MB Application: afterRender
Database queries total: 596.97 ms
15.27 MB (16,007,832 Bytes)
62 Queries Logged 596.97 ms
8 duplicate found!
- Query Time: 0.87 ms Query memory: 0.018 MB Memory before query: 0.900 MB Rows returned: 0
SELECT `data`
FROM `ydfui_session`
WHERE `session_id` = 'ar048cg40s17jji0ojapgdt4d0'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_session const PRIMARY PRIMARY 575 const 1 Status Duration Starting 0.18 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:259 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:773 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:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.70 ms After last query: 2.46 ms Query memory: 0.008 MB Memory before query: 0.964 MB
DELETE
FROM `ydfui_session`
WHERE `time` < '1763350403'EXPLAIN not possible on query: DELETE FROM `ydfui_session` WHERE `time` < '1763350403'Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.03 ms init for update 0.10 ms Updating 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.05 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:790 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:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.61 ms After last query: 0.29 ms Query memory: 0.012 MB Memory before query: 0.975 MB Rows returned: 0
SELECT `session_id`
FROM `ydfui_session`
WHERE `session_id` = 'ar048cg40s17jji0ojapgdt4d0'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_session const PRIMARY PRIMARY 575 const 1 Using index Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 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:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.62 ms After last query: 0.35 ms Query memory: 0.009 MB Memory before query: 0.990 MB
INSERT INTO `ydfui_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('ar048cg40s17jji0ojapgdt4d0', 0, 1, '1763355803', 0, '')EXPLAIN not possible on query: INSERT INTO `ydfui_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('ar048cg40s17jji0ojapgdt4d0', 0, 1, '1763355803', 0, '')Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init for update 0.03 ms Update 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.08 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:212 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 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:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 1.18 ms After last query: 2.70 ms Query memory: 0.021 MB Memory before query: 1.045 MB Rows returned: 38
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 Extra 1 SIMPLE ydfui_extensions ref extension extension 62 const 38 Using index condition Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.29 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 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:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 1.48 ms Query memory: 0.015 MB Memory before query: 1.120 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 Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.03 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:835 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:904 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 0.49 ms Query memory: 0.014 MB Memory before query: 1.140 MB Rows returned: 6
SELECT id, rules
FROM `ydfui_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.07 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.02 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.04 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1494 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:921 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.52 ms After last query: 0.33 ms Query memory: 0.015 MB Memory before query: 1.159 MB Rows returned: 79
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 Extra 1 SIMPLE ydfui_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 223 Using where; Using filesort Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.60 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.03 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 7 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.25 ms After last query: 18.51 ms Query memory: 0.019 MB Memory before query: 1.846 MB Rows returned: 1Duplicate queries: #10
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 Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 7 Using where Status Duration Starting 0.27 ms checking permissions 0.05 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.07 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.15 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 0.33 ms Query memory: 0.020 MB Memory before query: 1.865 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 Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 7 Using where Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.20 ms After last query: 7.44 ms Query memory: 0.015 MB Memory before query: 2.075 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 Extra 1 SIMPLE ydfui_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Using filesort Status Duration Starting 0.23 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.04 ms Creating sort index 0.14 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 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:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.45 ms After last query: 16.75 ms Query memory: 0.016 MB Memory before query: 2.490 MB Rows returned: 1
SELECT timestamp
FROM ydfui_zt_visitor_counter
WHERE ipaddress = '216.73.216.108'
AND useragent LIKE "%other%"
ORDER BY timestamp DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_zt_visitor_counter index NULL timestamp 4 NULL 1 Using where Status Duration Starting 0.29 ms checking permissions 0.04 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.08 ms Optimizing 0.08 ms Statistics 0.10 ms Preparing 0.06 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.12 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.04 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.03 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:1728 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 0.34 ms Query memory: 0.014 MB Memory before query: 2.502 MB
UPDATE ydfui_zt_visitor_counter
SET visits=visits + 1, guests=guests + 1, useragent = 'other'
WHERE timestamp = 1763360847
AND `ipaddress` = '216.73.216.108';EXPLAIN not possible on query: UPDATE ydfui_zt_visitor_counter SET visits=visits + 1, guests=guests + 1, useragent = 'other' WHERE timestamp = 1763360847 AND `ipaddress` = '216.73.216.108';Status Duration Starting 0.09 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init for update 0.12 ms Updating 0.14 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.09 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.91 ms After last query: 1.80 ms Query memory: 0.023 MB Memory before query: 2.570 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.08 ms checking permissions 0.02 ms closing tables 0.02 ms checking permissions 0.01 ms Opening tables 0.65 ms After opening tables 0.03 ms System lock 0.01 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.02 ms Opening tables 0.03 ms After opening tables 0.02 ms checking permissions 0.20 ms closing tables 0.04 ms checking permissions 0.02 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.03 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.12 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 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:1689 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:31 11 JTableExtension->__construct() JROOT/libraries/joomla/table/table.php:308 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.01 ms After last query: 1.58 ms Query memory: 0.016 MB Memory before query: 2.638 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 Extra 1 SIMPLE ydfui_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where; Using index Status Duration Starting 0.15 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.05 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.05 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.03 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 11 JDatabaseDriver->loadResult() JROOT/libraries/joomla/table/extension.php:109 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.74 ms After last query: 0.36 ms Query memory: 0.020 MB Memory before query: 2.655 MB Rows returned: 1Duplicate queries: #18
SELECT *
FROM ydfui_extensions
WHERE `extension_id` = '10117'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 ms Unlocking tables 0.04 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.05 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 0.28 ms Query memory: 0.016 MB Memory before query: 2.669 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 Extra 1 SIMPLE ydfui_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.04 ms Executing 0.04 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.03 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 11 JDatabaseDriver->loadResult() JROOT/libraries/joomla/table/extension.php:109 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 0.33 ms Query memory: 0.020 MB Memory before query: 2.685 MB Rows returned: 1Duplicate queries: #16
SELECT *
FROM ydfui_extensions
WHERE `extension_id` = '10117'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.05 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 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:1453 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.32 ms After last query: 38.66 ms Query memory: 0.049 MB Memory before query: 3.036 MB Rows returned: 156
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 Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 308 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 pasanga2_website.m.component_id 1 Using where Status Duration Starting 0.28 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 1.10 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 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:145 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:439 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:197 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:535 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1115 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.42 ms After last query: 27.10 ms Query memory: 0.027 MB Memory before query: 5.350 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `ydfui_assets`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ydfui_assets`Status Duration Starting 0.11 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.03 ms Opening tables 0.38 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms checking permissions 0.07 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.10 ms closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.03 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 17 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 16 JTable->__construct() JROOT/libraries/joomla/table/asset.php:60 15 JTableAsset->__construct() JROOT/libraries/joomla/table/table.php:308 14 JTable::getInstance() JROOT/libraries/joomla/access/access.php:696 13 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 12 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 5.397 MB Rows returned: 1
SELECT *
FROM ydfui_assets
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_assets const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 15 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 14 JTable->load() JROOT/libraries/joomla/access/access.php:697 13 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 12 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.65 ms After last query: 0.21 ms Query memory: 0.018 MB Memory before query: 5.413 MB Rows returned: 1Duplicate queries: #23
SELECT a.rules
FROM ydfui_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index_merge PRIMARY,idx_asset_name PRIMARY,idx_asset_name 4,152 NULL 2 Using union(PRIMARY,idx_asset_name); Using where Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 13 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:652 12 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.70 ms Query memory: 0.019 MB Memory before query: 5.442 MB Rows returned: 1Duplicate queries: #22
SELECT a.rules
FROM ydfui_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index_merge PRIMARY,idx_asset_name PRIMARY,idx_asset_name 4,152 NULL 2 Using union(PRIMARY,idx_asset_name); Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:652 13 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:176 12 JAccess::check() JROOT/libraries/joomla/user/user.php:394 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 1.02 ms Query memory: 0.024 MB Memory before query: 5.524 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 Extra 1 SIMPLE ydfui_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using index condition Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 18 JDatabaseDriver->loadObject() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 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:755 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 0.27 ms Query memory: 0.017 MB Memory before query: 5.531 MB
UPDATE `ydfui_extensions`
SET `params` = '{\"mediaversion\":\"b3399d18a59a7881c7c70d8b21760601\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `ydfui_extensions` SET `params` = '{\"mediaversion\":\"b3399d18a59a7881c7c70d8b21760601\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.09 ms Updating 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.07 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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:755 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.74 ms After last query: 1.48 ms Query memory: 0.025 MB Memory before query: 5.655 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 Extra 1 SIMPLE ydfui_jcomments_settings ref PRIMARY PRIMARY 214 const,const 91 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 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:152 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.69 ms After last query: 0.75 ms Query memory: 0.018 MB Memory before query: 5.678 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 Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 7 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 pasanga2_website.s.template,const 1 Using index condition; Using where Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 0.44 ms Query memory: 0.027 MB Memory before query: 5.717 MB Rows returned: 71
SELECT *
FROM ydfui_rokcandy
WHERE published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_rokcandy ALL NULL NO INDEX KEY COULD BE USED NULL NULL 79 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.14 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 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:152 12 JCacheControllerCallback->get() JROOT/libraries/joomla/cache/controller/callback.php:40 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:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 1.12 ms Query memory: 0.014 MB Memory before query: 5.773 MB Rows returned: 0
SELECT *
FROM ydfui_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.75 ms After last query: 3.64 ms Query memory: 0.060 MB Memory before query: 6.033 MB Rows returned: 1477
SELECT a.id, a.parent_id
FROM ydfui_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL PRIMARY,idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 1656 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:332 18 JAccess::preloadPermissionsParentIdMapping() JROOT/libraries/joomla/access/access.php:240 17 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 16 JAccess::check() JROOT/libraries/joomla/user/user.php:394 15 JUser->authorise() JROOT/components/com_content/models/category.php:142 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:435 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:408 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:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.86 ms After last query: 3.64 ms Query memory: 0.071 MB Memory before query: 7.217 MB Rows returned: 1477
SELECT a.id, a.name, a.rules
FROM ydfui_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL PRIMARY,idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 1656 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.28 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1255 19 JDatabaseDriver->getIterator() JROOT/libraries/joomla/access/access.php:373 18 JAccess::preloadPermissions() JROOT/libraries/joomla/access/access.php:243 17 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 16 JAccess::check() JROOT/libraries/joomla/user/user.php:394 15 JUser->authorise() JROOT/components/com_content/models/category.php:142 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:435 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:408 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:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 3.81 ms After last query: 7.38 ms Query memory: 0.029 MB Memory before query: 8.921 MB Rows returned: 2Duplicate queries: #38
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 Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 147 Using where 1 PRIMARY <derived2> ref key0 key0 5 pasanga2_website.c.id 17 Using where 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 152 const 50 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 147 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.15 ms Optimizing 0.04 ms Optimizing 0.02 ms Statistics 0.08 ms Statistics 0.23 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Creating tmp table 0.12 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 1.09 ms Creating sort index 0.07 ms Removing tmp table 0.01 ms Creating sort index 0.65 ms Creating sort index 0.10 ms Removing tmp table 0.13 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.12 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 15 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 14 JCategories->get() JROOT/components/com_content/models/category.php:354 13 ContentModelCategory->getCategory() JROOT/libraries/legacy/view/legacy.php:408 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:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.70 ms After last query: 1.46 ms Query memory: 0.030 MB Memory before query: 9.008 MB Rows returned: 38
SELECT element
FROM ydfui_extensions
WHERE type = 'component'
AND enabled = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_extensions ref extension extension 62 const 38 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.15 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 22 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:413 21 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 20 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 19 JAccess::check() JROOT/libraries/joomla/user/user.php:394 18 JUser->authorise() JROOT/components/com_content/models/articles.php:466 17 ContentModelArticles->getListQuery() JROOT/libraries/legacy/model/list.php:129 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:183 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 0.27 ms Query memory: 0.030 MB Memory before query: 9.045 MB Rows returned: 38
SELECT a.name, a.rules
FROM ydfui_assets AS a
WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_jcomments','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_profiles','com_redirect','com_rokcandy','com_rokgallery','com_roksprocket','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper') OR a.name = 'root.1')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_asset_name idx_asset_name 152 NULL 39 Using index condition Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.13 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.29 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1494 22 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:441 21 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 20 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 19 JAccess::check() JROOT/libraries/joomla/user/user.php:394 18 JUser->authorise() JROOT/components/com_content/models/articles.php:466 17 ContentModelArticles->getListQuery() JROOT/libraries/legacy/model/list.php:129 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:183 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 6.59 ms After last query: 2.11 ms Query memory: 0.044 MB Memory before query: 9.594 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_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 <= '2025-11-17 05:03:24')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-17 05:03:24')
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 15id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 586 Using where; Using filesort 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 pasanga2_website.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 pasanga2_website.a.modified_by 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 pasanga2_website.a.id 1 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 152 const 50 Using index condition; Using where Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.12 ms After opening tables 0.05 ms System lock 0.02 ms table lock 0.02 ms init 0.13 ms Optimizing 0.06 ms Optimizing 0.02 ms Statistics 0.06 ms Statistics 0.18 ms Preparing 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 1.92 ms Executing 0.03 ms Sending data 0.25 ms Executing 0.01 ms Sending data 0.22 ms Executing 0.02 ms Sending data 0.19 ms Executing 0.01 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.23 ms Executing 0.02 ms Sending data 0.21 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.01 ms Sending data 0.24 ms Executing 0.02 ms Sending data 0.18 ms Executing 0.02 ms Sending data 0.21 ms Executing 0.01 ms Sending data 0.19 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.04 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:310 16 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:183 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 108.47 ms After last query: 6.62 ms Query memory: 0.024 MB Memory before query: 10.088 MB Rows returned: 1
SELECT COUNT(*)
FROM ydfui_content AS a
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 <= '2025-11-17 05:03:24')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-17 05:03:24')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 586 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 0 Using where 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 2 LATERAL DERIVED parent ref cat_idx,idx_left_right cat_idx 152 const 50 Using index condition; Using where Status Duration Executing 0.02 ms Sending data 0.16 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.21 ms Executing 0.02 ms Sending data 0.16 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.19 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.16 ms Executing 0.02 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.18 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.18 ms Executing 0.01 ms Sending data 0.18 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.16 ms Executing 0.01 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.21 ms Executing 0.02 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.16 ms Executing 0.01 ms Sending data 0.18 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.20 ms Executing 0.02 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.15 ms Executing 0.01 ms Sending data 0.16 ms Executing 0.01 ms Sending data 0.19 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:337 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:278 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:228 14 JModelList->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:408 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:128 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.94 ms After last query: 1.44 ms Query memory: 0.025 MB Memory before query: 10.114 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 Extra 1 SIMPLE t ALL PRIMARY,tag_idx,idx_access NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 8 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.03 ms table lock 0.02 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:435 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:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 3.71 ms After last query: 3.88 ms Query memory: 0.032 MB Memory before query: 10.308 MB Rows returned: 2Duplicate queries: #32
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 Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 147 Using where 1 PRIMARY <derived2> ref key0 key0 5 pasanga2_website.c.id 17 Using where 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 152 const 50 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 147 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.02 ms init 0.19 ms Optimizing 0.07 ms Optimizing 0.03 ms Statistics 0.07 ms Statistics 0.15 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Creating tmp table 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 1.12 ms Creating sort index 0.08 ms Removing tmp table 0.02 ms Creating sort index 0.71 ms Creating sort index 0.08 ms Removing tmp table 0.12 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.02 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 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:44 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.23 ms After last query: 2.36 ms Query memory: 0.023 MB Memory before query: 10.400 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1345
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 1.92 ms Query memory: 0.023 MB Memory before query: 10.435 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1344
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.55 ms After last query: 1.33 ms Query memory: 0.023 MB Memory before query: 10.468 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1343
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 1.21 ms Query memory: 0.023 MB Memory before query: 10.499 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1342
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.23 ms After last query: 1.20 ms Query memory: 0.023 MB Memory before query: 10.531 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1341
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 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:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.65 ms After last query: 1.13 ms Query memory: 0.023 MB Memory before query: 10.563 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1340
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.03 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 1.16 ms Query memory: 0.023 MB Memory before query: 10.599 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1339
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.58 ms After last query: 1.16 ms Query memory: 0.023 MB Memory before query: 10.632 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1338
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 1.17 ms Query memory: 0.023 MB Memory before query: 10.668 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1337
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.08 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.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 1.12 ms Query memory: 0.023 MB Memory before query: 10.703 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1336
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.79 ms After last query: 1.11 ms Query memory: 0.023 MB Memory before query: 10.736 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1335
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.70 ms After last query: 1.08 ms Query memory: 0.023 MB Memory before query: 10.767 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1333
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.04 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 1.17 ms Query memory: 0.023 MB Memory before query: 10.798 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1332
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 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.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 1.32 ms Query memory: 0.023 MB Memory before query: 10.829 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1331
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.58 ms After last query: 1.34 ms Query memory: 0.023 MB Memory before query: 10.867 MB Rows returned: 1
SELECT count(*)
FROM ydfui_jcomments AS c
WHERE c.object_id = 1330
AND c.object_group = 'com_content'
AND c.published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref idx_object idx_object 772 const,const,const 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:114 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:664 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:702 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.91 ms After last query: 17.71 ms Query memory: 0.021 MB Memory before query: 11.245 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 Extra 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 302 const 1 Using index condition Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 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:159 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:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.07 ms After last query: 22.36 ms Query memory: 0.028 MB Memory before query: 11.718 MB Rows returned: 23
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 <= '2025-11-17 05:03:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-17 05:03:24')
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 Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 139 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 pasanga2_website.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 pasanga2_website.m.id 2 Using where; Using index Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.03 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.11 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.95 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 16 JCacheControllerCallback->get() JROOT/libraries/cms/module/helper.php:425 15 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:361 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.09 ms After last query: 98.23 ms Query memory: 0.038 MB Memory before query: 12.665 MB Rows returned: 1
SELECT *
FROM ydfui_modules
WHERE id='114'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_modules const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.14 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 26 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:101 25 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 24 plgContentLoadModuleInArticle->onContentPrepare() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/cms/html/html.php:237 18 JHtml::call() JROOT/libraries/cms/html/html.php:105 17 JHtml::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/cms/module/helper.php:199 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 2.09 ms Query memory: 0.037 MB Memory before query: 12.709 MB Rows returned: 1
SELECT *
FROM ydfui_modules
WHERE id='126'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_modules const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 26 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:101 25 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 24 plgContentLoadModuleInArticle->onContentPrepare() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/cms/html/html.php:237 18 JHtml::call() JROOT/libraries/cms/html/html.php:105 17 JHtml::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/cms/module/helper.php:199 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 3.28 ms After last query: 1.37 ms Query memory: 0.039 MB Memory before query: 12.813 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 Extra 1 SIMPLE ydfui_zt_visitor_counter range timestamp timestamp 4 NULL 1009 Using index condition Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.03 ms Executing 0.01 ms Sending data 2.59 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 30 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:32 29 modZTCounterHelper->getTodayVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:57 28 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:199 27 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 26 JDocumentRendererHtmlModule->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 25 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 24 plgContentLoadModuleInArticle->onContentPrepare() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/cms/html/html.php:237 18 JHtml::call() JROOT/libraries/cms/html/html.php:105 17 JHtml::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/cms/module/helper.php:199 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 7.75 ms After last query: 0.39 ms Query memory: 0.038 MB Memory before query: 12.852 MB Rows returned: 1
SELECT SUM(visits)
FROM ydfui_zt_visitor_counter
WHERE timestamp BETWEEN 1763251200
AND 1763856000id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_zt_visitor_counter range timestamp timestamp 4 NULL 2303 Using index condition Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 7.00 ms End of update loop 0.06 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 30 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:103 29 modZTCounterHelper->getWeekVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:74 28 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:199 27 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 26 JDocumentRendererHtmlModule->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 25 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 24 plgContentLoadModuleInArticle->onContentPrepare() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/cms/html/html.php:237 18 JHtml::call() JROOT/libraries/cms/html/html.php:105 17 JHtml::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/cms/module/helper.php:199 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 58.27 ms After last query: 0.39 ms Query memory: 0.038 MB Memory before query: 12.889 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 Extra 1 SIMPLE ydfui_zt_visitor_counter range timestamp timestamp 4 NULL 42514 Using index condition Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.02 ms Sending data 57.45 ms End of update loop 0.11 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 30 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:150 29 modZTCounterHelper->getMonthVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:94 28 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:199 27 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 26 JDocumentRendererHtmlModule->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 25 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 24 plgContentLoadModuleInArticle->onContentPrepare() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/cms/html/html.php:237 18 JHtml::call() JROOT/libraries/cms/html/html.php:105 17 JHtml::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/cms/module/helper.php:199 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 352.14 ms After last query: 0.38 ms Query memory: 0.038 MB Memory before query: 12.926 MB Rows returned: 1
SELECT SUM(visits)
FROM ydfui_zt_visitor_counterid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_zt_visitor_counter ALL NULL NO INDEX KEY COULD BE USED NULL NULL 933456 Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.01 ms Sending data 351.29 ms End of update loop 0.14 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 30 JDatabaseDriver->loadResult() JROOT/modules/mod_zt_visitor_counter/helper.php:187 29 modZTCounterHelper->getTotalVisitors() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:112 28 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:199 27 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 26 JDocumentRendererHtmlModule->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 25 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 24 plgContentLoadModuleInArticle->onContentPrepare() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/cms/html/html.php:237 18 JHtml::call() JROOT/libraries/cms/html/html.php:105 17 JHtml::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/cms/module/helper.php:199 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.01 ms After last query: 0.51 ms Query memory: 0.039 MB Memory before query: 12.965 MB Rows returned: 43
SELECT guest, client_id
FROM ydfui_session
WHERE client_id = 0
AND `time` BETWEEN 1763354904
AND 1763355804id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ydfui_session ALL time NO INDEX KEY COULD BE USED NULL NULL 200 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.28 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 30 JDatabaseDriver->loadObjectList() JROOT/modules/mod_zt_visitor_counter/helper.php:309 29 modZTCounterHelper->getOnline() JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:139 28 include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php JROOT/libraries/cms/module/helper.php:199 27 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 26 JDocumentRendererHtmlModule->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 25 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 24 plgContentLoadModuleInArticle->onContentPrepare() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/cms/html/html.php:237 18 JHtml::call() JROOT/libraries/cms/html/html.php:105 17 JHtml::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/cms/module/helper.php:199 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:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49
39 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
15 × SELECT count(*)
FROM ydfui_jcomments AS c3 × SELECT SUM(visits)
FROM ydfui_zt_visitor_counter2 × SELECT *
FROM ydfui_extensions2 × SELECT a.rules
FROM ydfui_assets AS a2 × 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 template
FROM ydfui_template_styles as s2 × SELECT `extension_id`
FROM `ydfui_extensions`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ydfui_extensions`2 × SELECT *
FROM ydfui_modules1 × SELECT guest, client_id
FROM ydfui_session1 × 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_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.name, a.rules
FROM ydfui_assets AS a1 × SELECT COUNT(*)
FROM ydfui_content AS a
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 element
FROM ydfui_extensions1 × 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 a.id, a.name, a.rules
FROM ydfui_assets AS a1 × SELECT SUM(visits)
FROM ydfui_zt_visitor_counte1 × 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_rokcandy1 × SELECT folder AS type, element AS name, params
FROM ydfui_extensions1 × SELECT extension, file, type
FROM ydfui_rokcommon_configs1 × SELECT id, rules
FROM `ydfui_viewlevels1 × SELECT b.id
FROM ydfui_usergroups AS a
LEFT JOIN ydfui_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `ydfui_session`1 × SELECT timestamp
FROM ydfui_zt_visitor_counter1 × 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 `data`
FROM `ydfui_session`1 × SELECT *
FROM ydfui_languages1 × 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 *
FROM `ydfui_jcomments_settings`1 × SELECT *
FROM ydfui_assets1 × SELECT a.id, a.parent_id
FROM ydfui_assets AS a
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `ydfui_assets1 × UPDATE `ydfui_extensions`
SET `params` = '{\"mediaversion\":\"b3399d18a59a7881c7c70d8b21760601\"}'1 × SHOW FULL COLUMNS
FROM `ydfui_extensions1 × UPDATE ydfui_zt_visitor_counter
SET visits=visits + 1, guests=guests + 1, useragent = 'other'1 × INSERT INTO `ydfui_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('ar048cg40s17jji0ojapgdt4d0', 0, 1, '1763355803', 0, ''1 × DELETE
FROM `ydfui_session`