Garry Brooke
Born: 24/11/1960 , Bethnal Green, London
Died: 18/01/2025 ,
|
 |
Garry Brooke, who passed away on 18th January 2025, played 11 games for St Albans City between August 1991 and October 1992.
Garry joined the Saints from Wivenhoe Town when, in the summer of 1991, City manager John Mitchell cherry-picked the Essex club to bring Garry to Clarence Park along with Steve Clark, Jimmy King and Paul Price.
Garry didn’t score during his time at Clarence Park but his 11 games saw him play in six different competitions. He scored three goals in eight Friendlies and made two appearances for the City Reserves. One of the pre-match rituals City did back in the early 1990s was to see who could hit the crossbar most often from just outside the penalty area. Garry may have been small in stature but he was head and shoulders above everyone else in striking the woodwork
Garry will be remembered most fondly for his time spent with Tottenham Hotspur. Having joined Spurs as a ten-year-old – after a year with Arsenal - he made his First team debut ten years later and had a bit-part as a substitute during Tottenham’s F.A. Cup wins of 1981 and 1982.
During his time at Tottenham, he was involved in a serious road accident that led to him being given the last rites. Garry, however, made a full recovery although his lungs only worked to 80% capacity.
Garry left Spurs in 1985 to join Norwich City where he teamed up with future St Albans manager Ian Culverhouse. After a year-and-a-half at Carrow Road, he moved to Dutch club Groningen, and then onto Stoke City, Brentford, Reading and Wimbledon, the latter he descried as a ‘disaster.’ Moving into the non-league game he played for Baldock Town and Wivenhoe Town. After leaving St Albans, Garry signed for Worthing.
Once his playing days were over, Garry got the see Spurs every week when he worked for the Press Association. Having gained coaching qualifications he set up the Palace Soccer School and ran various Sunday Youth teams. He also turned out for Martin Chivers’ Tottenham Veterans team and for many years was landlord at a pub in Studham in Bedfordshire.
He was at Baldock at the same time as another future City manager, Ian Allinson, who paid tribute upon hearing of Garry’s death. “Garry was a lovely lad who could strike the ball beautifully, he could kick it miles.” John Mitchell also paid tribute to the player he had signed almost 34 years earlier, “Really sad to hear of Garry’s death, a nice guy, great player and will be sadly missed.”
Garry was born in Bethnal Green on 24th November 1960 and passed away on Saturday 18th January 2025, following a long illness.
|
|
Garry Brooke's full debut
|
|
13.08.1991 at 19:30
|
Herts Charity Cup / 1st Round |
A |
Boreham Wood
|
0 - 1 |
|
|
Joomla! Debug Console{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1793549359,
"last": 1793549359,
"now": 1793549362
},
"token": "LfKPzEx2q0QYEQ067Lbmfp0fqFMyz3GA"
},
"registry": {
"com_tlpteam": {
"edit": {
"team": {
"id": "612"
}
}
}
},
"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
}
}
}
10.37 MB (10,875,576 Bytes) 47 Queries Logged 38.03 msQuery Time: 0.33 ms Query memory: 0.023 MB Memory before query: 5.596 MB Rows returned: 1 SELECT `data`
FROM `qqrl9_session`
WHERE `session_id` = X'3737363462383465396239386131643962666632656534393163336632303839' | 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.07 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 | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.00 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.05 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 |
|---|
| 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.37 ms After last query: 0.34 ms Query memory: 0.038 MB Memory before query: 5.638 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` = 1 | id | 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.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.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.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.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 |
|---|
| 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.20 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 5.664 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.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 | 0.03 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.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 |
|---|
| 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.26 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 5.675 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 = 9 | id | 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.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 | | Unlocking tables | 0.00 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.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.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 |
|---|
| 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.54 ms After last query: 0.08 ms Query memory: 0.077 MB Memory before query: 5.696 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 ordering | id | 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.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.00 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.30 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.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 |
|---|
| 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.33 ms After last query: 1.47 ms Query memory: 0.021 MB Memory before query: 5.996 MB Rows returned: 1 SELECT a.template
FROM `qqrl9_template_styles` AS a
WHERE client_id = 0
AND a.home = 1 | id | 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.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.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.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.02 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.48 ms After last query: 0.65 ms Query memory: 0.023 MB Memory before query: 6.161 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.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.01 ms | | init | 0.03 ms | | Optimizing | 0.01 ms | | Statistics | 0.10 ms | | Preparing | 0.02 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.01 ms | | closing tables | 0.01 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 |
|---|
| 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.22 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 6.224 MB Rows returned: 1 SELECT a.template
FROM `qqrl9_template_styles` AS a
WHERE client_id = 0
AND a.home = 1 | id | 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.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.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.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 |
|---|
| 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.24 ms After last query: 2.91 ms Query memory: 0.022 MB Memory before query: 6.453 MB Rows returned: 1 SELECT template
FROM qqrl9_template_styles as s
WHERE s.client_id = 0
AND s.home = 1 | id | 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.00 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.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.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 |
|---|
| 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.20 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 6.460 MB Rows returned: 1 SELECT template
FROM qqrl9_template_styles as s
WHERE s.client_id = 0
AND s.home = 1 | id | 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.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.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.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 |
|---|
| 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.23 ms After last query: 0.73 ms Query memory: 0.021 MB Memory before query: 6.589 MB Rows returned: 2 SELECT extension, file, type
FROM qqrl9_rokcommon_configs
ORDER BY priority | id | 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.02 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 | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 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.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 |
|---|
| 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.05 ms After last query: 9.82 ms Query memory: 0.023 MB Memory before query: 6.839 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.06 ms | | checking permissions | 0.01 ms | | closing tables | 0.01 ms | | checking permissions | 0.00 ms | | Opening tables | 0.48 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 | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | checking permissions | 0.09 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.04 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.14 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.01 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.27 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 6.868 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.03 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.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.06 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.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: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.23 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 6.874 MB Rows returned: 1 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.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.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.00 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.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 |
|---|
| 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.25 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 6.879 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.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.02 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.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: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.24 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 6.884 MB Rows returned: 1 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.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.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.00 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.00 ms | | Query end | 0.04 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: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.24 ms After last query: 7.96 ms Query memory: 0.021 MB Memory before query: 7.038 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.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 | | 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.00 ms | | Starting cleanup | 0.01 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.20 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 7.044 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwgears_schedule`
WHERE time + '86400'<'1793549362' | 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.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.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.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.02 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.57 ms After last query: 0.53 ms Query memory: 1.169 MB Memory before query: 7.073 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.lft | id | 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.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 1.24 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 |
|---|
| 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.40 ms After last query: 3.96 ms Query memory: 0.021 MB Memory before query: 8.542 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 = 1 | id | 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.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.06 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.06 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 |
|---|
| 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.05 ms After last query: 2.54 ms Query memory: 0.029 MB Memory before query: 8.565 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.03 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.76 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.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 |
|---|
| 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.23 ms After last query: 0.48 ms Query memory: 0.021 MB Memory before query: 8.574 MB Rows returned: 0 SELECT ip
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | 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.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.02 ms | | Preparing | 0.02 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.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: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.20 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 8.578 MB Rows returned: 0 SELECT botname
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | 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.01 ms | | System lock | 0.00 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.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.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 |
|---|
| 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.29 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 8.583 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE iphash = UNHEX(SHA1('216.73.216.223'))
AND tm + '86400'>'1793549362' | 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 | 4 | 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.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.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/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: 0.73 ms After last query: 0.30 ms Query memory: 0.029 MB Memory before query: 8.590 MB Rows returned: 268 SELECT id, ip
FROM `qqrl9_cwtraffic`
WHERE country_code = "" OR country_code is null | id | 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 | 269 | 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.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.47 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.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 |
|---|
| 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.59 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 8.735 MB Rows returned: 268 SELECT id, ip
FROM `qqrl9_cwtraffic`
WHERE country_code = "" OR country_code is null | id | 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 | 269 | Using index condition |
| 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.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.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.35 ms After last query: 184.02 ms Query memory: 0.005 MB Memory before query: 8.741 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.07 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 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.00 ms | | System lock | 0.01 ms | | table lock | 0.00 ms | | init | 0.00 ms | | init for update | 0.03 ms | | Searching rows for update | 0.02 ms | | Updating | 0.04 ms | | End of update loop | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 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.00 ms | | Updating status | 0.01 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.25 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 8.623 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.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.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.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.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 |
|---|
| 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.26 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 8.616 MB UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"cba37d4b5566dd30cdac0a123c10c5a2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' EXPLAIN not possible on query: UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"cba37d4b5566dd30cdac0a123c10c5a2\"}'
WHERE `type` = 'library' AND `element` = 'joomla' | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | checking permissions | 0.00 ms | | After opening tables | 0.00 ms | | init for update | 0.00 ms | | init | 0.01 ms | | Updating main table | 0.01 ms | | init | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.00 ms | | init for update | 0.03 ms | | Updating | 0.03 ms | | End of update loop | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.04 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 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 |
|---|
| 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: 16.79 ms After last query: 0.40 ms Query memory: 0.021 MB Memory before query: 8.624 MB Rows returned: 0 SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `qqrl9_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 50 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic | index | NULL | unique_tm_ip | 156 | NULL | 14850 | Using index; Using temporary; 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.01 ms | | Creating tmp table | 0.02 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 16.00 ms | | Creating sort index | 0.56 ms | | Removing tmp table | 0.01 ms | | Creating sort index | 0.01 ms | | End of update loop | 0.00 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: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.28 ms After last query: 0.05 ms Query memory: 0.177 MB Memory before query: 8.628 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.08 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.00 ms | | Starting cleanup | 0.01 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/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.20 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 8.634 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.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.00 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.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 |
|---|
| 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.25 ms After last query: 1.46 ms Query memory: 0.020 MB Memory before query: 8.679 MB Rows returned: 1 SELECT *
FROM qqrl9_languages
WHERE published=1
ORDER BY ordering ASC | id | 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.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 | | 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.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.03 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 |
|---|
| 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: 0.85 ms After last query: 1.00 ms Query memory: 0.025 MB Memory before query: 8.733 MB Rows returned: 18 SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_tlpteam_team` | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.45 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 | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | checking permissions | 0.08 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.10 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.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 | | 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 | | 18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 | | 17 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_tlpteam/tables/team.php:26 | | 16 | TlpteamTableteam->__construct() | JROOT/libraries/src/Table/Table.php:328 | | 15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_tlpteam/models/team.php:93 | | 14 | TlpteamModelTeam->getTable() | JROOT/components/com_tlpteam/models/team.php:64 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.20 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 8.764 MB Rows returned: 1 SELECT *
FROM qqrl9_tlpteam_team
WHERE `id` = '1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_tlpteam_team | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 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.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 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.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 |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.39 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 8.778 MB Rows returned: 2 SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets`
WHERE `name` LIKE 'com_tlpteam.%' OR `name` = 'com_tlpteam' OR `parent_id` = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 619 | 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.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.17 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.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 |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 | | 20 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 | | 19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 | | 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_tlpteam/tables/team.php:142 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.68 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 8.792 MB Rows returned: 8 SHOW FULL COLUMNS
FROM `qqrl9_assets` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_assets` | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.35 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 | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.03 ms | | closing tables | 0.01 ms | | checking permissions | 0.00 ms | | Executing | 0.00 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.09 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 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 |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 | | 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 | | 22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 | | 21 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Asset.php:61 | | 20 | Joomla\CMS\Table\Asset->__construct() | JROOT/libraries/src/Access/Access.php:783 | | 19 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_tlpteam/tables/team.php:142 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.18 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 8.814 MB Rows returned: 0 SELECT *
FROM qqrl9_assets
WHERE `name` = 'com_tlpteam.team.1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 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.00 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.00 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.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 |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 21 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 20 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 | | 19 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_tlpteam/tables/team.php:142 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.16 ms After last query: 0.25 ms Query memory: 0.024 MB Memory before query: 8.829 MB Rows returned: 0 SELECT *
FROM qqrl9_assets
WHERE `name` = 'com_tlpteam.team.1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 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.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.00 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.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 | | 17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/administrator/components/com_tlpteam/tables/team.php:145 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.71 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 8.834 MB Rows returned: 17 SHOW FULL COLUMNS
FROM `qqrl9_users` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_users` | Status | Duration |
|---|
| Starting | 0.01 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.37 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.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.00 ms | | checking permissions | 0.04 ms | | closing tables | 0.01 ms | | checking permissions | 0.00 ms | | Executing | 0.00 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.09 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.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 | | 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 | | 22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 | | 21 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:41 | | 20 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:328 | | 19 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 | | 18 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:877 | | 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 | | 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 | | 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 | | 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_tlpteam/models/team.php:85 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.17 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 8.865 MB Rows returned: 0 SELECT *
FROM `qqrl9_users`
WHERE `id` = 159 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 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.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.00 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.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 |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 | | 18 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 | | 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 | | 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 | | 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 | | 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_tlpteam/models/team.php:85 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->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.86 ms After last query: 10.47 ms Query memory: 0.512 MB Memory before query: 9.056 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-01 16:09:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-01 16:09:22')
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.ordering | id | 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.11 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.06 ms | | Preparing | 0.03 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.42 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.41 ms After last query: 2.57 ms Query memory: 0.029 MB Memory before query: 9.054 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.04 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.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 | 1.02 ms | | Executing | 0.01 ms | | Sending data | 0.11 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 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 |
|---|
| 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.33 ms After last query: 0.56 ms Query memory: 0.024 MB Memory before query: 9.087 MB Rows returned: 121 SELECT guest, client_id
FROM qqrl9_session
WHERE client_id IS NULL | id | 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 | 121 | 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.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.07 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 |
|---|
| 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.29 ms After last query: 5.02 ms Query memory: 0.022 MB Memory before query: 9.632 MB Rows returned: 0 SELECT uikit
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/612' | 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.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.01 ms | | Statistics | 0.01 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.23 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 9.639 MB Rows returned: 0 SELECT uikit_plus
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/612' | 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.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.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.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 |
|---|
| 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: 1.23 ms After last query: 0.25 ms Query memory: 0.028 MB Memory before query: 9.683 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | 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.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 | | checking permissions | 0.87 ms | | Executing | 0.01 ms | | Sending data | 0.11 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.00 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/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 |
36 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 a 2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets` 2 × SELECT template
FROM qqrl9_template_styles as s 2 × SELECT `extension_id`
FROM `qqrl9_extensions` 2 × SELECT *
FROM qqrl9_extensions 2 × SELECT count(*)
FROM `qqrl9_cwtraffic` 2 × SELECT id, ip
FROM `qqrl9_cwtraffic` 2 × SELECT *
FROM qqrl9_assets 1 × SELECT `data`
FROM `qqrl9_session` 1 × SELECT id, rules
FROM `qqrl9_viewlevels 1 × SELECT b.id
FROM qqrl9_usergroups AS a
LEFT JOIN qqrl9_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qqrl9_extensions 1 × SELECT extension, file, type
FROM qqrl9_rokcommon_configs 1 × SELECT count(*)
FROM `qqrl9_cwgears_schedule 1 × 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_id 1 × 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 1 × 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 5 1 × SELECT TCOUNT
FROM `qqrl9_cwtraffic_total 1 × SELECT *
FROM qqrl9_languages 1 × SELECT *
FROM qqrl9_tlpteam_team 1 × SELECT *
FROM `qqrl9_users` 1 × 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 1 × SELECT guest, client_id
FROM qqrl9_session 1 × SELECT uikit
FROM `qqrl9_cwgears` 1 × SELECT uikit_plus
FROM `qqrl9_cwgears`
OTHER Tables:3 × SHOW TABLE 1 × SHOW FULL COLUMNS
FROM `qqrl9_extensions 1 × UPDATE qqrl9_cwtraffic
SET city = NULL 1 × UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"cba37d4b5566dd30cdac0a123c10c5a2\"}' 1 × SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team 1 × SHOW FULL COLUMNS
FROM `qqrl9_assets 1 × SHOW FULL COLUMNS
FROM `qqrl9_users
|
