Statistics Ranking - Properties: A-Klasa 2026/27 **

Statystyki indyw.

logospon

Kartki CZE

Rank	Imię	Team	Kartki CZE

View full table

Kartki ŻÓŁ

Rank	Imię	Team	Kartki ŻÓŁ

View full table

Bramki

Rank	Imię	Team	Bramki

View full table

Minuty

Rank	Imię	Team	Minuty

View full table

:: Powered by JoomLeague - Version 3.0.22.57ae969 ::

Konsola diagnostyczna Joomla!

Sesja

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

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

#	Wywołujący	Plik i numer linii
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `net92_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6262373161383530643162383535393134663664323834383164633663626261', 1, 1784353579, 0, '', 0)

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.10 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.34 ms Po ostatnim zapytaniu: 0.34 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 1.071 MB Zwróconych wierszy: 36

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

  FROM `net92_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_extensions	ref	extension	extension	82	const	43	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Identyczny z wywołaniem linii niżej.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.14 ms Po ostatnim zapytaniu: 0.43 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.096 MB Zwróconych wierszy: 4

SELECT id, rules

  FROM `net92_viewlevels`

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_viewlevels	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.18 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.108 MB Zwróconych wierszy: 2

SELECT b.id

  FROM net92_usergroups AS a

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

  WHERE a.id = 9

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.35 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 1.129 MB Zwróconych wierszy: 45

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM net92_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_extensions	ALL	extension	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	236	Using where; Uruchomiono metodę filesort

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.15 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Identyczny z wywołaniem linii niżej.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.26 ms Po ostatnim zapytaniu: 12.31 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.604 MB Zwróconych wierszy: 1

SELECT `template`

  FROM `net92_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_template_styles	ALL	idx_client_id,idx_client_id_home	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 1.34 ms Pamięć zapytania: 0.048 MB Pamięć przed zapytaniem: 1.653 MB Zwróconych wierszy: 23

Duplikaty zapytań: #51 #52

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

  LEFT JOIN net92_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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	70	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.22 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Identyczny z wywołaniem linii niżej.
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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 2.62 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 1.979 MB Zwróconych wierszy: 36

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

  FROM `net92_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_dropeditor','com_installer','com_j2xml','com_jce','com_joomgallery','com_joomlaupdate','com_joomleague','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_plugins','com_postinstall','com_privacy','com_redirect','com_tags','com_team','com_templates','com_users','com_vertexupdate','com_wrapper')

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_assets	range	idx_asset_name	idx_asset_name	202	NULL	37	Using index condition

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.09 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.17 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:192
8	RegularLabs\Library\SystemPlugin->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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.19 ms Po ostatnim zapytaniu: 0.32 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.051 MB Zwróconych wierszy: 1

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

  FROM `net92_extensions`

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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Identyczny z wywołaniem linii niżej.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.25 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 2.042 MB

UPDATE `net92_extensions`

  SET `params` = '{\"mediaversion\":\"76adf536f3369b6041887a19a6cf5f8e\"}'

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

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `net92_extensions` SET `params` = '{\"mediaversion\":\"76adf536f3369b6041887a19a6cf5f8e\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init for update	0.02 ms
Updating	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.10 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.20 ms Po ostatnim zapytaniu: 0.22 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 2.070 MB Zwróconych wierszy: 1

SELECT *

  FROM net92_languages

  WHERE published=1

  ORDER BY ordering ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_languages	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using where; Uruchomiono metodę filesort

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.23 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 2.080 MB Zwróconych wierszy: 5

SELECT id, home, template, s.params

  FROM net92_template_styles as s

  LEFT JOIN net92_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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	7	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	czarni_baza92.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.23 ms Po ostatnim zapytaniu: 1.22 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.315 MB Zwróconych wierszy: 1

Duplikaty zapytań: #15 #16 #17 #18 #19 #20 #21 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.04 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
10	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:42
9	JoomleagueHelperExtensioncontroller->getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:53
8	JoomleagueHelperExtensioncontroller->initExtensions()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:93
7	JLGController::getInstance()	JROOT/components/com_joomleague/joomleague.php:28
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.16 ms Po ostatnim zapytaniu: 0.44 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.326 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #16 #17 #18 #19 #20 #21 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
10	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:42
9	JoomleagueHelperExtensioncontroller->getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:77
8	JoomleagueHelperExtensioncontroller->addModelPaths()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:104
7	JLGController::getInstance()	JROOT/components/com_joomleague/joomleague.php:28
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.13 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.332 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #17 #18 #19 #20 #21 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
10	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:42
9	JoomleagueHelperExtensioncontroller->getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:94
8	JoomleagueHelperExtensioncontroller->addViewPaths()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:105
7	JLGController::getInstance()	JROOT/components/com_joomleague/joomleague.php:28
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.11 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.340 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #18 #19 #20 #21 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:41
12	JLGController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
11	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/libraries/src/MVC/Controller/BaseController.php:613
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.20 ms Po ostatnim zapytaniu: 0.90 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.353 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #19 #20 #21 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
18	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgview.php:56
17	JLGView->_setPath()	JROOT/libraries/src/MVC/View/HtmlView.php:191
16	Joomla\CMS\MVC\View\HtmlView->__construct()	JROOT/components/com_joomleague/assets/classes/jlgview.php:24
15	JLGView->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
14	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
13	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:82
12	JLGController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
11	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/libraries/src/MVC/Controller/BaseController.php:613
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.17 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.363 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #20 #21 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
18	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgview.php:56
17	JLGView->_setPath()	JROOT/libraries/src/MVC/View/HtmlView.php:202
16	Joomla\CMS\MVC\View\HtmlView->__construct()	JROOT/components/com_joomleague/assets/classes/jlgview.php:24
15	JLGView->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
14	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
13	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:82
12	JLGController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
11	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/libraries/src/MVC/Controller/BaseController.php:613
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.16 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.379 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #21 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
14	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgmodel.php:22
13	JLGModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:31
12	JLGController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
11	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.19 ms Po ostatnim zapytaniu: 1.98 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.538 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #23 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
17	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/models/project.php:699
16	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/models/statsranking.php:52
15	JoomleagueModelStatsRanking->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
14	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgmodel.php:62
13	JLGModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:31
12	JLGController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
11	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.31 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.546 MB Zwróconych wierszy: 1

Duplikaty zapytań: #24

SELECT t.params
				   
  FROM net92_joomleague_template_config AS t
				   
  INNER JOIN net92_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='statsranking'
				   
  AND p.id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	45	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
16	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/models/statsranking.php:52
15	JoomleagueModelStatsRanking->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
14	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgmodel.php:62
13	JLGModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:31
12	JLGController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
11	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.18 ms Po ostatnim zapytaniu: 0.78 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.560 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #21 #27 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/models/project.php:699
12	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/views/statsranking/view.html.php:16
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.30 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.565 MB Zwróconych wierszy: 1

Duplikaty zapytań: #22

SELECT t.params
				   
  FROM net92_joomleague_template_config AS t
				   
  INNER JOIN net92_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='statsranking'
				   
  AND p.id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	45	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
12	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/views/statsranking/view.html.php:16
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.570 MB Zwróconych wierszy: 1

SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,
					LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,
					
  CASE WHEN CHAR_LENGTH( p.alias )
					THEN CONCAT_WS( ':', p.id, p.alias )
					ELSE p.id
					END AS slug,
					l.name AS league_name,
					s.name AS season_name
					
  FROM net92_joomleague_project AS p
					
  INNER JOIN net92_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id
					
  LEFT JOIN net92_joomleague_league AS l 
  ON p.league_id = l.id
					
  LEFT JOIN net92_joomleague_season AS s 
  ON p.season_id = s.id
					
  WHERE p.id='19' 
  LIMIT 0, 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	st	system	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1
1	SIMPLE	p	const	PRIMARY,sports_type_id	PRIMARY	4	const	1
1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:99
12	JoomleagueModelProject->getProject()	JROOT/components/com_joomleague/views/statsranking/view.html.php:18
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.65 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.051 MB Pamięć przed zapytaniem: 2.584 MB Zwróconych wierszy: 14

SELECT	tl.id AS projectteamid,
								tl.division_id,
								tl.standard_playground,
								tl.start_points,
								tl.points_finally,
								tl.neg_points_finally,
								tl.matches_finally,
								tl.won_finally,
								tl.draws_finally,
								tl.lost_finally,
								tl.homegoals_finally,
								tl.guestgoals_finally,
								tl.diffgoals_finally,
								tl.info,
								tl.reason,
								tl.team_id,
								tl.checked_out,
								tl.checked_out_time,
								tl.is_in_score,
								tl.picture AS projectteam_picture,
								t.picture as team_picture,
								IF((ISNULL(tl.picture) OR (tl.picture="")),
									(IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) as picture,
								tl.project_id,

								t.id,t.name,
								t.short_name,
								t.middle_name,
								t.notes,
								t.club_id,

								c.email as club_email,
								c.logo_small,
								c.logo_middle,
								c.logo_big,
								c.country,
								c.website,

								d.name AS division_name,
								d.picture AS division_picture,
								d.shortname AS division_shortname,
								d.parent_id AS parent_division_id,

								plg.name AS playground_name,
								plg.short_name AS playground_short_name,

								
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
								
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
								
  CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
								
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug

						
  FROM net92_joomleague_project_team tl
							
  LEFT JOIN net92_joomleague_team t 
  ON tl.team_id=t.id
							
  LEFT JOIN net92_joomleague_club c 
  ON t.club_id=c.id
							
  LEFT JOIN net92_joomleague_division d 
  ON d.id=tl.division_id
							
  LEFT JOIN net92_joomleague_playground plg 
  ON plg.id=tl.standard_playground
							
  LEFT JOIN net92_joomleague_project AS p 
  ON p.id=tl.project_id

						
  WHERE tl.project_id=19

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	system	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	0	Const row not found
1	SIMPLE	tl	ref	combi,project_id	combi	4	const	11
1	SIMPLE	plg	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tl.standard_playground	1	Using where
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tl.team_id	1
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.t.club_id	1	Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.25 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:501
14	JoomleagueModelProject->_getTeams()	JROOT/components/com_joomleague/models/project.php:528
13	JoomleagueModelProject->getTeams()	JROOT/components/com_joomleague/models/project.php:553
12	JoomleagueModelProject->getTeamsIndexedById()	JROOT/components/com_joomleague/views/statsranking/view.html.php:21
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.19 ms Po ostatnim zapytaniu: 1.17 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.655 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #21 #23 #40 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
14	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/models/project.php:699
13	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/models/project.php:763
12	JoomleagueModelProject->getOverallConfig()	JROOT/components/com_joomleague/views/statsranking/view.html.php:34
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.28 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.660 MB Zwróconych wierszy: 1

SELECT t.params
				   
  FROM net92_joomleague_template_config AS t
				   
  INNER JOIN net92_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='overall'
				   
  AND p.id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	45	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
13	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/models/project.php:763
12	JoomleagueModelProject->getOverallConfig()	JROOT/components/com_joomleague/views/statsranking/view.html.php:34
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.71 ms Po ostatnim zapytaniu: 0.11 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.677 MB Zwróconych wierszy: 16

SELECT	stat.id,
								stat.name,
								stat.short,
								stat.class,
								stat.icon,
								stat.calculated,
								ppos.id as pposid,
								ppos.position_id AS position_id,
								stat.params, stat.baseparams
						
  FROM net92_joomleague_statistic AS stat
						
  INNER JOIN net92_joomleague_position_statistic AS ps 
  ON ps.statistic_id=stat.id
						
  INNER JOIN net92_joomleague_project_position AS ppos 
  ON ppos.position_id=ps.position_id
						  
  AND ppos.project_id=19
						
  INNER JOIN net92_joomleague_position AS pos 
  ON pos.id=ps.position_id
						
  WHERE stat.published=1
						  
  AND pos.published =1
						   
  ORDER BY pos.ordering,ps.ordering

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pos	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	ppos	eq_ref	pos_proj,project_id,position_id	pos_proj	8	czarni_baza92.pos.id,const	1
1	SIMPLE	stat	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	ps	eq_ref	pos_et,position_id,statistic_id	pos_et	8	czarni_baza92.pos.id,czarni_baza92.stat.id	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.27 ms
Creating sort index	0.06 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:844
13	JoomleagueModelProject->getProjectStats()	JROOT/components/com_joomleague/models/statsranking.php:128
12	JoomleagueModelStatsRanking->getProjectUniqueStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:37
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.22 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.701 MB Zwróconych wierszy: 4

SELECT	pos.id,
								pos.persontype,
								pos.name,
								pos.ordering,
								pos.published,
								ppos.id AS pposid
						
  FROM net92_joomleague_project_position AS ppos
						
  INNER JOIN net92_joomleague_position AS pos 
  ON ppos.position_id=pos.id
						
  WHERE ppos.project_id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pos	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4
1	SIMPLE	ppos	eq_ref	pos_proj,project_id,position_id	pos_proj	8	czarni_baza92.pos.id,const	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:896
14	JoomleagueModelProject->getProjectPositions()	JROOT/components/com_joomleague/models/project.php:848
13	JoomleagueModelProject->getProjectStats()	JROOT/components/com_joomleague/models/statsranking.php:128
12	JoomleagueModelStatsRanking->getProjectUniqueStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:37
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.59 ms Po ostatnim zapytaniu: 0.69 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.722 MB Zwróconych wierszy: 1

SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '4' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	ms	ref\|filter	match_id,teamplayer_id,statistic_id	teamplayer_id\|statistic_id	4\|4	czarni_baza92.tp.id	15 (1%)	Using where; Using rowid filter
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomleague/statistics/basic.php:135
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.47 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.731 MB Zwróconych wierszy: 0

SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '4' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2' 
  GROUP BY tp.id  
  ORDER BY total desc, tp.id 
  LIMIT 0, 5

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	ms	ref\|filter	match_id,teamplayer_id,statistic_id	teamplayer_id\|statistic_id	4\|4	czarni_baza92.tp.id	15 (1%)	Using where; Using rowid filter
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_joomleague/statistics/basic.php:138
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.58 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.745 MB Zwróconych wierszy: 1

SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '3' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	ms	ref\|filter	match_id,teamplayer_id,statistic_id	teamplayer_id\|statistic_id	4\|4	czarni_baza92.tp.id	15 (10%)	Using where; Using rowid filter
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.25 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomleague/statistics/basic.php:135
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.60 ms Po ostatnim zapytaniu: 0.01 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.754 MB Zwróconych wierszy: 0

SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '3' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2' 
  GROUP BY tp.id  
  ORDER BY total desc, tp.id 
  LIMIT 0, 5

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	ms	ref\|filter	match_id,teamplayer_id,statistic_id	teamplayer_id\|statistic_id	4\|4	czarni_baza92.tp.id	15 (10%)	Using where; Using rowid filter
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.23 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_joomleague/statistics/basic.php:138
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.55 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.761 MB Zwróconych wierszy: 1

SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '2' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	ms	ref\|filter	match_id,teamplayer_id,statistic_id	teamplayer_id\|statistic_id	4\|4	czarni_baza92.tp.id	15 (10%)	Using where; Using rowid filter
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomleague/statistics/basic.php:135
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.60 ms Po ostatnim zapytaniu: 0.01 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.770 MB Zwróconych wierszy: 0

SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '2' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2' 
  GROUP BY tp.id  
  ORDER BY total desc, tp.id 
  LIMIT 0, 5

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	ms	ref\|filter	match_id,teamplayer_id,statistic_id	teamplayer_id\|statistic_id	4\|4	czarni_baza92.tp.id	15 (10%)	Using where; Using rowid filter
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.24 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_joomleague/statistics/basic.php:138
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.01 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.777 MB Zwróconych wierszy: 1

SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '1' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	ms	ref	match_id,teamplayer_id,statistic_id	teamplayer_id	4	czarni_baza92.tp.id	15	Using where
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomleague/statistics/basic.php:135
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.47 ms Po ostatnim zapytaniu: 0.01 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.785 MB Zwróconych wierszy: 0

SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '1' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1 
  WHERE pt.project_id = '19'   
  AND p.published = 1    
  AND pt.team_id = '2' 
  GROUP BY tp.id  
  ORDER BY total desc, tp.id 
  LIMIT 0, 5

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	PRIMARY,combi,project_id,team_id	combi	8	const,const	1	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	tp	ref	PRIMARY,projectteam_id,person_id	projectteam_id	5	const	15	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.tp.person_id	1	Using where
1	SIMPLE	ms	ref	match_id,teamplayer_id,statistic_id	teamplayer_id	4	czarni_baza92.tp.id	15	Using where
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.ms.match_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.11 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_joomleague/statistics/basic.php:138
13	JLGStatisticBasic->getPlayersRanking()	JROOT/components/com_joomleague/models/statsranking.php:148
12	JoomleagueModelStatsRanking->getPlayersStats()	JROOT/components/com_joomleague/views/statsranking/view.html.php:38
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.20 ms Po ostatnim zapytaniu: 0.15 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.789 MB Zwróconych wierszy: 1

Duplikaty zapytań: #46

SELECT CONCAT(major,".",minor,".",build,".",revision) AS version

  FROM net92_joomleague_version

  ORDER BY date DESC 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_version	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	6	Uruchomiono metodę filesort

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:1179
13	JoomleagueHelper::getVersion()	JROOT/components/com_joomleague/assets/classes/jlgview.php:100
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.19 ms Po ostatnim zapytaniu: 3.37 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.882 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #21 #23 #27 #41

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgview.php:158
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.16 ms Po ostatnim zapytaniu: 0.43 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.906 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #21 #23 #27 #40

SELECT extension

  FROM net92_joomleague_project

  WHERE id='19'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_project	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
17	JoomleagueHelper::getExtensions()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:731
16	JoomleagueHelper::addTemplatePaths()	JROOT/components/com_joomleague/views/statsranking/tmpl/default.php:6
15	include JROOT/components/com_joomleague/views/statsranking/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomleague/assets/classes/jlgview.php:215
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.17 ms Po ostatnim zapytaniu: 1.12 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 2.948 MB Zwróconych wierszy: 1

Duplikaty zapytań: #1 #43 #44 #45

SELECT `session_id`

  FROM `net92_session`

  WHERE `session_id` = X'6262373161383530643162383535393134663664323834383164633663626261' 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
25	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
24	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
23	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
22	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
21	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
20	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
19	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:564
18	JoomleagueHelperRoute::getStatsRankingRoute()	JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php:153
17	include JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_joomleague/views/statsranking/tmpl/default.php:17
15	include JROOT/components/com_joomleague/views/statsranking/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomleague/assets/classes/jlgview.php:215
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.14 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 2.974 MB Zwróconych wierszy: 1

Duplikaty zapytań: #1 #42 #44 #45

SELECT `session_id`

  FROM `net92_session`

  WHERE `session_id` = X'6262373161383530643162383535393134663664323834383164633663626261' 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
25	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
24	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
23	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
22	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
21	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
20	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
19	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:564
18	JoomleagueHelperRoute::getStatsRankingRoute()	JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php:153
17	include JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_joomleague/views/statsranking/tmpl/default.php:17
15	include JROOT/components/com_joomleague/views/statsranking/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomleague/assets/classes/jlgview.php:215
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.13 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 2.999 MB Zwróconych wierszy: 1

Duplikaty zapytań: #1 #42 #43 #45

SELECT `session_id`

  FROM `net92_session`

  WHERE `session_id` = X'6262373161383530643162383535393134663664323834383164633663626261' 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
25	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
24	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
23	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
22	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
21	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
20	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
19	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:564
18	JoomleagueHelperRoute::getStatsRankingRoute()	JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php:153
17	include JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_joomleague/views/statsranking/tmpl/default.php:17
15	include JROOT/components/com_joomleague/views/statsranking/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomleague/assets/classes/jlgview.php:215
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.12 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.025 MB Zwróconych wierszy: 1

Duplikaty zapytań: #1 #42 #43 #44

SELECT `session_id`

  FROM `net92_session`

  WHERE `session_id` = X'6262373161383530643162383535393134663664323834383164633663626261' 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.01 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
25	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
24	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
23	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
22	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
21	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
20	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
19	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:564
18	JoomleagueHelperRoute::getStatsRankingRoute()	JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php:153
17	include JROOT/components/com_joomleague/views/statsranking/tmpl/default_stats.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_joomleague/views/statsranking/tmpl/default.php:17
15	include JROOT/components/com_joomleague/views/statsranking/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomleague/assets/classes/jlgview.php:215
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.15 ms Po ostatnim zapytaniu: 0.13 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.036 MB Zwróconych wierszy: 1

Duplikaty zapytań: #39

SELECT CONCAT(major,".",minor,".",build,".",revision) AS version

  FROM net92_joomleague_version

  ORDER BY date DESC 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_joomleague_version	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	6	Uruchomiono metodę filesort

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:1179
18	JoomleagueHelper::getVersion()	JROOT/components/com_joomleague/views/footer/tmpl/default_footer.php:23
17	include JROOT/components/com_joomleague/views/footer/tmpl/default_footer.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_joomleague/views/statsranking/tmpl/default.php:21
15	include JROOT/components/com_joomleague/views/statsranking/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomleague/assets/classes/jlgview.php:215
12	JLGView->display()	JROOT/components/com_joomleague/views/statsranking/view.html.php:71
11	JoomleagueViewStatsRanking->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.21 ms Po ostatnim zapytaniu: 0.73 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.973 MB Zwróconych wierszy: 2

SELECT * 
  FROM net92_template_styles 
  WHERE template = 'shape5_vertex';

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_template_styles	ref	idx_template	idx_template	202	const	2	Using index condition

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/templates/shape5_vertex/vertex/parameters.php:20
9	getTemplateName()	JROOT/templates/shape5_vertex/vertex/parameters.php:169
8	require JROOT/templates/shape5_vertex/vertex/parameters.php	JROOT/templates/shape5_vertex/index.php:21
7	require JROOT/templates/shape5_vertex/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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.30 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.983 MB Zwróconych wierszy: 0

SELECT * 
  FROM net92_menu 
  WHERE template_style_id IN (26,27) 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_menu	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	118	Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/templates/shape5_vertex/vertex/parameters.php:45
9	getTemplateName()	JROOT/templates/shape5_vertex/vertex/parameters.php:169
8	require JROOT/templates/shape5_vertex/vertex/parameters.php	JROOT/templates/shape5_vertex/index.php:21
7	require JROOT/templates/shape5_vertex/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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.77 ms Po ostatnim zapytaniu: 2.27 ms Pamięć zapytania: 0.095 MB Pamięć przed zapytaniem: 3.087 MB Zwróconych wierszy: 29

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM net92_modules AS m

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

  LEFT JOIN net92_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	published,newsfeeds	published	5	NULL	35	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	czarni_baza92.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.44 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
15	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
14	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/shape5_vertex/vertex/module_calcs.php:41
8	require JROOT/templates/shape5_vertex/vertex/module_calcs.php	JROOT/templates/shape5_vertex/index.php:23
7	require JROOT/templates/shape5_vertex/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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.24 ms Po ostatnim zapytaniu: 2.79 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 3.331 MB Zwróconych wierszy: 0

SELECT menutype  
  FROM  net92_menu 
  WHERE language = 'pl-PL' 
  AND home = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	net92_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_menu.php:284
10	include JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_top_bar.php:169
9	require JROOT/templates/shape5_vertex/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/shape5_vertex/vertex/includes/vertex_includes_top.php:12
8	require JROOT/templates/shape5_vertex/vertex/includes/vertex_includes_top.php	JROOT/templates/shape5_vertex/index.php:126
7	require JROOT/templates/shape5_vertex/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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.54 ms Po ostatnim zapytaniu: 1.95 ms Pamięć zapytania: 0.048 MB Pamięć przed zapytaniem: 3.437 MB Zwróconych wierszy: 23

Duplikaty zapytań: #8 #52

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

  LEFT JOIN net92_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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	70	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.27 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
16	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
13	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
12	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
11	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:75
10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:107
8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:158
7	require JROOT/templates/shape5_vertex/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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.049 MB Pamięć przed zapytaniem: 3.531 MB Zwróconych wierszy: 23

Duplikaty zapytań: #8 #51

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

  LEFT JOIN net92_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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	70	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.21 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Identyczny z wywołaniem linii niżej.
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/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:78
10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:107
8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:158
7	require JROOT/templates/shape5_vertex/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

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

31 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

12 × SELECT extension 
  FROM net92_joomleague_project

5 × SELECT `session_id` 
  FROM `net92_session`

3 × 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 net92_menu AS m 
  LEFT JOIN net92_extensions AS e 
  ON m.component_id = e.extension_id

3 × SELECT t.params        
  FROM net92_joomleague_template_config AS t        
  INNER JOIN net92_joomleague_project AS p 
  ON p.id=t.project_id

2 × SELECT CONCAT(major,".",minor,".",build,".",revision) AS version 
  FROM net92_joomleague_version

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `net92_extensions`

1 × SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '4' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM net92_modules AS m 
  LEFT JOIN net92_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN net92_advancedmodules as am 
  ON am.moduleid = m.id

```
1 × SELECT * 
  FROM net92_menu
```

1 × SELECT * 
  FROM net92_template_styles

1 × SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '1' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '1' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '2' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '2' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT SUM(ms.value) AS total, tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic, p.firstname, p.nickname, p.lastname, p.picture, p.country, pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture, t.name AS team_name, t.short_name AS team_short_name 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '3' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '3' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT stat.id,         stat.name,         stat.short,         stat.class,         stat.icon,         stat.calculated,         ppos.id as pposid,         ppos.position_id AS position_id,         stat.params, stat.baseparams       
  FROM net92_joomleague_statistic AS stat       
  INNER JOIN net92_joomleague_position_statistic AS ps 
  ON ps.statistic_id=stat.id       
  INNER JOIN net92_joomleague_project_position AS ppos 
  ON ppos.position_id=ps.position_id         
  AND ppos.project_id=19       
  INNER JOIN net92_joomleague_position AS pos 
  ON pos.id=ps.position_id

1 × SELECT COUNT(DISTINCT tp.id) as count 
  FROM net92_joomleague_team_player AS tp 
  INNER JOIN net92_joomleague_person AS p 
  ON p.id = tp.person_id 
  INNER JOIN net92_joomleague_project_team AS pt 
  ON pt.id = tp.projectteam_id 
  INNER JOIN net92_joomleague_team AS t 
  ON pt.team_id = t.id 
  INNER JOIN net92_joomleague_match_statistic AS ms 
  ON ms.teamplayer_id = tp.id   
  AND ms.statistic_id = '4' 
  INNER JOIN net92_joomleague_match AS m 
  ON m.id = ms.match_id   
  AND m.published = 1

1 × SELECT pos.id,         pos.persontype,         pos.name,         pos.ordering,         pos.published,         ppos.id AS pposid       
  FROM net92_joomleague_project_position AS ppos       
  INNER JOIN net92_joomleague_position AS pos 
  ON ppos.position_id=pos.id

1 × SELECT tl.id AS projectteamid,         tl.division_id,         tl.standard_playground,         tl.start_points,         tl.points_finally,         tl.neg_points_finally,         tl.matches_finally,         tl.won_finally,         tl.draws_finally,         tl.lost_finally,         tl.homegoals_finally,         tl.guestgoals_finally,         tl.diffgoals_finally,         tl.info,         tl.reason,         tl.team_id,         tl.checked_out,         tl.checked_out_time,         tl.is_in_score,         tl.picture AS projectteam_picture,         t.picture as team_picture,         IF((ISNULL(tl.picture) OR (tl.picture="")),          (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) as picture,         tl.project_id,          t.id,t.name,         t.short_name,         t.middle_name,         t.notes,         t.club_id,          c.email as club_email,         c.logo_small,         c.logo_middle,         c.logo_big,         c.country,         c.website,          d.name AS division_name,         d.picture AS division_picture,         d.shortname AS division_shortname,         d.parent_id AS parent_division_id,          plg.name AS playground_name,         plg.short_name AS playground_short_name,          
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,         
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,         
  CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,         
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug        
  FROM net92_joomleague_project_team tl        
  LEFT JOIN net92_joomleague_team t 
  ON tl.team_id=t.id        
  LEFT JOIN net92_joomleague_club c 
  ON t.club_id=c.id        
  LEFT JOIN net92_joomleague_division d 
  ON d.id=tl.division_id        
  LEFT JOIN net92_joomleague_playground plg 
  ON plg.id=tl.standard_playground        
  LEFT JOIN net92_joomleague_project AS p 
  ON p.id=tl.project_id

1 × SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,      LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,      
  CASE WHEN CHAR_LENGTH( p.alias )      THEN CONCAT_WS( ':', p.id, p.alias )      ELSE p.id      END AS slug,      l.name AS league_name,      s.name AS season_name      
  FROM net92_joomleague_project AS p      
  INNER JOIN net92_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id      
  LEFT JOIN net92_joomleague_league AS l 
  ON p.league_id = l.id      
  LEFT JOIN net92_joomleague_season AS s 
  ON p.season_id = s.id

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

```
1 × SELECT * 
  FROM net92_languages
```

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

1 × SELECT `template` 
  FROM `net92_template_styles`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM net92_extensions

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

1 × SELECT id, rules 
  FROM `net92_viewlevels

1 × SELECT menutype  
  FROM  net92_menu

INNE tabele:

1 × INSERT INTO `net92_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6262373161383530643162383535393134663664323834383164633663626261', 1, 1784353579, 0, '', 0

1 × UPDATE `net92_extensions` 
  SET `params` = '{\"mediaversion\":\"76adf536f3369b6041887a19a6cf5f8e\"}'

Login

REGISTER

Kartki CZE

Kartki ŻÓŁ

Bramki

Minuty

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

52 zapytań zarejestrowanych 16.08 ms

24 znalezionych duplikatów!

31 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

INNE tabele: