Club information: KS Mściszewice

Club information: KS Mściszewice | A-Klasa 2025/26 ***

Teams of this club

KS Mściszewice (KS )

:: Powered by JoomLeague - Version 3.0.22.57ae969 ::

Konsola diagnostyczna Joomla!

Sesja

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

#	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'6335636631373334303934356435326531386437333166333630663731356162', 1, 1768253623, 0, '', 0)

Profile

Status	Duration
Starting	0.04 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.00 ms
Query end	0.00 ms
Commit	0.09 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.04 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.33 ms Po ostatnim zapytaniu: 0.94 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 4.403 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.04 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.08 ms
End of update loop	0.00 ms
Query end	0.00 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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.20 ms Po ostatnim zapytaniu: 0.98 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 4.656 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.04 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
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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 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.23 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 4.668 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.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.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.03 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.38 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 4.737 MB Zwróconych wierszy: 44

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	246	Using where; Uruchomiono metodę filesort

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.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.15 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.40 ms Po ostatnim zapytaniu: 8.55 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 6.541 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	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	Using where

Profile

Status	Duration
Starting	0.11 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.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.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.01 ms
Freeing items	0.06 ms
Updating status	0.02 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.49 ms Po ostatnim zapytaniu: 4.33 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 7.502 MB Zwróconych wierszy: 23

Duplikaty zapytań: #41 #42

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.08 ms
checking permissions	0.01 ms
Opening tables	0.02 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.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.17 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.04 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.46 ms Po ostatnim zapytaniu: 9.71 ms Pamięć zapytania: 0.008 MB Pamięć przed zapytaniem: 9.766 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_djleague','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.07 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.05 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.13 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.03 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.23 ms Po ostatnim zapytaniu: 0.46 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 9.939 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.04 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.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.03 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.28 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 9.930 MB

UPDATE `net92_extensions`

  SET `params` = '{\"mediaversion\":\"62d7601849cb7bb5476219212e0ad431\"}'

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

Objaśnienie

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

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.00 ms
init for update	0.03 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.08 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.01 ms
Freeing items	0.03 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.22 ms Po ostatnim zapytaniu: 0.93 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 10.111 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.04 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.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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 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.28 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 10.120 MB Zwróconych wierszy: 4

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	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	4
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.04 ms
checking permissions	0.00 ms
Opening tables	0.02 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.04 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.03 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: 2.68 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 10.713 MB Zwróconych wierszy: 1

Duplikaty zapytań: #15 #16 #17 #18 #19 #20 #22 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.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.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
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.19 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 10.736 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #16 #17 #18 #19 #20 #22 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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.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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.17 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 10.742 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #17 #18 #19 #20 #22 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.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.01 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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.17 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.008 MB Pamięć przed zapytaniem: 10.750 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #18 #19 #20 #22 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.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.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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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/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.17 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 10.770 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #19 #20 #22 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.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.01 ms
Preparing	0.00 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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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: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.18 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 10.781 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #20 #22 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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
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.03 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.17 ms Po ostatnim zapytaniu: 0.28 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 10.895 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #22 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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
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.03 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.22 ms Po ostatnim zapytaniu: 1.16 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.117 MB Zwróconych wierszy: 1

SELECT *

  FROM `net92_joomleague_club`

  WHERE `id` = '118'

Objaśnienie

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

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.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
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.03 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/clubinfo.php:54
12	JoomleagueModelClubInfo->getClub()	JROOT/components/com_joomleague/views/clubinfo/view.html.php:16
11	JoomleagueViewClubInfo->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: 2.24 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.409 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #25 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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
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.00 ms
Query end	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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/clubinfo/view.html.php:17
11	JoomleagueViewClubInfo->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.32 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.414 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='clubinfo'
				   
  AND p.id='18'

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	83	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 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.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.09 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.03 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:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
12	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/views/clubinfo/view.html.php:17
11	JoomleagueViewClubInfo->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.33 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.422 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='18' 
  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.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 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
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.03 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/clubinfo/view.html.php:18
11	JoomleagueViewClubInfo->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.04 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.479 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #22 #29 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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.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.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.03 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/clubinfo/view.html.php:20
11	JoomleagueViewClubInfo->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.05 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.485 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='18'

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	83	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 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.01 ms
Sending data	0.09 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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 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/clubinfo/view.html.php:20
11	JoomleagueViewClubInfo->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.45 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.496 MB Zwróconych wierszy: 1

SELECT `id`,
  CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(':', `id`,`alias`) ELSE `id` END AS slug,`name` AS `team_name`,`short_name` AS `team_shortcut`,`info` AS `team_description`,COALESCE((SELECT MAX(project_id)
							
  FROM net92_joomleague_project_team
							RIGHT JOIN net92_joomleague_project p 
  on project_id=p.id
							
  WHERE team_id=t.id 
  and p.published = 1), 0) as pid

  FROM `net92_joomleague_team` AS `t`

  WHERE `club_id` = 118

  ORDER BY `t`.`ordering`

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	t	ref	club_id,fk_club	club_id	5	const	2	Using where; Uruchomiono metodę filesort
2	DEPENDENT SUBQUERY	net92_joomleague_project_team	ref	combi,project_id,team_id	team_id	4	czarni_baza92.t.id	2
2	DEPENDENT SUBQUERY	p	eq_ref	PRIMARY	PRIMARY	4	czarni_baza92.net92_joomleague_project_team.project_id	1	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 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.04 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
Executing	0.01 ms
Sending data	0.04 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
Removing tmp table	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/clubinfo.php:97
12	JoomleagueModelClubInfo->getTeamsByClubId()	JROOT/components/com_joomleague/views/clubinfo/view.html.php:21
11	JoomleagueViewClubInfo->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.03 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.505 MB Zwróconych wierszy: 0

SELECT DISTINCT(pt.standard_playground)

  FROM `net92_joomleague_project_team` AS `pt`

  INNER JOIN `net92_joomleague_team` AS `t` 
  ON `t`.`id` = `team_id`

  INNER JOIN `net92_joomleague_club` AS `c` 
  ON `c`.`id` = `t`.`club_id`

  WHERE `c`.`id` = '118' 
  AND `pt`.`standard_playground` > 0

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary
1	SIMPLE	t	ref	PRIMARY,club_id,fk_club	club_id	5	const	2
1	SIMPLE	pt	ref	team_id	team_id	4	czarni_baza92.t.id	2	Using where

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.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_joomleague/models/clubinfo.php:129
13	JoomleagueModelClubInfo->getPlaygroundIds()	JROOT/components/com_joomleague/models/clubinfo.php:145
12	JoomleagueModelClubInfo->getPlaygrounds()	JROOT/components/com_joomleague/views/clubinfo/view.html.php:22
11	JoomleagueViewClubInfo->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: 0.78 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.569 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #22 #25 #31 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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.01 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.03 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:768
12	JoomleagueModelProject->getMapConfig()	JROOT/components/com_joomleague/views/clubinfo/view.html.php:24
11	JoomleagueViewClubInfo->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.007 MB Pamięć przed zapytaniem: 11.575 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='map'
				   
  AND p.id='18'

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	83	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 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.08 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.03 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:768
12	JoomleagueModelProject->getMapConfig()	JROOT/components/com_joomleague/views/clubinfo/view.html.php:24
11	JoomleagueViewClubInfo->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.18 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.583 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #22 #25 #29 #33 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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.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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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:233
12	JLGView->getExtended()	JROOT/components/com_joomleague/views/clubinfo/view.html.php:27
11	JoomleagueViewClubInfo->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.18 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 11.592 MB Zwróconych wierszy: 1

Duplikaty zapytań: #36

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.04 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.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.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.03 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/clubinfo/view.html.php:30
11	JoomleagueViewClubInfo->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: 4.98 ms Pamięć zapytania: 0.008 MB Pamięć przed zapytaniem: 12.050 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #22 #25 #29 #31 #34

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.09 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.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.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 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/clubinfo/view.html.php:30
11	JoomleagueViewClubInfo->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: 0.19 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 12.080 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14 #15 #16 #17 #18 #19 #20 #22 #25 #29 #31 #33

SELECT extension

  FROM net92_joomleague_project

  WHERE id='18'

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.04 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.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.03 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/clubinfo/tmpl/default.php:6
15	include JROOT/components/com_joomleague/views/clubinfo/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/clubinfo/view.html.php:30
11	JoomleagueViewClubInfo->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: 4.18 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 12.738 MB Zwróconych wierszy: 1

Duplikaty zapytań: #1

SELECT `session_id`

  FROM `net92_session`

  WHERE `session_id` = X'6335636631373334303934356435326531386437333166333630663731356162' 
  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.09 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.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
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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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:32
18	JoomleagueHelperRoute::getTeamInfoRoute()	JROOT/components/com_joomleague/views/clubinfo/tmpl/default_teams.php:14
17	include JROOT/components/com_joomleague/views/clubinfo/tmpl/default_teams.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_joomleague/views/clubinfo/tmpl/default.php:48
15	include JROOT/components/com_joomleague/views/clubinfo/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/clubinfo/view.html.php:30
11	JoomleagueViewClubInfo->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.32 ms Pamięć zapytania: 0.010 MB Pamięć przed zapytaniem: 12.760 MB Zwróconych wierszy: 1

Duplikaty zapytań: #32

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.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.01 ms
Preparing	0.01 ms
Sorting result	0.01 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.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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/clubinfo/tmpl/default.php:58
15	include JROOT/components/com_joomleague/views/clubinfo/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/clubinfo/view.html.php:30
11	JoomleagueViewClubInfo->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.23 ms Po ostatnim zapytaniu: 2.01 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 12.925 MB Zwróconych wierszy: 1

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	1	Using index condition

Profile

Status	Duration
Starting	0.04 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.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.04 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.26 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 12.932 MB Zwróconych wierszy: 0

SELECT * 
  FROM net92_menu 
  WHERE template_style_id IN (26) 
  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	125	Using where

Profile

Status	Duration
Starting	0.04 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.07 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.51 ms Po ostatnim zapytaniu: 3.25 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 13.848 MB Zwróconych wierszy: 16

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	22	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.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 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.19 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.03 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/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.22 ms Po ostatnim zapytaniu: 4.15 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 14.255 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.04 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.01 ms
Statistics	0.02 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.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.42 ms Po ostatnim zapytaniu: 3.11 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 14.517 MB Zwróconych wierszy: 23

Duplikaty zapytań: #8 #42

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.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.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.16 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 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.36 ms Po ostatnim zapytaniu: 0.11 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 14.616 MB Zwróconych wierszy: 23

Duplikaty zapytań: #8 #41

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.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.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.13 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.00 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.03 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/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]

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

WYBRANE tabele:

13 × SELECT extension 
  FROM net92_joomleague_project

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`

2 × SELECT `session_id` 
  FROM `net92_session`

1 × SELECT `template` 
  FROM `net92_template_styles`

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

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

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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM net92_extensions

1 × SELECT * 
  FROM `net92_joomleague_club`

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 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`,
  CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(':', `id`,`alias`) ELSE `id` END AS slug,`name` AS `team_name`,`short_name` AS `team_shortcut`,`info` AS `team_description`,COALESCE((SELECT MAX(project_id)        
  FROM net92_joomleague_project_team        RIGHT JOIN net92_joomleague_project p 
  on project_id=p.id

1 × SELECT DISTINCT(pt.standard_playground) 
  FROM `net92_joomleague_project_team` AS `pt` 
  INNER JOIN `net92_joomleague_team` AS `t` 
  ON `t`.`id` = `team_id` 
  INNER JOIN `net92_joomleague_club` AS `c` 
  ON `c`.`id` = `t`.`club_id`

1 × SELECT id, rules 
  FROM `net92_viewlevels

1 × SELECT * 
  FROM net92_template_styles

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

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 menutype  
  FROM  net92_menu

INNE tabele:

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

1 × UPDATE `net92_extensions` 
  SET `params` = '{\"mediaversion\":\"62d7601849cb7bb5476219212e0ad431\"}'

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

42 zapytań zarejestrowanych 11.49 ms

20 znalezionych duplikatów!

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

WYBRANE tabele:

INNE tabele: