Runners looking for team

Runner name	Time on 10km	City
Adriana Miklianová	01:06:00	Bratislava - Petržalka
Annamária Kohanová	01:00:00	Košice - Sever
Andrea Hinštová	01:05:00	Bratislava - Rača
Andrei Stain	00:39:00	Bratislava - Staré Mesto
Anita Bolechová	00:58:00	Trenčín
Lenka Meliš	01:00:00	Ilava
Barbora Hermanová	01:00:00	Sliač
Brano Lanak	00:56:00	Bratislava - Devín
Daniel Poluch	00:55:00	Bratislava - Petržalka
Daniel Rímsky	01:00:00	Trenčín
Dávid Kállay	00:45:00	Bratislava - Podunajské Biskupice
David Stolton	01:05:00	Bratislava - Staré Mesto
Ján Zsibrita	01:00:00	Lehnice
Dusan Tomic	00:41:00	Bratislava - Nové Mesto
Eduard Adam	00:55:00	Vranov nad Topľou
Filip Tomášek	00:45:00	Miloslavov
Alfred Pohly	00:50:00	Harichovce
Gabriela Orszaghova	00:52:00	Bratislava - Petržalka
Gabriel Ferencz	00:55:00	Košice - Barca
Jakub Laurenčík	00:55:00	Bratislava - Ružinov
Jana Ševčíková	00:56:00	Bratislava - Petržalka
Jaroslav Hlavina	00:48:00	Trenčianska Teplá
Matus Jurko	00:55:00	Bratislava - Petržalka
Soňa Karabašová	00:44:00	Košice - Sídlisko Ťahanovce
Tono Krivda	00:48:00	Tvrdošín
Ladislav Péter	00:44:00	Fiľakovo
Marián Novotný	00:58:00	Bratislava - Petržalka
Marcela Pistova	01:00:00	Bratislava - Nové Mesto
Marek Mička	00:48:00	Bratislava - Petržalka
Marek Gajdoš	00:50:00	Východná
Martin Molnár	00:54:00	Bratislava - Ružinov
Martina Krišková	00:54:00	Košice - Sídlisko Ťahanovce
Michal Mikulka	00:50:00	Bratislava - Karlova Ves
Michal Jurčišin	00:47:00	Poprad
Michal Karlubik	00:50:00	Bratislava - Karlova Ves
Michal Šušoliak	00:52:00	Bratislava - Dúbravka
Milos Bezec	01:00:00	Bratislava - Karlova Ves
Norbert Ištók	00:55:00	Bratislava - Podunajské Biskupice
Oleg Dinuš	00:48:00	Láb
Patrik Binovsky	00:40:00	Bratislava - Ružinov
Petr Procházka	00:58:00	Humenné
Martin Fulmek	00:15:00	Kolárovice
Richard Kuna	00:45:00	Košice - Sídlisko Ťahanovce
Robert Pastor	00:49:00	Valaliky
Roman Schiller	00:50:00	Lučenec
Samuel Vetrak	00:48:00	Bratislava - Ružinov
Tibor Ďurina	00:55:00	Piešťany
Vanessa Kocsisova	01:00:00	Bratislava - Nové Mesto
Vladimír Ďuriš	00:53:00	Zvolen
Rudolf Mišejka	00:58:00	Rajecké Teplice
Zuzana VACULČIAKOVÁ	00:58:00	Banská Bystrica

Time until start 336 days 3 hours 5 minutes

214 teams registered

Main partners

Main sport partner
Partners


Main medial partners

Under the auspices

Supported the event


Medial partners


Production

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726277077,
                "last": 1726277077,
                "now": 1726277077
            },
            "token": "xrF2g9K0puwFFQrm02rU3WWLIYcCCk2J"
        },
        "registry": {
            "com_odtatierkdunaju": {
                "users": {
                    "ordercol": null
                }
            }
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Profile Information

Time

Memory

Time: 3.91 ms / 3.91 ms Memory: 0.519 MB / 0.89 MB Application: afterLoad

Time: 32.07 ms / 35.98 ms Memory: 2.534 MB / 3.42 MB Application: afterInitialise

Time: 4.90 ms / 40.88 ms Memory: 0.342 MB / 3.77 MB Application: afterRoute

Time: 1.56 ms / 42.44 ms Memory: 0.157 MB / 3.92 MB Application: beforeRenderComponent com_odtatierkdunaju

Time: 21.99 ms / 64.43 ms Memory: 0.308 MB / 4.23 MB Application: afterRenderComponent com_odtatierkdunaju

Time: 3.52 ms / 67.95 ms Memory: 0.094 MB / 4.33 MB Application: afterDispatch

Time: 54.62 ms / 122.57 ms Memory: 0.091 MB / 4.42 MB Application: beforeRenderModule mod_otd_timeuntilrace (Time until the Race!)

Time: 0.51 ms / 123.08 ms Memory: 0.007 MB / 4.42 MB Application: afterRenderModule mod_otd_timeuntilrace (Time until the Race!)

Time: 0.03 ms / 123.11 ms Memory: -0.002 MB / 4.42 MB Application: beforeRenderModule mod_otd_timeuntilrace (Registered teams)

Time: 9.45 ms / 132.55 ms Memory: 0.018 MB / 4.44 MB Application: afterRenderModule mod_otd_timeuntilrace (Registered teams)

Time: 0.62 ms / 133.17 ms Memory: 0.036 MB / 4.48 MB Application: beforeRenderModule mod_menu (Register)

Time: 45.17 ms / 178.35 ms Memory: 0.016 MB / 4.49 MB Application: afterRenderModule mod_menu (Register)

Time: 3.15 ms / 181.49 ms Memory: -0.003 MB / 4.49 MB Application: beforeRenderModule mod_menu (Users menu-en)

Time: 3.36 ms / 184.85 ms Memory: 0.013 MB / 4.50 MB Application: afterRenderModule mod_menu (Users menu-en)

Time: 2.89 ms / 187.74 ms Memory: -0.002 MB / 4.50 MB Application: beforeRenderModule mod_menu (Main menu)

Time: 48.51 ms / 236.25 ms Memory: 0.168 MB / 4.67 MB Application: afterRenderModule mod_menu (Main menu)

Time: 3.48 ms / 239.73 ms Memory: -0.017 MB / 4.65 MB Application: beforeRenderModule mod_cookiesaccept (CookiesAccept)

Time: 0.43 ms / 240.16 ms Memory: 0.019 MB / 4.67 MB Application: afterRenderModule mod_cookiesaccept (CookiesAccept)

Time: 1.30 ms / 241.46 ms Memory: 0.180 MB / 4.85 MB Application: afterRender

Database queries total: 32.04 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	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

EXPLAIN not possible on query: INSERT INTO `otd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'34736b323831333861726b64756a71727636626d3075336b3174', 1, 1726277077, 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.22 ms
end	0.02 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 2.16 ms Query memory: 0.021 MB Memory before query: 1.443 MB Rows returned: 6

SELECT id, rules

  FROM `otd_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.36 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.455 MB Rows returned: 2

SELECT b.id

  FROM otd_usergroups AS a

  LEFT JOIN otd_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	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	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.36 ms After last query: 5.69 ms Query memory: 0.022 MB Memory before query: 1.977 MB Rows returned: 1

SELECT `value`

  FROM `otd_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_admintools_storage	NULL	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 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.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.26 ms After last query: 0.62 ms Query memory: 0.021 MB Memory before query: 2.018 MB Rows returned: 1

SELECT *

  FROM `otd_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_admintools_wafexceptions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 7.21 ms Query memory: 0.021 MB Memory before query: 2.348 MB Rows returned: 0

SELECT *

  FROM `otd_admintools_ipautoban`

  WHERE `ip` = '98.81.24.230'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 2.354 MB Rows returned: 40

SELECT `ip`

  FROM `otd_admintools_ipblock`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_admintools_ipblock	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	40	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:143
11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:37
10	AtsystemFeatureIpblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.361 MB Rows returned: 1

SELECT *

  FROM `otd_admintools_storage`

  WHERE `key` LIKE 'timestamp_%'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_admintools_storage	NULL	range	PRIMARY	PRIMARY	402	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115
10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.30 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 2.372 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `otd_admintools_redirects`

  WHERE ((`dest` = 'index.php/en/start-list/runners-looking-for-team') OR (`dest` = 'index.php/en/start-list/runners-looking-for-team') OR ('index.php/en/start-list/runners-looking-for-team' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_admintools_redirects	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.04 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.01 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 7.17 ms Query memory: 0.021 MB Memory before query: 3.756 MB Rows returned: 1

SELECT *

  FROM `otd_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_odtatierkdunaju') 
  AND `view` IN('','users') 
  AND `task` IN('','users.') 
  AND `enabled` = '1'

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_admintools_wafblacklists	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:92
10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:154
8	plgSystemAdmintools->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.45 ms After last query: 0.72 ms Query memory: 0.005 MB Memory before query: 3.831 MB

UPDATE `otd_extensions`

  SET `params` = '{\"mediaversion\":\"b0f05b2b33391ec2d44be7a55d1f361b\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	otd_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.12 ms
updating	0.12 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 14.80 ms After last query: 4.09 ms Query memory: 0.031 MB Memory before query: 4.128 MB Rows returned: 51

SELECT u.id as uid,ud.name_first,ud.name_last,u.username,ud.time_on_10km,ud.hide_profile,obec.nazov as city,
  CASE WHEN length(u.activation) > 0 THEN 1 ELSE 0 END as active

  FROM otd_users u

  LEFT JOIN otd_otd_userdetails ud 
  ON u.id = ud.user_id

  LEFT JOIN otd_user_usergroup_map ugm 
  ON u.id = ugm.user_id

  LEFT JOIN otd_otd_address_obec obec 
  ON ud.city = obec.id 
  AND obec.lang = 'en-GB'

  WHERE ugm.group_id = 12 
  AND ud.hide_profile = 0 
  AND ud.city <> 0 
  AND length(u.activation) <= 0

  ORDER BY u.username

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ud	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2615	9.00	Using where; Using temporary; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	odtatierkdunaju_j4.ud.user_id	1	100.00	Using where
1	SIMPLE	ugm	NULL	eq_ref	PRIMARY	PRIMARY	8	odtatierkdunaju_j4.ud.user_id,const	1	100.00	Using where; Using index
1	SIMPLE	obec	NULL	eq_ref	PRIMARY	PRIMARY	26	odtatierkdunaju_j4.ud.city,const	1	100.00	NULL

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.44 ms
init	1.19 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	12.53 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_odtatierkdunaju/models/users.php:51
11	OdtatierkdunajuModelUsers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_odtatierkdunaju/views/users/view.html.php:19
9	OdtatierkdunajuViewUsers->display()	JROOT/components/com_odtatierkdunaju/controller.php:40
8	OdtatierkdunajuController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_odtatierkdunaju/odtatierkdunaju.php:26
6	require_once JROOT/components/com_odtatierkdunaju/odtatierkdunaju.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.44 ms After last query: 0.19 ms Query memory: 0.030 MB Memory before query: 4.170 MB Rows returned: 27

SELECT *

  FROM otd_otd_userdetails

  WHERE user_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_otd_userdetails	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2615	10.00	Using where

Profile

Status	Duration
starting	0.04 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
executing	0.00 ms
Sending data	1.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.41 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_odtatierkdunaju/helpers/JOdtatierkdunajuHelper.php:595
11	JOdtatierkdunajuHelper::getOtdUserDetails()	JROOT/components/com_odtatierkdunaju/helpers/JOdtatierkdunajuHelper.php:582
10	JOdtatierkdunajuHelper::isLookingForTeammates()	JROOT/components/com_odtatierkdunaju/views/users/view.html.php:31
9	OdtatierkdunajuViewUsers->display()	JROOT/components/com_odtatierkdunaju/controller.php:40
8	OdtatierkdunajuController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_odtatierkdunaju/odtatierkdunaju.php:26
6	require_once JROOT/components/com_odtatierkdunaju/odtatierkdunaju.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.68 ms After last query: 0.32 ms Query memory: 0.028 MB Memory before query: 4.182 MB Rows returned: 23

SHOW FULL COLUMNS 
  FROM `otd_otd_team`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `otd_otd_team`

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.04 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.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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 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.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.42 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_odtatierkdunaju/tables/team.php:17
12	OdtatierkdunajuTableTeam->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_odtatierkdunaju/helpers/JOdtatierkdunajuHelper.php:438
10	JOdtatierkdunajuHelper::getOtdTeamIdByCaptainId()	JROOT/components/com_odtatierkdunaju/views/users/view.html.php:37
9	OdtatierkdunajuViewUsers->display()	JROOT/components/com_odtatierkdunaju/controller.php:40
8	OdtatierkdunajuController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_odtatierkdunaju/odtatierkdunaju.php:26
6	require_once JROOT/components/com_odtatierkdunaju/odtatierkdunaju.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.34 ms Query memory: 0.022 MB Memory before query: 4.220 MB Rows returned: 0

SELECT id

  FROM otd_otd_team

  WHERE captain = 0 
  AND competition_year =2024

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_otd_team	NULL	ref	idx_captain	idx_captain	4	const	1	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.15 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_odtatierkdunaju/helpers/JOdtatierkdunajuHelper.php:442
10	JOdtatierkdunajuHelper::getOtdTeamIdByCaptainId()	JROOT/components/com_odtatierkdunaju/views/users/view.html.php:37
9	OdtatierkdunajuViewUsers->display()	JROOT/components/com_odtatierkdunaju/controller.php:40
8	OdtatierkdunajuController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_odtatierkdunaju/odtatierkdunaju.php:26
6	require_once JROOT/components/com_odtatierkdunaju/odtatierkdunaju.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.42 ms After last query: 1.03 ms Query memory: 0.021 MB Memory before query: 4.296 MB Rows returned: 6

SELECT language,id

  FROM `otd_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	otd_menu	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	300	0.86	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.04 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.21 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	4.11 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.20 ms After last query: 4.30 ms Query memory: 0.040 MB Memory before query: 4.378 MB Rows returned: 10

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM otd_modules AS m

  LEFT JOIN otd_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN otd_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 <= '2024-09-14 01:24:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-14 01:24:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 132 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	36	1.49	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	odtatierkdunaju_j4.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	odtatierkdunaju_j4.m.id	2	40.00	Using where; Using index

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.64 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	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/odtatierkdunaju/index.php:159
7	require JROOT/templates/odtatierkdunaju/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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 8.89 ms After last query: 52.92 ms Query memory: 0.022 MB Memory before query: 4.450 MB Rows returned: 1

SELECT COUNT(*)

  FROM otd_otd_team t

  LEFT JOIN otd_users u 
  ON u.id = t.captain

  LEFT JOIN otd_otd_userdetails ud 
  ON u.id = ud.user_id

  LEFT JOIN otd_otd_category c 
  ON c.id = t.category

  LEFT JOIN (SELECT p.captain, p.competition_year, COUNT(*) AS cnt 
  FROM otd_otd_payment p
			
  WHERE p.payment_reason = 1 
			
  GROUP by p.captain, p.competition_year) 
			AS pay 
  ON u.id = pay.captain 
  AND pay.competition_year = t.competition_year

  WHERE ud.user_id IS NOT NULL 
  AND t.competition_year = 2024

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	ud	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2615	90.00	Using where
1	PRIMARY	u	NULL	eq_ref	PRIMARY	PRIMARY	4	odtatierkdunaju_j4.ud.user_id	1	100.00	Using index
1	PRIMARY	t	NULL	ref	idx_captain	idx_captain	4	odtatierkdunaju_j4.ud.user_id	1	10.00	Using index condition; Using where
1	PRIMARY	c	NULL	ref	PRIMARY	PRIMARY	4	odtatierkdunaju_j4.t.category	1	100.00	Using where; Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	8	odtatierkdunaju_j4.ud.user_id,const	10	100.00	Using where
2	DERIVED	p	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2267	10.00	Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.12 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.06 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.10 ms
executing	0.00 ms
Sending data	1.63 ms
Creating sort index	6.54 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	3.59 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_otd_timeuntilrace/helper.php:39
11	modOtdTimeUntilRaceHelper::getRegisteredTeams()	JROOT/modules/mod_otd_timeuntilrace/mod_otd_timeuntilrace.php:39
10	include JROOT/modules/mod_otd_timeuntilrace/mod_otd_timeuntilrace.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1 × SELECT `data` 
  FROM `otd_session`

1 × SELECT `source`,`keepurlparams` 
  FROM `otd_admintools_redirects`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM otd_modules AS m 
  LEFT JOIN otd_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN otd_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT language,id 
  FROM `otd_menu`

```
1 × SELECT id 
  FROM otd_otd_team
```

1 × SELECT * 
  FROM otd_otd_userdetails

1 × SELECT u.id as uid,ud.name_first,ud.name_last,u.username,ud.time_on_10km,ud.hide_profile,obec.nazov as city,
  CASE WHEN length(u.activation) > 0 THEN 1 ELSE 0 END as active 
  FROM otd_users u 
  LEFT JOIN otd_otd_userdetails ud 
  ON u.id = ud.user_id 
  LEFT JOIN otd_user_usergroup_map ugm 
  ON u.id = ugm.user_id 
  LEFT JOIN otd_otd_address_obec obec 
  ON ud.city = obec.id 
  AND obec.lang = 'en-GB'

1 × SELECT * 
  FROM `otd_admintools_wafblacklists`

1 × SELECT * 
  FROM `otd_admintools_storage`

1 × SELECT `session_id` 
  FROM `otd_session`

1 × SELECT `ip` 
  FROM `otd_admintools_ipblock

1 × SELECT * 
  FROM `otd_admintools_ipautoban`

1 × SELECT * 
  FROM `otd_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `otd_admintools_storage`

1 × SELECT b.id 
  FROM otd_usergroups AS a 
  LEFT JOIN otd_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `otd_viewlevels

1 × SELECT COUNT(*) 
  FROM otd_otd_team t 
  LEFT JOIN otd_users u 
  ON u.id = t.captain 
  LEFT JOIN otd_otd_userdetails ud 
  ON u.id = ud.user_id 
  LEFT JOIN otd_otd_category c 
  ON c.id = t.category 
  LEFT JOIN (SELECT p.captain, p.competition_year, COUNT(*) AS cnt 
  FROM otd_otd_payment p

OTHER Tables:

1 × INSERT INTO `otd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'34736b323831333861726b64756a71727636626d3075336b3174', 1, 1726277077, 0, '', 0

1 × UPDATE `otd_extensions` 
  SET `params` = '{\"mediaversion\":\"b0f05b2b33391ec2d44be7a55d1f361b\"}'

1 × SHOW FULL COLUMNS 
  FROM `otd_otd_team

Runners looking for team

Main

partners

Main

sport

partner

Partners

Main medial partners

Under the auspices

Supported

the event

Medial partners

Production

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

20 Queries Logged 32.04 ms

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: