We have 643 guests and no members online
Copyright © 2026 St Albans City F.C. History & Archives
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1793618585,
"last": 1793618585,
"now": 1793618585
},
"token": "AxyjkI63LLjGKdr5D5wySVpRb5Ae1Xwo"
},
"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: 4.81 ms / 4.81 ms Memory: 0.753 MB / 5.52 MB Application: afterLoad
Time: 11.83 ms / 16.64 ms Memory: 0.643 MB / 6.16 MB Application: Before Access::preloadComponents (all components)
Time: 0.70 ms / 17.34 ms Memory: 0.063 MB / 6.22 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 17.36 ms Memory: -0.001 MB / 6.22 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Time: 0.15 ms / 17.51 ms Memory: 0.007 MB / 6.23 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Time: 28.66 ms / 46.17 ms Memory: 0.825 MB / 7.05 MB Application: afterInitialise
Time: 287.71 ms / 333.89 ms Memory: 1.626 MB / 8.68 MB Application: afterRoute
Time: 0.52 ms / 334.41 ms Memory: 0.012 MB / 8.69 MB Application: beforeRenderComponent com_tlpteam
Time: 10.45 ms / 344.86 ms Memory: 0.151 MB / 8.84 MB Application: afterRenderComponent com_tlpteam
Time: 3.26 ms / 348.12 ms Memory: 0.100 MB / 8.94 MB Application: afterDispatch
Time: 5.05 ms / 353.17 ms Memory: 0.044 MB / 8.99 MB Application: beforeRenderModule mod_whosonline (Who's Online)
Time: 0.85 ms / 354.02 ms Memory: 0.016 MB / 9.00 MB Application: afterRenderModule mod_whosonline (Who's Online)
Time: 0.03 ms / 354.05 ms Memory: -0.002 MB / 9.00 MB Application: beforeRenderModule mod_menu (TOP menu2)
Time: 3.33 ms / 357.38 ms Memory: 0.558 MB / 9.56 MB Application: afterRenderModule mod_menu (TOP menu2)
Time: 3.53 ms / 360.90 ms Memory: 0.117 MB / 9.67 MB Application: afterRender
Database queries total: 45.32 ms
10.25 MB (10,750,024 Bytes)
43 Queries Logged 45.32 ms
11 duplicate found!
- Query Time: 0.35 ms Query memory: 0.023 MB Memory before query: 5.594 MB Rows returned: 0
SELECT `data`
FROM `qqrl9_session`
WHERE `session_id` = X'3364336639313463326334666432393261333562653864633161316232623839'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.10 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.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 15 JSessionStorageDatabase->read() Same as call in the line below. 14 session_start() JROOT/libraries/joomla/session/handler/native.php:260 13 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 12 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 11 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 10 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 9 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 8 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 7 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 6 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 5 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 4 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 3 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 2 Joomla\CMS\Factory::getApplication() JROOT/indexx.php:46 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.21 ms After last query: 0.27 ms Query memory: 0.020 MB Memory before query: 5.606 MB Rows returned: 0
SELECT `session_id`
FROM `qqrl9_session`
WHERE `session_id` = X'3364336639313463326334666432393261333562653864633161316232623839'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 8 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 7 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 6 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 5 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 4 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 3 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 2 Joomla\CMS\Factory::getApplication() JROOT/indexx.php:46 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.31 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 5.611 MB
INSERT INTO `qqrl9_session` (`session_id`,`guest`,`time`,`userid`,`username`)
VALUES (X'3364336639313463326334666432393261333562653864633161316232623839', 1, 1793618585, 0, '')EXPLAIN not possible on query: INSERT INTO `qqrl9_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'3364336639313463326334666432393261333562653864633161316232623839', 1, 1793618585, 0, '')Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.06 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.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 8 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 7 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 6 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 5 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 4 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 3 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 2 Joomla\CMS\Factory::getApplication() JROOT/indexx.php:46 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.45 ms After last query: 0.33 ms Query memory: 0.038 MB Memory before query: 5.640 MB Rows returned: 49
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_extensions ref extension extension 82 const 49 Using index condition; Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 11 Joomla\CMS\Component\ComponentHelper::{closure:Joomla\CMS\Component\ComponentHelper::load():434}() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 9 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 8 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 7 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 6 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 5 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.23 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 5.667 MB Rows returned: 5
SELECT id, rules
FROM `qqrl9_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.03 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 9 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 8 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 7 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 6 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 5 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 5.677 MB Rows returned: 2
SELECT b.id
FROM qqrl9_usergroups AS a
LEFT JOIN qqrl9_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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.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.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.00 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.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 10 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 9 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 8 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 7 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 6 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 5 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.82 ms After last query: 0.08 ms Query memory: 0.077 MB Memory before query: 5.698 MB Rows returned: 101
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qqrl9_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 296 Using where; Using filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.52 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 10 Joomla\CMS\Plugin\PluginHelper::{closure:Joomla\CMS\Plugin\PluginHelper::load():323}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 7 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 6 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 5 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.30 ms After last query: 2.06 ms Query memory: 0.021 MB Memory before query: 5.998 MB Rows returned: 1Duplicate queries: #10
SELECT a.template
FROM `qqrl9_template_styles` AS a
WHERE client_id = 0
AND a.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_client_id,idx_client_id_home idx_client_id 1 const 6 Using where Status Duration Starting 0.03 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.02 ms Optimizing 0.02 ms Statistics 0.05 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.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504 9 Yjsg::getDefaultTemplate() JROOT/plugins/system/yjsg/yjsg.php:122 8 plgSystemYjsg->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 7 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.58 ms After last query: 0.80 ms Query memory: 0.023 MB Memory before query: 6.164 MB Rows returned: 49
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jdownloads','com_joomlaupdate','com_languages','com_login','com_mailto','com_matches','com_maximenuck','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_opponent','com_playeral','com_playlist','com_plugins','com_postinstall','com_privacy','com_recordbook','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_thisday','com_tlpteam','com_uniterevolution2','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_assets range idx_asset_name idx_asset_name 202 NULL 50 Using index condition 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.01 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.22 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 13 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 12 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 11 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 10 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 9 Joomla\CMS\User\User->authorise() JROOT/plugins/system/yjsg/yjsg.php:132 8 plgSystemYjsg->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 7 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.25 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 6.227 MB Rows returned: 1Duplicate queries: #8
SELECT a.template
FROM `qqrl9_template_styles` AS a
WHERE client_id = 0
AND a.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_client_id,idx_client_id_home idx_client_id 1 const 6 Using where Status Duration Starting 0.03 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.01 ms Optimizing 0.01 ms Statistics 0.03 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.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504 9 Yjsg::getDefaultTemplate() JROOT/plugins/system/yjsg/yjsg.php:133 8 plgSystemYjsg->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 7 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.28 ms After last query: 2.39 ms Query memory: 0.022 MB Memory before query: 6.456 MB Rows returned: 1Duplicate queries: #12
SELECT template
FROM qqrl9_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 ref idx_client_id,idx_client_id_home idx_client_id 1 const 6 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.03 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.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 12 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 11 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 10 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 9 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 8 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 7 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.463 MB Rows returned: 1Duplicate queries: #11
SELECT template
FROM qqrl9_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 ref idx_client_id,idx_client_id_home idx_client_id 1 const 6 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 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.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 14 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 12 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 11 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 10 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 9 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 8 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 7 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.24 ms After last query: 0.51 ms Query memory: 0.021 MB Memory before query: 6.592 MB Rows returned: 2
SELECT extension, file, type
FROM qqrl9_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 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.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 9 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 8 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 7 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 6 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 1.35 ms After last query: 10.36 ms Query memory: 0.023 MB Memory before query: 6.841 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `qqrl9_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_extensions`Status Duration Starting 0.09 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.64 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.16 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Removing tmp table 0.13 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 11 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 9 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.37 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 6.870 MB Rows returned: 1
SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index 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.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 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.00 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 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:46 9 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.30 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 6.876 MB Rows returned: 1Duplicate queries: #18
SELECT *
FROM qqrl9_extensions
WHERE `extension_id` = '10223'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 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.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 10 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 9 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 6.882 MB Rows returned: 1
SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.02 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 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.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:69 9 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.28 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 6.888 MB Rows returned: 1Duplicate queries: #16
SELECT *
FROM qqrl9_extensions
WHERE `extension_id` = '10223'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 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.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 10 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 9 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.28 ms After last query: 10.43 ms Query memory: 0.021 MB Memory before query: 7.041 MB Rows returned: 1
SELECT count(*)
FROM `qqrl9_cwgears_schedule`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwgears_schedule ALL NULL NO INDEX KEY COULD BE USED NULL NULL 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.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 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.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:103 9 plgSystemCwgears->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.24 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 7.046 MB Rows returned: 1
SELECT count(*)
FROM `qqrl9_cwgears_schedule`
WHERE time + '86400'<'1793618585'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwgears_schedule ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 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.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:146 9 plgSystemCwgears->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 5 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 4 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 1.48 ms After last query: 0.76 ms Query memory: 1.169 MB Memory before query: 7.075 MB Rows returned: 211
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 qqrl9_menu AS m
LEFT JOIN qqrl9_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,wdbi_client_id_published_lft_parent_id_53ead0dcf209 NO INDEX KEY COULD BE USED NULL NULL 317 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 u887698322_new1.m.component_id 1 Using where 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.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 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.04 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 18 Joomla\CMS\Menu\SiteMenu->{closure:Joomla\CMS\Menu\SiteMenu::load():77}() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 15 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 14 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 13 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 12 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 11 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 10 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 9 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 8 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 7 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 6 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.41 ms After last query: 6.33 ms Query memory: 0.021 MB Memory before query: 8.544 MB Rows returned: 6
SELECT id, home, template, s.params
FROM qqrl9_template_styles as s
LEFT JOIN qqrl9_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 ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 6 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 u887698322_new1.s.template,const 1 Using index condition; Using where 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.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 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.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/yjsg/yjsg.php:231 9 plgSystemYjsg->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 1.11 ms After last query: 4.20 ms Query memory: 0.029 MB Memory before query: 8.567 MB Rows returned: 334
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms checking permissions 0.78 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.00 ms Removing tmp table 0.03 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 10 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jdownloads/jdownloads.php:220 9 plgSystemjdownloads->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.22 ms After last query: 0.69 ms Query memory: 0.021 MB Memory before query: 8.576 MB Rows returned: 0
SELECT ip
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic_knownips ref idx_state idx_state 1 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:158 9 plgSystemCwtrafficCount->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.19 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 8.581 MB Rows returned: 0
SELECT botname
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic_knownips ref idx_state idx_state 1 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:186 9 plgSystemCwtrafficCount->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 8.586 MB Rows returned: 1
SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE iphash = UNHEX(SHA1('216.73.217.128'))
AND tm + '86400'>'1793618585'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic ref idx_iphash,idx_iphashtm idx_iphashtm 20 const 1 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 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.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:242 9 plgSystemCwtrafficCount->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 1.10 ms After last query: 0.23 ms Query memory: 0.029 MB Memory before query: 8.592 MB Rows returned: 328Duplicate queries: #28
SELECT id, ip
FROM `qqrl9_cwtraffic`
WHERE country_code = "" OR country_code is nullid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic ref_or_null wdbi_country_code_a0cb144d0696 wdbi_country_code_a0cb144d0696 33 const 329 Using index condition Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.81 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:62 10 CoalawebtrafficHelperLocation::location_updatev2() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 9 plgSystemCwtrafficCount->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.89 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 8.766 MB Rows returned: 328Duplicate queries: #27
SELECT id, ip
FROM `qqrl9_cwtraffic`
WHERE country_code = "" OR country_code is nullid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic ref_or_null wdbi_country_code_a0cb144d0696 wdbi_country_code_a0cb144d0696 33 const 329 Using index condition Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.65 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:67 10 CoalawebtrafficHelperLocation::location_updatev2() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 9 plgSystemCwtrafficCount->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.47 ms After last query: 241.18 ms Query memory: 0.005 MB Memory before query: 8.772 MB
UPDATE qqrl9_cwtraffic
SET city = NULL
WHERE city = ""EXPLAIN not possible on query: UPDATE qqrl9_cwtraffic SET city = NULL WHERE city = ""Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.05 ms checking permissions 0.01 ms After opening tables 0.01 ms init for update 0.01 ms init 0.02 ms Updating main table 0.01 ms init 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms init for update 0.06 ms Searching rows for update 0.02 ms Updating 0.01 ms End of update loop 0.01 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.00 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 11 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:100 10 CoalawebtrafficHelperLocation::location_updatev2() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 9 plgSystemCwtrafficCount->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.38 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 8.625 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition 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.01 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 18 Joomla\CMS\Helper\LibraryHelper::{closure:Joomla\CMS\Helper\LibraryHelper::loadLibrary():157}() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 15 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 14 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 13 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:202 9 plgSystemCwgears->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.29 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 8.618 MB
UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"4a5f9a954becd6592b6a051e16020709\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `qqrl9_extensions` SET `params` = '{\"mediaversion\":\"4a5f9a954becd6592b6a051e16020709\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms checking permissions 0.01 ms After opening tables 0.01 ms init for update 0.01 ms init 0.01 ms Updating main table 0.01 ms init 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms init for update 0.04 ms Updating 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:202 9 plgSystemCwgears->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 23.59 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 8.626 MB Rows returned: 0
SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `qqrl9_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 50id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic index NULL unique_tm_ip 156 NULL 16727 Using index; Using temporary; Using filesort Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 22.70 ms Creating sort index 0.58 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:132 9 plgSystemCwtrafficClean->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 1.29 ms After last query: 0.05 ms Query memory: 0.177 MB Memory before query: 8.632 MB Rows returned: 5112
SELECT TCOUNT
FROM `qqrl9_cwtraffic_total`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic_total ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5112 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 1.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:221 9 plgSystemCwtrafficClean->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.23 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 8.638 MB Rows returned: 1
SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE tm < '1792882800'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwtraffic range unique_tm_ip,unique_tm_iphash,idx_tm unique_tm_ip 4 NULL 1 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:289 9 plgSystemCwtrafficClean->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 7 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 6 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 5 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 4 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.28 ms After last query: 1.71 ms Query memory: 0.019 MB Memory before query: 8.682 MB Rows returned: 1
SELECT *
FROM qqrl9_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 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.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 7 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 6 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 5 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 4 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 1.63 ms After last query: 1.64 ms Query memory: 0.039 MB Memory before query: 8.738 MB Rows returned: 6
SELECT DISTINCT a.*,uc.name AS editor
FROM `qqrl9_tlpteam_team` AS a
LEFT JOIN qqrl9_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qqrl9_users AS created_by
ON created_by.id = a.created_by
WHERE a.state = 1
ORDER BY ordering asc
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using where; Using temporary; Using filesort 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 u887698322_new1.a.checked_out 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.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.95 ms Creating sort index 0.12 ms Removing tmp table 0.14 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.04 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tlpteam/models/teams.php:243 13 TlpteamModelTeams->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tlpteam/views/teams/view.html.php:31 11 TlpteamViewTeams->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tlpteam/controller.php:32 9 TlpteamController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tlpteam/tlpteam.php:22 7 require_once JROOT/components/com_tlpteam/tlpteam.php JROOT/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.29 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 8.775 MB Rows returned: 1
SELECT COUNT(*)
FROM `qqrl9_tlpteam_team` AS a
LEFT JOIN qqrl9_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qqrl9_users AS created_by
ON created_by.id = a.created_by
WHERE a.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using where 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.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 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.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 14 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 13 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tlpteam/views/teams/view.html.php:32 11 TlpteamViewTeams->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tlpteam/controller.php:32 9 TlpteamController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tlpteam/tlpteam.php:22 7 require_once JROOT/components/com_tlpteam/tlpteam.php JROOT/libraries/src/Component/ComponentHelper.php:402 6 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 5 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 4 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 3 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.80 ms After last query: 10.38 ms Query memory: 0.512 MB Memory before query: 8.979 MB Rows returned: 253
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qqrl9_modules AS m
LEFT JOIN qqrl9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qqrl9_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 <= '2026-11-02 11:23:05')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-02 11:23:05')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 331 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 77 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 u887698322_new1.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 u887698322_new1.m.id 11 Using where Status Duration Starting 0.12 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.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.37 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 13 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 12 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 11 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 10 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/joothemes-transport/includes/params.php:14 9 include JROOT/templates/joothemes-transport/includes/params.php JROOT/templates/joothemes-transport/index.php:15 8 require JROOT/templates/joothemes-transport/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 7 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 6 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 5 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 4 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 3 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 1.14 ms After last query: 2.55 ms Query memory: 0.029 MB Memory before query: 8.977 MB Rows returned: 334
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms checking permissions 0.86 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 12 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 11 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/mobilemenuck/helpers/helper.php:186 10 Mobilemenuck\Helper::searchTable() JROOT/plugins/system/mobilemenuck/helpers/helper.php:174 9 Mobilemenuck\Helper::checkIsProVersion() JROOT/plugins/system/mobilemenuck/mobilemenuck.php:634 8 PlgSystemMobilemenuck->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 4 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 3 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.38 ms After last query: 0.47 ms Query memory: 0.034 MB Memory before query: 9.010 MB Rows returned: 643
SELECT guest, client_id
FROM qqrl9_session
WHERE client_id IS NULLid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_session ref client_id_guest client_id_guest 2 const 588 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:45 12 ModWhosonlineHelper::getOnlineCount() JROOT/modules/mod_whosonline/mod_whosonline.php:19 11 include JROOT/modules/mod_whosonline/mod_whosonline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 10 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 9 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 8 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 7 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 6 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 5 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 4 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 3 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.19 ms After last query: 3.95 ms Query memory: 0.022 MB Memory before query: 9.555 MB Rows returned: 0
SELECT uikit
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwgears ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:64 14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:430 13 plgSystemCwgears->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 9 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 7 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 6 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 5 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 4 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 3 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 9.561 MB Rows returned: 0
SELECT uikit_plus
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qqrl9_cwgears ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.03 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:64 14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:439 13 plgSystemCwgears->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 9 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 7 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 6 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 5 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 4 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 3 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110 - Query Time: 0.83 ms After last query: 0.24 ms Query memory: 0.028 MB Memory before query: 9.617 MB Rows returned: 334
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms checking permissions 0.60 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 9 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jdownloads/jdownloads.php:116 8 plgSystemjdownloads->onAfterRender() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 4 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 3 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 2 Joomla\CMS\Application\CMSApplication->execute() JROOT/indexx.php:49 1 include JROOT/indexx.php JROOT/index.php:110
34 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions`2 × SELECT a.template
FROM `qqrl9_template_styles` AS a2 × SELECT template
FROM qqrl9_template_styles as s2 × SELECT `extension_id`
FROM `qqrl9_extensions`2 × SELECT *
FROM qqrl9_extensions2 × SELECT count(*)
FROM `qqrl9_cwtraffic`2 × SELECT id, ip
FROM `qqrl9_cwtraffic`1 × SELECT `data`
FROM `qqrl9_session`1 × SELECT `session_id`
FROM `qqrl9_session`1 × SELECT id, rules
FROM `qqrl9_viewlevels1 × SELECT b.id
FROM qqrl9_usergroups AS a
LEFT JOIN qqrl9_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qqrl9_extensions1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets`1 × SELECT extension, file, type
FROM qqrl9_rokcommon_configs1 × SELECT count(*)
FROM `qqrl9_cwgears_schedule1 × SELECT count(*)
FROM `qqrl9_cwgears_schedule`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qqrl9_menu AS m
LEFT JOIN qqrl9_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM qqrl9_template_styles as s
LEFT JOIN qqrl9_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT ip
FROM `qqrl9_cwtraffic_knownips`1 × SELECT botname
FROM `qqrl9_cwtraffic_knownips`1 × SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `qqrl9_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 51 × SELECT TCOUNT
FROM `qqrl9_cwtraffic_total1 × SELECT *
FROM qqrl9_languages1 × SELECT DISTINCT a.*,uc.name AS editor
FROM `qqrl9_tlpteam_team` AS a
LEFT JOIN qqrl9_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qqrl9_users AS created_by
ON created_by.id = a.created_by1 × SELECT COUNT(*)
FROM `qqrl9_tlpteam_team` AS a
LEFT JOIN qqrl9_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qqrl9_users AS created_by
ON created_by.id = a.created_by1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qqrl9_modules AS m
LEFT JOIN qqrl9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qqrl9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT guest, client_id
FROM qqrl9_session1 × SELECT uikit
FROM `qqrl9_cwgears`1 × SELECT uikit_plus
FROM `qqrl9_cwgears`
OTHER Tables:
3 × SHOW TABLE
1 × INSERT INTO `qqrl9_session` (`session_id`,`guest`,`time`,`userid`,`username`)
VALUES (X'3364336639313463326334666432393261333562653864633161316232623839', 1, 1793618585, 0, ''1 × SHOW FULL COLUMNS
FROM `qqrl9_extensions1 × UPDATE qqrl9_cwtraffic
SET city = NULL1 × UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"4a5f9a954becd6592b6a051e16020709\"}'