 |
Experienced and versatile player who signed Southern League forms in November 2011 but had been with the Saints since the summer as coach to the successful City Youth Midweek team.
A familiar face in the Isthmian and Southern League’s having played for the likes of Harpenden Town, Barton Rovers, Chesham United, Leighton Town, Wealdstone, Arlesey Town, and Dunstable.
Started his career with Sheffield Wednesday (also had a trial for Sheffield United) and had spells with fellow northern clubs Rotherham United, Sheffield, Denaby United, Worksop and Lincoln United.
Joined forces with Graham Golds to form a managership partnership at Clarence Park and guided The Saints to promotion via a play-off win against Chesham United in the 2013/14 season.
|
|
James Gray's managerial record
|
|
Season
|
Games
|
Won
|
Drawn
|
Lost
|
Win%
|
|
Season 2012-13
|
29 |
13 |
4 |
12 |
44.83 |
|
Season 2013-14
|
65 |
37 |
14 |
14 |
56.92 |
|
Season 2014-15
|
51 |
22 |
7 |
22 |
43.14 |
|
Season 2015-16
|
23 |
7 |
4 |
12 |
30.43 |
|
Total
|
168
|
79
|
29
|
60
|
47.02
|
|
James Gray's full debut
|
|
05.11.2011 at 19:45
|
Evo-Stik League Southern Premier Division |
A |
Oxford City
|
1 - 3 |
|
Latest opening squad appearances (max.10)James Gray started
|
|
12.11.2013 at 15:00
|
Herts Senior Cup / 1st Round |
A |
Royston Town
|
3 - 1 |
|
02.09.2013 at 19:45
|
Calor League Premier Division |
A |
Hitchin Town
|
1 - 1 |
|
31.08.2013 at 15:00
|
Calor League Premier Division |
H |
Corby Town
|
1 - 0 |
|
16.02.2013 at 15:00
|
Evo-Stik League Southern Premier Division |
H |
Bideford
|
4 - 3 |
|
02.02.2013 at 15:00
|
Evo-Stik League Southern Premier Division |
A |
Arlesey Town
|
3 - 1 |
|
Latest matches where player has scored one or more goals (max. 10)James Gray scored
|
|
01.09.2012 at 15:00
|
Evo-Stik League Southern Premier Division |
H |
Stourbridge
|
2 - 4 |
|
11.08.2012 at 15:00
|
Herts Charity Cup / 1st Round |
A |
Royston Town
|
3 - 2 |
|
28.01.2012 at 15:00
|
Evo-Stik League Southern Premier Division |
H |
Bedford Town
|
1 - 2 |
|
21.01.2012 at 15:00
|
Evo-Stik League Southern Premier Division |
H |
Swindon Supermarine
|
2 - 1 |
|
10.12.2011 at 15:00
|
Evo-Stik League Southern Premier Division |
A |
Hitchin Town
|
3 - 0 |
|
|
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1793366269,
"last": 1793366269,
"now": 1793366269
},
"token": "nUD02xN605U0wEmcnk70gbNlScJvh1IJ"
},
"registry": {
"com_tlpteam": {
"edit": {
"team": {
"id": "1231"
}
}
}
},
"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.43 MB (10,936,528 Bytes) 49 Queries Logged 95.33 msQuery Time: 0.28 ms Query memory: 0.023 MB Memory before query: 5.595 MB Rows returned: 0 SELECT `data`
FROM `qqrl9_session`
WHERE `session_id` = X'3830353561623662383233626236316432323130363961323738663734633932' | 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.09 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.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: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.20 ms After last query: 0.28 ms Query memory: 0.020 MB Memory before query: 5.606 MB Rows returned: 0 SELECT `session_id`
FROM `qqrl9_session`
WHERE `session_id` = X'3830353561623662383233626236316432323130363961323738663734633932'
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.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 | | 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 |
|---|
| 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.22 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 5.611 MB INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'3830353561623662383233626236316432323130363961323738663734633932', 1, 1793366269, 0, '') EXPLAIN not possible on query: INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'3830353561623662383233626236316432323130363961323738663734633932', 1, 1793366269, 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.01 ms | | table lock | 0.01 ms | | init for update | 0.01 ms | | Update | 0.03 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.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.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.43 ms After last query: 0.40 ms Query memory: 0.038 MB Memory before query: 5.641 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.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.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.14 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.41 ms Query memory: 0.021 MB Memory before query: 5.667 MB Rows returned: 5 SELECT id, rules
FROM `qqrl9_viewlevels` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.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: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.28 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 5.678 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.02 ms | | Statistics | 0.04 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.61 ms After last query: 0.09 ms Query memory: 0.077 MB Memory before query: 5.699 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.04 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.02 ms | | Optimizing | 0.03 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.33 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.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.26 ms After last query: 1.70 ms Query memory: 0.021 MB Memory before query: 5.999 MB Rows returned: 1 SELECT a.template
FROM `qqrl9_template_styles` AS a
WHERE client_id = 0
AND a.home = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.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.50 ms After last query: 0.59 ms Query memory: 0.023 MB Memory before query: 6.165 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.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.03 ms | | Optimizing | 0.01 ms | | Statistics | 0.07 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.27 ms Query memory: 0.021 MB Memory before query: 6.228 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.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.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.34 ms After last query: 2.73 ms Query memory: 0.022 MB Memory before query: 6.456 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.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.02 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.29 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.463 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.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.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/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.30 ms After last query: 0.89 ms Query memory: 0.021 MB Memory before query: 6.592 MB Rows returned: 2 SELECT extension, file, type
FROM qqrl9_rokcommon_configs
ORDER BY 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 | | 9 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 | | 8 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 7 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 | | 6 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.35 ms After last query: 8.79 ms Query memory: 0.023 MB Memory before query: 6.842 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.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.60 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.02 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | checking permissions | 0.19 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.07 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Removing tmp table | 0.14 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.34 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 6.871 MB Rows returned: 1 SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.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.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 |
|---|
| 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.31 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 6.877 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.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.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.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 |
|---|
| 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.31 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 6.883 MB Rows returned: 1 SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.02 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 11 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 | | 10 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:69 | | 9 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.28 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 6.889 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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.45 ms After last query: 8.38 ms Query memory: 0.021 MB Memory before query: 7.042 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.08 ms | | checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.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.06 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.32 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 7.047 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwgears_schedule`
WHERE time + '86400'<'1793366269' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears_schedule | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.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.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 |
|---|
| 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: 2.57 ms After last query: 0.83 ms Query memory: 1.169 MB Memory before query: 7.076 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.08 ms | | checking permissions | 0.02 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.06 ms | | Preparing | 0.03 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 1.99 ms | | End of update loop | 0.03 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.05 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.60 ms After last query: 7.07 ms Query memory: 0.021 MB Memory before query: 8.545 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.10 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.07 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.08 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.63 ms After last query: 4.42 ms Query memory: 0.029 MB Memory before query: 8.568 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.05 ms | | checking permissions | 0.01 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.02 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | checking permissions | 1.17 ms | | Executing | 0.01 ms | | Sending data | 0.08 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.33 ms After last query: 0.94 ms Query memory: 0.021 MB Memory before query: 8.577 MB Rows returned: 0 SELECT ip
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic_knownips | ref | idx_state | idx_state | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.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 |
|---|
| 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.30 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 8.581 MB Rows returned: 0 SELECT botname
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic_knownips | ref | idx_state | idx_state | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.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.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:186 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.35 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 8.586 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE iphash = UNHEX(SHA1('216.73.216.223'))
AND tm + '86400'>'1793366269' | 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 | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.05 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.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.34 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/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.92 ms After last query: 0.29 ms Query memory: 0.048 MB Memory before query: 8.593 MB Rows returned: 571 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 | 572 | 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.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 1.51 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.03 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 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: 1.67 ms After last query: 0.27 ms Query memory: 0.048 MB Memory before query: 8.890 MB Rows returned: 571 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 | 572 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 1.31 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 |
|---|
| 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.44 ms After last query: 370.86 ms Query memory: 0.005 MB Memory before query: 8.912 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.09 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | checking permissions | 0.01 ms | | After opening tables | 0.01 ms | | init for update | 0.01 ms | | init | 0.02 ms | | Updating main table | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | init for update | 0.05 ms | | Searching rows for update | 0.02 ms | | Updating | 0.04 ms | | End of update loop | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:100 | | 10 | CoalawebtrafficHelperLocation::location_updatev2() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.31 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 8.642 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.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: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.34 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 8.634 MB UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"33770a07af00e6cddc3a0e44ff66eab6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' EXPLAIN not possible on query: UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"33770a07af00e6cddc3a0e44ff66eab6\"}'
WHERE `type` = 'library' AND `element` = 'joomla' | Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | checking permissions | 0.01 ms | | After opening tables | 0.01 ms | | init for update | 0.01 ms | | init | 0.01 ms | | Updating main table | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | init for update | 0.03 ms | | Updating | 0.05 ms | | End of update loop | 0.02 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.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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: 66.80 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 8.642 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 | 43088 | 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.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Creating tmp table | 0.02 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 65.00 ms | | Creating sort index | 1.46 ms | | Removing tmp table | 0.03 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.35 ms After last query: 0.11 ms Query memory: 0.177 MB Memory before query: 8.648 MB Rows returned: 5112 SELECT TCOUNT
FROM `qqrl9_cwtraffic_total` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic_total | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5112 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.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 | 1.10 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.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:221 | | 9 | plgSystemCwtrafficClean->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 8.655 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.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.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/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.82 ms Query memory: 0.019 MB Memory before query: 8.698 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.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 | | Sorting result | 0.01 ms | | Executing | 0.01 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.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 |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 | | 6 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 | | 5 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.98 ms After last query: 1.24 ms Query memory: 0.025 MB Memory before query: 8.753 MB Rows returned: 18 SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_tlpteam_team` | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.01 ms | | Opening tables | 0.46 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.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.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.14 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.00 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.25 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 8.784 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.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.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.15 ms Query memory: 0.025 MB Memory before query: 8.798 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.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.04 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.22 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.74 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 8.812 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.38 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.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.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.09 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.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.19 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 8.834 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.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.20 ms After last query: 0.25 ms Query memory: 0.024 MB Memory before query: 8.850 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.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.76 ms After last query: 0.23 ms Query memory: 0.026 MB Memory before query: 8.855 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.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | checking permissions | 0.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.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.11 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.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.05 ms Query memory: 0.024 MB Memory before query: 8.885 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.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 |
|---|
| 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: 1.14 ms After last query: 10.97 ms Query memory: 0.512 MB Memory before query: 9.084 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-30 13:17:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-30 13:17:49')
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.03 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.04 ms | | Optimizing | 0.04 ms | | Statistics | 0.07 ms | | Preparing | 0.04 ms | | Sorting result | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.63 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.02 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | Same as call in the line below. | | 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 | | 13 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 | | 12 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | | 11 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 | | 10 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/joothemes-transport/includes/params.php:14 | | 9 | include JROOT/templates/joothemes-transport/includes/params.php | JROOT/templates/joothemes-transport/index.php:15 | | 8 | require JROOT/templates/joothemes-transport/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 7 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 6 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 5 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.33 ms After last query: 2.80 ms Query memory: 0.029 MB Memory before query: 9.082 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.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.94 ms | | Executing | 0.02 ms | | Sending data | 0.08 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.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 |
|---|
| 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.50 ms After last query: 0.72 ms Query memory: 0.030 MB Memory before query: 9.116 MB Rows returned: 385 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 | 375 | 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.05 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.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.32 ms After last query: 5.96 ms Query memory: 0.022 MB Memory before query: 9.661 MB Rows returned: 0 SELECT uikit
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/1231' | 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.26 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 9.668 MB Rows returned: 0 SELECT uikit_plus
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/1231' | 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.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/helpers/loadcount.php:64 | | 14 | CwGearsHelperLoadcount::getCounts() | JROOT/plugins/system/cwgears/cwgears.php:439 | | 13 | plgSystemCwgears->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 | | 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 11 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 10 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 | | 9 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 | | 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 | | 7 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 | | 6 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 | | 5 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.28 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 9.716 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | checking permissions | 0.84 ms | | Executing | 0.02 ms | | Sending data | 0.08 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Removing tmp table | 0.08 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 |
|---|
| 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'3830353561623662383233626236316432323130363961323738663734633932', 1, 1793366269, 0, '' 1 × SHOW FULL COLUMNS
FROM `qqrl9_extensions 1 × UPDATE qqrl9_cwtraffic
SET city = NULL 1 × UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"33770a07af00e6cddc3a0e44ff66eab6\"}' 1 × SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team 1 × SHOW FULL COLUMNS
FROM `qqrl9_assets 1 × SHOW FULL COLUMNS
FROM `qqrl9_users
|
