megafuncups - 2024 SSML EUROPA LEAGUE OCT
| Association: | ||||||||
| SSML EUROPA LEA | SSML CONFERENCE | SSML CHAMPIONS | LOW ITA CUP | HIGH ITA CUP | SSML SERIE B | SSML SERIE A | DFB-FunPokal | Super FunLig |
PC SWOS WORLD OFFLINE
| # | Player | SRN |
| 1 |
 Blazej_Bdg
|
2086 |
| 2 |
 djowGer
|
1742 |
| 3 |
bobbiebobras
|
1605 |
| 4 |
 AndYpsilon
|
1603 |
| 5 |
 Rebel
|
1598 |
| 6 |
 M4RK
|
1506 |
| 7 |
ElMichaJ
|
1495 |
| 8 |
 Ali
|
1433 |
| 9 |
Bomb
|
1344 |
| 10 |
Klinki
|
1293 |
| View More | ||
AMIGA SWOS WORLD OFFLINE
| # | Player | SRN |
| 1 |
Blazej_Bdg
|
2187 |
| 2 |
lobo
|
1902 |
| 3 |
bobbiebobras
|
1831 |
| 4 |
Bomb
|
1716 |
| 5 |
Ali
|
1696 |
| 6 |
Rebel
|
1658 |
| 7 |
djowGer
|
1641 |
| 8 |
assura
|
1637 |
| 9 |
SPIR
|
1561 |
| 10 |
andib
|
1521 |
| View More | ||
AMIGA SENSI WORLD OFFLINE
| # | Player | SRN |
| 1 |
Blazej_Bdg
|
1988 |
| 2 |
bobbiebobras
|
1774 |
| 3 |
ElMichaJ
|
1658 |
| 4 |
djowGer
|
1604 |
| 5 |
Ali
|
1487 |
| 6 |
Bomb
|
1343 |
| 7 |
andib
|
1308 |
| 8 |
FRK Pawel
|
1293 |
| 9 |
SPIR
|
1278 |
| 10 |
Rebel
|
1152 |
| View More | ||
AMIGA SWOS WORLD ONLINE
| # | Player | SRN |
| 1 |
Playaveli
|
2482 |
| 2 |
yashalkok
|
2458 |
| 3 |
 crom1
|
2385 |
| 4 |
Nestoroide
|
2381 |
| 5 |
Rebel
|
2319 |
| 6 |
Julen
|
2274 |
| 7 |
bobbiebobras
|
2206 |
| 8 |
Zafer
|
2191 |
| 9 |
Nicomagno
|
2159 |
| 10 |
umtytm
|
2126 |
| View More | ||
XBOX SWOS OFFLINE
| # | Player | SRN |
| 1 |
bobbiebobras
|
1619 |
| 2 |
lobo
|
1449 |
| 3 |
AndYpsilon
|
1360 |
| 4 |
crom1
|
1337 |
| 5 |
Bomb
|
1318 |
| 6 |
Schulle
|
1250 |
| 7 |
M4RK
|
1205 |
| 8 |
Fifko
|
1199 |
| 9 |
 Rock and Roll
|
1086 |
| 10 |
Insane
|
1012 |
| View More | ||
XBOX SWOS ONLINE
| # | Player | SRN |
| 1 |
Zafer
|
1968 |
| 2 |
ozgur1907
|
1241 |
| 3 |
 Mladen
|
1177 |
| 4 |
Playaveli
|
1176 |
| 5 |
SirJoe79
|
1175 |
| 6 |
 Adrian Pejovic
|
1125 |
| 7 |
BrowarFans
|
1079 |
| 8 |
CocaCola
|
1045 |
| 9 |
GoX2
|
1044 |
| 10 |
lauchlan
|
1044 |
| View More | ||
AMIGA SWOS OFFLINE OOO
| # | Player | SRN |
| 1 |
djowGer
|
1521 |
| 2 |
Bomb
|
1437 |
| 3 |
andib
|
1212 |
| 4 |
ElMichaJ
|
1198 |
| 5 |
Rebel
|
1085 |
| 6 |
lobo
|
1073 |
| 7 |
SPIR
|
1054 |
| 8 |
CocaCola
|
1022 |
| 9 |
umtytm
|
978 |
| 10 |
Klaris
|
948 |
| View More | ||
PC SWOS OFFLINE OOO
| # | Player | SRN |
| 1 |
Bomb
|
1465 |
| 2 |
djowGer
|
1439 |
| 3 |
M4RK
|
1291 |
| 4 |
andib
|
1044 |
| 5 |
Klaris
|
995 |
| 6 |
SPIR
|
984 |
| 7 |
Hannes
|
967 |
| 8 |
 DoTa
|
965 |
| 9 |
ElMichaJ
|
946 |
| 10 |
andreaselsner
|
946 |
| View More | ||
PC SWOS WORLD ONLINE
| # | Player | SRN |
| 1 |
AndYpsilon
|
1965 |
| 2 |
Playaveli
|
1961 |
| 3 |
Rebel
|
1889 |
| 4 |
yashalkok
|
1835 |
| 5 |
Nestoroide
|
1735 |
| 6 |
Mladen
|
1693 |
| 7 |
M4RK
|
1677 |
| 8 |
Zafer
|
1651 |
| 9 |
ElMichaJ
|
1418 |
| 10 |
BrowarFans
|
1388 |
| View More | ||
Next Offline Tournaments
|
8 - London Calling |
| @2025-11-15 13:00:49 |
Next Online Tournaments
|
10/25 - PCL Cup |
| @2025-10-23 21:30:44 | |
|
10/25 - PP |
| @2025-10-29 20:48:00 | |
|
10/25 - UK / IRE CUP |
| @2025-10-29 21:00:35 | |
|
10/25 - ASL Cup |
| @2025-10-30 21:30:24 |
Last Tournaments
|
2025 - DFB-FunPokal |
| @2025-10-20 20:48:00 | |
|
|
2024 - SSML EUROPA LEA |
| @2025-10-17 19:45:18 | |
|
|
2024 - SSML CONFERENCE |
| @2025-10-17 19:41:49 | |
|
|
2024 - SSML CHAMPIONS |
| @2025-10-17 19:38:48 | |
|
10/25 - APL Cup |
| @2025-10-16 20:48:00 | |
|
10/25 - Ligapokal |
| @2025-10-16 10:07:42 | |
|
|
2025 - Super FunLig |
| @2025-10-07 20:48:00 | |
|
|
2024 - HIGH ITA CUP |
| @2025-10-07 18:04:54 | |
|
|
2024 - LOW ITA CUP |
| @2025-10-06 18:16:37 | |
|
|
2024 - SSML SERIE B |
| @2025-10-06 17:57:57 |
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1760997045,
"last": 1760997045,
"now": 1760997045
},
"token": "KdrbzgXLmg2zHQ96vsT7loDckfcpjXgJ"
},
"registry": {},
"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
},
"gtag": false
}
}
Time
Memory
Time: 13.80 ms / 13.80 ms Memory: 1.766 MB / 2.14 MB Application: afterLoad
Time: 89.41 ms / 103.20 ms Memory: 5.261 MB / 7.40 MB Application: afterInitialise
Time: 20.41 ms / 123.62 ms Memory: 1.003 MB / 8.40 MB Application: afterRoute
Time: 2.32 ms / 125.94 ms Memory: 0.018 MB / 8.42 MB Application: beforeRenderComponent com_tournament
Time: 11.85 ms / 137.79 ms Memory: 0.539 MB / 8.96 MB Application: afterRenderComponent com_tournament
Time: 5.62 ms / 143.41 ms Memory: 0.262 MB / 9.22 MB Application: afterDispatch
Time: 3.96 ms / 147.37 ms Memory: 0.154 MB / 9.37 MB Application: beforeRenderModule mod_je_social (Social Links)
Time: 0.49 ms / 147.86 ms Memory: 0.035 MB / 9.41 MB Application: afterRenderModule mod_je_social (Social Links)
Time: 0.03 ms / 147.89 ms Memory: -0.006 MB / 9.40 MB Application: beforeRenderModule mod_menu (Footer)
Time: 1.88 ms / 149.76 ms Memory: 0.167 MB / 9.57 MB Application: afterRenderModule mod_menu (Footer)
Time: 0.06 ms / 149.82 ms Memory: -0.002 MB / 9.57 MB Application: beforeRenderModule mod_discord (Discord)
Time: 0.12 ms / 149.94 ms Memory: 0.004 MB / 9.57 MB Application: afterRenderModule mod_discord (Discord)
Time: 0.02 ms / 149.96 ms Memory: -0.001 MB / 9.57 MB Application: beforeRenderModule mod_useronline (Users Online)
Time: 30.52 ms / 180.48 ms Memory: 0.273 MB / 9.84 MB Application: afterRenderModule mod_useronline (Users Online)
Time: 0.04 ms / 180.52 ms Memory: -0.007 MB / 9.84 MB Application: beforeRenderModule mod_rankings (Rankings)
Time: 20.04 ms / 200.55 ms Memory: 0.227 MB / 10.06 MB Application: afterRenderModule mod_rankings (Rankings)
Time: 0.06 ms / 200.61 ms Memory: -0.022 MB / 10.04 MB Application: beforeRenderModule mod_tournaments (Tournaments)
Time: 26.29 ms / 226.91 ms Memory: 0.061 MB / 10.10 MB Application: afterRenderModule mod_tournaments (Tournaments)
Time: 0.08 ms / 226.98 ms Memory: 0.001 MB / 10.10 MB Application: beforeRenderModule mod_menu (Sensible Support Advertisement)
Time: 1.25 ms / 228.23 ms Memory: 0.034 MB / 10.14 MB Application: afterRenderModule mod_menu (Sensible Support Advertisement)
Time: 0.09 ms / 228.32 ms Memory: 0.002 MB / 10.14 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 11.51 ms / 239.82 ms Memory: 0.700 MB / 10.84 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.06 ms / 239.89 ms Memory: -0.008 MB / 10.83 MB Application: beforeRenderModule mod_userstatus (Userstatus)
Time: 0.44 ms / 240.33 ms Memory: 0.020 MB / 10.85 MB Application: afterRenderModule mod_userstatus (Userstatus)
Time: 4.64 ms / 244.97 ms Memory: 0.337 MB / 11.19 MB Application: afterRender
Database queries total: 92.89 ms
11.74 MB (12,309,048 Bytes)
53 Queries Logged 92.89 ms
- Query Time: 0.52 ms Query memory: 0.022 MB Memory before query: 3.893 MB Rows returned: 0
SELECT `data`
FROM `joomla_session`
WHERE `session_id` = X'6462653261663063336265346564626135656436643339613861396164633566'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.37 ms After last query: 1.57 ms Query memory: 0.020 MB Memory before query: 3.988 MB Rows returned: 0
SELECT `session_id`
FROM `joomla_session`
WHERE `session_id` = X'6462653261663063336265346564626135656436643339613861396164633566'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 5.18 ms After last query: 0.11 ms Query memory: 0.003 MB Memory before query: 3.992 MB
INSERT INTO `joomla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6462653261663063336265346564626135656436643339613861396164633566', 1, 1760997045, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `joomla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6462653261663063336265346564626135656436643339613861396164633566', 1, 1760997045, 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 0.13 ms end 0.01 ms query end 4.64 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.82 ms After last query: 3.16 ms Query memory: 0.037 MB Memory before query: 4.179 MB Rows returned: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joomla_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_extensions NULL ref extension extension 82 const 44 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.26 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() 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/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 4.11 ms Query memory: 0.020 MB Memory before query: 4.427 MB Rows returned: 6
SELECT id, rules
FROM `joomla_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 4.437 MB Rows returned: 2
SELECT b.id
FROM joomla_usergroups AS a
LEFT JOIN joomla_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 21 100.00 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.56 ms After last query: 0.84 ms Query memory: 0.022 MB Memory before query: 4.505 MB Rows returned: 85
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joomla_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_extensions NULL ref extension extension 82 const 133 0.60 Using index condition; Using where; Using filesort Status Duration starting 0.18 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 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.46 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.55 ms After last query: 38.60 ms Query memory: 0.020 MB Memory before query: 7.117 MB Rows returned: 1
SELECT `enabled`
FROM `joomla_extensions`
WHERE `element` = 'com_bwpostman'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_extensions NULL ref element_clientid,element_folder_clientid element_clientid 402 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/bwpm_useraccount/bwpm_useraccount.php:162 8 PlgSystemBWPM_UserAccount->setBwPostmanComponentStatus() JROOT/plugins/system/bwpm_useraccount/bwpm_useraccount.php:135 7 PlgSystemBWPM_UserAccount->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 7.122 MB Rows returned: 1
SELECT `manifest_cache`
FROM `joomla_extensions`
WHERE `element` = 'com_bwpostman'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_extensions NULL ref element_clientid,element_folder_clientid element_clientid 402 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/bwpm_useraccount/bwpm_useraccount.php:200 8 PlgSystemBWPM_UserAccount->setBwPostmanComponentVersion() JROOT/plugins/system/bwpm_useraccount/bwpm_useraccount.php:136 7 PlgSystemBWPM_UserAccount->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 1.06 ms Query memory: 0.020 MB Memory before query: 7.227 MB Rows returned: 1
SELECT count(*)
FROM `joomla_cwgears_schedule`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_cwgears_schedule NULL index NULL PRIMARY 4 NULL 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:102 8 plgSystemCwgears->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.09 ms Query memory: 0.020 MB Memory before query: 7.231 MB Rows returned: 1
SELECT count(*)
FROM `joomla_cwgears_schedule`
WHERE time + '86400'<'1760997045'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_cwgears_schedule NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:145 8 plgSystemCwgears->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.63 ms After last query: 4.12 ms Query memory: 0.072 MB Memory before query: 7.584 MB Rows returned: 93
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 joomla_menu AS m
LEFT JOIN joomla_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 133 10.00 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dbs203386.m.component_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.84 ms After last query: 10.97 ms Query memory: 0.023 MB Memory before query: 8.241 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joomla_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms Sending data 0.85 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:200 8 plgSystemCwgears->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.55 ms After last query: 0.22 ms Query memory: 0.006 MB Memory before query: 8.233 MB
UPDATE `joomla_extensions`
SET `params` = '{\"mediaversion\":\"79a178f4f8501b4e688ae7664303a001\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE joomla_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.06 ms updating 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:200 8 plgSystemCwgears->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.72 ms After last query: 2.92 ms Query memory: 0.019 MB Memory before query: 8.404 MB Rows returned: 1
SELECT *
FROM joomla_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 16.67 Using where; Using filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.05 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.70 ms After last query: 0.29 ms Query memory: 0.018 MB Memory before query: 8.412 MB Rows returned: 1
SELECT id, home, template, s.params
FROM joomla_template_styles as s
LEFT JOIN joomla_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 1 100.00 NULL 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 dbs203386.s.template,const 1 4.44 Using index condition; Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 6.94 ms Query memory: 0.022 MB Memory before query: 8.882 MB Rows returned: 1Duplicate queries: #20
SELECT `t`.`name_eng` AS `t_name_eng`,`r`.`name_eng` AS `r_name_eng`,`t`.`id` AS `id`,`s`.`name_eng` AS `s_name_eng`,`t`.`text_eng` AS `t_text_eng`,`t`.`date_start` AS `t_date_start`,`t`.`date_finish` AS `t_date_finish`,`ee`.`name_eng` AS `ee_name_eng`,`e`.`name_eng` AS `e_name_eng`,`e`.`id` AS `eid`,`t`.`status_id` AS `status_id`,`r`.`id` AS `rid`,`i`.`path` AS `image`,`v`.`name_eng` AS `v_name_eng`,`v`.`value` AS `v_value`,`t`.`teams` AS `tteams`
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_rankings` AS `r`
ON (`r`.`id` = `t`.`rankings_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments_status` AS `s`
ON (`s`.`id` = `t`.`status_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments_values` AS `v`
ON (`v`.`id` = `t`.`values_id`)
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON (`ee`.`id` = `t`.`editions_id`)
LEFT JOIN `joomla_swos_events` AS `e`
ON (`e`.`id` = `ee`.`events_id`)
LEFT JOIN `joomla_swos_images` AS `i`
ON (`i`.`id` = `e`.`images_id`)
WHERE t.id = 7307id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ee NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE i NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.27 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/tournament.php:165 11 TournamentModelTournament->getDetails() JROOT/libraries/src/MVC/View/HtmlView.php:425 10 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tournament/views/tournament/view.html.php:13 9 TournamentViewTournament->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tournament/tournament.php:9 6 require_once JROOT/components/com_tournament/tournament.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 8.886 MB Rows returned: 1
SELECT ass.seasons_id,as.associations_id,ass.tournaments_id
FROM `joomla_swos_associations_series_seasons` AS `ass`
LEFT JOIN `joomla_swos_associations_series` AS `as`
ON (`as`.`id` = `ass`.`series_id`)
WHERE ass.tournaments_id = 7307id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ass NULL ref tournaments_id tournaments_id 4 const 1 100.00 NULL 1 SIMPLE as NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ass.series_id 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_tournament/models/tournament.php:101 11 TournamentModelTournament->getSeasondata() JROOT/libraries/src/MVC/View/HtmlView.php:425 10 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tournament/views/tournament/view.html.php:14 9 TournamentViewTournament->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tournament/tournament.php:9 6 require_once JROOT/components/com_tournament/tournament.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.46 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 8.894 MB Rows returned: 9
SELECT ass.tournaments_id,t.name_short,a.name_eng,as.associations_id
FROM `joomla_swos_associations_series_seasons` AS `ass`
LEFT JOIN `joomla_swos_associations_series` AS `as`
ON (`as`.`id` = `ass`.`series_id`)
LEFT JOIN `joomla_swos_associations` AS `a`
ON (`a`.`id` = `as`.`associations_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments` AS `t`
ON (`t`.`id` = `ass`.`tournaments_id`)
WHERE ass.seasons_id = 229
and as.associations_id = 66
ORDER BY ass.series_id asc, ass.class ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE as NULL ref PRIMARY,associations_id associations_id 4 const 1 100.00 Using index; Using temporary; Using filesort 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ass NULL ref series_id,seasons_id seasons_id 4 const 43 3.45 Using where 1 SIMPLE t NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ass.tournaments_id 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.31 ms preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.15 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.01 ms closing tables 0.13 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_tournament/models/tournament.php:118 11 TournamentModelTournament->getSeasondata() JROOT/libraries/src/MVC/View/HtmlView.php:425 10 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tournament/views/tournament/view.html.php:14 9 TournamentViewTournament->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tournament/tournament.php:9 6 require_once JROOT/components/com_tournament/tournament.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.89 ms After last query: 1.00 ms Query memory: 0.022 MB Memory before query: 8.928 MB Rows returned: 1Duplicate queries: #17
SELECT `t`.`name_eng` AS `t_name_eng`,`r`.`name_eng` AS `r_name_eng`,`t`.`id` AS `id`,`s`.`name_eng` AS `s_name_eng`,`t`.`text_eng` AS `t_text_eng`,`t`.`date_start` AS `t_date_start`,`t`.`date_finish` AS `t_date_finish`,`ee`.`name_eng` AS `ee_name_eng`,`e`.`name_eng` AS `e_name_eng`,`e`.`id` AS `eid`,`t`.`status_id` AS `status_id`,`r`.`id` AS `rid`,`i`.`path` AS `image`,`v`.`name_eng` AS `v_name_eng`,`v`.`value` AS `v_value`,`t`.`teams` AS `tteams`
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_rankings` AS `r`
ON (`r`.`id` = `t`.`rankings_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments_status` AS `s`
ON (`s`.`id` = `t`.`status_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments_values` AS `v`
ON (`v`.`id` = `t`.`values_id`)
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON (`ee`.`id` = `t`.`editions_id`)
LEFT JOIN `joomla_swos_events` AS `e`
ON (`e`.`id` = `ee`.`events_id`)
LEFT JOIN `joomla_swos_images` AS `i`
ON (`i`.`id` = `e`.`images_id`)
WHERE t.id = 7307id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE s NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ee NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE i NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.25 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/tournament.php:165 12 TournamentModelTournament->getDetails() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tournament/views/tournament/view.html.php:40 10 TournamentViewTournament->setDocument() JROOT/components/com_tournament/views/tournament/view.html.php:33 9 TournamentViewTournament->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tournament/tournament.php:9 6 require_once JROOT/components/com_tournament/tournament.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.83 ms After last query: 8.48 ms Query memory: 0.022 MB Memory before query: 9.362 MB Rows returned: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joomla_modules AS m
LEFT JOIN joomla_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joomla_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 <= '2025-10-20 21:50:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-20 21:50:45')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds published 1 const 13 2.50 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 dbs203386.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 dbs203386.m.id 1 40.00 Using where; Using index Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/swos/index.php:94 7 require JROOT/templates/swos/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 19.28 ms After last query: 3.93 ms Query memory: 0.022 MB Memory before query: 9.599 MB Rows returned: 2
SELECT *
FROM `joomla_users` AS `u`
WHERE lastvisitDate >= DATE_ADD( NOW(), INTERVAL -15 MINUTE)
ORDER BY lastvisitDate desc
LIMIT 50id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 15575 33.33 Using where; Using filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 18.75 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_useronline/helper.php:25 11 ModUserOnlineHelper::getUserOnline() JROOT/modules/mod_useronline/mod_useronline.php:8 10 include JROOT/modules/mod_useronline/mod_useronline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 2.78 ms Query memory: 0.022 MB Memory before query: 9.828 MB Rows returned: 1
SELECT *
FROM `joomla_swos_countries` AS `c`
WHERE id = 99id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/userprofile.php:41 12 TournamentModelUserprofile->getCountry() JROOT/modules/mod_useronline/tmpl/default.php:34 11 require JROOT/modules/mod_useronline/tmpl/default.php JROOT/modules/mod_useronline/mod_useronline.php:9 10 include JROOT/modules/mod_useronline/mod_useronline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.10 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 9.836 MB Rows returned: 1
SELECT count(m.id) as anzahl
FROM `joomla_swos_matches` AS `m`
LEFT JOIN `joomla_swos_events_editions_tournaments` AS `t`
ON t.id = m.tournaments_id
LEFT JOIN `joomla_swos_events_editions_tournaments_admins` AS `ta`
ON t.id = ta.tournaments_id
WHERE ta.users_id = 20738id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ta NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3936 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ta.tournaments_id 1 100.00 Using index 1 SIMPLE m NULL ref matches_tournaments matches_tournaments 4 dbs203386.ta.tournaments_id 36 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 2.54 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/userprofile.php:125 12 TournamentModelUserprofile->getAdminPoints() JROOT/modules/mod_useronline/tmpl/default.php:36 11 require JROOT/modules/mod_useronline/tmpl/default.php JROOT/modules/mod_useronline/mod_useronline.php:9 10 include JROOT/modules/mod_useronline/mod_useronline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.37 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 9.842 MB Rows returned: 1
SELECT sum(p.credits) as anzahl
FROM `joomla_swos_payments` AS `p`
LEFT JOIN `joomla_swos_users_payments` AS `pu`
ON p.id = pu.payments_id
WHERE pu.users_id = 20738id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pu NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 98 10.00 Using where 1 SIMPLE p NULL eq_ref PRIMARY PRIMARY 4 dbs203386.pu.payments_id 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/userprofile.php:155 12 TournamentModelUserprofile->getSupportPoints() JROOT/modules/mod_useronline/tmpl/default.php:37 11 require JROOT/modules/mod_useronline/tmpl/default.php JROOT/modules/mod_useronline/mod_useronline.php:9 10 include JROOT/modules/mod_useronline/mod_useronline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 9.849 MB Rows returned: 1
SELECT *
FROM `joomla_swos_countries` AS `c`
WHERE id = 160id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/userprofile.php:41 12 TournamentModelUserprofile->getCountry() JROOT/modules/mod_useronline/tmpl/default.php:34 11 require JROOT/modules/mod_useronline/tmpl/default.php JROOT/modules/mod_useronline/mod_useronline.php:9 10 include JROOT/modules/mod_useronline/mod_useronline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.01 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 9.856 MB Rows returned: 1
SELECT count(m.id) as anzahl
FROM `joomla_swos_matches` AS `m`
LEFT JOIN `joomla_swos_events_editions_tournaments` AS `t`
ON t.id = m.tournaments_id
LEFT JOIN `joomla_swos_events_editions_tournaments_admins` AS `ta`
ON t.id = ta.tournaments_id
WHERE ta.users_id = 21164id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ta NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3936 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ta.tournaments_id 1 100.00 Using index 1 SIMPLE m NULL ref matches_tournaments matches_tournaments 4 dbs203386.ta.tournaments_id 36 100.00 Using index Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 2.32 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/userprofile.php:125 12 TournamentModelUserprofile->getAdminPoints() JROOT/modules/mod_useronline/tmpl/default.php:36 11 require JROOT/modules/mod_useronline/tmpl/default.php JROOT/modules/mod_useronline/mod_useronline.php:9 10 include JROOT/modules/mod_useronline/mod_useronline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 9.862 MB Rows returned: 1
SELECT sum(p.credits) as anzahl
FROM `joomla_swos_payments` AS `p`
LEFT JOIN `joomla_swos_users_payments` AS `pu`
ON p.id = pu.payments_id
WHERE pu.users_id = 21164id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pu NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 98 10.00 Using where 1 SIMPLE p NULL eq_ref PRIMARY PRIMARY 4 dbs203386.pu.payments_id 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_tournament/models/userprofile.php:155 12 TournamentModelUserprofile->getSupportPoints() JROOT/modules/mod_useronline/tmpl/default.php:37 11 require JROOT/modules/mod_useronline/tmpl/default.php JROOT/modules/mod_useronline/mod_useronline.php:9 10 include JROOT/modules/mod_useronline/mod_useronline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.36 ms Query memory: 0.022 MB Memory before query: 9.868 MB Rows returned: 9
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE r.active = 1
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 14 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:18 11 ModRankingsHelper::getRankings() JROOT/modules/mod_rankings/mod_rankings.php:8 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 9.893 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 1
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.43 ms After last query: 0.05 ms Query memory: 0.038 MB Memory before query: 9.903 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -800 DAY)
and ru.rankings_id = 1
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 463 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.99 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 9.945 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 2
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.02 ms After last query: 0.05 ms Query memory: 0.038 MB Memory before query: 9.956 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -800 DAY)
and ru.rankings_id = 2
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 537 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.45 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 9.960 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 3
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.42 ms After last query: 0.05 ms Query memory: 0.038 MB Memory before query: 9.969 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -800 DAY)
and ru.rankings_id = 3
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 174 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 9.972 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 5
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 5.13 ms After last query: 0.05 ms Query memory: 0.038 MB Memory before query: 9.981 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -90 DAY)
and ru.rankings_id = 5
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 2867 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 4.64 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 9.984 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 7
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 0.10 ms Query memory: 0.038 MB Memory before query: 9.993 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -1000 DAY)
and ru.rankings_id = 7
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 175 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.39 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 10.012 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 8
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 0.12 ms Query memory: 0.038 MB Memory before query: 10.021 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -400 DAY)
and ru.rankings_id = 8
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 130 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.37 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 10.024 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 9
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.05 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 0.09 ms Query memory: 0.038 MB Memory before query: 10.033 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -1000 DAY)
and ru.rankings_id = 9
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 43 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 10.037 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 10
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 10.046 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -1000 DAY)
and ru.rankings_id = 10
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 34 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 10.049 MB Rows returned: 1
SELECT *
FROM `joomla_swos_rankings` AS `r`
WHERE id = 13
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_rankings/helper.php:38 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.92 ms After last query: 0.08 ms Query memory: 0.038 MB Memory before query: 10.059 MB Rows returned: 10
SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)
WHERE ru.date_change >= DATE_ADD(NOW(), INTERVAL -100 DAY)
and ru.rankings_id = 13
ORDER BY ru.rn desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ru NULL ref RU_rankings RU_rankings 4 const 192 33.33 Using index condition; Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ru.users_id 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 dbs203386.u.country 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.44 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_rankings/helper.php:52 12 ModRankingsHelper::getPlayers() JROOT/modules/mod_rankings/tmpl/default.php:15 11 require JROOT/modules/mod_rankings/tmpl/default.php JROOT/modules/mod_rankings/mod_rankings.php:9 10 include JROOT/modules/mod_rankings/mod_rankings.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 7.35 ms After last query: 0.70 ms Query memory: 0.021 MB Memory before query: 10.079 MB Rows returned: 1
SELECT i.path, t.name_short, t.id as tid, ee.short_name as edition, t.date_start, r.color, e.id as eid
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON ee.id = t.editions_id
LEFT JOIN `joomla_swos_events` AS `e`
ON e.id = ee.events_id
LEFT JOIN `joomla_swos_images` AS `i`
ON i.id = e.images_id
LEFT JOIN `joomla_swos_rankings` AS `r`
ON r.id = t.rankings_id
WHERE t.date_start > NOW()
and rankings_id in (1,2,3,7,9,10)
ORDER BY t.date_start asc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5069 16.66 Using where; Using filesort 1 SIMPLE ee NULL eq_ref PRIMARY PRIMARY 4 dbs203386.t.editions_id 1 100.00 NULL 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ee.events_id 1 100.00 NULL 1 SIMPLE i NULL eq_ref PRIMARY PRIMARY 4 dbs203386.e.images_id 1 100.00 NULL 1 SIMPLE r NULL eq_ref PRIMARY PRIMARY 4 dbs203386.t.rankings_id 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 6.30 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_tournaments/helper.php:23 11 ModTournamentsHelper::getNextOfflineTournaments() JROOT/modules/mod_tournaments/mod_tournaments.php:8 10 include JROOT/modules/mod_tournaments/mod_tournaments.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 8.51 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 10.086 MB Rows returned: 4
SELECT i.path, t.name_short, t.id as tid, ee.short_name as edition, t.date_start, r.color, e.id as eid
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON ee.id = t.editions_id
LEFT JOIN `joomla_swos_events` AS `e`
ON e.id = ee.events_id
LEFT JOIN `joomla_swos_images` AS `i`
ON i.id = e.images_id
LEFT JOIN `joomla_swos_rankings` AS `r`
ON r.id = t.rankings_id
WHERE t.date_start > NOW()
and rankings_id in (5,8,13)
ORDER BY t.date_start asc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5069 10.00 Using where; Using filesort 1 SIMPLE ee NULL eq_ref PRIMARY PRIMARY 4 dbs203386.t.editions_id 1 100.00 NULL 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ee.events_id 1 100.00 NULL 1 SIMPLE i NULL eq_ref PRIMARY PRIMARY 4 dbs203386.e.images_id 1 100.00 NULL 1 SIMPLE r NULL eq_ref PRIMARY PRIMARY 4 dbs203386.t.rankings_id 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 8.06 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_tournaments/helper.php:46 11 ModTournamentsHelper::getNextOnlineTournaments() JROOT/modules/mod_tournaments/mod_tournaments.php:9 10 include JROOT/modules/mod_tournaments/mod_tournaments.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 9.49 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 10.094 MB Rows returned: 10
SELECT i.path, t.name_short, t.id as tid, ee.short_name as edition, t.date_start, r.color, e.id as eid
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON ee.id = t.editions_id
LEFT JOIN `joomla_swos_events` AS `e`
ON e.id = ee.events_id
LEFT JOIN `joomla_swos_images` AS `i`
ON i.id = e.images_id
LEFT JOIN `joomla_swos_rankings` AS `r`
ON r.id = t.rankings_id
WHERE t.date_start < NOW()
ORDER BY t.date_start desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5069 33.33 Using where; Using filesort 1 SIMPLE ee NULL eq_ref PRIMARY PRIMARY 4 dbs203386.t.editions_id 1 100.00 NULL 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dbs203386.ee.events_id 1 100.00 NULL 1 SIMPLE i NULL eq_ref PRIMARY PRIMARY 4 dbs203386.e.images_id 1 100.00 NULL 1 SIMPLE r NULL eq_ref PRIMARY PRIMARY 4 dbs203386.t.rankings_id 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 9.00 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_tournaments/helper.php:71 11 ModTournamentsHelper::getLastTournaments() JROOT/modules/mod_tournaments/mod_tournaments.php:10 10 include JROOT/modules/mod_tournaments/mod_tournaments.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 5.16 ms Query memory: 0.025 MB Memory before query: 10.522 MB Rows returned: 1
SELECT *
FROM `joomla_kunena_configuration`
WHERE `id`=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_kunena_configuration NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 22 JDatabaseDriver->loadAssoc() JROOT/libraries/kunena/config.php:1430 21 KunenaConfig->load() JROOT/libraries/kunena/config.php:1403 20 KunenaConfig::getInstance() JROOT/components/com_kunena/router.php:42 19 KunenaBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 18 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_menu/helper.php:139 11 ModMenuHelper::getList() JROOT/modules/mod_menu/mod_menu.php:15 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.37 ms After last query: 9.40 ms Query memory: 0.022 MB Memory before query: 10.950 MB Rows returned: 0
SELECT uikit
FROM `joomla_cwgears`
WHERE url = 'https://sensiblesoccer.de/index.php?id=7307&option=com_tournament&view=tournament'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_cwgears NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:64 13 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:337 12 plgSystemCwgears->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 10.956 MB Rows returned: 0
SELECT uikit_plus
FROM `joomla_cwgears`
WHERE url = 'https://sensiblesoccer.de/index.php?id=7307&option=com_tournament&view=tournament'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE joomla_cwgears NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:64 13 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:346 12 plgSystemCwgears->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
30 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
10 × SELECT *
FROM `joomla_swos_rankings` AS `r`9 × SELECT *
FROM `joomla_swos_rankings_users` AS `ru`
LEFT JOIN `joomla_users` AS `u`
ON u.id = ru.users_id
LEFT JOIN `joomla_swos_countries` AS `c`
ON (`u`.`country` = `c`.`id`)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joomla_extensions`2 × SELECT `t`.`name_eng` AS `t_name_eng`,`r`.`name_eng` AS `r_name_eng`,`t`.`id` AS `id`,`s`.`name_eng` AS `s_name_eng`,`t`.`text_eng` AS `t_text_eng`,`t`.`date_start` AS `t_date_start`,`t`.`date_finish` AS `t_date_finish`,`ee`.`name_eng` AS `ee_name_eng`,`e`.`name_eng` AS `e_name_eng`,`e`.`id` AS `eid`,`t`.`status_id` AS `status_id`,`r`.`id` AS `rid`,`i`.`path` AS `image`,`v`.`name_eng` AS `v_name_eng`,`v`.`value` AS `v_value`,`t`.`teams` AS `tteams`
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_rankings` AS `r`
ON (`r`.`id` = `t`.`rankings_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments_status` AS `s`
ON (`s`.`id` = `t`.`status_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments_values` AS `v`
ON (`v`.`id` = `t`.`values_id`)
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON (`ee`.`id` = `t`.`editions_id`)
LEFT JOIN `joomla_swos_events` AS `e`
ON (`e`.`id` = `ee`.`events_id`)
LEFT JOIN `joomla_swos_images` AS `i`
ON (`i`.`id` = `e`.`images_id`)2 × SELECT *
FROM `joomla_swos_countries` AS `c`2 × SELECT count(m.id) as anzahl
FROM `joomla_swos_matches` AS `m`
LEFT JOIN `joomla_swos_events_editions_tournaments` AS `t`
ON t.id = m.tournaments_id
LEFT JOIN `joomla_swos_events_editions_tournaments_admins` AS `ta`
ON t.id = ta.tournaments_id2 × SELECT sum(p.credits) as anzahl
FROM `joomla_swos_payments` AS `p`
LEFT JOIN `joomla_swos_users_payments` AS `pu`
ON p.id = pu.payments_id2 × SELECT i.path, t.name_short, t.id as tid, ee.short_name as edition, t.date_start, r.color, e.id as eid
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON ee.id = t.editions_id
LEFT JOIN `joomla_swos_events` AS `e`
ON e.id = ee.events_id
LEFT JOIN `joomla_swos_images` AS `i`
ON i.id = e.images_id
LEFT JOIN `joomla_swos_rankings` AS `r`
ON r.id = t.rankings_id1 × SELECT `data`
FROM `joomla_session`1 × SELECT `session_id`
FROM `joomla_session`1 × SELECT id, rules
FROM `joomla_viewlevels1 × SELECT b.id
FROM joomla_usergroups AS a
LEFT JOIN joomla_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joomla_extensions1 × SELECT `enabled`
FROM `joomla_extensions`1 × SELECT `manifest_cache`
FROM `joomla_extensions`1 × SELECT count(*)
FROM `joomla_cwgears_schedule1 × SELECT count(*)
FROM `joomla_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 joomla_menu AS m
LEFT JOIN joomla_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM joomla_languages1 × SELECT id, home, template, s.params
FROM joomla_template_styles as s
LEFT JOIN joomla_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT ass.seasons_id,as.associations_id,ass.tournaments_id
FROM `joomla_swos_associations_series_seasons` AS `ass`
LEFT JOIN `joomla_swos_associations_series` AS `as`
ON (`as`.`id` = `ass`.`series_id`)1 × SELECT ass.tournaments_id,t.name_short,a.name_eng,as.associations_id
FROM `joomla_swos_associations_series_seasons` AS `ass`
LEFT JOIN `joomla_swos_associations_series` AS `as`
ON (`as`.`id` = `ass`.`series_id`)
LEFT JOIN `joomla_swos_associations` AS `a`
ON (`a`.`id` = `as`.`associations_id`)
LEFT JOIN `joomla_swos_events_editions_tournaments` AS `t`
ON (`t`.`id` = `ass`.`tournaments_id`)1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joomla_modules AS m
LEFT JOIN joomla_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joomla_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM `joomla_users` AS `u`1 × SELECT i.path, t.name_short, t.id as tid, ee.short_name as edition, t.date_start, r.color, e.id as eid
FROM `joomla_swos_events_editions_tournaments` AS `t`
LEFT JOIN `joomla_swos_events_editions` AS `ee`
ON ee.id = t.editions_id
LEFT JOIN `joomla_swos_events` AS `e`
ON e.id = ee.events_id
LEFT JOIN `joomla_swos_images` AS `i`
ON i.id = e.images_id
LEFT JOIN `joomla_swos_rankings` AS `r`
ON r.id = t.rankings_id1 × SELECT *
FROM `joomla_kunena_configuration`1 × SELECT uikit
FROM `joomla_cwgears`1 × SELECT uikit_plus
FROM `joomla_cwgears`
OTHER Tables:
1 × INSERT INTO `joomla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6462653261663063336265346564626135656436643339613861396164633566', 1, 1760997045, 0, '', 01 × UPDATE `joomla_extensions`
SET `params` = '{\"mediaversion\":\"79a178f4f8501b4e688ae7664303a001\"}'