Games Schedule View

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1716072761,
                "last": 1716072761,
                "now": 1716072761
            },
            "token": "1TnhiwQpjHBF0A41ryefODq7sNT5fiB6"
        },
        "registry": {
            "com_djleague": {
                "schedule": {
                    "limitstart": 60
                }
            }
        },
        "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
        }
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 1498.20 ms / 1498.20 ms Pamięć: 1.839 MB / 2.18 MB Application: afterLoad

Czas: 1691.06 ms / 3189.25 ms Pamięć: 3.845 MB / 6.02 MB Application: afterInitialise

Czas: 633.17 ms / 3822.42 ms Pamięć: 2.107 MB / 8.13 MB Application: afterRoute

Czas: 3.66 ms / 3826.09 ms Pamięć: 0.018 MB / 8.15 MB Application: beforeRenderComponent com_djleague

Czas: 510.43 ms / 4336.51 ms Pamięć: 1.582 MB / 9.73 MB Application: afterRenderComponent com_djleague

Czas: 18.20 ms / 4354.71 ms Pamięć: 0.005 MB / 9.74 MB Application: afterDispatch

Czas: 843.06 ms / 5197.77 ms Pamięć: 1.355 MB / 11.09 MB Application: beforeRenderModule mod_djleague_tables (Wyniki Ligi okręgowej 2017/2018)

Czas: 199.84 ms / 5397.61 ms Pamięć: 0.130 MB / 11.22 MB Application: afterRenderModule mod_djleague_tables (Wyniki Ligi okręgowej 2017/2018)

Czas: 0.37 ms / 5397.99 ms Pamięć: -0.012 MB / 11.21 MB Application: beforeRenderModule mod_djleague_tables (Wyniki Ligi okręgowej 2018/2019)

Czas: 6.54 ms / 5404.53 ms Pamięć: 0.041 MB / 11.25 MB Application: afterRenderModule mod_djleague_tables (Wyniki Ligi okręgowej 2018/2019)

Czas: 79.26 ms / 5483.79 ms Pamięć: 0.194 MB / 11.44 MB Application: beforeRenderModule mod_custom (Copyrights)

Czas: 121.91 ms / 5605.70 ms Pamięć: 0.006 MB / 11.45 MB Application: afterRenderModule mod_custom (Copyrights)

Czas: 0.23 ms / 5605.93 ms Pamięć: -0.001 MB / 11.45 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Czas: 250.32 ms / 5856.26 ms Pamięć: 0.032 MB / 11.48 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Czas: 0.34 ms / 5856.60 ms Pamięć: 0.008 MB / 11.49 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu)

Czas: 80.64 ms / 5937.24 ms Pamięć: 0.324 MB / 11.81 MB Application: beforeRenderModule all-in-one-accessibility (Accessibility_modul)

Czas: 784.26 ms / 6721.49 ms Pamięć: 0.008 MB / 11.82 MB Application: afterRenderModule all-in-one-accessibility (Accessibility_modul)

Czas: 66.74 ms / 6788.23 ms Pamięć: -0.045 MB / 11.78 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu)

Czas: 0.07 ms / 6788.30 ms Pamięć: -0.029 MB / 11.75 MB Application: beforeRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)

Czas: 2.78 ms / 6791.07 ms Pamięć: 0.006 MB / 11.75 MB Application: afterRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)

Czas: 0.08 ms / 6791.15 ms Pamięć: 0.012 MB / 11.76 MB Application: beforeRenderModule mod_pwebbox (Facebook)

Czas: 336.27 ms / 7127.42 ms Pamięć: 0.446 MB / 12.21 MB Application: afterRenderModule mod_pwebbox (Facebook)

Czas: 657.02 ms / 7784.45 ms Pamięć: 0.260 MB / 12.47 MB Application: afterRender

Ogółem zapytań do bazy danych: 85.57 ms

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

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.04 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.17 ms
preparing	0.02 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

#	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

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

#	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 `l1nea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'393267373470646c35676a3862676f636e35696731673164676f', 1, 1716072761, 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.02 ms
update	0.14 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.06 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
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: 1.53 ms Po ostatnim zapytaniu: 109.97 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 4.217 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.11 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.04 ms
Table lock	0.02 ms
After table lock	0.02 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.45 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.04 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.58 ms Po ostatnim zapytaniu: 42.27 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 4.479 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.14 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
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.47 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.491 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.05 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.02 ms
optimizing	0.02 ms
statistics	0.07 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]

Czas zapytania: 1.26 ms Po ostatnim zapytaniu: 2.02 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 4.561 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.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.44 ms
Sending data	0.32 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]

Czas zapytania: 2.99 ms Po ostatnim zapytaniu: 748.23 ms Pamięć zapytania: 0.088 MB Pamięć przed zapytaniem: 6.233 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.19 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 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.07 ms
optimizing	0.06 ms
statistics	0.16 ms
preparing	0.07 ms
executing	0.02 ms
Sorting result	0.71 ms
Sending data	1.28 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.04 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()	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: 1.27 ms Po ostatnim zapytaniu: 386.57 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 7.043 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.12 ms
checking permissions	0.03 ms
Opening tables	0.05 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.06 ms
optimizing	0.05 ms
statistics	0.18 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.12 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.05 ms
updating status	0.09 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: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]

Czas zapytania: 0.80 ms Po ostatnim zapytaniu: 0.57 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 7.036 MB

UPDATE `l1nea_extensions`

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

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

Objaśnienie

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 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.14 ms
Updating	0.17 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	0.07 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.02 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]

Czas zapytania: 1.29 ms Po ostatnim zapytaniu: 16.93 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 7.293 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.14 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 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.06 ms
optimizing	0.09 ms
statistics	0.17 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.20 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.02 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]

Czas zapytania: 1.42 ms Po ostatnim zapytaniu: 203.20 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 8.138 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.12 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.02 ms
After table lock	0.03 ms
init	0.09 ms
optimizing	0.06 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.02 ms
Sorting result	0.11 ms
Sending data	0.23 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.03 ms
updating status	0.08 ms
cleaning up	0.03 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: 3.07 ms Po ostatnim zapytaniu: 210.95 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 8.865 MB Zwróconych wierszy: 1

SELECT COUNT(*)

  FROM l1nea_djl_games AS a

  INNER JOIN l1nea_djl_teams as ht 
  ON ht.id=a.team_home

  INNER JOIN l1nea_djl_teams as at 
  ON at.id=a.team_away

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

  INNER JOIN l1nea_djl_leagues AS l 
  ON l.id=a.league_id

  LEFT JOIN l1nea_djl_tournaments AS tr 
  ON tr.id=l.tournament_id

  LEFT JOIN l1nea_djl_seasons AS se 
  ON se.id=l.season_id

  WHERE (a.team_home=17 OR a.team_away=17) 
  AND a.status!=-1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	10
1	SIMPLE	a	ref	league,league_id	league_id	4	novaprod24_grom.l.id	88	Using index condition; Using where
1	SIMPLE	at	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.team_away	1	Using index
1	SIMPLE	ht	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.team_home	1	Using index

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	2.33 ms
end	0.02 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:323
13	Joomla\CMS\MVC\Model\ListModel->getStart()	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/schedule/view.html.php:49
10	DJLeagueViewSchedule->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]

Czas zapytania: 47.68 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 8.865 MB Zwróconych wierszy: 20

SELECT a.*, uc.name AS editor, ht.name as home_name, ht.logo as home_logo, at.name as away_name, at.logo as away_logo,tr.name as tournament,se.name as season

  FROM l1nea_djl_games AS a

  INNER JOIN l1nea_djl_teams as ht 
  ON ht.id=a.team_home

  INNER JOIN l1nea_djl_teams as at 
  ON at.id=a.team_away

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

  INNER JOIN l1nea_djl_leagues AS l 
  ON l.id=a.league_id

  LEFT JOIN l1nea_djl_tournaments AS tr 
  ON tr.id=l.tournament_id

  LEFT JOIN l1nea_djl_seasons AS se 
  ON se.id=l.season_id

  WHERE (a.team_home=17 OR a.team_away=17) 
  AND a.status!=-1

  ORDER BY a.date desc 
  LIMIT 60, 20

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	10	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	tr	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.l.tournament_id	1
1	SIMPLE	se	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.l.season_id	1
1	SIMPLE	a	ref	league,league_id	league_id	4	novaprod24_grom.l.id	88	Using index condition; Using where
1	SIMPLE	at	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.team_away	1
1	SIMPLE	ht	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.team_home	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	novaprod24_grom.a.checked_out	1

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 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.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.35 ms
Copying to tmp table	45.84 ms
Sorting result	0.16 ms
Sending data	0.28 ms
end	0.01 ms
removing tmp table	0.18 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.06 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/schedule/view.html.php:49
10	DJLeagueViewSchedule->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]

Czas zapytania: 0.81 ms Po ostatnim zapytaniu: 329.32 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.019 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.07 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.04 ms
init	0.07 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.05 ms
cleaning up	0.02 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]

Czas zapytania: 6.06 ms Po ostatnim zapytaniu: 133.24 ms Pamięć zapytania: 0.072 MB Pamięć przed zapytaniem: 11.007 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-18 22:52:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-18 22:52:44') 
  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.27 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 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.11 ms
optimizing	0.11 ms
statistics	0.19 ms
preparing	0.12 ms
executing	0.02 ms
Sorting result	1.21 ms
Sending data	3.45 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.04 ms
updating status	0.05 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]

Czas zapytania: 0.90 ms Po ostatnim zapytaniu: 687.39 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 11.130 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.11 ms
checking permissions	0.02 ms
Opening tables	0.03 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.06 ms
optimizing	0.05 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 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: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]

Czas zapytania: 0.79 ms Po ostatnim zapytaniu: 46.73 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 11.177 MB Zwróconych wierszy: 1

Duplikaty zapytań: #17

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.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.04 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.04 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 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]

Czas zapytania: 8.32 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 11.192 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.29 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.05 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.19 ms
optimizing	0.02 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.06 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.02 ms
Creating tmp table	0.07 ms
Copying to tmp table	0.09 ms
executing	0.02 ms
Sending data	1.58 ms
executing	0.02 ms
Sending data	1.45 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.88 ms
removing tmp table	0.02 ms
Sending data	2.26 ms
Sorting result	0.06 ms
Sending data	0.13 ms
end	0.02 ms
removing tmp table	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.02 ms
closing tables	0.03 ms
freeing items	0.06 ms
updating status	0.06 ms
cleaning up	0.02 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]

Czas zapytania: 0.88 ms Po ostatnim zapytaniu: 98.83 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 11.232 MB Zwróconych wierszy: 0

Duplikaty zapytań: #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.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.01 ms
After table lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.13 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: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]

Czas zapytania: 0.68 ms Po ostatnim zapytaniu: 0.50 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 11.243 MB Zwróconych wierszy: 0

Duplikaty zapytań: #20

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.05 ms
checking permissions	0.02 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.02 ms
init	0.04 ms
optimizing	0.06 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 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.04 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]

Czas zapytania: 1.90 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 11.258 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.22 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.06 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.21 ms
optimizing	0.02 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.05 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.07 ms
statistics	0.09 ms
preparing	0.07 ms
executing	0.02 ms
Creating tmp table	0.07 ms
Copying to tmp table	0.07 ms
Sorting result	0.04 ms
Sending data	0.05 ms
end	0.02 ms
removing tmp table	0.02 ms
end	0.02 ms
removing tmp table	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.02 ms
closing tables	0.03 ms
freeing items	0.04 ms
updating status	0.08 ms
cleaning up	0.02 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]

Czas zapytania: 0.91 ms Po ostatnim zapytaniu: 532.01 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 11.784 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.08 ms
checking permissions	0.02 ms
Opening tables	0.03 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.04 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.04 ms
executing	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.05 ms
cleaning up	0.04 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]

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

WYBRANE tabele:

4 × SELECT * 
  FROM l1nea_djl_leagues

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

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

1 × SELECT `data` 
  FROM `l1nea_session`

1 × SELECT `session_id` 
  FROM `l1nea_session`

1 × SELECT id, rules 
  FROM `l1nea_viewlevels

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

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

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

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

```
1 × SELECT * 
  FROM l1nea_languages
```

1 × SELECT COUNT(*) 
  FROM l1nea_djl_games AS a 
  INNER JOIN l1nea_djl_teams as ht 
  ON ht.id=a.team_home 
  INNER JOIN l1nea_djl_teams as at 
  ON at.id=a.team_away 
  LEFT JOIN l1nea_users AS uc 
  ON uc.id=a.checked_out 
  INNER JOIN l1nea_djl_leagues AS l 
  ON l.id=a.league_id 
  LEFT JOIN l1nea_djl_tournaments AS tr 
  ON tr.id=l.tournament_id 
  LEFT JOIN l1nea_djl_seasons AS se 
  ON se.id=l.season_id

1 × SELECT a.*, uc.name AS editor, ht.name as home_name, ht.logo as home_logo, at.name as away_name, at.logo as away_logo,tr.name as tournament,se.name as season 
  FROM l1nea_djl_games AS a 
  INNER JOIN l1nea_djl_teams as ht 
  ON ht.id=a.team_home 
  INNER JOIN l1nea_djl_teams as at 
  ON at.id=a.team_away 
  LEFT JOIN l1nea_users AS uc 
  ON uc.id=a.checked_out 
  INNER JOIN l1nea_djl_leagues AS l 
  ON l.id=a.league_id 
  LEFT JOIN l1nea_djl_tournaments AS tr 
  ON tr.id=l.tournament_id 
  LEFT JOIN l1nea_djl_seasons AS se 
  ON se.id=l.season_id

1 × SELECT id 
  FROM l1nea_template_styles

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

1 × SELECT manifest_cache 
  FROM l1nea_extensions

INNE tabele:

1 × INSERT INTO `l1nea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'393267373470646c35676a3862676f636e35696731673164676f', 1, 1716072761, 0, '', 0

1 × UPDATE `l1nea_extensions` 
  SET `params` = '{\"mediaversion\":\"a615200be313bf2f5912e07908361e76\"}'

środa, 29 sierpień 2018
22:21	Piast Piastów	1 : 2	Grom Warszawa	Piastów , Piast Piastów
22:21		Piastów , Piast Piastów
sobota, 25 sierpień 2018
22:32	Grom Warszawa	2 : 2	Laura Chylice	Warszawa , Grom Warszawa
22:32		Warszawa , Grom Warszawa
sobota, 18 sierpień 2018
22:29	LKS Chlebnia	0 : 4	Grom Warszawa	Chlebnia , LKS Chlebnia
22:29		Chlebnia , LKS Chlebnia
środa, 15 sierpień 2018
22:25	Grom Warszawa	5 : 0	LKS Osuchów	Warszawa , Grom Warszawa
22:25		Warszawa , Grom Warszawa
sobota, 16 czerwiec 2018
23:42	Naprzód Stare Babice	3 : 2	Grom Warszawa	Stare Babice , Stare Babice
23:42		Stare Babice , Stare Babice
sobota, 9 czerwiec 2018
23:41	Grom Warszawa	3 : 0	SEMP Ursynów Warszawa	Warszawa , Grom Warszawa
23:41		Warszawa , Grom Warszawa
niedziela, 3 czerwiec 2018
22:45	Błękitni Korytów	2 : 1	Grom Warszawa	Korytów , Korytów
22:45		Korytów , Korytów
sobota, 26 maj 2018
22:38	Grom Warszawa	3 : 0	Piast Piastów	Warszawa , Grom Warszawa
22:38		Warszawa , Grom Warszawa
środa, 23 maj 2018
10:59	Przyszłość Włochy	0 : 4	Grom Warszawa	W-wa Włochy , Przyszłość Włochy
10:59		W-wa Włochy , Przyszłość Włochy
sobota, 19 maj 2018
13:19	Grom Warszawa	3 : 0	Sparta II Jazgarzew	Warszawa , Grom Warszawa
13:19		Warszawa , Grom Warszawa
sobota, 12 maj 2018
14:55	LKS Chlebnia	2 : 4	Grom Warszawa	Chlebnia , LKS Chlebnia
14:55		Chlebnia , LKS Chlebnia
sobota, 5 maj 2018
14:13	Grom Warszawa	1 : 2	Pogoń Grodzisk Mazowiecki	Warszawa , Grom Warszawa
14:13		Warszawa , Grom Warszawa
piątek, 27 kwiecień 2018
12:44	KS Raszyn	5 : 1	Grom Warszawa	KS Raszyn , Raszyn
12:44		KS Raszyn , Raszyn
sobota, 21 kwiecień 2018
11:33	Grom Warszawa	8 : 0	KS Konstancin	Warszawa , Grom Warszawa
11:33		Warszawa , Grom Warszawa
sobota, 14 kwiecień 2018
18:03	Józefovia Józefów	1 : 1	Grom Warszawa	Józefów , Jozefow
18:03		Józefów , Jozefow
środa, 11 kwiecień 2018
15:46	AP Żyrardów	4 : 2	Grom Warszawa	Żyrardów , AP Żyrardów
15:46		Żyrardów , AP Żyrardów
sobota, 7 kwiecień 2018
13:37	Grom Warszawa	2 : 1	Naprzód Brwinów	Warszawa , Grom Warszawa
13:37		Warszawa , Grom Warszawa
piątek, 30 marzec 2018
22:17	Grom Warszawa	3 : 2	KS Teresin	Warszawa , Grom Warszawa
22:17		Warszawa , Grom Warszawa
niedziela, 25 marzec 2018
15:52	Ursus Warszawa	2 : 2	Grom Warszawa	Warszawa , Ursus Warszawa
15:52		Warszawa , Ursus Warszawa
sobota, 11 listopad 2017
11:00	Grom Warszawa	6 : 0	Naprzód Stare Babice	Warszawa , Grom Warszawa
11:00		Warszawa , Grom Warszawa

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

23 zapytań zarejestrowanych 85.57 ms

4 znalezionych duplikatów!

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

WYBRANE tabele:

INNE tabele: