Tomáš Hora

Starty	Body celkem	Vítězství	Pódia
1	50	1	1

Sezóny	Tým	Umístění	Body	Vítězství	Pódia
BARRSA GTE		22	50	1	1

Stáj / tým	Kolo	Poznámky	Umístění	Body
	Imola Circuit	Porsche 911 RSR	1	50

Konzole ladění chyb Joomla!

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1776643550,
                "last": 1776643550,
                "now": 1776643550
            },
            "client": {
                "forwarded": "2600:1f28:365:80b0:41d:4c79:9a62:c936"
            }
        },
        "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

31 zaznamenaných dotazů 151.71 ms

Nalezeno 10 duplikátů!

2 duplikátů: #9 #13

2 duplikátů: #14 #19

2 duplikátů: #17 #20

2 duplikátů: #18 #21

2 duplikátů: #24 #27

Čas pro dotazy: 0.41 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 5.928 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.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 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.03 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.50 ms Po posledním dotazu: 12.36 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 6.965 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.02 ms
init	0.01 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.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.43 ms Po posledním dotazu: 0.17 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 6.958 MB

UPDATE `nsivc_extensions`

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

  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.04 ms
updating	0.05 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.01 ms
freeing items	0.03 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: 0.98 ms Po posledním dotazu: 6.01 ms Dotaz paměti: 0.072 MB Paměť před dotazem: 7.701 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.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 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.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.52 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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.47 ms Po posledním dotazu: 10.91 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 8.998 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.02 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.03 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
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:308
12	TracksRouter->getIndividualId()	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: 1.49 ms Po posledním dotazu: 0.60 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 9.055 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_individuals

  WHERE `alias` = 'tomas-hora'

Vysvětlení

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.12 ms
end	0.01 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:309
12	TracksRouter->getIndividualId()	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.42 ms Po posledním dotazu: 1.68 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 9.238 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.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 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.45 ms Po posledním dotazu: 1.36 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 9.368 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.02 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.00 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/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.37 ms Po posledním dotazu: 8.67 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 10.330 MB Vráceno řádků: 1

Duplicitní dotazy: #13

SELECT *

  FROM nsivc_tracks_individuals

  WHERE `id` = '300'

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.04 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.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/src/MVC/Model/AdminModel.php:976
12	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/components/com_tracks/models/individual.php:45
11	TracksModelIndividual->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tracks/views/individual/view.html.php:46
9	TracksViewIndividual->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.84 ms Po posledním dotazu: 2.36 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 10.639 MB Vráceno řádků: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM nsivc_fields AS a

  LEFT JOIN `nsivc_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN nsivc_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN nsivc_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN nsivc_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN nsivc_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_tracks.individual' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Použití filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	ttrtvcz2.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 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
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/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_tracks/models/individual.php:59
11	TracksModelIndividual->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tracks/views/individual/view.html.php:46
9	TracksViewIndividual->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.36 ms Po posledním dotazu: 0.95 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 10.787 MB Vráceno řádků: 1

SELECT rr.rank, rr.performance, rr.bonus_points, pr.project_id,
  CASE WHEN rr.number THEN rr.number ELSE part.number END AS number,r.name AS roundname, r.id as pr,srt.name AS subroundname,srt.points_attribution, srt.count_points, psr.rank_offset,p.name AS projectname,c.name AS competitionname,s.name AS seasonname,t.name AS teamname,
  CASE WHEN CHAR_LENGTH( r.alias ) THEN CONCAT_WS( ':', pr.id, r.alias ) ELSE pr.id END AS prslug,
  CASE WHEN CHAR_LENGTH( r.alias ) THEN CONCAT_WS( ':', r.id, r.alias ) ELSE r.id END AS rslug

  FROM nsivc_tracks_events_results AS rr

  LEFT JOIN nsivc_tracks_participants AS part 
  ON part.individual_id = rr.individual_id 
  AND part.team_id = rr.team_id

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

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

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

  INNER JOIN nsivc_tracks_rounds AS r 
  ON r.id = pr.round_id

  INNER JOIN nsivc_tracks_projects AS p 
  ON p.id = pr.project_id

  INNER JOIN nsivc_tracks_seasons AS s 
  ON s.id = p.season_id

  INNER JOIN nsivc_tracks_competitions AS c 
  ON c.id = p.competition_id

  LEFT JOIN nsivc_tracks_teams AS t 
  ON t.id = rr.team_id

  WHERE rr.individual_id = '300' 
  AND p.published 
  AND pr.published 
  AND psr.published

  GROUP BY rr.id

  ORDER BY p.ordering ASC, pr.ordering ASC, psr.ordering ASC

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rr	NULL	ref	PRIMARY,individual_id,team_id,event_id	individual_id	4	const	1	100.00	Using index condition; Using temporary; Použití filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.rr.team_id	1	100.00	NULL
1	SIMPLE	psr	NULL	eq_ref	PRIMARY,projectround_id,type	PRIMARY	4	ttrtvcz2.rr.event_id	1	90.00	Using where
1	SIMPLE	srt	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.psr.type	1	100.00	NULL
1	SIMPLE	pr	NULL	eq_ref	PRIMARY,round_id,project_id	PRIMARY	4	ttrtvcz2.psr.projectround_id	1	90.00	Using where
1	SIMPLE	p	NULL	eq_ref	PRIMARY,competition_id,season_id	PRIMARY	4	ttrtvcz2.pr.project_id	1	90.00	Using where
1	SIMPLE	s	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.p.season_id	1	100.00	NULL
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.p.competition_id	1	100.00	NULL
1	SIMPLE	r	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.pr.round_id	1	100.00	NULL
1	SIMPLE	part	NULL	ref	individual_id,team_id	individual_id	4	ttrtvcz2.rr.individual_id	2	100.00	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
13	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_tracks/models/individual.php:304
11	TracksModelIndividual->getRaceResults()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tracks/views/individual/view.html.php:48
9	TracksViewIndividual->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.15 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 10.796 MB Vráceno řádků: 39

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `nsivc_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jea','com_joomlaupdate','com_joomsport','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_miniorange_oauth','com_modules','com_newsfeeds','com_nicepage','com_plugins','com_postinstall','com_privacy','com_redcore','com_redirect','com_search','com_tags','com_templates','com_tracks','com_users','com_wrapper')

Vysvětlení

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.63 ms
end	0.00 ms
query end	0.00 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
16	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/components/com_tracks/views/individual/view.html.php:50
9	TracksViewIndividual->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.40 ms Po posledním dotazu: 6.13 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 11.520 MB Vráceno řádků: 1

Duplicitní dotazy: #9

SELECT *

  FROM nsivc_tracks_individuals

  WHERE `id` = '300'

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.02 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.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
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/base.php:837
20	TrackslibEntityBase::load()	JROOT/components/com_tracks/views/individual/tmpl/default_stats.php:19
19	include JROOT/components/com_tracks/views/individual/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:224
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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: 0.36 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 11.561 MB Vráceno řádků: 1

Duplicitní dotazy: #19

SELECT p.*

  FROM nsivc_tracks_participants AS p

  INNER JOIN nsivc_tracks_projects as project 
  ON project.id = p.project_id

  WHERE p.individual_id = 300 
  AND project.published = 1

  ORDER BY project.ordering asc

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	NULL	ref	individual_id,project_id	individual_id	4	const	1	100.00	Using temporary; Použití filesort
1	SIMPLE	project	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.p.project_id	1	10.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.04 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.10 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/entity/individual.php:57
21	TrackslibEntityIndividual->getParticipants()	JROOT/libraries/tracks/entity/individual.php:68
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_stats.php:20
19	include JROOT/components/com_tracks/views/individual/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:224
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.58 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 11.630 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.01 ms
statistics	0.02 ms
preparing	0.00 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.03 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
32	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
31	JDatabaseDriver->loadAssoc()	JROOT/libraries/redcore/table/table.php:1072
30	RTable->getFields()	JROOT/libraries/src/Table/Table.php:180
29	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/redcore/table/table.php:191
28	RTable->__construct()	JROOT/libraries/src/Table/Table.php:328
27	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/redcore/table/table.php:884
26	RTable::getAutoInstance()	JROOT/libraries/redcore/table/table.php:907
25	RTable::getAdminInstance()	JROOT/libraries/tracks/entity/base.php:751
24	TrackslibEntityBase->getTable()	JROOT/libraries/tracks/entity/base.php:883
23	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
22	TrackslibEntityBase::load()	JROOT/libraries/tracks/entity/participant.php:53
21	TrackslibEntityParticipant->getProject()	JROOT/libraries/tracks/entity/individual.php:81
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_stats.php:20
19	include JROOT/components/com_tracks/views/individual/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:224
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.27 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 11.664 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_projects

  WHERE `id` = '32'

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.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 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
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
27	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
25	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
24	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
23	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
22	TrackslibEntityBase::load()	JROOT/libraries/tracks/entity/participant.php:53
21	TrackslibEntityParticipant->getProject()	JROOT/libraries/tracks/entity/individual.php:81
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_stats.php:20
19	include JROOT/components/com_tracks/views/individual/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:224
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.71 ms Po posledním dotazu: 1.04 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 11.739 MB Vráceno řádků: 29

Duplicitní dotazy: #20

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 = 32 
  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	29	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.01 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.21 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
25	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:227
23	TrackslibRankingtoolDefault->_initIndividuals()	JROOT/libraries/tracks/rankingtool/default.php:110
22	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/rankingtool/default.php:96
21	TrackslibRankingtoolDefault->getIndividualRanking()	JROOT/libraries/tracks/entity/individual.php:82
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_stats.php:20
19	include JROOT/components/com_tracks/views/individual/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:224
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.77 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.065 MB Paměť před dotazem: 11.822 MB Vráceno řádků: 105

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 = 32 
  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	5	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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.43 ms
end	0.00 ms
query end	0.01 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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
25	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:274
23	TrackslibRankingtoolDefault->_getResults()	JROOT/libraries/tracks/rankingtool/default.php:112
22	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/rankingtool/default.php:96
21	TrackslibRankingtoolDefault->getIndividualRanking()	JROOT/libraries/tracks/entity/individual.php:82
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_stats.php:20
19	include JROOT/components/com_tracks/views/individual/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:224
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.38 ms Po posledním dotazu: 1.63 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 11.774 MB Vráceno řádků: 1

Duplicitní dotazy: #14

SELECT p.*

  FROM nsivc_tracks_participants AS p

  INNER JOIN nsivc_tracks_projects as project 
  ON project.id = p.project_id

  WHERE p.individual_id = 300 
  AND project.published = 1

  ORDER BY project.ordering asc

Vysvětlení

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	NULL	ref	individual_id,project_id	individual_id	4	const	1	100.00	Using temporary; Použití filesort
1	SIMPLE	project	NULL	eq_ref	PRIMARY	PRIMARY	4	ttrtvcz2.p.project_id	1	10.00	Using where

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.27 ms
Creating sort index	0.07 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.15 ms
cleaning up	0.03 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/entity/individual.php:57
21	TrackslibEntityIndividual->getParticipants()	JROOT/libraries/tracks/entity/individual.php:68
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_rankings.php:21
19	include JROOT/components/com_tracks/views/individual/tmpl/default_rankings.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:228
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.14 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 11.785 MB Vráceno řádků: 29

Duplicitní dotazy: #17

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 = 32 
  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	29	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.16 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.33 ms
Creating sort index	0.08 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.09 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:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:227
23	TrackslibRankingtoolDefault->_initIndividuals()	JROOT/libraries/tracks/rankingtool/default.php:110
22	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/rankingtool/default.php:96
21	TrackslibRankingtoolDefault->getIndividualRanking()	JROOT/libraries/tracks/entity/individual.php:82
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_rankings.php:21
19	include JROOT/components/com_tracks/views/individual/tmpl/default_rankings.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:228
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.59 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.065 MB Paměť před dotazem: 11.867 MB Vráceno řádků: 105

Duplicitní dotazy: #18

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 = 32 
  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	5	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.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 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.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.62 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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
25	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/tracks/rankingtool/default.php:274
23	TrackslibRankingtoolDefault->_getResults()	JROOT/libraries/tracks/rankingtool/default.php:112
22	TrackslibRankingtoolDefault->getIndividualsRankings()	JROOT/libraries/tracks/rankingtool/default.php:96
21	TrackslibRankingtoolDefault->getIndividualRanking()	JROOT/libraries/tracks/entity/individual.php:82
20	TrackslibEntityIndividual->getStats()	JROOT/components/com_tracks/views/individual/tmpl/default_rankings.php:21
19	include JROOT/components/com_tracks/views/individual/tmpl/default_rankings.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:228
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.65 ms Po posledním dotazu: 3.18 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 11.861 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 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.04 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
31	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
30	JDatabaseDriver->loadAssoc()	JROOT/libraries/redcore/table/table.php:1072
29	RTable->getFields()	JROOT/libraries/src/Table/Table.php:180
28	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/redcore/table/table.php:191
27	RTable->__construct()	JROOT/libraries/src/Table/Table.php:328
26	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/redcore/table/table.php:884
25	RTable::getAutoInstance()	JROOT/libraries/redcore/table/table.php:907
24	RTable::getAdminInstance()	JROOT/libraries/tracks/entity/base.php:751
23	TrackslibEntityBase->getTable()	JROOT/libraries/tracks/entity/base.php:883
22	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
21	TrackslibEntityBase::load()	JROOT/libraries/tracks/helper/route.php:68
20	TrackslibHelperRoute::getRoundResultRoute()	JROOT/components/com_tracks/views/individual/tmpl/default_results.php:77
19	include JROOT/components/com_tracks/views/individual/tmpl/default_results.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:232
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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: 0.42 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 11.894 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '404:imola-circuit'

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.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
26	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
24	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
23	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
22	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
21	TrackslibEntityBase::load()	JROOT/libraries/tracks/helper/route.php:68
20	TrackslibHelperRoute::getRoundResultRoute()	JROOT/components/com_tracks/views/individual/tmpl/default_results.php:77
19	include JROOT/components/com_tracks/views/individual/tmpl/default_results.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:232
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.43 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 11.913 MB Vráceno řádků: 1

Duplicitní dotazy: #27

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '404'

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.01 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.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
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
35	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
34	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
33	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
32	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
31	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:47
30	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
29	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
20	Joomla\CMS\Router\Route::_()	JROOT/components/com_tracks/views/individual/tmpl/default_results.php:77
19	include JROOT/components/com_tracks/views/individual/tmpl/default_results.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:232
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.72 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 11.947 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.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.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
42	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
41	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
40	JDatabaseDriver->loadAssoc()	JROOT/libraries/redcore/table/table.php:1072
39	RTable->getFields()	JROOT/libraries/src/Table/Table.php:180
38	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/redcore/table/table.php:191
37	RTable->__construct()	JROOT/libraries/src/Table/Table.php:328
36	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/redcore/table/table.php:884
35	RTable::getAutoInstance()	JROOT/libraries/redcore/table/table.php:907
34	RTable::getAdminInstance()	JROOT/libraries/tracks/entity/base.php:751
33	TrackslibEntityBase->getTable()	JROOT/libraries/tracks/entity/base.php:883
32	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/base.php:837
31	TrackslibEntityBase::load()	JROOT/libraries/tracks/entity/projectround.php:54
30	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
29	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
20	Joomla\CMS\Router\Route::_()	JROOT/components/com_tracks/views/individual/tmpl/default_results.php:77
19	include JROOT/components/com_tracks/views/individual/tmpl/default_results.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:232
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.40 ms Po posledním dotazu: 0.23 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 11.985 MB Vráceno řádků: 1

SELECT *

  FROM nsivc_tracks_rounds

  WHERE `id` = '35'

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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.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
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/base.php:837
31	TrackslibEntityBase::load()	JROOT/libraries/tracks/entity/projectround.php:54
30	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
29	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
20	Joomla\CMS\Router\Route::_()	JROOT/components/com_tracks/views/individual/tmpl/default_results.php:77
19	include JROOT/components/com_tracks/views/individual/tmpl/default_results.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:232
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.28 ms Po posledním dotazu: 0.27 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 12.011 MB Vráceno řádků: 1

Duplicitní dotazy: #24

SELECT *

  FROM nsivc_tracks_projects_rounds

  WHERE `id` = '404'

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.03 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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/redcore/database/driver/mysqli.php:71
37	RDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
36	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
35	Joomla\CMS\Table\Table->load()	JROOT/libraries/redcore/table/table.php:321
34	RTable->load()	JROOT/libraries/tracks/entity/base.php:883
33	TrackslibEntityBase->loadItem()	JROOT/libraries/tracks/entity/projectround.php:47
32	TrackslibEntityProjectround->getRound()	JROOT/components/com_tracks/router.php:259
31	TracksRouter->getRoundResultSegment()	Stejné jako volání na řádku níže.
30	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
29	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
28	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
27	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_tracks/router.php:126
26	TracksRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
20	Joomla\CMS\Router\Route::_()	JROOT/components/com_tracks/views/individual/tmpl/default_results.php:77
19	include JROOT/components/com_tracks/views/individual/tmpl/default_results.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/redcore/view/base.php:97
17	RViewBase->loadTemplate()	JROOT/components/com_tracks/views/individual/tmpl/default.php:232
16	include JROOT/components/com_tracks/views/individual/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/individual/view.html.php:66
9	TracksViewIndividual->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.89 ms Po posledním dotazu: 5.47 ms Dotaz paměti: 0.050 MB Paměť před dotazem: 12.419 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-20 00:05:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-20 00:05:50') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 352 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.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 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.89 ms Po posledním dotazu: 29.57 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 13.108 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.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.04 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
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.04 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 13.124 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.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.67 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.68 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 1.798 MB Paměť před dotazem: 13.130 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.07 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	3.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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.]

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

VYBRANÉ tabulky:

4 × SELECT * 
  FROM nsivc_redcore_schemas

3 × SELECT * 
  FROM nsivc_tracks_individuals

3 × SELECT * 
  FROM nsivc_tracks_projects_rounds

2 × SELECT p.* 
  FROM nsivc_tracks_participants AS p 
  INNER JOIN nsivc_tracks_projects as project 
  ON project.id = p.project_id

2 × 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 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

1 × SELECT COUNT(extension_id) 
  FROM nsivc_extensions

1 × SELECT * 
  FROM nsivc_nicepage_params

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_tracks_rounds

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `nsivc_assets`

1 × SELECT * 
  FROM nsivc_tracks_projects

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

1 × SELECT rr.rank, rr.performance, rr.bonus_points, pr.project_id,
  CASE WHEN rr.number THEN rr.number ELSE part.number END AS number,r.name AS roundname, r.id as pr,srt.name AS subroundname,srt.points_attribution, srt.count_points, psr.rank_offset,p.name AS projectname,c.name AS competitionname,s.name AS seasonname,t.name AS teamname,
  CASE WHEN CHAR_LENGTH( r.alias ) THEN CONCAT_WS( ':', pr.id, r.alias ) ELSE pr.id END AS prslug,
  CASE WHEN CHAR_LENGTH( r.alias ) THEN CONCAT_WS( ':', r.id, r.alias ) ELSE r.id END AS rslug 
  FROM nsivc_tracks_events_results AS rr 
  LEFT JOIN nsivc_tracks_participants AS part 
  ON part.individual_id = rr.individual_id 
  AND part.team_id = rr.team_id 
  INNER JOIN nsivc_tracks_events AS psr 
  ON psr.id = rr.event_id 
  INNER JOIN nsivc_tracks_eventtypes AS srt 
  ON srt.id = psr.type 
  INNER JOIN nsivc_tracks_projects_rounds AS pr 
  ON pr.id = psr.projectround_id 
  INNER JOIN nsivc_tracks_rounds AS r 
  ON r.id = pr.round_id 
  INNER JOIN nsivc_tracks_projects AS p 
  ON p.id = pr.project_id 
  INNER JOIN nsivc_tracks_seasons AS s 
  ON s.id = p.season_id 
  INNER JOIN nsivc_tracks_competitions AS c 
  ON c.id = p.competition_id 
  LEFT JOIN nsivc_tracks_teams AS t 
  ON t.id = rr.team_id

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM nsivc_fields AS a 
  LEFT JOIN `nsivc_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN nsivc_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN nsivc_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN nsivc_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN nsivc_fields_groups AS g 
  ON g.id = a.group_id

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 * 
  FROM nsivc_languages
```

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_nicepage_param

OSTATNÍ tabulky:

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

1 × SHOW FULL COLUMNS 
  FROM `nsivc_nicepage_params

Tomáš Hora

Historie účasti

Podrobné výsledky

BARRSA GTE

Konzole ladění chyb Joomla!

Sezení

Informace o profilu

Čas

Paměť

Využití paměti

Dotazy do databáze

31 zaznamenaných dotazů 151.71 ms

Nalezeno 10 duplikátů!

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

VYBRANÉ tabulky:

OSTATNÍ tabulky: