Johnny Westmore
Born: 16/08/1926 ,
Died: 10/12/1914 ,
|
 |
 A right-half who could also play on the right wing, Johnny joined the City at the start of the 1953-54 season from Hendon having previously seen service with fellow north London clubs Finchley and Wealdstone. He was one of a cluster of new signings made by St Albans that summer, as the club sought to improve its fortunes after finishing in the top half of the table just once in the 13 seasons either side of World War II.
After a couple of trial matches, Johnny made his debut on 22nd August – six days after his 27th birthday – during a 1-1 draw at Clarence Park with Ilford. Included in the City side that afternoon were long time favourites Fred Collings and Ron McCormack. St Albans began the season with a seven match unbeaten run, during which Johnny scored his first goal for the club. That goal came during a 3-1 win over Romford at their old Brooklands Stadium and was most notable in that Johnny scored in the opening minute before a single Romford player had touched the ball.
Unfortunately, following a defeat at Wealdstone in the 2nd Round Qualifying of the FA Cup, the team failed to return to its earlier good form and finished the season in eighth place. Even so, this was still a position that City had bettered on only two other occasions since 1931.
Johnny played in both of our FA Amateur Cup ties that season, the first of which was the long trip to Dartmouth United. The players had the rare experience of travelling to Devon the day before the game, while the supporters coach left St Albans at midnight on the Friday. Still, it was all worthwhile as two goals from Alan Tompkins secured victory in front of Dartmouth’s record attendance of 1,104.
 In the next Round the Saints suffered a shock 2-1 defeat at home to Spartan League side Briggs Sports. Johnny played in that match and also our Herts Senior Cup semi-final defeat at Ware. But he missed our Herts Charity Cup semi-final win, this time at home to Ware, due to attending his brother Roger’s wedding. He was, however, back in the side for the final, which saw City defeat Athenian League outfit Barnet 2-0 at Underhill with another two goals from Tompkins.
Photo: Johnny Westmore challenges Barnet ‘keeper Fred Stevens with the Bees captain Ray Livermore giving cover.
St Albans continued to strengthen the squad in the run up to the 1954-55 season and Johnny looked to be very much a part of the set-up when he featured in the first ten games of the season. He was then ‘rested’ for a trip to Kingstonian and was in and out of the side before making his final appearance for St Albans City during a 2-1 1st Round Amateur Cup defeat by Woking at Kingfield on 18thDecember 1954. Johnny Westmore played 46 times for the City and scored seven times. He made a further two appearances for the City Reserves.
 After leaving Clarence Park Johnny rejoined Hendon where he stayed until the end of the 1950’s, taking his total appearances to 106 and scoring 16 times. During his first spell with the Dons he was a member of the side that reached the last four of the Amateur Cup, where they bowed out in a replay at Selhurst Park to eventual winners Pegasus following a draw at Highbury. In the previous round his goal secured a draw at Wimbledon in front of a crowd of 12,000, and he was also on target in the replay at Claremont Road.
Photo right: Johnny Westmore opens the scoring as Hendon defeat Wimbledon 2-0 in the Amateur Cup quarter-final replay at Claremont Road in 1951.
Away from football John was a carpenter and builder with most of his work in his home town of Mill Hill. At the end of his first season with St Albans City, in June 1954 to be precise, John married Sylvia and the couple were presented with a silver canteen of cutlery by the Club. Aside from the clubs listed above he also played football in Ceylon between 1943-47 for the Royal Navy. The Westmore name continues to be seen in local football as one of his grandsons plays for London Colney whilst two others play for Potters Bar Crusaders (U11’s) and Colney Heath Youth (U9’s).
Johnny passed away on the 10th December 2014. We thank his son Darren for assisting with the above information.
David Tavener
|
|
Johnny Westmore's full debut
|
|
22.08.1953 at 19:00
|
Isthmian League |
H |
Ilford
|
1 - 1 |
|
Latest opening squad appearances (max.10)Johnny Westmore started
|
|
18.12.1954 at 19:00
|
Amateur Cup / 1st Rd |
A |
Woking
|
1 - 2 |
|
11.12.1954 at 19:00
|
Isthmian League |
H |
Leytonstone
|
1 - 1 |
|
04.12.1954 at 19:00
|
Isthmian League |
H |
Wycombe Wanderers
|
3 - 2 |
|
30.10.1954 at 19:00
|
Isthmian League |
A |
Romford
|
2 - 1 |
|
09.10.1954 at 19:00
|
Isthmian League |
H |
Bromley
|
2 - 2 |
|
|
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1793170753,
"last": 1793170753,
"now": 1793170753
},
"token": "1eZol04581Br5cgr4HZmYiTm7VFhLkbp"
},
"registry": {
"com_tlpteam": {
"edit": {
"team": {
"id": "2090"
}
}
}
},
"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.26 MB (10,757,632 Bytes) 49 Queries Logged 70.32 msQuery Time: 0.29 ms Query memory: 0.023 MB Memory before query: 5.424 MB Rows returned: 0 SELECT `data`
FROM `qqrl9_session`
WHERE `session_id` = X'3635636638393764646266383337363832306333346537646337626135643835' | 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.08 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.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.16 ms After last query: 0.21 ms Query memory: 0.020 MB Memory before query: 5.436 MB Rows returned: 0 SELECT `session_id`
FROM `qqrl9_session`
WHERE `session_id` = X'3635636638393764646266383337363832306333346537646337626135643835'
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.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.23 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 5.441 MB INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'3635636638393764646266383337363832306333346537646337626135643835', 1, 1793170753, 0, '') EXPLAIN not possible on query: INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'3635636638393764646266383337363832306333346537646337626135643835', 1, 1793170753, 0, '') | Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init for update | 0.01 ms | | Update | 0.04 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.04 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.35 ms After last query: 0.26 ms Query memory: 0.038 MB Memory before query: 5.470 MB Rows returned: 49 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | extension | extension | 82 | const | 49 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.11 ms | | End of update loop | 0.02 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.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 | | 11 | Joomla\CMS\Component\ComponentHelper::{closure:Joomla\CMS\Component\ComponentHelper::load():434}() | Same as call in the line below. | | 10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 | | 8 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 | | 7 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 | | 6 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 | | 5 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.17 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 5.497 MB Rows returned: 5 SELECT id, rules
FROM `qqrl9_viewlevels` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.24 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 5.507 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.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 | | 10 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 | | 9 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 | | 8 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 | | 7 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | | 6 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | | 5 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.54 ms After last query: 0.06 ms Query memory: 0.077 MB Memory before query: 5.528 MB Rows returned: 101 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qqrl9_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 296 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.31 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.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.22 ms After last query: 1.39 ms Query memory: 0.021 MB Memory before query: 5.828 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.00 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504 | | 9 | Yjsg::getDefaultTemplate() | JROOT/plugins/system/yjsg/yjsg.php: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.43 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 5.931 MB Rows returned: 49 SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jdownloads','com_joomlaupdate','com_languages','com_login','com_mailto','com_matches','com_maximenuck','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_opponent','com_playeral','com_playlist','com_plugins','com_postinstall','com_privacy','com_recordbook','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_thisday','com_tlpteam','com_uniterevolution2','com_users','com_wrapper') | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 50 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.03 ms | | Optimizing | 0.01 ms | | Statistics | 0.06 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.14 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.20 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 5.995 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.00 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.30 ms After last query: 2.28 ms Query memory: 0.022 MB Memory before query: 6.285 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.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 | | 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 | | 12 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 | | 11 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 | | 10 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 | | 9 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 | | 8 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 7 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 | | 6 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.23 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.293 MB Rows returned: 1 SELECT template
FROM qqrl9_template_styles as s
WHERE s.client_id = 0
AND s.home = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.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.20 ms After last query: 0.52 ms Query memory: 0.021 MB Memory before query: 6.422 MB Rows returned: 2 SELECT extension, file, type
FROM qqrl9_rokcommon_configs
ORDER BY priority | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_rokcommon_configs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using filesort |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.08 ms After last query: 7.67 ms Query memory: 0.023 MB Memory before query: 6.671 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.02 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.01 ms | | Opening tables | 0.52 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | checking permissions | 0.10 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.09 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.12 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 | | 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 | | 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 | | 12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Extension.php:32 | | 11 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:328 | | 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 | | 9 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.23 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 6.700 MB Rows returned: 1 SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.05 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 11 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 | | 10 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:46 | | 9 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.19 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 6.706 MB Rows returned: 1 SELECT *
FROM qqrl9_extensions
WHERE `extension_id` = '10223' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 10 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 | | 9 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 6.712 MB Rows returned: 1 SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.19 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 6.718 MB Rows returned: 1 SELECT *
FROM qqrl9_extensions
WHERE `extension_id` = '10223' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.22 ms After last query: 7.42 ms Query memory: 0.021 MB Memory before query: 6.871 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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.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/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.18 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 6.876 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwgears_schedule`
WHERE time + '86400'<'1793170753' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears_schedule | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:146 | | 9 | plgSystemCwgears->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.06 ms After last query: 0.48 ms Query memory: 1.169 MB Memory before query: 6.905 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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.81 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.37 ms After last query: 4.23 ms Query memory: 0.021 MB Memory before query: 8.374 MB Rows returned: 6 SELECT id, home, template, s.params
FROM qqrl9_template_styles as s
LEFT JOIN qqrl9_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | | | 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | u887698322_new1.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.05 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.06 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.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.39 ms After last query: 2.63 ms Query memory: 0.029 MB Memory before query: 8.397 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.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 | 1.02 ms | | Executing | 0.02 ms | | Sending data | 0.11 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.02 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.26 ms After last query: 0.51 ms Query memory: 0.021 MB Memory before query: 8.406 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.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.25 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 8.411 MB Rows returned: 0 SELECT botname
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic_knownips | ref | idx_state | idx_state | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.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: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.30 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 8.416 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE iphash = UNHEX(SHA1('216.73.216.89'))
AND tm + '86400'>'1793170753' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic | ref | idx_iphash,idx_iphashtm | idx_iphashtm | 20 | const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.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.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.61 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 8.422 MB Rows returned: 510 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 | 511 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 1.33 ms | | End of update loop | 0.02 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:62 | | 10 | CoalawebtrafficHelperLocation::location_updatev2() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.40 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 8.683 MB Rows returned: 510 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 | 511 | 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.13 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php: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: 448.27 ms Query memory: 0.005 MB Memory before query: 8.704 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.10 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 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.00 ms | | init for update | 0.05 ms | | Searching rows for update | 0.03 ms | | Updating | 0.04 ms | | End of update loop | 0.01 ms | | End of update loop | 0.00 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.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/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.32 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 8.471 MB Rows returned: 1 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 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.06 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | | 19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 | | 18 | Joomla\CMS\Helper\LibraryHelper::{closure:Joomla\CMS\Helper\LibraryHelper::loadLibrary():157}() | Same as call in the line below. | | 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 | | 15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 | | 14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 | | 13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 | | 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/cwgears/cwgears.php:202 | | 9 | plgSystemCwgears->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.30 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 8.464 MB UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"70bb36e80fbd1ec12872e29762244b9b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' EXPLAIN not possible on query: UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"70bb36e80fbd1ec12872e29762244b9b\"}'
WHERE `type` = 'library' AND `element` = 'joomla' | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | checking permissions | 0.00 ms | | After opening tables | 0.00 ms | | init for update | 0.00 ms | | init | 0.01 ms | | Updating main table | 0.01 ms | | init | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.00 ms | | init for update | 0.03 ms | | Updating | 0.06 ms | | End of update loop | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.05 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.02 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: 47.64 ms After last query: 0.59 ms Query memory: 0.021 MB Memory before query: 8.472 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 | 39137 | Using index; Using temporary; Using filesort |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Creating tmp table | 0.03 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 46.02 ms | | Creating sort index | 1.29 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.02 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.06 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.31 ms After last query: 0.11 ms Query memory: 0.177 MB Memory before query: 8.478 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 1.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.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/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.24 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 8.484 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE tm < '1790204400' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic | range | unique_tm_ip,unique_tm_iphash,idx_tm | unique_tm_ip | 4 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.05 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.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 |
|---|
| 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.26 ms After last query: 1.77 ms Query memory: 0.019 MB Memory before query: 8.528 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.00 ms | | table lock | 0.00 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 | | 6 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 | | 5 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.04 ms After last query: 1.24 ms Query memory: 0.025 MB Memory before query: 8.583 MB Rows returned: 18 SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_tlpteam_team` | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.51 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.12 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.09 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.11 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.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 | | 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 | | 18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 | | 17 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_tlpteam/tables/team.php:26 | | 16 | TlpteamTableteam->__construct() | JROOT/libraries/src/Table/Table.php:328 | | 15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_tlpteam/models/team.php:93 | | 14 | TlpteamModelTeam->getTable() | JROOT/components/com_tlpteam/models/team.php:64 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.24 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 8.613 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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.02 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.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: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.41 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 8.628 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.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.17 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.85 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 8.641 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.37 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.05 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.04 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.09 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.10 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 | | 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 | | 22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 | | 21 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Asset.php:61 | | 20 | Joomla\CMS\Table\Asset->__construct() | JROOT/libraries/src/Access/Access.php:783 | | 19 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_tlpteam/tables/team.php:142 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.18 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 8.664 MB Rows returned: 0 SELECT *
FROM qqrl9_assets
WHERE `name` = 'com_tlpteam.team.1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 21 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 20 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 | | 19 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_tlpteam/tables/team.php:142 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.18 ms After last query: 0.33 ms Query memory: 0.024 MB Memory before query: 8.679 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.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 | | 17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/administrator/components/com_tlpteam/tables/team.php:145 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.76 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 8.684 MB Rows returned: 17 SHOW FULL COLUMNS
FROM `qqrl9_users` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_users` | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.36 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.07 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.04 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.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 | | 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 | | 22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 | | 21 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:41 | | 20 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:328 | | 19 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 | | 18 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:877 | | 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 | | 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 | | 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 | | 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_tlpteam/models/team.php:85 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.19 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 8.715 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.02 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.00 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 | | 18 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 | | 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 | | 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 | | 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 | | 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_tlpteam/models/team.php:85 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.97 ms After last query: 9.77 ms Query memory: 0.512 MB Memory before query: 8.914 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-28 06:59:14')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-28 06:59:14')
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.10 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.04 ms | | Optimizing | 0.04 ms | | Statistics | 0.07 ms | | Preparing | 0.03 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.48 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | Same as call in the line below. | | 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 | | 13 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 | | 12 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | | 11 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 | | 10 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/joothemes-transport/includes/params.php:14 | | 9 | include JROOT/templates/joothemes-transport/includes/params.php | JROOT/templates/joothemes-transport/index.php:15 | | 8 | require JROOT/templates/joothemes-transport/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 7 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 6 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 5 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.97 ms After last query: 2.61 ms Query memory: 0.029 MB Memory before query: 8.912 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.00 ms | | checking permissions | 0.68 ms | | Executing | 0.01 ms | | Sending data | 0.06 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.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: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.35 ms After last query: 0.52 ms Query memory: 0.024 MB Memory before query: 8.945 MB Rows returned: 121 SELECT guest, client_id
FROM qqrl9_session
WHERE client_id IS NULL | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_session | ref | client_id_guest | client_id_guest | 2 | const | 121 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.02 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.06 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.11 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.20 ms After last query: 3.82 ms Query memory: 0.022 MB Memory before query: 9.490 MB Rows returned: 0 SELECT uikit
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/2090' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.15 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 9.497 MB Rows returned: 0 SELECT uikit_plus
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/2090' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.00 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/helpers/loadcount.php:64 | | 14 | CwGearsHelperLoadcount::getCounts() | JROOT/plugins/system/cwgears/cwgears.php:439 | | 13 | plgSystemCwgears->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 | | 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 11 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 10 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 | | 9 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 | | 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 | | 7 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 | | 6 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 | | 5 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.86 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 9.545 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Filling schema table | 0.00 ms | | checking permissions | 0.59 ms | | Executing | 0.01 ms | | Sending data | 0.06 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.03 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 | | 9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:116 | | 8 | plgSystemjdownloads->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 | | 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
38 Query Types Logged, Sorted by Occurrences.SELECT Tables:2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions` 2 × SELECT a.template
FROM `qqrl9_template_styles` AS a 2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets` 2 × SELECT template
FROM qqrl9_template_styles as s 2 × SELECT `extension_id`
FROM `qqrl9_extensions` 2 × SELECT *
FROM qqrl9_extensions 2 × SELECT count(*)
FROM `qqrl9_cwtraffic` 2 × SELECT id, ip
FROM `qqrl9_cwtraffic` 2 × SELECT *
FROM qqrl9_assets 1 × SELECT `data`
FROM `qqrl9_session` 1 × SELECT `session_id`
FROM `qqrl9_session` 1 × SELECT id, rules
FROM `qqrl9_viewlevels 1 × SELECT b.id
FROM qqrl9_usergroups AS a
LEFT JOIN qqrl9_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qqrl9_extensions 1 × SELECT extension, file, type
FROM qqrl9_rokcommon_configs 1 × SELECT count(*)
FROM `qqrl9_cwgears_schedule 1 × SELECT count(*)
FROM `qqrl9_cwgears_schedule` 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qqrl9_menu AS m
LEFT JOIN qqrl9_extensions AS e
ON m.component_id = e.extension_id 1 × SELECT id, home, template, s.params
FROM qqrl9_template_styles as s
LEFT JOIN qqrl9_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id 1 × SELECT ip
FROM `qqrl9_cwtraffic_knownips` 1 × SELECT botname
FROM `qqrl9_cwtraffic_knownips` 1 × SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `qqrl9_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 5 1 × SELECT TCOUNT
FROM `qqrl9_cwtraffic_total 1 × SELECT *
FROM qqrl9_languages 1 × SELECT *
FROM qqrl9_tlpteam_team 1 × SELECT *
FROM `qqrl9_users` 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qqrl9_modules AS m
LEFT JOIN qqrl9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qqrl9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id 1 × SELECT guest, client_id
FROM qqrl9_session 1 × SELECT uikit
FROM `qqrl9_cwgears` 1 × SELECT uikit_plus
FROM `qqrl9_cwgears`
OTHER Tables:3 × SHOW TABLE 1 × INSERT INTO `qqrl9_session` (`session_id`,`guest`,`time`,`userid`,`username`)
VALUES (X'3635636638393764646266383337363832306333346537646337626135643835', 1, 1793170753, 0, '' 1 × SHOW FULL COLUMNS
FROM `qqrl9_extensions 1 × UPDATE qqrl9_cwtraffic
SET city = NULL 1 × UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"70bb36e80fbd1ec12872e29762244b9b\"}' 1 × SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team 1 × SHOW FULL COLUMNS
FROM `qqrl9_assets 1 × SHOW FULL COLUMNS
FROM `qqrl9_users
|
