Charlie MacDonald
Born: 13/02/1981 ,
,
|
 |
MacDonald played for the Millwall youth team before joining Charlton Athletic as a trainee, turning professional in August 1998. He made his Charlton debut on 3 January 2000, as a late substitute for Martin Pringle in a 3–0 win at home to Nottingham Forest. He started the FA Cup tie against Queens Park Rangers the following weekend, scoring the only goal as Charlton progressed to the fourth round. He made two further appearances as substitute that season and won the Charlton Young Player of the Year Award.
He joined Cheltenham Town on loan in March 2001, scoring twice in seven games with both goals coming in the same game against Blackpool. He returned to the Charlton first team squad later that year and scored his first ever Premiership goal when scoring the late equaliser in the 1–1 draw with Newcastle United at The Valley. However, that was his last involvement with the Charlton first team and in February 2002 he joined Torquay United on loan, playing five games without scoring. In March 2002 he joined Colchester United on loan, but made just four appearances and scored one goal, in a 2–2 draw with Wigan Athletic, before returning to his parent club at The Valley.
He was released by Charlton in May 2002 and joined Conference side Margate in August. After one goal against Forest Green Rovers, the following month he moved to Conference rivals Stevenage Borough.
In August 2003 he moved to Crawley Town, and after an injury-troubled start, went on to play a crucial role in the club winning the Dr Martens League Premier Division and with it, promotion to the Nationwide Conference for the first time in its history. His best spell saw him score nine goals in seven matches – scoring in all seven. He was the side’s leading scorer in the league, with 17 goals.
He had the honour of scoring Crawley’s first ever goal in the Conference, part of a brace that saw them beat Leigh RMI away from home 2–1. He scored seven goals in the first two months, but eventually lost his place and was loaned out to Weymouth in April 2005.
In May 2005 he moved to Gravesend & Northfleet and soon settled in as a regular in the Gravesend team and a regular on the score sheet. His contract with Gravesend and Northfleet ended at the close of the 2006–07 season and put pen-to-paper on a two-year deal with Southend United, arriving at Roots Hall on a free transfer. During his time at Southend he scored just once in the league against Doncaster Rovers, but he scored a further four goals in cup competitions with a goal against Watford in the League Cup, a brace against Oxford United in the FA Cup and another goal in the FA Cup against Dagenham & Redbridge.
He joined Brentford on 9 July 2008 for an undisclosed fee on a two-year contract. He scored 18 goals in his first season at the club, helping Brentford to win League Two. He was awarded the Powerade League Two Player of the Month award for February 2009. His first season was ended in March due to a shoulder injury; however, he bounced back to become Brentford’s top scorer in the 2009–10 season.
On 26 August 2011, Charlie MacDonald signed a two-year contract with MK Dons for an undisclosed fee. In his three-year stay at Brentford he scored a goal every 2.7 games; 40 goals in 111 games at Griffin Park. MacDonald was the replacement for Sam Baldock, who recently left MK Dons to join West Ham United.
MacDonald signed for Leyton Orient on a free transfer on 12 January 2013.
MacDonald joined Barnet on 16 July 2014 and scored a penalty on his debut, a 5–0 away win at Chester. He was appointed captain of the side by manager Martin Allen. After scoring eight goals during Barnet’s promotion winning campaign, MacDonald was not offered a new contract with the Bees and joined newly promoted Boreham Wood in the summer of 2015.
In January 2016, MacDonald joined the Saints on loan.
|
|
Charlie MacDonald's full debut
|
|
23.01.2016 at 15:00
|
National League South |
A |
Oxford City
|
1 - 4 |
|
|
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1793627980,
"last": 1793627980,
"now": 1793627980
},
"token": "15KsHhwyKOIwSj79Fr2REvI8fTzJ7QjA"
},
"registry": {
"com_tlpteam": {
"edit": {
"team": {
"id": "2184"
}
}
}
},
"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.41 MB (10,919,888 Bytes) 49 Queries Logged 39.43 msQuery Time: 0.31 ms Query memory: 0.023 MB Memory before query: 5.594 MB Rows returned: 0 SELECT `data`
FROM `qqrl9_session`
WHERE `session_id` = X'3930353338613537356165373339646337666362346566333262656163333763' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.09 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.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.22 ms After last query: 0.28 ms Query memory: 0.020 MB Memory before query: 5.606 MB Rows returned: 0 SELECT `session_id`
FROM `qqrl9_session`
WHERE `session_id` = X'3930353338613537356165373339646337666362346566333262656163333763'
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.01 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.04 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 |
|---|
| 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.29 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 5.611 MB INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'3930353338613537356165373339646337666362346566333262656163333763', 1, 1793627980, 0, '') EXPLAIN not possible on query: INSERT INTO `qqrl9_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'3930353338613537356165373339646337666362346566333262656163333763', 1, 1793627980, 0, '') | 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 for update | 0.01 ms | | Update | 0.06 ms | | End of update loop | 0.01 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.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.34 ms Query memory: 0.038 MB Memory before query: 5.640 MB Rows returned: 49 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | extension | extension | 82 | const | 49 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.10 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 |
|---|
| 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.19 ms After last query: 0.41 ms Query memory: 0.021 MB Memory before query: 5.667 MB Rows returned: 5 SELECT id, rules
FROM `qqrl9_viewlevels` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.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.28 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 5.677 MB Rows returned: 2 SELECT b.id
FROM qqrl9_usergroups AS a
LEFT JOIN qqrl9_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | | | 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 | | 10 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 | | 9 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 | | 8 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 | | 7 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | | 6 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | | 5 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.61 ms After last query: 0.08 ms Query memory: 0.077 MB Memory before query: 5.699 MB Rows returned: 101 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qqrl9_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 296 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.35 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.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 | | 10 | Joomla\CMS\Plugin\PluginHelper::{closure:Joomla\CMS\Plugin\PluginHelper::load():323}() | Same as call in the line below. | | 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 | | 7 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | | 6 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | | 5 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.25 ms After last query: 1.50 ms Query memory: 0.021 MB Memory before query: 5.998 MB Rows returned: 1 SELECT a.template
FROM `qqrl9_template_styles` AS a
WHERE client_id = 0
AND a.home = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/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.49 ms After last query: 0.54 ms Query memory: 0.023 MB Memory before query: 6.164 MB Rows returned: 49 SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jdownloads','com_joomlaupdate','com_languages','com_login','com_mailto','com_matches','com_maximenuck','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_opponent','com_playeral','com_playlist','com_plugins','com_postinstall','com_privacy','com_recordbook','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_thisday','com_tlpteam','com_uniterevolution2','com_users','com_wrapper') | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 50 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.06 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.08 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.16 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | | 13 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | | 12 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | | 11 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 10 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 9 | Joomla\CMS\User\User->authorise() | JROOT/plugins/system/yjsg/yjsg.php:132 | | 8 | plgSystemYjsg->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 7 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 | | 6 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.23 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 6.228 MB Rows returned: 1 SELECT a.template
FROM `qqrl9_template_styles` AS a
WHERE client_id = 0
AND a.home = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.02 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.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504 | | 9 | Yjsg::getDefaultTemplate() | JROOT/plugins/system/yjsg/yjsg.php:133 | | 8 | plgSystemYjsg->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 7 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 | | 6 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.23 ms After last query: 2.70 ms Query memory: 0.022 MB Memory before query: 6.456 MB Rows returned: 1 SELECT template
FROM qqrl9_template_styles as s
WHERE s.client_id = 0
AND s.home = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.02 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.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 |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 | | 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 | | 12 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 | | 11 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 | | 10 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 | | 9 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 | | 8 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 7 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 | | 6 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.463 MB Rows returned: 1 SELECT template
FROM qqrl9_template_styles as s
WHERE s.client_id = 0
AND s.home = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.21 ms After last query: 0.70 ms Query memory: 0.021 MB Memory before query: 6.592 MB Rows returned: 2 SELECT extension, file, type
FROM qqrl9_rokcommon_configs
ORDER BY priority | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_rokcommon_configs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using filesort |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/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.06 ms After last query: 9.78 ms Query memory: 0.023 MB Memory before query: 6.842 MB Rows returned: 18 SHOW FULL COLUMNS
FROM `qqrl9_extensions` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_extensions` | Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.50 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.11 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.07 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.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.34 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 6.871 MB Rows returned: 1 SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.07 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 11 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 | | 10 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:46 | | 9 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.26 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 6.877 MB Rows returned: 1 SELECT *
FROM qqrl9_extensions
WHERE `extension_id` = '10223' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 10 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 | | 9 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.25 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 6.883 MB Rows returned: 1 SELECT `extension_id`
FROM `qqrl9_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.22 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 6.888 MB Rows returned: 1 SELECT *
FROM qqrl9_extensions
WHERE `extension_id` = '10223' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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: 8.31 ms Query memory: 0.021 MB Memory before query: 7.042 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwgears_schedule` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears_schedule | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | |
| Status | Duration |
|---|
| Starting | 0.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.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.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:103 | | 9 | plgSystemCwgears->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.20 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 7.047 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwgears_schedule`
WHERE time + '86400'<'1793627980' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears_schedule | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.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 | | 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.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:146 | | 9 | plgSystemCwgears->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 5 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | | 4 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.20 ms After last query: 0.58 ms Query memory: 1.169 MB Memory before query: 7.076 MB Rows returned: 211 SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qqrl9_menu AS m
LEFT JOIN qqrl9_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language,wdbi_client_id_published_lft_parent_id_53ead0dcf209 | NO INDEX KEY COULD BE USED | NULL | NULL | 317 | Using where; Using filesort | | 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | u887698322_new1.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.91 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 | | 18 | Joomla\CMS\Menu\SiteMenu->{closure:Joomla\CMS\Menu\SiteMenu::load():77}() | Same as call in the line below. | | 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 | | 15 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 | | 14 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 | | 13 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 | | 12 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 | | 11 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 | | 10 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 | | 9 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 | | 8 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 | | 7 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 | | 6 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.38 ms After last query: 4.83 ms Query memory: 0.021 MB Memory before query: 8.545 MB Rows returned: 6 SELECT id, home, template, s.params
FROM qqrl9_template_styles as s
LEFT JOIN qqrl9_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 6 | | | 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | u887698322_new1.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.02 ms | | Statistics | 0.06 ms | | Preparing | 0.03 ms | | Executing | 0.01 ms | | Sending data | 0.07 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.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.02 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 | | 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/yjsg/yjsg.php:231 | | 9 | plgSystemYjsg->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.05 ms After last query: 2.78 ms Query memory: 0.029 MB Memory before query: 8.568 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.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.00 ms | | Filling schema table | 0.01 ms | | checking permissions | 0.77 ms | | Executing | 0.02 ms | | Sending data | 0.06 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 | | 10 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:220 | | 9 | plgSystemjdownloads->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.29 ms After last query: 0.70 ms Query memory: 0.021 MB Memory before query: 8.576 MB Rows returned: 0 SELECT ip
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 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.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.04 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.21 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 8.581 MB Rows returned: 0 SELECT botname
FROM `qqrl9_cwtraffic_knownips`
WHERE state = 1
AND count = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic_knownips | ref | idx_state | idx_state | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.02 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:186 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 8.586 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE iphash = UNHEX(SHA1('216.73.217.128'))
AND tm + '86400'>'1793627980' | 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.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.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:242 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.85 ms After last query: 0.23 ms Query memory: 0.029 MB Memory before query: 8.593 MB Rows returned: 347 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 | 348 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.59 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.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:62 | | 10 | CoalawebtrafficHelperLocation::location_updatev2() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.71 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 8.776 MB Rows returned: 347 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 | 348 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.02 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.47 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.02 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:67 | | 10 | CoalawebtrafficHelperLocation::location_updatev2() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.35 ms After last query: 239.27 ms Query memory: 0.005 MB Memory before query: 8.782 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.08 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | checking permissions | 0.01 ms | | After opening tables | 0.01 ms | | init for update | 0.01 ms | | init | 0.01 ms | | Updating main table | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | init for update | 0.04 ms | | Searching rows for update | 0.02 ms | | Updating | 0.01 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.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 |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:100 | | 10 | CoalawebtrafficHelperLocation::location_updatev2() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:313 | | 9 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.30 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 8.626 MB Rows returned: 1 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qqrl9_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.02 ms | | Executing | 0.01 ms | | Sending data | 0.04 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | | 19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 | | 18 | Joomla\CMS\Helper\LibraryHelper::{closure:Joomla\CMS\Helper\LibraryHelper::loadLibrary():157}() | Same as call in the line below. | | 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 | | 15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 | | 14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 | | 13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 | | 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/cwgears/cwgears.php:202 | | 9 | plgSystemCwgears->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.34 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 8.618 MB UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"a2e62b1a68512c7bed5b56c21a4f822f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' EXPLAIN not possible on query: UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"a2e62b1a68512c7bed5b56c21a4f822f\"}'
WHERE `type` = 'library' AND `element` = 'joomla' | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | checking permissions | 0.01 ms | | After opening tables | 0.01 ms | | init for update | 0.01 ms | | init | 0.01 ms | | Updating main table | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.00 ms | | init | 0.01 ms | | init for update | 0.03 ms | | Updating | 0.03 ms | | End of update loop | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.05 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.04 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 | | 14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 | | 13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 | | 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/cwgears/cwgears.php:202 | | 9 | plgSystemCwgears->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 18.81 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 8.627 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 | 17160 | 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.02 ms | | Sorting result | 0.01 ms | | Executing | 0.00 ms | | Sending data | 18.01 ms | | Creating sort index | 0.56 ms | | Removing tmp table | 0.01 ms | | Creating sort index | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:132 | | 9 | plgSystemCwtrafficClean->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 1.31 ms After last query: 0.04 ms Query memory: 0.177 MB Memory before query: 8.633 MB Rows returned: 5112 SELECT TCOUNT
FROM `qqrl9_cwtraffic_total` | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic_total | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5112 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Sending data | 1.08 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:221 | | 9 | plgSystemCwtrafficClean->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 | | 8 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 7 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 6 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 | | 5 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | | 4 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.21 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 8.639 MB Rows returned: 1 SELECT count(*)
FROM `qqrl9_cwtraffic`
WHERE tm < '1792882800' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwtraffic | range | unique_tm_ip,unique_tm_iphash,idx_tm | unique_tm_ip | 4 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.03 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.70 ms Query memory: 0.019 MB Memory before query: 8.682 MB Rows returned: 1 SELECT *
FROM qqrl9_languages
WHERE published=1
ORDER BY ordering ASC | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.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.05 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 |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 | | 6 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 | | 5 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.86 ms After last query: 1.25 ms Query memory: 0.025 MB Memory before query: 8.737 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.43 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.00 ms | | checking permissions | 0.08 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.12 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.00 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.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.22 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 8.768 MB Rows returned: 1 SELECT *
FROM qqrl9_tlpteam_team
WHERE `id` = '1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_tlpteam_team | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Unlocking tables | 0.00 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.39 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 8.782 MB Rows returned: 2 SELECT `id`,`name`,`rules`,`parent_id`
FROM `qqrl9_assets`
WHERE `name` LIKE 'com_tlpteam.%' OR `name` = 'com_tlpteam' OR `parent_id` = 0 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 619 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.04 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.18 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 | | 20 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 | | 19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 | | 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_tlpteam/tables/team.php:142 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.69 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 8.796 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.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.03 ms | | closing tables | 0.01 ms | | checking permissions | 0.00 ms | | Executing | 0.00 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.09 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.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 |
|---|
| 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.17 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 8.818 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.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 21 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 20 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 | | 19 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_tlpteam/tables/team.php:142 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.18 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 8.834 MB Rows returned: 0 SELECT *
FROM qqrl9_assets
WHERE `name` = 'com_tlpteam.team.1' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 | | 18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 | | 17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/administrator/components/com_tlpteam/tables/team.php:145 | | 15 | TlpteamTableteam->bind() | JROOT/libraries/src/Table/Table.php:757 | | 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_tlpteam/models/team.php:67 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.71 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 8.839 MB Rows returned: 17 SHOW FULL COLUMNS
FROM `qqrl9_users` EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qqrl9_users` | Status | Duration |
|---|
| Starting | 0.01 ms | | checking permissions | 0.01 ms | | closing tables | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.35 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.00 ms | | Filling schema table | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | checking permissions | 0.04 ms | | closing tables | 0.01 ms | | checking permissions | 0.01 ms | | Executing | 0.00 ms | | Sending data | 0.03 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.10 ms | | closing tables | 0.01 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.00 ms | | Query end | 0.00 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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.18 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 8.869 MB Rows returned: 0 SELECT *
FROM `qqrl9_users`
WHERE `id` = 159 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.02 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.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.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 | | 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 | | 18 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 | | 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 | | 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 | | 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 | | 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_tlpteam/models/team.php:85 | | 13 | TlpteamModelTeam->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_tlpteam/views/team/view.html.php:33 | | 11 | TlpteamViewTeam->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_tlpteam/controller.php:32 | | 9 | TlpteamController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tlpteam/tlpteam.php:22 | | 7 | require_once JROOT/components/com_tlpteam/tlpteam.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | | 6 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | | 5 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | | 4 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 3 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.72 ms After last query: 11.01 ms Query memory: 0.512 MB Memory before query: 9.068 MB Rows returned: 253 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qqrl9_modules AS m
LEFT JOIN qqrl9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qqrl9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-11-02 13:59:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-02 13:59:40')
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.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.01 ms | | init | 0.03 ms | | Optimizing | 0.03 ms | | Statistics | 0.05 ms | | Preparing | 0.03 ms | | Sorting result | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.36 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.01 ms | | closing tables | 0.01 ms | | Query end | 0.01 ms | | Starting cleanup | 0.00 ms | | Freeing items | 0.01 ms | | Updating status | 0.01 ms | | Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 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.87 ms After last query: 2.96 ms Query memory: 0.029 MB Memory before query: 9.066 MB Rows returned: 334 SHOW TABLES EXPLAIN not possible on query: SHOW TABLES | Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.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.61 ms | | Executing | 0.01 ms | | Sending data | 0.05 ms | | End of update loop | 0.01 ms | | Query end | 0.01 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.01 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.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 |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 12 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 | | 11 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/mobilemenuck/helpers/helper.php:186 | | 10 | Mobilemenuck\Helper::searchTable() | JROOT/plugins/system/mobilemenuck/helpers/helper.php:174 | | 9 | Mobilemenuck\Helper::checkIsProVersion() | JROOT/plugins/system/mobilemenuck/mobilemenuck.php:634 | | 8 | PlgSystemMobilemenuck->onBeforeRender() | JROOT/libraries/joomla/event/event.php:70 | | 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1102 | | 4 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 3 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | | 2 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/indexx.php:49 | | 1 | include JROOT/indexx.php | JROOT/index.php:110 |
Query Time: 0.33 ms After last query: 0.57 ms Query memory: 0.030 MB Memory before query: 9.100 MB Rows returned: 430 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 | 380 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.00 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.05 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.10 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.00 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Unlocking tables | 0.00 ms | | closing tables | 0.01 ms | | Query end | 0.00 ms | | Starting cleanup | 0.01 ms | | Freeing items | 0.00 ms | | Updating status | 0.01 ms | | Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 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: 4.12 ms Query memory: 0.022 MB Memory before query: 9.645 MB Rows returned: 0 SELECT uikit
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/2184' | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | qqrl9_cwgears | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | After opening tables | 0.01 ms | | System lock | 0.01 ms | | table lock | 0.00 ms | | init | 0.01 ms | | Optimizing | 0.01 ms | | Statistics | 0.01 ms | | Preparing | 0.01 ms | | Executing | 0.01 ms | | Sending data | 0.02 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | Commit | 0.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 |
|---|
| 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.16 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 9.652 MB Rows returned: 0 SELECT uikit_plus
FROM `qqrl9_cwgears`
WHERE url = 'https://www.saintsstatistics.co.uk/index.php/city-statistics/seasonsquads/team/2184' | 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.79 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 9.700 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.01 ms | | After opening tables | 0.00 ms | | System lock | 0.01 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.55 ms | | Executing | 0.01 ms | | Sending data | 0.05 ms | | End of update loop | 0.01 ms | | Query end | 0.00 ms | | closing tables | 0.00 ms | | Removing tmp table | 0.02 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'3930353338613537356165373339646337666362346566333262656163333763', 1, 1793627980, 0, '' 1 × SHOW FULL COLUMNS
FROM `qqrl9_extensions 1 × UPDATE qqrl9_cwtraffic
SET city = NULL 1 × UPDATE `qqrl9_extensions`
SET `params` = '{\"mediaversion\":\"a2e62b1a68512c7bed5b56c21a4f822f\"}' 1 × SHOW FULL COLUMNS
FROM `qqrl9_tlpteam_team 1 × SHOW FULL COLUMNS
FROM `qqrl9_assets 1 × SHOW FULL COLUMNS
FROM `qqrl9_users
|
