Games Schedule View

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

Czas

Pamięć

24 zapytań zarejestrowanych 33.77 ms

1. Czas zapytania: 0.64 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 3.891 MB Zwróconych wierszy: 0

   SELECT `data`
   
     FROM `l1nea_session`
   
     WHERE `session_id` = X'386b6a7533356e386c706b626f386e306d303533653538363273'

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l1nea_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.03 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.02 ms
   init	0.04 ms
   optimizing	0.03 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   updating status	0.03 ms
   cleaning up	0.04 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Identyczny z wywołaniem linii niżej.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Czas zapytania: 0.56 ms Po ostatnim zapytaniu: 4.31 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 3.998 MB Zwróconych wierszy: 0

   SELECT `session_id`
   
     FROM `l1nea_session`
   
     WHERE `session_id` = X'386b6a7533356e386c706b626f386e306d303533653538363273' 
     LIMIT 1

   Objaśnienie

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

   Profile

   Status	Duration
   starting	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   After table lock	0.02 ms
   init	0.04 ms
   optimizing	0.05 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 ms

   Stos wywołania

   #	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

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

   ---

3. Czas zapytania: 0.38 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 4.003 MB

   INSERT INTO `l1nea_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'386b6a7533356e386c706b626f386e306d303533653538363273', 1, 1716191400, 0, '', 0)

   Objaśnienie

   Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `l1nea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'386b6a7533356e386c706b626f386e306d303533653538363273', 1, 1716191400, 0, '', 0)

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.02 ms
   update	0.08 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.01 ms
   query end	0.05 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 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]

   ---

4. Czas zapytania: 0.86 ms Po ostatnim zapytaniu: 7.10 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 4.213 MB Zwróconych wierszy: 41

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `l1nea_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	l1nea_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

   Profile

   Status	Duration
   starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.04 ms
   optimizing	0.03 ms
   statistics	0.08 ms
   preparing	0.04 ms
   executing	0.01 ms
   Sending data	0.28 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 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]

   ---

5. Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 7.13 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 4.476 MB Zwróconych wierszy: 5

   SELECT id, rules
   
     FROM `l1nea_viewlevels`

   Objaśnienie

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

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.04 ms
   cleaning up	0.01 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]

   ---

6. Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.488 MB Zwróconych wierszy: 2

   SELECT b.id
   
     FROM l1nea_usergroups AS a
   
     LEFT JOIN l1nea_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	3	Using where; Using index

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.03 ms
   optimizing	0.03 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.01 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]

   ---

7. Czas zapytania: 1.75 ms Po ostatnim zapytaniu: 1.46 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 4.558 MB Zwróconych wierszy: 109

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM l1nea_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	l1nea_extensions	ref	extension	extension	82	const	132	Using index condition; Using where; Uruchomiono metodę filesort

   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.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.04 ms
   optimizing	0.05 ms
   statistics	0.07 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sorting result	0.70 ms
   Sending data	0.50 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 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]

   ---

8. Czas zapytania: 1.79 ms Po ostatnim zapytaniu: 44.65 ms Pamięć zapytania: 0.088 MB Pamięć przed zapytaniem: 6.232 MB Zwróconych wierszy: 56

   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 l1nea_menu AS m
   
     LEFT JOIN l1nea_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	89	Using index condition; Using where; Uruchomiono metodę filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.m.component_id	1	Using where

   Profile

   Status	Duration
   starting	0.12 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.05 ms
   optimizing	0.04 ms
   statistics	0.08 ms
   preparing	0.05 ms
   executing	0.01 ms
   Sorting result	0.43 ms
   Sending data	0.76 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.01 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]

   ---

9. Czas zapytania: 0.68 ms Po ostatnim zapytaniu: 20.83 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 7.045 MB Zwróconych wierszy: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `l1nea_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Objaśnienie

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

   Profile

   Status	Duration
   starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.04 ms
   optimizing	0.03 ms
   statistics	0.14 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.08 ms
   end	0.01 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 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/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
   8	plgSystemDJjQueryMonster->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]

   ---

10. Czas zapytania: 4.41 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 7.038 MB

    UPDATE `l1nea_extensions`
    
      SET `params` = '{\"mediaversion\":\"c00905546b06a164365ef2f23db0f053\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.08 ms
    Updating	0.09 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.01 ms
    query end	3.96 ms
    closing tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
    8	plgSystemDJjQueryMonster->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]

    ---

11. Czas zapytania: 0.67 ms Po ostatnim zapytaniu: 3.89 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 7.295 MB Zwróconych wierszy: 4

    SELECT id, home, template, s.params
    
      FROM l1nea_template_styles as s
    
      LEFT JOIN l1nea_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.01 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/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1018
    9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
    8	plgSystemEF4_JMFramework->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]

    ---

12. Czas zapytania: 0.88 ms Po ostatnim zapytaniu: 17.72 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 8.142 MB Zwróconych wierszy: 1

    SELECT *
    
      FROM l1nea_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	l1nea_languages	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	2	Using where; Uruchomiono metodę filesort

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.02 ms
    init	0.05 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.07 ms
    Sending data	0.08 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.05 ms
    cleaning up	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]

    ---

13. Czas zapytania: 0.64 ms Po ostatnim zapytaniu: 1217.56 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 8.830 MB Zwróconych wierszy: 0
    Duplikaty zapytań: #15  #21  #22

    SELECT * 
      FROM l1nea_djl_leagues 
      WHERE tournament_id=7 
      AND season_id=1 
      LIMIT 1

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_djleague/models/scoretables.php:190
    15	DJLeagueModelScoretables->getLeague()	JROOT/administrator/components/com_djleague/models/scoretables.php:86
    14	DJLeagueModelScoretables->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djleague/views/tables/view.html.php:48
    10	DJLeagueViewTables->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djleague/controller.php:68
    8	DJLeagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djleague/djleague.php:45
    6	require_once JROOT/components/com_djleague/djleague.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]

    ---

14. Czas zapytania: 1.29 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 8.841 MB Zwróconych wierszy: 0

    SELECT a.*, t.name, t.logo,
    				count(s.id) AS played, sum(s.won) AS won, sum(s.drawn) AS drawn, sum(s.lost) AS lost, 
    				sum(s.score_for) AS score_for, sum(s.score_against) AS score_against, 
    				sum(s.score_for-s.score_against) AS score_diff, (sum(s.points)+a.extra_points) AS points 
      FROM
    				  l1nea_djl_tables a, l1nea_djl_teams t
    				  
      LEFT JOIN (
    					SELECT g.id, g.team_home AS team_id, 
    					
      case when g.winner=1 then 1 else 0 end AS won, 
    					
      case when g.winner=0 then 1 else 0 end AS drawn, 
    					
      case when g.winner=2 then 1 else 0 end AS lost, 
    					g.score_home AS score_for, 
    					g.score_away AS score_against,
    					g.points_home AS points 
    					
      FROM `l1nea_djl_games` g 
    					
      WHERE (g.league_id=0 
      AND g.status=1) 
    					
    					UNION 
    					SELECT g.id, g.team_away AS team_id, 
    					
      case when g.winner=2 then 1 else 0 end AS won, 
    					
      case when g.winner=0 then 1 else 0 end AS drawn, 
    					
      case when g.winner=1 then 1 else 0 end AS lost, 
    					g.score_away AS score_for, 
    					g.score_home AS score_against,
    					g.points_away AS points 
    					
      FROM `l1nea_djl_games` g 
    					
      WHERE (g.league_id=0 
      AND g.status=1) 
    					
    				  ) AS s 
      ON t.id=s.team_id
    				  
      WHERE t.id=a.team_id 
      AND a.league_id=0
    				  
      GROUP BY a.team_id
    				  
      ORDER BY points desc, score_diff desc, played desc,  a.ordering asc

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ref	league_id	league_id	4	const	1	Using where; Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.team_id	1
    1	PRIMARY	<derived2>	ref	key0	key0	5	novaprod24_grom.a.team_id	2
    2	DERIVED	g	ref	league,league_id	league	4	const	1	Using where
    3	UNION	g	ref	league,league_id	league	4	const	1	Using where
    NULL	UNION RESULT	<union2,3>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.13 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.04 ms
    statistics	0.05 ms
    preparing	0.04 ms
    executing	0.02 ms
    Creating tmp table	0.05 ms
    Copying to tmp table	0.06 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djleague/views/tables/view.html.php:48
    10	DJLeagueViewTables->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djleague/controller.php:68
    8	DJLeagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djleague/djleague.php:45
    6	require_once JROOT/components/com_djleague/djleague.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]

    ---

15. Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.13 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 8.849 MB Zwróconych wierszy: 0
    Duplikaty zapytań: #13  #21  #22

    SELECT * 
      FROM l1nea_djl_leagues 
      WHERE tournament_id=7 
      AND season_id=1 
      LIMIT 1

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 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/administrator/components/com_djleague/models/scoretables.php:190
    12	DJLeagueModelScoretables->getLeague()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djleague/views/tables/view.html.php:51
    10	DJLeagueViewTables->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djleague/controller.php:68
    8	DJLeagueController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djleague/djleague.php:45
    6	require_once JROOT/components/com_djleague/djleague.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]

    ---

16. Czas zapytania: 0.78 ms Po ostatnim zapytaniu: 417.43 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 9.707 MB Zwróconych wierszy: 6

    SELECT id 
      FROM l1nea_template_styles 
      ORDER BY id

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l1nea_template_styles	index	NULL	PRIMARY	4	NULL	6	Using index

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sorting result	0.02 ms
    Sending data	0.10 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.07 ms
    cleaning up	0.03 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/plugins/system/ef4_jmframework/includes/libraries/template.php:329
    9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126
    8	JMFTemplate->__construct()	JROOT/templates/jm-sport/index.php:18
    7	require JROOT/templates/jm-sport/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]

    ---

17. Czas zapytania: 7.57 ms Po ostatnim zapytaniu: 149.76 ms Pamięć zapytania: 0.073 MB Pamięć przed zapytaniem: 10.760 MB Zwróconych wierszy: 31

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM l1nea_modules AS m
    
      LEFT JOIN l1nea_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN l1nea_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-20 07:50:02') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 07:50:02') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 969 OR mm.menuid <= 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	ref	PRIMARY,published,newsfeeds	published	1	const	114	Using index condition; Using where; Uruchomiono metodę filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	novaprod24_grom.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	novaprod24_grom.m.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.23 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.10 ms
    optimizing	0.13 ms
    statistics	0.24 ms
    preparing	0.13 ms
    executing	0.02 ms
    Sorting result	1.50 ms
    Sending data	4.69 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    updating status	0.06 ms
    cleaning up	0.02 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	Identyczny z wywołaniem linii niżej.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476
    11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469
    10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711
    9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
    8	JMFTemplate->__construct()	JROOT/templates/jm-sport/index.php:18
    7	require JROOT/templates/jm-sport/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]

    ---

18. Czas zapytania: 0.54 ms Po ostatnim zapytaniu: 724.43 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 10.882 MB Zwróconych wierszy: 1
    Duplikaty zapytań: #19

    SELECT * 
      FROM l1nea_djl_leagues 
      WHERE tournament_id=2 
      AND season_id=1 
      LIMIT 1

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.04 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 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/modules/mod_djleague_tables/helper.php:91
    17	modDJLeagueTablesHelper::getLeague()	JROOT/modules/mod_djleague_tables/mod_djleague_tables.php:40
    16	include JROOT/modules/mod_djleague_tables/mod_djleague_tables.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-sport/tpl/blocks/main.php:69
    12	include JROOT/templates/jm-sport/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-sport/tpl/default.php:72
    10	include JROOT/templates/jm-sport/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-sport/index.php:19
    7	require JROOT/templates/jm-sport/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]

    ---

19. Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 10.895 MB Zwróconych wierszy: 1
    Duplikaty zapytań: #18

    SELECT * 
      FROM l1nea_djl_leagues 
      WHERE tournament_id=2 
      AND season_id=1 
      LIMIT 1

    Objaśnienie

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

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_djleague/models/scoretables.php:190
    21	DJLeagueModelScoretables->getLeague()	JROOT/administrator/components/com_djleague/models/scoretables.php:86
    20	DJLeagueModelScoretables->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    19	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/modules/mod_djleague_tables/helper.php:55
    17	modDJLeagueTablesHelper::getItems()	JROOT/modules/mod_djleague_tables/mod_djleague_tables.php:43
    16	include JROOT/modules/mod_djleague_tables/mod_djleague_tables.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-sport/tpl/blocks/main.php:69
    12	include JROOT/templates/jm-sport/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-sport/tpl/default.php:72
    10	include JROOT/templates/jm-sport/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-sport/index.php:19
    7	require JROOT/templates/jm-sport/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]

    ---

20. Czas zapytania: 5.09 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 10.910 MB Zwróconych wierszy: 16

    SELECT a.*, t.name, t.logo,
    				count(s.id) AS played, sum(s.won) AS won, sum(s.drawn) AS drawn, sum(s.lost) AS lost, 
    				sum(s.score_for) AS score_for, sum(s.score_against) AS score_against, 
    				sum(s.score_for-s.score_against) AS score_diff, (sum(s.points)+a.extra_points) AS points 
      FROM
    				  l1nea_djl_tables a, l1nea_djl_teams t
    				  
      LEFT JOIN (
    					SELECT g.id, g.team_home AS team_id, 
    					
      case when g.winner=1 then 1 else 0 end AS won, 
    					
      case when g.winner=0 then 1 else 0 end AS drawn, 
    					
      case when g.winner=2 then 1 else 0 end AS lost, 
    					g.score_home AS score_for, 
    					g.score_away AS score_against,
    					g.points_home AS points 
    					
      FROM `l1nea_djl_games` g 
    					
      WHERE (g.league_id=2 
      AND g.status=1) 
    					
      AND g.round<=2
    					UNION 
    					SELECT g.id, g.team_away AS team_id, 
    					
      case when g.winner=2 then 1 else 0 end AS won, 
    					
      case when g.winner=0 then 1 else 0 end AS drawn, 
    					
      case when g.winner=1 then 1 else 0 end AS lost, 
    					g.score_away AS score_for, 
    					g.score_home AS score_against,
    					g.points_away AS points 
    					
      FROM `l1nea_djl_games` g 
    					
      WHERE (g.league_id=2 
      AND g.status=1) 
    					
      AND g.round<=2
    				  ) AS s 
      ON t.id=s.team_id
    				  
      WHERE t.id=a.team_id 
      AND a.league_id=2
    				  
      GROUP BY a.team_id
    				  
      ORDER BY points desc, score_diff desc, played desc,  a.ordering asc

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ref	league_id	league_id	4	const	16	Using where; Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.team_id	1
    1	PRIMARY	<derived2>	ref	key0	key0	5	novaprod24_grom.a.team_id	10
    2	DERIVED	g	ref	league,league_id	league_id	5	const,const	239	Using where
    3	UNION	g	ref	league,league_id	league_id	5	const,const	239	Using where
    NULL	UNION RESULT	<union2,3>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.13 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.04 ms
    statistics	0.05 ms
    preparing	0.04 ms
    executing	0.01 ms
    Creating tmp table	0.06 ms
    Copying to tmp table	0.06 ms
    executing	0.01 ms
    Sending data	0.88 ms
    executing	0.02 ms
    Sending data	0.79 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.52 ms
    removing tmp table	0.01 ms
    Sending data	1.54 ms
    Sorting result	0.04 ms
    Sending data	0.10 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/modules/mod_djleague_tables/helper.php:55
    17	modDJLeagueTablesHelper::getItems()	JROOT/modules/mod_djleague_tables/mod_djleague_tables.php:43
    16	include JROOT/modules/mod_djleague_tables/mod_djleague_tables.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-sport/tpl/blocks/main.php:69
    12	include JROOT/templates/jm-sport/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-sport/tpl/default.php:72
    10	include JROOT/templates/jm-sport/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-sport/index.php:19
    7	require JROOT/templates/jm-sport/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]

    ---

21. Czas zapytania: 0.63 ms Po ostatnim zapytaniu: 160.53 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 10.969 MB Zwróconych wierszy: 0
    Duplikaty zapytań: #13  #15  #22

    SELECT * 
      FROM l1nea_djl_leagues 
      WHERE tournament_id=7 
      AND season_id=1 
      LIMIT 1

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.01 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/modules/mod_djleague_tables/helper.php:91
    17	modDJLeagueTablesHelper::getLeague()	JROOT/modules/mod_djleague_tables/mod_djleague_tables.php:40
    16	include JROOT/modules/mod_djleague_tables/mod_djleague_tables.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-sport/tpl/blocks/main.php:69
    12	include JROOT/templates/jm-sport/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-sport/tpl/default.php:72
    10	include JROOT/templates/jm-sport/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-sport/index.php:19
    7	require JROOT/templates/jm-sport/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]

    ---

22. Czas zapytania: 0.49 ms Po ostatnim zapytaniu: 0.19 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 10.980 MB Zwróconych wierszy: 0
    Duplikaty zapytań: #13  #15  #21

    SELECT * 
      FROM l1nea_djl_leagues 
      WHERE tournament_id=7 
      AND season_id=1 
      LIMIT 1

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_djleague/models/scoretables.php:190
    21	DJLeagueModelScoretables->getLeague()	JROOT/administrator/components/com_djleague/models/scoretables.php:86
    20	DJLeagueModelScoretables->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    19	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/modules/mod_djleague_tables/helper.php:55
    17	modDJLeagueTablesHelper::getItems()	JROOT/modules/mod_djleague_tables/mod_djleague_tables.php:43
    16	include JROOT/modules/mod_djleague_tables/mod_djleague_tables.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-sport/tpl/blocks/main.php:69
    12	include JROOT/templates/jm-sport/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-sport/tpl/default.php:72
    10	include JROOT/templates/jm-sport/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-sport/index.php:19
    7	require JROOT/templates/jm-sport/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. Czas zapytania: 1.36 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 10.995 MB Zwróconych wierszy: 0

    SELECT a.*, t.name, t.logo,
    				count(s.id) AS played, sum(s.won) AS won, sum(s.drawn) AS drawn, sum(s.lost) AS lost, 
    				sum(s.score_for) AS score_for, sum(s.score_against) AS score_against, 
    				sum(s.score_for-s.score_against) AS score_diff, (sum(s.points)+a.extra_points) AS points 
      FROM
    				  l1nea_djl_tables a, l1nea_djl_teams t
    				  
      LEFT JOIN (
    					SELECT g.id, g.team_home AS team_id, 
    					
      case when g.winner=1 then 1 else 0 end AS won, 
    					
      case when g.winner=0 then 1 else 0 end AS drawn, 
    					
      case when g.winner=2 then 1 else 0 end AS lost, 
    					g.score_home AS score_for, 
    					g.score_away AS score_against,
    					g.points_home AS points 
    					
      FROM `l1nea_djl_games` g 
    					
      WHERE (g.league_id=0 
      AND g.status=1) 
    					
      AND g.round<=2
    					UNION 
    					SELECT g.id, g.team_away AS team_id, 
    					
      case when g.winner=2 then 1 else 0 end AS won, 
    					
      case when g.winner=0 then 1 else 0 end AS drawn, 
    					
      case when g.winner=1 then 1 else 0 end AS lost, 
    					g.score_away AS score_for, 
    					g.score_home AS score_against,
    					g.points_away AS points 
    					
      FROM `l1nea_djl_games` g 
    					
      WHERE (g.league_id=0 
      AND g.status=1) 
    					
      AND g.round<=2
    				  ) AS s 
      ON t.id=s.team_id
    				  
      WHERE t.id=a.team_id 
      AND a.league_id=0
    				  
      GROUP BY a.team_id
    				  
      ORDER BY points desc, score_diff desc, played desc,  a.ordering asc

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ref	league_id	league_id	4	const	1	Using where; Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.team_id	1
    1	PRIMARY	<derived2>	ref	key0	key0	5	novaprod24_grom.a.team_id	2
    2	DERIVED	g	ref	league,league_id	league	4	const	1	Using where
    3	UNION	g	ref	league,league_id	league	4	const	1	Using where
    NULL	UNION RESULT	<union2,3>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL

    Profile

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.16 ms
    optimizing	0.02 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.06 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.05 ms
    statistics	0.06 ms
    preparing	0.04 ms
    executing	0.01 ms
    Creating tmp table	0.05 ms
    Copying to tmp table	0.04 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/modules/mod_djleague_tables/helper.php:55
    17	modDJLeagueTablesHelper::getItems()	JROOT/modules/mod_djleague_tables/mod_djleague_tables.php:43
    16	include JROOT/modules/mod_djleague_tables/mod_djleague_tables.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-sport/tpl/blocks/main.php:69
    12	include JROOT/templates/jm-sport/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-sport/tpl/default.php:72
    10	include JROOT/templates/jm-sport/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-sport/index.php:19
    7	require JROOT/templates/jm-sport/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]

    ---

24. Czas zapytania: 1.03 ms Po ostatnim zapytaniu: 597.46 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 11.451 MB Zwróconych wierszy: 1

    SELECT manifest_cache 
      FROM l1nea_extensions 
      WHERE element='mod_djmegamenu' 
      LIMIT 1

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l1nea_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.16 ms
    preparing	0.05 ms
    executing	0.02 ms
    Sending data	0.11 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.07 ms
    freeing items	0.03 ms
    updating status	0.06 ms
    cleaning up	0.02 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/modules/mod_djmegamenu/helper.php:313
    11	modDJMMHelper::getVersion()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:80
    10	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

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

WYBRANE tabele:

1. 6 × SELECT * 
     FROM l1nea_djl_leagues

2. 3 × SELECT a.*, t.name, t.logo,     count(s.id) AS played, sum(s.won) AS won, sum(s.drawn) AS drawn, sum(s.lost) AS lost,      sum(s.score_for) AS score_for, sum(s.score_against) AS score_against,      sum(s.score_for-s.score_against) AS score_diff, (sum(s.points)+a.extra_points) AS points 
     FROM       l1nea_djl_tables a, l1nea_djl_teams t       
     LEFT JOIN (      SELECT g.id, g.team_home AS team_id,       
     case when g.winner=1 then 1 else 0 end AS won,       
     case when g.winner=0 then 1 else 0 end AS drawn,       
     case when g.winner=2 then 1 else 0 end AS lost,       g.score_home AS score_for,       g.score_away AS score_against,      g.points_home AS points       
     FROM `l1nea_djl_games` g

3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `l1nea_extensions`

4. 1 × SELECT `data` 
     FROM `l1nea_session`

5. 1 × SELECT `session_id` 
     FROM `l1nea_session`

6. 1 × SELECT id, rules 
     FROM `l1nea_viewlevels

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

8. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
     FROM l1nea_extensions

9. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
     FROM l1nea_menu AS m 
     LEFT JOIN l1nea_extensions AS e 
     ON m.component_id = e.extension_id

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

11. 1 × SELECT * 
      FROM l1nea_languages

12. 1 × SELECT id 
      FROM l1nea_template_styles

13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM l1nea_modules AS m 
      LEFT JOIN l1nea_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN l1nea_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

14. 1 × SELECT manifest_cache 
      FROM l1nea_extensions

INNE tabele:

1. 1 × INSERT INTO `l1nea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'386b6a7533356e386c706b626f386e306d303533653538363273', 1, 1716191400, 0, '', 0

2. 1 × UPDATE `l1nea_extensions` 
     SET `params` = '{\"mediaversion\":\"c00905546b06a164365ef2f23db0f053\"}'