John Colfer
Born: 30/10/1963 ,
,
|
 |
During 142 games for the club he proved himself to be a versatile player who featured in most of the defensive and midfield positions, and on 30 March 1991 he even played in goal during a 3-3 Isthmian League draw at Barking.
Well known for a lengthy and highly successful career in local Sunday League football he worked his way through the ranks at Clarence Park playing for the Youth and Reserve sides before making his first team debut during a Herts Charity Cup defeat at Hitchin Town on 12 August 1989. Ended the season with runners up medals in both the Isthmian League Cup and Herts Senior Cup.
Probably his finest hour for the Saints came on 24 October 1992 when he played during a 4th Round Qualifying FA Cup victory away to Telford United – forty minutes before kick off he was sitting in the clubhouse drinking with supporters unaware that injuries were about to change his day.
That season saw him combine his playing with the position of Commercial Manager at Clarence Park.
|
|
John Colfer's full debut
|
|
12.08.1989 at 15:00
|
Herts Charity Cup / 1st Rd |
A |
Hitchin Town
|
1 - 4 |
|
Latest matches where player has scored one or more goals (max. 10)John Colfer scored
|
|
19.01.1991 at 15:00
|
Vauxhall Premier League |
A |
Dagenham
|
2 - 2 |
|
26.12.1990 at 13:00
|
Vauxhall Premier League |
H |
Hendon
|
3 - 0 |
|
06.01.1990 at 15:00
|
Vauxhall Premier League |
H |
Hayes
|
3 - 0 |
|
07.10.1989 at 15:00
|
Vauxhall Premier League |
H |
Windsor & Eton
|
2 - 4 |
|
30.09.1989 at 15:00
|
Vauxhall Premier League |
A |
Bognor Regis Town
|
1 - 3 |
|
|
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1793113464,
"last": 1793113464,
"now": 1793113464
},
"token": "efqkxvaa7xhR9GYlSW7ZAUrUaztGRmid"
},
"registry": {
"com_tlpteam": {
"edit": {
"team": {
"id": "657"
}
}
}
},
"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.20 MB (10,695,032 Bytes) 49 Queries Logged 66.45 msQuery Time: 0.25 ms Query memory: 0.023 MB Memory before query: 5.388 MB Rows returned: 0 SELECT `data`
FROM `qqrl9_session`
WHERE `session_id` = X'3630363430666437383637323566346565343863303032346666396365613364' | 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.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.02 ms | | Preparing | 0.01 ms | | Executing | 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 |
|---|
| 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.18 ms After last query: 0.28 ms Query memory: 0.020 MB Memory before query: 5.399 MB Rows returned: 0 SELECT `session_id`
FROM `qqrl9_session`
WHERE `session_id` = X'3630363430666437383637323566346565343863303032346666396365613364'
LIMIT 1 | 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.03 ms | | checking permissions | 0.02 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.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 9 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 | | 8 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 | | 7 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | | 6 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | | 5 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | | 4 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | | 3 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 2 | Joomla\CMS\Factory::getApplication() | JROOT/indexx.php:46 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.24 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 5.404 MB INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'3630363430666437383637323566346565343863303032346666396365613364', 1, 1793113464, 0, '') EXPLAIN not possible on query: INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'3630363430666437383637323566346565343863303032346666396365613364', 1, 1793113464, 0, '') | 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 for update | 0.01 ms | | Update | 0.06 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.03 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 | | 8 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 | | 7 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | | 6 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | | 5 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | | 4 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | | 3 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 2 | Joomla\CMS\Factory::getApplication() | JROOT/indexx.php:46 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.34 ms After last query: 0.38 ms Query memory: 0.038 MB Memory before query: 5.434 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.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.11 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.22 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 5.460 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.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.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.25 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 5.471 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.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.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: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.52 ms After last query: 0.09 ms Query memory: 0.077 MB Memory before query: 5.492 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.01 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.29 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/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.28 ms After last query: 1.87 ms Query memory: 0.021 MB Memory before query: 5.792 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.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504 | | 9 | Yjsg::getDefaultTemplate() | JROOT/plugins/system/yjsg/yjsg.php: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.53 ms After last query: 0.72 ms Query memory: 0.023 MB Memory before query: 5.895 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.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.03 ms | | Optimizing | 0.02 ms | | Statistics | 0.11 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.17 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | | 13 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | | 12 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | | 11 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 10 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 9 | Joomla\CMS\User\User->authorise() | JROOT/plugins/system/yjsg/yjsg.php:132 | | 8 | plgSystemYjsg->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 7 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 | | 6 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.25 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 5.959 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.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.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 |
|---|
| 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: 3.54 ms Query memory: 0.022 MB Memory before query: 6.249 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.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.21 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.256 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.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.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 15 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 | | 14 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 | | 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 | | 12 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 | | 11 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 | | 10 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 | | 9 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 | | 8 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 7 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 | | 6 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.24 ms After last query: 0.88 ms Query memory: 0.021 MB Memory before query: 6.386 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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.02 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: 0.96 ms After last query: 11.57 ms Query memory: 0.023 MB Memory before query: 6.635 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.05 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.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.07 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.07 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.01 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.29 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 6.664 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.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.02 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.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.22 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 6.670 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.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.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: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.21 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 6.676 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.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.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.20 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 6.682 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.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.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.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: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.23 ms After last query: 10.16 ms Query memory: 0.021 MB Memory before query: 6.835 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.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php: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.27 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 6.840 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwgears_schedule`
WHERE time + '86400'<'1793113464' | 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.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.05 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.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.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:146 | | 9 | plgSystemCwgears->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.58 ms After last query: 0.70 ms Query memory: 1.169 MB Memory before query: 6.869 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.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 1.25 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.39 ms After last query: 6.27 ms Query memory: 0.021 MB Memory before query: 8.338 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.06 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.05 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.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/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.10 ms After last query: 4.30 ms Query memory: 0.029 MB Memory before query: 8.361 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.02 ms | | Opening tables | 0.04 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.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.74 ms | | Executing | 0.02 ms | | Sending data | 0.07 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.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.24 ms After last query: 0.88 ms Query memory: 0.021 MB Memory before query: 8.370 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.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.02 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.03 ms Query memory: 0.021 MB Memory before query: 8.374 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.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:186 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 8.379 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE iphash = UNHEX(SHA1('216.73.217.85'))
AND tm + '86400'>'1793113464' | 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 | 3 | 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.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.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:242 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.21 ms After last query: 0.26 ms Query memory: 0.029 MB Memory before query: 8.386 MB Rows returned: 501 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 | 502 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.93 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:62 | | 10 | CoalawebtrafficHelperLocation::location_updatev2() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.96 ms After last query: 0.22 ms Query memory: 0.029 MB Memory before query: 8.642 MB Rows returned: 501 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 | 502 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.71 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: 341.37 ms Query memory: 0.005 MB Memory before query: 8.648 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.00 ms | | init | 0.01 ms | | Updating main table | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.00 ms | | init | 0.01 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.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.30 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 8.419 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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.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.00 ms | | Query end | 0.00 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.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.27 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 8.412 MB UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"98e1e157f4dbe1e1bd3a07926ee33ab5\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' EXPLAIN not possible on query: UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"98e1e157f4dbe1e1bd3a07926ee33ab5\"}'
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.01 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.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.00 ms | | init for update | 0.03 ms | | Updating | 0.04 ms | | End of update loop | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.03 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.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 | | 14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 | | 13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 | | 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/cwgears/cwgears.php:202 | | 9 | plgSystemCwgears->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 43.97 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 8.420 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 | 38323 | Using index; Using temporary; Using filesort |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.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.01 ms | | Sending data | 42.41 ms | | Creating sort index | 1.24 ms | | Removing tmp table | 0.02 ms | | Creating sort index | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 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.54 ms After last query: 0.10 ms Query memory: 0.177 MB Memory before query: 8.426 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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 1.26 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.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.26 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 8.432 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE tm < '1790204400' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic | range | unique_tm_ip,unique_tm_iphash,idx_tm | unique_tm_ip | 4 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.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.04 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.02 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.32 ms After last query: 1.70 ms Query memory: 0.019 MB Memory before query: 8.476 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.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.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.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 | | 6 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 | | 5 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.00 ms After last query: 1.24 ms Query memory: 0.025 MB Memory before query: 8.531 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.03 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.51 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.01 ms | | checking permissions | 0.09 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.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.13 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.24 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 8.561 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.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.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 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.47 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 8.576 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.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.02 ms | | Statistics | 0.04 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.20 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.76 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 8.589 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.41 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.01 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.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.02 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.20 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 8.612 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.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.02 ms | | Preparing | 0.01 ms | | Executing | 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.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.21 ms After last query: 0.27 ms Query memory: 0.024 MB Memory before query: 8.627 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.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.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 |
|---|
| 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.75 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 8.632 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.02 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.36 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 | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.04 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.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.21 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 8.663 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.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.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 |
|---|
| 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.87 ms After last query: 12.36 ms Query memory: 0.512 MB Memory before query: 8.854 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-10-27 15:04:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-27 15:04:24')
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.09 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.06 ms | | Preparing | 0.03 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.44 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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: 0.93 ms After last query: 2.90 ms Query memory: 0.029 MB Memory before query: 8.852 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.03 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Filling schema table | 0.00 ms | | checking permissions | 0.67 ms | | Executing | 0.01 ms | | Sending data | 0.06 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 12 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 | | 11 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/mobilemenuck/helpers/helper.php:186 | | 10 | Mobilemenuck\Helper::searchTable() | JROOT/plugins/system/mobilemenuck/helpers/helper.php:174 | | 9 | Mobilemenuck\Helper::checkIsProVersion() | JROOT/plugins/system/mobilemenuck/mobilemenuck.php:634 | | 8 | PlgSystemMobilemenuck->onBeforeRender() | JROOT/libraries/joomla/event/event.php:70 | | 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1102 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.26 ms After last query: 0.57 ms Query memory: 0.025 MB Memory before query: 8.886 MB Rows returned: 166 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 | 166 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.06 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.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 13 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_whosonline/helper.php:45 | | 12 | ModWhosonlineHelper::getOnlineCount() | JROOT/modules/mod_whosonline/mod_whosonline.php:19 | | 11 | include JROOT/modules/mod_whosonline/mod_whosonline.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 10 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 9 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 | | 8 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 | | 7 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 | | 6 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 | | 5 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.27 ms After last query: 3.95 ms Query memory: 0.022 MB Memory before query: 9.431 MB Rows returned: 0 SELECT uikit
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/657' | 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.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.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.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: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.22 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 9.437 MB Rows returned: 0 SELECT uikit_plus
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/657' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.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.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: 0.95 ms After last query: 0.24 ms Query memory: 0.028 MB Memory before query: 9.485 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.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | checking permissions | 0.66 ms | | Executing | 0.01 ms | | Sending data | 0.06 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.01 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 |
|---|
| 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 |
38 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 `session_id`
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 × INSERT INTO `qqrl9_session` (`session_id`,`guest`,`time`,`userid`,`username`)
VALUES (X'3630363430666437383637323566346565343863303032346666396365613364', 1, 1793113464, 0, '' 1 × SHOW FULL COLUMNS
FROM `qqrl9_extensions 1 × UPDATE qqrl9_cwtraffic
SET city = NULL 1 × UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"98e1e157f4dbe1e1bd3a07926ee33ab5\"}' 1 × SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team 1 × SHOW FULL COLUMNS
FROM `qqrl9_assets 1 × SHOW FULL COLUMNS
FROM `qqrl9_users
|
