Biuletyn Informacji Publicznej BOS

Archiwum BIP

Tytuł	Wytworzony	Autor	Odsłony
Zapytanie ofertowe na wykonanie w 2020 r. poboru i badania wody w zakresie chemicznym, mikrobiologicznym i na obecność Legionelli z pływalni Białołęckiego Ośrodka Sportu w Warszawie przy ul. Światowida 56, oraz na obecność Legionelli z instalacji ciepłej	02-01-2020	Udostępniony i zatwierdzony przez: Adam Białapko	Odsłon: 519
Zapytanie ofertowe: Świadczenie usług z zakresu organizowania i nadzorowania przebiegu działań związanych z bezpieczeństwem i higieną pracy w Białołęckim Ośrodku Sportu.	30-11--0001	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 566
Zapytanie ofertowe: Dostawa fabrycznie nowych środków czystości i produktów toaletowych do Białołęckiego Ośrodka Sportu w Warszawie przy ul. Światowida 56 i ul. Strumykowej 21 w 2022 roku.	30-11--0001	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 438
Zapytanie ofertowe na prowadzenie zajęć sportowo – rekreacyjnych na pływalni Białołęckiego Ośrodka Sportu w ramach programu „Senior starszy sprawniejszy 2022 r.	11-01-2022	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 636
Zapytanie ofertowe na prowadzenie zajęć w Białołęckim Ośrodku Sportu w 2022 roku	03-01-2022	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 1036
Zapytanie ofertowe: Dostawa 15 tys. litrów oleju opałowego odpowiadającego wymaganiom jakościowym wg Polskiej Normy PN-C-96024 gatunek L1 do obiektów Białołęckiego Ośrodka Sportu.	10-12-2021	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 870
Zapytanie ofertowe: Dostawa artykułów biurowych do Białołęckiego Ośrodka Sportu w Warszawie przy ul. Światowida 56	19-11-2021	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 760
Zapytanie ofertowe: Dzierżawa sztucznego lodowiska z dwoma kontenerami oraz urządzeniami technicznymi wraz z wyposażeniem, w sezonie zimowym 2021/2022 na obiekcie sportowym przy ul. Strumykowej 21 w Warszawie	08-11-2021	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 601
Zapytanie ofertowe: Wykonanie usługi rozłożenia i przygotowania do użytkowania w sezonie 2021/2022 sztucznego lodowiska, a także przeprowadzenie przeglądów konserwacyjnych rolby WM 1700 MINI, agregatu mrożącego Blue Box Zeta ECHOS i instalacji mrożącej	21-09-2021	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 898
Zapytanie ofertowe: Prowadzenie zajęć aqua aerobiku na pływalni / prowadzenie zajęć sportowo – rekreacyjnych na pływalni Białołęckiego Ośrodka Sportu w ramach programu „Senior starszy sprawniejszy 2021”.	18-02-2021	Udostępniony i zatwierdzony przez: Michał Jankowski	Odsłon: 1253

Strona 1 z 9

start
Poprzedni artykuł
1
2
3
4
...
6
7
8
9

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1752222181,
                "last": 1752222181,
                "now": 1752222181
            },
            "client": {
                "forwarded": "216.73.216.209"
            },
            "token": "qYJFBphiUzJR9tPq8AjKGkicm5oPUsh0"
        },
        "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
        }
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 10.27 ms / 10.27 ms Pamięć: 1.633 MB / 1.98 MB Application: afterLoad

Czas: 62.38 ms / 72.64 ms Pamięć: 7.333 MB / 9.31 MB Application: afterInitialise

Czas: 11.03 ms / 83.67 ms Pamięć: 1.546 MB / 10.85 MB Application: afterRoute

Czas: 0.30 ms / 83.97 ms Pamięć: 0.041 MB / 10.90 MB Application: beforeRenderComponent com_govarticle

Czas: 4.89 ms / 88.86 ms Pamięć: 0.837 MB / 11.73 MB Application: Before Access::preloadComponents (all components)

Czas: 1.93 ms / 90.79 ms Pamięć: 0.056 MB / 11.79 MB Application: After Access::preloadComponents (all components)

Czas: 0.01 ms / 90.80 ms Pamięć: -0.004 MB / 11.78 MB Application: Before Access::preloadPermissions (com_govarticle)

Czas: 2.26 ms / 93.06 ms Pamięć: 0.214 MB / 12.00 MB Application: After Access::preloadPermissions (com_govarticle)

Czas: 0.02 ms / 93.08 ms Pamięć: -0.011 MB / 11.99 MB Application: Before Access::getAssetRules (id:791 name:com_govarticle.category.116)

Czas: 0.28 ms / 93.36 ms Pamięć: 0.029 MB / 12.02 MB Application: After Access::getAssetRules (id:791 name:com_govarticle.category.116)

Czas: 6.81 ms / 100.17 ms Pamięć: 0.470 MB / 12.49 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Czas: 0.01 ms / 100.18 ms Pamięć: 0.002 MB / 12.49 MB Application: After Access::getAssetRules (id:1 name:root.1)

Czas: 148.89 ms / 249.07 ms Pamięć: 4.020 MB / 16.51 MB Application: afterRenderComponent com_govarticle

Czas: 0.23 ms / 249.30 ms Pamięć: 0.005 MB / 16.51 MB Application: afterDispatch

Czas: 15.06 ms / 264.36 ms Pamięć: 1.214 MB / 17.73 MB Application: beforeRenderModule mod_menu (Menu serwisu)

Czas: 3.32 ms / 267.68 ms Pamięć: 0.336 MB / 18.06 MB Application: afterRenderModule mod_menu (Menu serwisu)

Czas: 0.29 ms / 267.98 ms Pamięć: -0.004 MB / 18.06 MB Application: beforeRenderModule mod_custom (Biuletyn Informacji Publicznej)

Czas: 0.23 ms / 268.20 ms Pamięć: 0.008 MB / 18.07 MB Application: afterRenderModule mod_custom (Biuletyn Informacji Publicznej)

Czas: 0.12 ms / 268.32 ms Pamięć: -0.017 MB / 18.05 MB Application: beforeRenderModule mod_govarticle_category (Popularne w BIP)

Czas: 20.64 ms / 288.96 ms Pamięć: 1.282 MB / 19.33 MB Application: afterRenderModule mod_govarticle_category (Popularne w BIP)

Czas: 0.05 ms / 289.01 ms Pamięć: -0.072 MB / 19.26 MB Application: beforeRenderModule mod_govarticle_category (Niedawno dodane)

Czas: 0.45 ms / 289.46 ms Pamięć: 0.082 MB / 19.34 MB Application: afterRenderModule mod_govarticle_category (Niedawno dodane)

Czas: 0.15 ms / 289.61 ms Pamięć: -0.058 MB / 19.28 MB Application: beforeRenderModule mod_custom (EPUAP)

Czas: 0.13 ms / 289.74 ms Pamięć: 0.003 MB / 19.29 MB Application: afterRenderModule mod_custom (EPUAP)

Czas: 1.63 ms / 291.38 ms Pamięć: -0.002 MB / 19.28 MB Application: beforeRenderModule mod_custom (Prawa autorskie)

Czas: 0.12 ms / 291.49 ms Pamięć: 0.004 MB / 19.29 MB Application: afterRenderModule mod_custom (Prawa autorskie)

Czas: 0.22 ms / 291.72 ms Pamięć: 0.003 MB / 19.29 MB Application: beforeRenderModule mod_breadcrumbs (Ścieżka powrotu)

Czas: 0.50 ms / 292.21 ms Pamięć: 0.023 MB / 19.31 MB Application: afterRenderModule mod_breadcrumbs (Ścieżka powrotu)

Czas: 0.23 ms / 292.45 ms Pamięć: 0.011 MB / 19.32 MB Application: beforeRenderModule mod_djmegamenu (Menu narzędziowe)

Czas: 1.21 ms / 293.66 ms Pamięć: 0.190 MB / 19.51 MB Application: beforeRenderModule mod_djmegamenu (DJ Menu witryny)

Czas: 2.80 ms / 296.45 ms Pamięć: 0.038 MB / 19.55 MB Application: afterRenderModule mod_djmegamenu (DJ Menu witryny)

Czas: 0.74 ms / 297.20 ms Pamięć: -0.096 MB / 19.46 MB Application: afterRenderModule mod_djmegamenu (Menu narzędziowe)

Czas: 0.11 ms / 297.31 ms Pamięć: -0.048 MB / 19.41 MB Application: beforeRenderModule mod_syndicate (RSS Moduł)

Czas: 0.27 ms / 297.58 ms Pamięć: 0.013 MB / 19.42 MB Application: afterRenderModule mod_syndicate (RSS Moduł)

Czas: 0.14 ms / 297.72 ms Pamięć: 0.021 MB / 19.44 MB Application: beforeRenderModule mod_search (Wyszukiwarka)

Czas: 0.51 ms / 298.23 ms Pamięć: 0.019 MB / 19.46 MB Application: afterRenderModule mod_search (Wyszukiwarka)

Czas: 0.22 ms / 298.44 ms Pamięć: -0.006 MB / 19.45 MB Application: beforeRenderModule mod_menu (Menu Skocz do)

Czas: 0.53 ms / 298.98 ms Pamięć: 0.007 MB / 19.46 MB Application: afterRenderModule mod_menu (Menu Skocz do)

Czas: 1.54 ms / 300.52 ms Pamięć: 0.122 MB / 19.58 MB Application: afterRender

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	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:856
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:414
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 `wpjtx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6361333431663237376665346565613266326464316436393764316633303066', 1, 1752222181, 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.13 ms
end	0.00 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 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:856
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 0.49 ms Po ostatnim zapytaniu: 3.85 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.447 MB Zwróconych wierszy: 5

SELECT id, rules

  FROM `wpjtx_viewlevels`

Objaśnienie

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 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.58 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.459 MB Zwróconych wierszy: 2

SELECT b.id

  FROM wpjtx_usergroups AS a

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

  WHERE a.id = 9

Objaśnienie

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	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: 0.64 ms Po ostatnim zapytaniu: 9.64 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 6.060 MB Zwróconych wierszy: 1

SELECT `value`

  FROM `wpjtx_admintools_storage`

  WHERE `key` = 'cparams'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_admintools_storage	NULL	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:874
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.50 ms Po ostatnim zapytaniu: 1.67 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 6.358 MB Zwróconych wierszy: 0

SELECT *

  FROM `wpjtx_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 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:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:592
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:503
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:883
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.73 ms Po ostatnim zapytaniu: 12.31 ms Pamięć zapytania: 0.010 MB Pamięć przed zapytaniem: 8.265 MB

UPDATE `wpjtx_extensions`

  SET `params` = '{\"mediaversion\":\"0081ca78b62d02527961e48021162eaf\"}'

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	wpjtx_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.03 ms
System lock	0.13 ms
updating	0.10 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
20	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
19	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
18	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
17	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
16	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
15	Joomla\CMS\HTML\HTMLHelper::script()	Identyczny z wywołaniem linii niżej.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Identyczny z wywołaniem linii niżej.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/adminbrandingreloaded/adminbrandingreloaded.php:17
7	require_once JROOT/plugins/system/adminbrandingreloaded/adminbrandingreloaded.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.70 ms Po ostatnim zapytaniu: 7.07 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 9.148 MB Zwróconych wierszy: 1

SHOW VARIABLES LIKE "collation_database"

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.00 ms
Sending data	2.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:345
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 9.156 MB Zwróconych wierszy: 0

SELECT *

  FROM `wpjtx_admintools_ipautoban`

  WHERE `ip` = '216.73.216.209'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.31 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 9.162 MB Zwróconych wierszy: 1

SELECT *

  FROM `wpjtx_admintools_storage`

  WHERE `key` LIKE 'timestamp_%'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_admintools_storage	NULL	range	PRIMARY	PRIMARY	402	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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:1506
13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:269
12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:349
11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:113
10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `word`

  FROM `wpjtx_admintools_badwords`

  GROUP BY `word`

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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:1550
11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/badwords.php:48
10	AtsystemFeatureBadwords->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.37 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 9.186 MB Zwróconych wierszy: 0

SELECT `source`,`keepurlparams`

  FROM `wpjtx_admintools_redirects`

  WHERE ((`dest` = 'archiwum-bip') OR (`dest` = 'archiwum-bip?width=fixed') OR ('archiwum-bip?width=fixed' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.64 ms Po ostatnim zapytaniu: 5.83 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.057 MB Zwróconych wierszy: 1

SELECT *

  FROM `wpjtx_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_govarticle') 
  AND `view` IN('','category') 
  AND `task` IN('','category.') 
  AND `enabled` = '1'

  GROUP BY `query`

  ORDER BY `query` ASC

Objaśnienie

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.07 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 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/plugins/system/admintools/feature/wafblacklist.php:87
10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:753
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:145
8	plgSystemAdmintools->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:1218
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.81 ms Po ostatnim zapytaniu: 10.48 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 11.736 MB Zwróconych wierszy: 38

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

  FROM `wpjtx_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_govarticle','com_installer','com_jce','com_jifile','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	41	100.00	Using index condition

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.27 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.81 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	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/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/category.php:148
14	GovArticleModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 2.02 ms Po ostatnim zapytaniu: 0.11 ms Pamięć zapytania: 0.045 MB Pamięć przed zapytaniem: 11.785 MB Zwróconych wierszy: 251

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

  FROM `wpjtx_assets`

  WHERE `name` LIKE 'com_govarticle.%' OR `name` = 'com_govarticle' OR `parent_id` = 0

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_assets	NULL	ALL	idx_asset_name,idx_parent_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	998	20.13	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.59 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	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/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/category.php:148
14	GovArticleModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 2.74 ms Po ostatnim zapytaniu: 1.22 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 12.071 MB Zwróconych wierszy: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `wpjtx_govarticle` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `wpjtx_categories` AS `s`

  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_govarticle' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 116

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	14	18.49	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	02129658_0000005.c.id	13	96.85	Using index condition; Using where

Profile

Status	Duration
starting	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.39 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.04 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.10 ms
executing	0.00 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	1.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/models/category.php:364
14	GovArticleModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.78 ms Po ostatnim zapytaniu: 1.92 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 12.458 MB Zwróconych wierszy: 8

SHOW FULL COLUMNS 
  FROM `wpjtx_assets`

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `wpjtx_assets`

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
23	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/articles.php:457
18	GovArticleModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_govarticle/models/articles.php:545
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.30 ms Po ostatnim zapytaniu: 0.30 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 12.498 MB Zwróconych wierszy: 0

Duplikaty zapytań: #20 #51 #52

SELECT *

  FROM wpjtx_assets

  WHERE `name` = 'com_govarticle'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/articles.php:457
18	GovArticleModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_govarticle/models/articles.php:545
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.25 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 12.511 MB Zwróconych wierszy: 0

Duplikaty zapytań: #19 #51 #52

SELECT *

  FROM wpjtx_assets

  WHERE `name` = 'com_govarticle'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/articles.php:457
18	GovArticleModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_govarticle/models/articles.php:545
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 9.11 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.049 MB Pamięć przed zapytaniem: 12.500 MB Zwróconych wierszy: 10

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,a.produced_by, a.produced_by_position,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM wpjtx_govarticle AS a

  LEFT JOIN wpjtx_govarticle_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN wpjtx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN wpjtx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN wpjtx_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN wpjtx_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN wpjtx_govarticle_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM wpjtx_categories AS cat JOIN wpjtx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_govarticle' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 116 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-11 08:23:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-11 08:23:01')

  ORDER BY    
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 10

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_catid	idx_catid	4	const	107	16.00	Using where
1	PRIMARY	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.id	1	100.00	Using index
1	PRIMARY	ua	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using where; Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	33.61	Using where; Using temporary; Uruchomiono metodę filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	119	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.38 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.53 ms
init	0.25 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.04 ms
statistics	0.23 ms
preparing	0.08 ms
Creating tmp table	0.10 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	2.55 ms
executing	0.00 ms
Sending data	1.58 ms
Creating sort index	2.21 ms
Creating sort index	0.48 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.10 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.07 ms
freeing items	0.06 ms
cleaning up	0.03 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/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_govarticle/models/articles.php:545
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.83 ms Po ostatnim zapytaniu: 1.12 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.729 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 229 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.50 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.751 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 288 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.49 ms Po ostatnim zapytaniu: 0.11 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.772 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 287 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.42 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.793 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 285 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.50 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.815 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 283 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.836 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 282 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.44 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.858 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 281 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.42 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.879 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 280 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.42 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.901 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 276 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 12.922 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 271 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
16	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
15	GovArticleModelArticles->getItems()	JROOT/components/com_govarticle/models/category.php:263
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 4.42 ms Po ostatnim zapytaniu: 0.75 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 13.098 MB Zwróconych wierszy: 1

SELECT COUNT(*)

  FROM wpjtx_govarticle AS a

  LEFT JOIN wpjtx_govarticle_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN wpjtx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN wpjtx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN wpjtx_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN wpjtx_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN wpjtx_govarticle_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM wpjtx_categories AS cat JOIN wpjtx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_govarticle' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 116 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-11 08:23:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-11 08:23:01')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	a	NULL	ref	idx_access,idx_catid	idx_catid	4	const	107	16.00	Using where
1	PRIMARY	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.id	1	100.00	Using index
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.id	1	100.00	Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using where; Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	33.61	Using where; Using temporary; Uruchomiono metodę filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	119	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:284
16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:234
15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_govarticle/models/category.php:275
14	GovArticleModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.54 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 13.106 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.category' 
  AND `m`.`content_item_id` = 116 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 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/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_govarticle/views/category/view.html.php:77
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.98 ms Po ostatnim zapytaniu: 3.18 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 13.530 MB Zwróconych wierszy: 1

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `wpjtx_categories` AS `s`

  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 116

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	14	19.33	Using index condition; Using where

Profile

Status	Duration
starting	0.18 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.22 ms
preparing	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 7.96 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.101 MB Pamięć przed zapytaniem: 13.542 MB Zwróconych wierszy: 91

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

  FROM wpjtx_fields AS a

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

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

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

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

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

  LEFT JOIN `wpjtx_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (116,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idx_state,idx_access,idx_context	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	97	93.81	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	l	NULL	ALL	idx_langcode	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uc	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	02129658_0000005.a.id	1	100.00	Using where; Using index; Distinct

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.51 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.23 ms
preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	5.07 ms
Creating sort index	1.24 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.37 ms Po ostatnim zapytaniu: 2.39 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 14.187 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '229'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	3	49.74	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.74 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.29 ms Po ostatnim zapytaniu: 12.74 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 14.676 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '288'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	3	49.74	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.73 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.25 ms Po ostatnim zapytaniu: 8.65 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 14.815 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '287'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	1	49.74	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.73 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.30 ms Po ostatnim zapytaniu: 8.54 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 14.955 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '285'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	3	49.74	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.79 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.22 ms Po ostatnim zapytaniu: 8.71 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 15.095 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '283'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	3	49.74	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.78 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.22 ms Po ostatnim zapytaniu: 8.62 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 15.234 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '282'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	3	49.74	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.79 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.24 ms Po ostatnim zapytaniu: 8.71 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 15.390 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '281'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	3	49.74	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.76 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.14 ms Po ostatnim zapytaniu: 8.64 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 15.529 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '280'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	1	49.74	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.71 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.17 ms Po ostatnim zapytaniu: 8.53 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 15.669 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '276'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	1	49.74	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.71 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.24 ms Po ostatnim zapytaniu: 8.79 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 15.809 MB Zwróconych wierszy: 0

SELECT `field_id`,`value`

  FROM `wpjtx_fields_values`

  WHERE `field_id` IN (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,79,80,81,82,83,84,85,86,88,92,93,94,95,96,97) 
  AND `item_id` = '271'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	3	49.74	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.73 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_govarticle/views/category/view.html.php:111
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.58 ms Po ostatnim zapytaniu: 10.70 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 16.177 MB Zwróconych wierszy: 0

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

  FROM wpjtx_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_govarticle.category.title' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	93.81	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	02129658_0000005.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.24 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.25 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.31 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
29	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
28	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
27	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
26	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
25	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
24	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
23	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
22	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
21	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
20	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
19	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/govarticle/category_default.php:41
18	include JROOT/layouts/govarticle/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
17	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
16	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_govarticle/views/category/tmpl/default.php:25
15	include JROOT/components/com_govarticle/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_govarticle/views/category/view.html.php:263
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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: 1.11 ms Po ostatnim zapytaniu: 2.45 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 16.496 MB Zwróconych wierszy: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `wpjtx_categories` AS `s`

  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_govarticle' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 116

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	14	18.49	Using index condition; Using where

Profile

Status	Duration
starting	0.21 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.22 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/helpers/route.php:49
21	GovArticleHelperRoute::getArticleRoute()	JROOT/components/com_govarticle/views/category/tmpl/default_articles.php:133
20	include JROOT/components/com_govarticle/views/category/tmpl/default_articles.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/layouts/govarticle/category_default.php:58
18	include JROOT/layouts/govarticle/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
17	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
16	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_govarticle/views/category/tmpl/default.php:25
15	include JROOT/components/com_govarticle/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_govarticle/views/category/view.html.php:263
11	GovArticleViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_govarticle/controller.php:111
8	GovArticleController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_govarticle/govarticle.php:21
6	require_once JROOT/components/com_govarticle/govarticle.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.72 ms Po ostatnim zapytaniu: 6.79 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 16.670 MB Zwróconych wierszy: 6

SELECT id 
  FROM wpjtx_template_styles 
  ORDER BY id

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_template_styles	NULL	index	NULL	PRIMARY	4	NULL	6	100.00	Using index

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	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/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/pcj-kds/index.php:18
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.64 ms Po ostatnim zapytaniu: 5.92 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 17.667 MB Zwróconych wierszy: 12

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM wpjtx_modules AS m

  LEFT JOIN wpjtx_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN wpjtx_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 <= '2025-07-11 08:23:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-07-11 08:23:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 327 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	44	2.27	Using where; Uruchomiono metodę filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	02129658_0000005.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	02129658_0000005.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.56 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	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()	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:591
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/pcj-kds/index.php:18
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.86 ms Po ostatnim zapytaniu: 7.15 ms Pamięć zapytania: 0.036 MB Pamięć przed zapytaniem: 18.283 MB Zwróconych wierszy: 11

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `wpjtx_govarticle` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `wpjtx_categories` AS `s`

  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_govarticle' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 9

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Uruchomiono metodę filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	8.54	Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	02129658_0000005.c.id	13	96.85	Using index condition; Using where

Profile

Status	Duration
starting	0.28 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.22 ms
preparing	0.03 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.28 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.09 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/models/categories.php:120
21	GovArticleModelCategories->getItems()	JROOT/modules/mod_govarticle_category/helper.php:122
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.29 ms Po ostatnim zapytaniu: 0.45 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 18.384 MB Zwróconych wierszy: 0

Duplikaty zapytań: #19 #20 #52

SELECT *

  FROM wpjtx_assets

  WHERE `name` = 'com_govarticle'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
30	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
29	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
28	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
27	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
26	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
25	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/articles.php:457
24	GovArticleModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
23	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_govarticle/models/articles.php:545
21	GovArticleModelArticles->getItems()	JROOT/modules/mod_govarticle_category/helper.php:174
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.23 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 18.398 MB Zwróconych wierszy: 0

Duplikaty zapytań: #19 #20 #51

SELECT *

  FROM wpjtx_assets

  WHERE `name` = 'com_govarticle'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
30	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
29	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
28	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
27	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
26	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
25	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/articles.php:457
24	GovArticleModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
23	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_govarticle/models/articles.php:545
21	GovArticleModelArticles->getItems()	JROOT/modules/mod_govarticle_category/helper.php:174
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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: 5.65 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.047 MB Pamięć przed zapytaniem: 18.390 MB Zwróconych wierszy: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,a.produced_by, a.produced_by_position,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM wpjtx_govarticle AS a

  LEFT JOIN wpjtx_govarticle_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN wpjtx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN wpjtx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN wpjtx_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN wpjtx_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN wpjtx_govarticle_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM wpjtx_categories AS cat JOIN wpjtx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_govarticle' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (9,10,11,15,17,16,32,48,34,33) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-11 08:23:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-11 08:23:01')

  ORDER BY a.hits DESC 
  LIMIT 3

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	range	idx_access,idx_catid	idx_catid	4	NULL	21	16.00	Using index condition; Using where; Using temporary; Uruchomiono metodę filesort
1	PRIMARY	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.id	1	100.00	Using index
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	02129658_0000005.a.catid	1	100.00	Using where
1	PRIMARY	ua	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.c.parent_id	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	02129658_0000005.c.id	10	100.00	Using where; Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	33.61	Using where; Using temporary; Uruchomiono metodę filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	119	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.44 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.27 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.04 ms
statistics	0.26 ms
preparing	0.08 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.95 ms
executing	0.00 ms
Sending data	1.60 ms
Creating sort index	0.87 ms
Creating sort index	0.32 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.06 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_govarticle/models/articles.php:545
21	GovArticleModelArticles->getItems()	JROOT/modules/mod_govarticle_category/helper.php:174
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.52 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 18.444 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 129 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
22	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
21	GovArticleModelArticles->getItems()	JROOT/modules/mod_govarticle_category/helper.php:174
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 18.469 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 128 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
22	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
21	GovArticleModelArticles->getItems()	JROOT/modules/mod_govarticle_category/helper.php:174
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.48 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 18.494 MB Zwróconych wierszy: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `wpjtx_contentitem_tag_map` AS m 

  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_govarticle.article' 
  AND `m`.`content_item_id` = 132 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	02129658_0000005.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
22	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/models/articles.php:671
21	GovArticleModelArticles->getItems()	JROOT/modules/mod_govarticle_category/helper.php:174
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.08 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 18.505 MB Zwróconych wierszy: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `wpjtx_categories` AS `s`

  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_govarticle' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 16

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Uruchomiono metodę filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	4.66	Using where

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.33 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/helpers/route.php:49
21	GovArticleHelperRoute::getArticleRoute()	JROOT/modules/mod_govarticle_category/helper.php:203
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.31 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 18.533 MB Zwróconych wierszy: 0

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

  FROM wpjtx_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	93.81	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	02129658_0000005.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.05 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
31	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
30	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
29	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
28	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
27	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
24	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
23	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
22	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
21	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_govarticle_category/helper.php:238
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.15 ms Po ostatnim zapytaniu: 0.36 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 18.580 MB Zwróconych wierszy: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `wpjtx_categories` AS `s`

  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_govarticle' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 17

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Uruchomiono metodę filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	4.51	Using where

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.21 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.34 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/helpers/route.php:49
21	GovArticleHelperRoute::getArticleRoute()	JROOT/modules/mod_govarticle_category/helper.php:203
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.13 ms Po ostatnim zapytaniu: 3.05 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 19.361 MB Zwróconych wierszy: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `wpjtx_categories` AS `s`

  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_govarticle' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 33

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Uruchomiono metodę filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	8.54	Using where

Profile

Status	Duration
starting	0.18 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.21 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.32 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/helpers/route.php:49
21	GovArticleHelperRoute::getArticleRoute()	JROOT/modules/mod_govarticle_category/helper.php:203
20	ModGovArticleCategoryHelper::getList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_govarticle_category/mod_govarticle_category.php:66
16	include JROOT/modules/mod_govarticle_category/mod_govarticle_category.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/pcj-kds/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-kds/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-kds/tpl/default.php:160
10	include JROOT/templates/pcj-kds/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/pcj-kds/index.php:19
7	require JROOT/templates/pcj-kds/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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]

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

WYBRANE tabele:

14 × SELECT `m`.`tag_id`,`t`.* 
  FROM `wpjtx_contentitem_tag_map` AS m  
  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

10 × SELECT `field_id`,`value` 
  FROM `wpjtx_fields_values`

5 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `wpjtx_categories` AS `s` 
  INNER JOIN `wpjtx_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

```
4 × SELECT * 
  FROM wpjtx_assets
```

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `wpjtx_assets`

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) 
  FROM `wpjtx_govarticle` AS `i`

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

2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,a.produced_by, a.produced_by_position,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM wpjtx_govarticle AS a 
  LEFT JOIN wpjtx_govarticle_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN wpjtx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN wpjtx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN wpjtx_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN wpjtx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN wpjtx_govarticle_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM wpjtx_categories AS cat JOIN wpjtx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT id 
  FROM wpjtx_template_styles

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

1 × SELECT COUNT(*) 
  FROM wpjtx_govarticle AS a 
  LEFT JOIN wpjtx_govarticle_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN wpjtx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN wpjtx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN wpjtx_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN wpjtx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN wpjtx_govarticle_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM wpjtx_categories AS cat JOIN wpjtx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `data` 
  FROM `wpjtx_session`

1 × SELECT `session_id` 
  FROM `wpjtx_session`

1 × SELECT * 
  FROM `wpjtx_admintools_wafblacklists`

1 × SELECT `source`,`keepurlparams` 
  FROM `wpjtx_admintools_redirects`

1 × SELECT `word` 
  FROM `wpjtx_admintools_badwords` 
  GROUP BY `word

1 × SELECT * 
  FROM `wpjtx_admintools_storage`

1 × SELECT * 
  FROM `wpjtx_admintools_ipautoban`

1 × SELECT * 
  FROM `wpjtx_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `wpjtx_admintools_storage`

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

1 × SELECT id, rules 
  FROM `wpjtx_viewlevels

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM wpjtx_modules AS m 
  LEFT JOIN wpjtx_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN wpjtx_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

INNE tabele:

1 × INSERT INTO `wpjtx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6361333431663237376665346565613266326464316436393764316633303066', 1, 1752222181, 0, '', 0

1 × UPDATE `wpjtx_extensions` 
  SET `params` = '{\"mediaversion\":\"0081ca78b62d02527961e48021162eaf\"}'

1 × SHOW VARIABLES LIKE "collation_database

1 × SHOW FULL COLUMNS 
  FROM `wpjtx_assets

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

60 zapytań zarejestrowanych 76.13 ms

4 znalezionych duplikatów!

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

WYBRANE tabele:

INNE tabele: