Safari Rally Kenya

Soutěž	Datum	Vítěz
EA Sports WRC	2024-03-20	Filip Kubašta
EA Sports WRC2	2024-03-20	Ján Kundlák

Konzole ladění chyb Joomla!

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1776462834,
                "last": 1776462834,
                "now": 1776462834
            }
        },
        "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
        }
    }
}

Informace o profilu

Využití paměti

Dotazy do databáze

41 zaznamenaných dotazů 238.50 ms

Nalezeno 20 duplikátů!

6 duplikátů: #12 #15 #16 #17 #20 #22

2 duplikátů: #14 #23

2 duplikátů: #19 #21

6 duplikátů: #24 #26 #27 #28 #31 #33

2 duplikátů: #25 #34

2 duplikátů: #30 #32

Čas pro dotazy: 0.53 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 5.316 MB Vráceno řádků: 1

SELECT COUNT(extension_id)

  FROM nsivc_extensions

  WHERE element = 'com_redcore' 
  AND type = 'component'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nsivc_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
12	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/redcore/component/helper.php:279
10	RComponentHelper::isInstalled()	JROOT/libraries/redcore/bootstrap.php:77
9	RBootstrap::getConfig()	JROOT/libraries/redcore/bootstrap.php:171
8	RBootstrap::bootstrap()	JROOT/plugins/system/redcore/redcore.php:43
7	PlgSystemRedcore->__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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.43 ms Po posledním dotazu: 11.80 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 6.230 MB Vráceno řádků: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `nsivc_extensions`

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

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nsivc_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
19	RDatabaseDriverMysqli->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}()	Stejné jako volání na řádku níže.
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/k2/k2.php:47
8	plgSystemK2->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.45 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 6.223 MB

UPDATE `nsivc_extensions`

  SET `params` = '{\"mediaversion\":\"77c586fed4d1043138e581c05fa968a8\"}'

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

Vysvětlení

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.06 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.08 ms
closing tables	0.00 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
14	RDatabaseDriverMysqli->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/k2/k2.php:47
8	plgSystemK2->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.04 ms Po posledním dotazu: 5.71 ms Dotaz paměti: 0.072 MB Paměť před dotazem: 6.855 MB Vráceno řádků: 48

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 nsivc_menu AS m

  LEFT JOIN nsivc_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	143	4.06	Using where; Použití filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.49 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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
19	RDatabaseDriverMysqli->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}()	Stejné jako volání na řádku níže.
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.46 ms Po posledním dotazu: 10.65 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 8.051 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_redcore_schemas

  WHERE asset_id = '#__tracks_rounds'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
18	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/redcore/table/table.php:1072
16	RTable->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/redcore/table/table.php:191
14	RTable->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_tracks/router.php:403
12	TracksRouter->getRoundId()	Stejné jako volání na řádku níže.
11	call_user_func_array()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140
10	Joomla\CMS\Component\Router\Rules\StandardRules->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.51 ms Po posledním dotazu: 0.52 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 8.094 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_rounds

  WHERE `alias` = 'safari-rally-kenya'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nsivc_tracks_rounds	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	74	10.00	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
16	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
13	RTable->load()	JROOT/components/com_tracks/router.php:404
12	TracksRouter->getRoundId()	Stejné jako volání na řádku níže.
11	call_user_func_array()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140
10	Joomla\CMS\Component\Router\Rules\StandardRules->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.39 ms Po posledním dotazu: 1.56 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 8.263 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_languages

  WHERE published=1

  ORDER BY ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nsivc_languages	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	2	50.00	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
14	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:235
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.46 ms Po posledním dotazu: 1.36 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 8.374 MB Vráceno řádků: 4

SELECT id, home, template, s.params

  FROM nsivc_template_styles as s

  LEFT JOIN nsivc_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	ttrtvcz2.e.element	1	71.43	Using index condition; Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
21	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Stejné jako volání na řádku níže.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:259
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.29 ms Po posledním dotazu: 4.52 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 8.801 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_rounds

  WHERE `id` = '84'

Vysvětlení

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 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.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
16	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
13	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
12	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
11	TrackslibEntityBase::load()	JROOT/components/com_tracks/models/round.php:28
10	TracksModelRound->getRound()	JROOT/components/com_tracks/views/round/view.html.php:35
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.56 ms Po posledním dotazu: 9.34 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 9.774 MB Vráceno řádků: 2

SELECT obj.*,r.name as name

  FROM `nsivc_tracks_projects_rounds` AS `obj`

  INNER JOIN nsivc_tracks_rounds AS r 
  on r.id = obj.round_id

  WHERE `obj`.`round_id` = 84 
  AND `obj`.`published` = 1

  ORDER BY obj.start_date desc

Vysvětlení

id	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	Použití filesort
1	SIMPLE	obj	NULL	ref	round_id	round_id	4	const	2	10.00	Using index condition; Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
23	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/tracks/model/list.php:59
19	TrackslibModelList->search()	JROOT/libraries/tracks/model/list.php:72
18	TrackslibModelList->searchEntities()	JROOT/libraries/tracks/entity/round.php:40
17	TrackslibEntityRound->getProjectrounds()	JROOT/components/com_tracks/views/round/tmpl/default.php:22
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.31 ms Po posledním dotazu: 3.09 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 10.320 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_redcore_schemas

  WHERE asset_id = '#__tracks_projects_rounds'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
39	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
38	JDatabaseDriver->loadAssoc()	JROOT/libraries/redcore/table/table.php:1072
37	RTable->getFields()	JROOT/libraries/src/Table/Table.php:180
36	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/redcore/table/table.php:191
35	RTable->__construct()	JROOT/libraries/src/Table/Table.php:328
34	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/redcore/table/table.php:884
33	RTable::getAutoInstance()	JROOT/libraries/redcore/table/table.php:907
32	RTable::getAdminInstance()	JROOT/libraries/tracks/entity/base.php:751
31	TrackslibEntityBase->getTable()	JROOT/libraries/tracks/entity/base.php:883
30	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:47
29	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
28	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.31 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 10.357 MB Vráceno řádků: 1

Duplicitní dotazy: #15 #16 #17 #20 #22

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '606'

Vysvětlení

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

Profil

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.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
34	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
32	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
31	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
30	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:47
29	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
28	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.30 ms Po posledním dotazu: 0.45 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 10.404 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_redcore_schemas

  WHERE asset_id = '#__tracks_projects'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
39	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
38	JDatabaseDriver->loadAssoc()	JROOT/libraries/redcore/table/table.php:1072
37	RTable->getFields()	JROOT/libraries/src/Table/Table.php:180
36	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/redcore/table/table.php:191
35	RTable->__construct()	JROOT/libraries/src/Table/Table.php:328
34	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/redcore/table/table.php:884
33	RTable::getAutoInstance()	JROOT/libraries/redcore/table/table.php:907
32	RTable::getAdminInstance()	JROOT/libraries/tracks/entity/base.php:751
31	TrackslibEntityBase->getTable()	JROOT/libraries/tracks/entity/base.php:883
30	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
29	TrackslibEntityBase::load()	JROOT/components/com_tracks/router.php:176
28	TracksRouter->getProjectSegment()	Stejné jako volání na řádku níže.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.32 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 10.441 MB Vráceno řádků: 1

Duplicitní dotazy: #23

SELECT *

  FROM nsivc_tracks_projects

  WHERE `id` = '45'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
34	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
32	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
31	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
30	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
29	TrackslibEntityBase::load()	JROOT/components/com_tracks/router.php:176
28	TracksRouter->getProjectSegment()	Stejné jako volání na řádku níže.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.23 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 10.461 MB Vráceno řádků: 1

Duplicitní dotazy: #12 #16 #17 #20 #22

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '606'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
36	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
33	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
32	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:47
31	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
30	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
27	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
26	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_tracks/router.php:126
25	TracksRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
24	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
23	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.19 ms Po posledním dotazu: 0.19 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 10.478 MB Vráceno řádků: 1

Duplicitní dotazy: #12 #15 #17 #20 #22

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '606'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
22	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
19	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
18	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
17	TrackslibEntityProjectround->getProject()	JROOT/components/com_tracks/views/round/tmpl/default.php:65
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.26 ms Po posledním dotazu: 0.68 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 10.504 MB Vráceno řádků: 1

Duplicitní dotazy: #12 #15 #16 #20 #22

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '606'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
23	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
20	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
19	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
18	TrackslibEntityProjectround->getProject()	JROOT/libraries/tracks/entity/projectround.php:92
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.29 ms Po posledním dotazu: 0.93 ms Dotaz paměti: 0.056 MB Paměť před dotazem: 10.569 MB Vráceno řádků: 113

SELECT i.id, i.first_name, i.last_name, i.country_code, i.picture_small, i.nickname,  pi.team_id, pi.number,  t.name AS team_name, t.short_name AS team_short_name, t.acronym AS team_acronym, t.picture_small AS team_logo, 
  CASE WHEN CHAR_LENGTH( i.alias ) THEN CONCAT_WS( ':', i.id, i.alias ) ELSE i.id END AS slug,  
  CASE WHEN CHAR_LENGTH( t.alias ) THEN CONCAT_WS( ':', t.id, t.alias ) ELSE t.id END AS teamslug  
  FROM nsivc_tracks_participants AS pi  
  INNER JOIN nsivc_tracks_individuals AS i 
  ON i.id = pi.individual_id  
  LEFT JOIN nsivc_tracks_teams AS t 
  ON t.id = pi.team_id  
  WHERE pi.project_id = 45 
  ORDER BY pi.number ASC, i.last_name ASC, i.first_name ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pi	NULL	ref	individual_id,project_id	project_id	4	const	113	100.00	Using temporary; Použití filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.pi.team_id	1	100.00	NULL
1	SIMPLE	i	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.pi.individual_id	1	100.00	NULL

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.57 ms
Creating sort index	0.17 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.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
21	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:227
19	TrackslibRankingtoolDefault->_initIndividuals()	JROOT/libraries/tracks/rankingtool/default.php:110
18	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/entity/projectround.php:92
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 43.79 ms Po posledním dotazu: 0.26 ms Dotaz paměti: 0.300 MB Paměť před dotazem: 10.850 MB Vráceno řádků: 661

Duplicitní dotazy: #21

SELECT rr.individual_id as id, rr.rank, rr.bonus_points, rr.team_id, rr.params, rr.performance,sr.projectround_id, sr.rank_offset,srt.points_attribution, srt.count_points, srt.enable_stats,(rr.rank + sr.rank_offset) AS global_rank

  FROM nsivc_tracks_events_results AS rr

  INNER JOIN nsivc_tracks_events AS sr 
  ON sr.id = rr.event_id

  INNER JOIN nsivc_tracks_eventtypes AS srt 
  ON srt.id = sr.type

  INNER JOIN nsivc_tracks_projects_rounds AS pr 
  ON pr.id = sr.projectround_id

  WHERE pr.project_id = 45 
  AND pr.published = 1 
  AND sr.published = 1

  ORDER BY pr.ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr	NULL	ref	PRIMARY,project_id	project_id	4	const	13	10.00	Using index condition; Using where; Použití filesort
1	SIMPLE	sr	NULL	ref	PRIMARY,projectround_id,type	projectround_id	4	ttrtvcz2.pr.id	1	10.00	Using where
1	SIMPLE	srt	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.sr.type	1	100.00	NULL
1	SIMPLE	rr	NULL	ref	event_id	event_id	4	ttrtvcz2.sr.id	18	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.65 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

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
21	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:274
19	TrackslibRankingtoolDefault->_getResults()	JROOT/libraries/tracks/rankingtool/default.php:112
18	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/entity/projectround.php:92
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.45 ms Po posledním dotazu: 1.77 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 10.607 MB Vráceno řádků: 1

Duplicitní dotazy: #12 #15 #16 #17 #22

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '606'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
25	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
22	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
21	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
20	TrackslibEntityProjectround->getProject()	JROOT/libraries/tracks/entity/projectround.php:102
19	TrackslibEntityProjectround->{closure}()	Stejné jako volání na řádku níže.
18	array_map()	JROOT/libraries/tracks/entity/projectround.php:106
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.24 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.301 MB Paměť před dotazem: 10.618 MB Vráceno řádků: 661

Duplicitní dotazy: #19

SELECT rr.individual_id as id, rr.rank, rr.bonus_points, rr.team_id, rr.params, rr.performance,sr.projectround_id, sr.rank_offset,srt.points_attribution, srt.count_points, srt.enable_stats,(rr.rank + sr.rank_offset) AS global_rank

  FROM nsivc_tracks_events_results AS rr

  INNER JOIN nsivc_tracks_events AS sr 
  ON sr.id = rr.event_id

  INNER JOIN nsivc_tracks_eventtypes AS srt 
  ON srt.id = sr.type

  INNER JOIN nsivc_tracks_projects_rounds AS pr 
  ON pr.id = sr.projectround_id

  WHERE pr.project_id = 45 
  AND pr.published = 1 
  AND sr.published = 1

  ORDER BY pr.ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr	NULL	ref	PRIMARY,project_id	project_id	4	const	13	10.00	Using index condition; Using where; Použití filesort
1	SIMPLE	sr	NULL	ref	PRIMARY,projectround_id,type	projectround_id	4	ttrtvcz2.pr.id	1	10.00	Using where
1	SIMPLE	srt	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.sr.type	1	100.00	NULL
1	SIMPLE	rr	NULL	ref	event_id	event_id	4	ttrtvcz2.sr.id	18	100.00	NULL

Profil

Status	Duration
starting	0.07 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.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.74 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
23	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:274
21	TrackslibRankingtoolDefault->_getResults()	JROOT/libraries/tracks/rankingtool/default.php:410
20	TrackslibRankingtoolDefault->getIndividualProjectRoundResults()	JROOT/libraries/tracks/entity/projectround.php:102
19	TrackslibEntityProjectround->{closure}()	Stejné jako volání na řádku níže.
18	array_map()	JROOT/libraries/tracks/entity/projectround.php:106
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.26 ms Po posledním dotazu: 1.18 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 10.686 MB Vráceno řádků: 1

Duplicitní dotazy: #12 #15 #16 #17 #20

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '606'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
22	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
19	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
18	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
17	TrackslibEntityProjectround->getProject()	JROOT/components/com_tracks/views/round/tmpl/default.php:86
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.23 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 10.697 MB Vráceno řádků: 1

Duplicitní dotazy: #14

SELECT *

  FROM nsivc_tracks_projects

  WHERE `id` = '45'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
22	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
19	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
18	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:427
17	TrackslibEntityBase->getParam()	JROOT/components/com_tracks/views/round/tmpl/default.php:86
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.21 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 10.710 MB Vráceno řádků: 1

Duplicitní dotazy: #26 #27 #28 #31 #33

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '619'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
34	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
32	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
31	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
30	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:47
29	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
28	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.22 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 10.731 MB Vráceno řádků: 1

Duplicitní dotazy: #34

SELECT *

  FROM nsivc_tracks_projects

  WHERE `id` = '46'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
34	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
32	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
31	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
30	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
29	TrackslibEntityBase::load()	JROOT/components/com_tracks/router.php:176
28	TracksRouter->getProjectSegment()	Stejné jako volání na řádku níže.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.23 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 10.752 MB Vráceno řádků: 1

Duplicitní dotazy: #24 #27 #28 #31 #33

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '619'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
36	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
34	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
33	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
32	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:47
31	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
30	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
27	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
26	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_tracks/router.php:126
25	TracksRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
24	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
23	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/libraries/tracks/entity/base.php:348
18	TrackslibEntityBase->formatUrl()	JROOT/libraries/tracks/entity/projectround.php:81
17	TrackslibEntityProjectround->getLink()	JROOT/components/com_tracks/views/round/tmpl/default.php:64
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.25 ms Po posledním dotazu: 0.14 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 10.768 MB Vráceno řádků: 1

Duplicitní dotazy: #24 #26 #28 #31 #33

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '619'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
22	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
19	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
18	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
17	TrackslibEntityProjectround->getProject()	JROOT/components/com_tracks/views/round/tmpl/default.php:65
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.23 ms Po posledním dotazu: 0.17 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 10.779 MB Vráceno řádků: 1

Duplicitní dotazy: #24 #26 #27 #31 #33

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '619'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
23	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
20	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
19	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
18	TrackslibEntityProjectround->getProject()	JROOT/libraries/tracks/entity/projectround.php:92
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 43.52 ms Po posledním dotazu: 0.21 ms Dotaz paměti: 0.109 MB Paměť před dotazem: 10.785 MB Vráceno řádků: 258

SELECT i.id, i.first_name, i.last_name, i.country_code, i.picture_small, i.nickname,  pi.team_id, pi.number,  t.name AS team_name, t.short_name AS team_short_name, t.acronym AS team_acronym, t.picture_small AS team_logo, 
  CASE WHEN CHAR_LENGTH( i.alias ) THEN CONCAT_WS( ':', i.id, i.alias ) ELSE i.id END AS slug,  
  CASE WHEN CHAR_LENGTH( t.alias ) THEN CONCAT_WS( ':', t.id, t.alias ) ELSE t.id END AS teamslug  
  FROM nsivc_tracks_participants AS pi  
  INNER JOIN nsivc_tracks_individuals AS i 
  ON i.id = pi.individual_id  
  LEFT JOIN nsivc_tracks_teams AS t 
  ON t.id = pi.team_id  
  WHERE pi.project_id = 46 
  ORDER BY pi.number ASC, i.last_name ASC, i.first_name ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pi	NULL	ref	individual_id,project_id	project_id	4	const	258	100.00	Using temporary; Použití filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.pi.team_id	1	100.00	NULL
1	SIMPLE	i	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.pi.individual_id	1	100.00	NULL

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 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
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	1.66 ms
Creating sort index	0.35 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
21	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:227
19	TrackslibRankingtoolDefault->_initIndividuals()	JROOT/libraries/tracks/rankingtool/default.php:110
18	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/entity/projectround.php:92
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 43.55 ms Po posledním dotazu: 0.46 ms Dotaz paměti: 0.429 MB Paměť před dotazem: 11.409 MB Vráceno řádků: 991

Duplicitní dotazy: #32

SELECT rr.individual_id as id, rr.rank, rr.bonus_points, rr.team_id, rr.params, rr.performance,sr.projectround_id, sr.rank_offset,srt.points_attribution, srt.count_points, srt.enable_stats,(rr.rank + sr.rank_offset) AS global_rank

  FROM nsivc_tracks_events_results AS rr

  INNER JOIN nsivc_tracks_events AS sr 
  ON sr.id = rr.event_id

  INNER JOIN nsivc_tracks_eventtypes AS srt 
  ON srt.id = sr.type

  INNER JOIN nsivc_tracks_projects_rounds AS pr 
  ON pr.id = sr.projectround_id

  WHERE pr.project_id = 46 
  AND pr.published = 1 
  AND sr.published = 1

  ORDER BY pr.ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr	NULL	ref	PRIMARY,project_id	project_id	4	const	13	10.00	Using index condition; Using where; Použití filesort
1	SIMPLE	sr	NULL	ref	PRIMARY,projectround_id,type	projectround_id	4	ttrtvcz2.pr.id	1	10.00	Using where
1	SIMPLE	srt	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.sr.type	1	100.00	NULL
1	SIMPLE	rr	NULL	ref	event_id	event_id	4	ttrtvcz2.sr.id	18	100.00	NULL

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
21	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:274
19	TrackslibRankingtoolDefault->_getResults()	JROOT/libraries/tracks/rankingtool/default.php:112
18	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/entity/projectround.php:92
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.64 ms Po posledním dotazu: 3.06 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 10.831 MB Vráceno řádků: 1

Duplicitní dotazy: #24 #26 #27 #28 #33

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '619'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
25	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
22	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
21	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
20	TrackslibEntityProjectround->getProject()	JROOT/libraries/tracks/entity/projectround.php:102
19	TrackslibEntityProjectround->{closure}()	Stejné jako volání na řádku níže.
18	array_map()	JROOT/libraries/tracks/entity/projectround.php:106
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 44.17 ms Po posledním dotazu: 0.21 ms Dotaz paměti: 0.430 MB Paměť před dotazem: 10.842 MB Vráceno řádků: 991

Duplicitní dotazy: #30

SELECT rr.individual_id as id, rr.rank, rr.bonus_points, rr.team_id, rr.params, rr.performance,sr.projectround_id, sr.rank_offset,srt.points_attribution, srt.count_points, srt.enable_stats,(rr.rank + sr.rank_offset) AS global_rank

  FROM nsivc_tracks_events_results AS rr

  INNER JOIN nsivc_tracks_events AS sr 
  ON sr.id = rr.event_id

  INNER JOIN nsivc_tracks_eventtypes AS srt 
  ON srt.id = sr.type

  INNER JOIN nsivc_tracks_projects_rounds AS pr 
  ON pr.id = sr.projectround_id

  WHERE pr.project_id = 46 
  AND pr.published = 1 
  AND sr.published = 1

  ORDER BY pr.ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr	NULL	ref	PRIMARY,project_id	project_id	4	const	13	10.00	Using index condition; Using where; Použití filesort
1	SIMPLE	sr	NULL	ref	PRIMARY,projectround_id,type	projectround_id	4	ttrtvcz2.pr.id	1	10.00	Using where
1	SIMPLE	srt	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.sr.type	1	100.00	NULL
1	SIMPLE	rr	NULL	ref	event_id	event_id	4	ttrtvcz2.sr.id	18	100.00	NULL

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
23	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:274
21	TrackslibRankingtoolDefault->_getResults()	JROOT/libraries/tracks/rankingtool/default.php:410
20	TrackslibRankingtoolDefault->getIndividualProjectRoundResults()	JROOT/libraries/tracks/entity/projectround.php:102
19	TrackslibEntityProjectround->{closure}()	Stejné jako volání na řádku níže.
18	array_map()	JROOT/libraries/tracks/entity/projectround.php:106
17	TrackslibEntityProjectround->getWinner()	JROOT/components/com_tracks/views/round/tmpl/default.php:72
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.67 ms Po posledním dotazu: 1.70 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 10.859 MB Vráceno řádků: 1

Duplicitní dotazy: #24 #26 #27 #28 #31

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '619'

Vysvětlení

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

Profil

Status	Duration
starting	0.07 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.05 ms
preparing	0.02 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.07 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
22	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
19	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
18	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:30
17	TrackslibEntityProjectround->getProject()	JROOT/components/com_tracks/views/round/tmpl/default.php:86
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.34 ms Po posledním dotazu: 0.30 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 10.871 MB Vráceno řádků: 1

Duplicitní dotazy: #25

SELECT *

  FROM nsivc_tracks_projects

  WHERE `id` = '46'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
22	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
19	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
18	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:427
17	TrackslibEntityBase->getParam()	JROOT/components/com_tracks/views/round/tmpl/default.php:86
16	include JROOT/components/com_tracks/views/round/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
14	RViewBase->loadTemplate()	JROOT/libraries/redcore/layouts/component/site.php:104
13	include JROOT/libraries/redcore/layouts/component/site.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/redcore/layout/helper.php:40
11	RLayoutHelper::render()	JROOT/libraries/redcore/view/site.php:50
10	RViewSite->display()	JROOT/components/com_tracks/views/round/view.html.php:52
9	TracksViewRound->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_tracks/tracks.php:33
6	require_once JROOT/components/com_tracks/tracks.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 42.59 ms Po posledním dotazu: 6.24 ms Dotaz paměti: 0.050 MB Paměť před dotazem: 11.276 MB Vráceno řádků: 51

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

  FROM nsivc_modules AS m

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

  LEFT JOIN nsivc_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-04-17 21:53:55') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-17 21:53:55') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 353 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	165	0.61	Using where; Použití filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	ttrtvcz2.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	ttrtvcz2.m.id	9	40.00	Using where; Using index

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.85 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
19	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Stejné jako volání na řádku níže.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/template_ttr_v4_4/library/Core/Statements.php:9
11	CoreStatements::containsModules()	JROOT/templates/template_ttr_v4_4/library/Core/Statements.php:16
10	CoreStatements::position()	JROOT/templates/template_ttr_v4_4/header.php:8
9	include_once JROOT/templates/template_ttr_v4_4/header.php	JROOT/templates/template_ttr_v4_4/library/Core/Page.php:41
8	CorePage->renderHeader()	JROOT/templates/template_ttr_v4_4/index.php:130
7	require JROOT/templates/template_ttr_v4_4/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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.60 ms Po posledním dotazu: 27.99 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 11.839 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_redcore_schemas

  WHERE asset_id = '#__tracks_individuals'

Vysvětlení

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 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.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
28	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/redcore/table/table.php:1072
26	RTable->getFields()	JROOT/libraries/src/Table/Table.php:180
25	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/redcore/table/table.php:191
24	RTable->__construct()	JROOT/libraries/src/Table/Table.php:328
23	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/redcore/table/table.php:884
22	RTable::getAutoInstance()	JROOT/libraries/redcore/table/table.php:907
21	RTable::getAdminInstance()	JROOT/libraries/tracks/entity/base.php:751
20	TrackslibEntityBase->getTable()	JROOT/libraries/tracks/entity/base.php:883
19	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
18	TrackslibEntityBase::load()	JROOT/components/com_tracks/router.php:139
17	TracksRouter->getIndividualSegment()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1118
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.33 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 11.884 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_individuals

  WHERE `id` = '461'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
23	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
20	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
19	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
18	TrackslibEntityBase::load()	JROOT/components/com_tracks/router.php:139
17	TracksRouter->getIndividualSegment()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1118
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.25 ms Po posledním dotazu: 0.24 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 11.947 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_individuals

  WHERE `id` = '528'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
23	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
20	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
19	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
18	TrackslibEntityBase::load()	JROOT/components/com_tracks/router.php:139
17	TracksRouter->getIndividualSegment()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1118
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.56 ms Po posledním dotazu: 1.34 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 12.027 MB Vráceno řádků: 3

SHOW FULL COLUMNS 
  FROM `nsivc_nicepage_params`

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `nsivc_nicepage_params`

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
19	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_nicepage/tables/params.php:20
14	PagesTableParams->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_nicepage/helpers/nicepage.php:261
12	NicepageHelpersNicepage::getParamsTable()	JROOT/administrator/components/com_nicepage/helpers/nicepage.php:208
11	NicepageHelpersNicepage::getConfig()	JROOT/administrator/components/com_nicepage/library/src/Config.php:30
10	NP\Config->__construct()	JROOT/administrator/components/com_nicepage/library/src/Config.php:122
9	NP\Config::getInstance()	JROOT/administrator/components/com_nicepage/library/src/Factory.php:51
8	NP\Factory::getConfig()	JROOT/plugins/system/nicepage/nicepage.php:66
7	PlgSystemNicepage->onAfterRender()	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/CMSApplication.php:1118
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.24 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 12.043 MB Vráceno řádků: 0

SELECT *

  FROM nsivc_nicepage_params

  WHERE `name` = 'com_nicepage'

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nsivc_nicepage_params	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	23	10.00	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
15	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_nicepage/tables/params.php:30
12	PagesTableParams->getParameters()	JROOT/administrator/components/com_nicepage/helpers/nicepage.php:208
11	NicepageHelpersNicepage::getConfig()	JROOT/administrator/components/com_nicepage/library/src/Config.php:30
10	NP\Config->__construct()	JROOT/administrator/components/com_nicepage/library/src/Config.php:122
9	NP\Config::getInstance()	JROOT/administrator/components/com_nicepage/library/src/Factory.php:51
8	NP\Factory::getConfig()	JROOT/plugins/system/nicepage/nicepage.php:66
7	PlgSystemNicepage->onAfterRender()	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/CMSApplication.php:1118
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.63 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 1.798 MB Paměť před dotazem: 12.048 MB Vráceno řádků: 23

SELECT *

  FROM nsivc_nicepage_params

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nsivc_nicepage_params	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	23	100.00	NULL

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
15	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_nicepage/tables/params.php:110
13	PagesTableParams->getAll()	JROOT/administrator/components/com_nicepage/tables/params.php:31
12	PagesTableParams->getParameters()	JROOT/administrator/components/com_nicepage/helpers/nicepage.php:208
11	NicepageHelpersNicepage::getConfig()	JROOT/administrator/components/com_nicepage/library/src/Config.php:30
10	NP\Config->__construct()	JROOT/administrator/components/com_nicepage/library/src/Config.php:122
9	NP\Config::getInstance()	JROOT/administrator/components/com_nicepage/library/src/Factory.php:51
8	NP\Factory::getConfig()	JROOT/plugins/system/nicepage/nicepage.php:66
7	PlgSystemNicepage->onAfterRender()	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/CMSApplication.php:1118
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

18 zaznamenaných typů dotazu, řazeno dle výskytu

VYBRANÉ tabulky:

12 × SELECT * 
  FROM nsivc_tracks_projects_rounds

4 × SELECT * 
  FROM nsivc_redcore_schemas

4 × SELECT * 
  FROM nsivc_tracks_projects

4 × SELECT rr.individual_id as id, rr.rank, rr.bonus_points, rr.team_id, rr.params, rr.performance,sr.projectround_id, sr.rank_offset,srt.points_attribution, srt.count_points, srt.enable_stats,(rr.rank + sr.rank_offset) AS global_rank 
  FROM nsivc_tracks_events_results AS rr 
  INNER JOIN nsivc_tracks_events AS sr 
  ON sr.id = rr.event_id 
  INNER JOIN nsivc_tracks_eventtypes AS srt 
  ON srt.id = sr.type 
  INNER JOIN nsivc_tracks_projects_rounds AS pr 
  ON pr.id = sr.projectround_id

2 × SELECT * 
  FROM nsivc_tracks_rounds

2 × SELECT i.id, i.first_name, i.last_name, i.country_code, i.picture_small, i.nickname,  pi.team_id, pi.number,  t.name AS team_name, t.short_name AS team_short_name, t.acronym AS team_acronym, t.picture_small AS team_logo, 
  CASE WHEN CHAR_LENGTH( i.alias ) THEN CONCAT_WS( ':', i.id, i.alias ) ELSE i.id END AS slug,  
  CASE WHEN CHAR_LENGTH( t.alias ) THEN CONCAT_WS( ':', t.id, t.alias ) ELSE t.id END AS teamslug  
  FROM nsivc_tracks_participants AS pi  
  INNER JOIN nsivc_tracks_individuals AS i 
  ON i.id = pi.individual_id  
  LEFT JOIN nsivc_tracks_teams AS t 
  ON t.id = pi.team_id

2 × SELECT * 
  FROM nsivc_tracks_individuals

1 × SELECT COUNT(extension_id) 
  FROM nsivc_extensions

1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `nsivc_extensions`

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 nsivc_menu AS m 
  LEFT JOIN nsivc_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM nsivc_languages
```

1 × SELECT id, home, template, s.params 
  FROM nsivc_template_styles as s 
  LEFT JOIN nsivc_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT obj.*,r.name as name 
  FROM `nsivc_tracks_projects_rounds` AS `obj` 
  INNER JOIN nsivc_tracks_rounds AS r 
  on r.id = obj.round_id

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

1 × SELECT * 
  FROM nsivc_nicepage_params

1 × SELECT * 
  FROM nsivc_nicepage_param

OSTATNÍ tabulky:

1 × UPDATE `nsivc_extensions` 
  SET `params` = '{\"mediaversion\":\"77c586fed4d1043138e581c05fa968a8\"}'

1 × SHOW FULL COLUMNS 
  FROM `nsivc_nicepage_params

Nejrychlejší čas
N/A	N/A	N/A