Biuletyn Informacji Publicznej BOS - Zapytanie ofertowe: Zaprojektowanie, wykonanie oraz wdrożenie portalu internetowego mającego na celu zbieranie zgłoszeń do Plebiscytu na 10 Najlepszych Sportowców Białołęki.

Metryczka

Szczegóły: Udostępniony i zatwierdzony przez: Michał Jankowski; Wytworzony przez: Michał Jankowski (Inspektor ds. promocji i marketingu); Kategoria: Archiwum BIP; Udostępniony: 22 listopad 2019; Wytworzony: 22 listopad 2019; Poprawiono: 06 czerwiec 2022; Odsłony: 737

Załączniki

Tytuł	Typ	Rozmiar	Dodany przez
Zapytanie ofertowe	docx	23.41 KB	Adam Białapko
Formularz ofertowy	docx	15.32 KB	Adam Białapko
REGULAMIN PLEBISCYTU NA 10 NAJLEPSZYCH SPORTOWCÓW BIAŁOŁĘKI	docx	464.36 KB	Adam Białapko
załącznik nr 1 - 10 NAJLEPSZYCH MŁODYCH SPORTOWCÓW BIAŁOŁĘKI - ROK URODZENIA 2002-2005	docx	24.31 KB	Adam Białapko
załącznik nr 2 - NAJLEPSZY NIEPEŁNOSPRAWNY MŁODY SPORTOWIEC BIAŁOŁĘKI W 2018 ROKU - ROK URODZENIA 2002-2005	docx	24.05 KB	Adam Białapko
załącznik nr 3 - MŁODY TALENT - ROK URODZENIA 2006 I MŁODSI	docx	24.29 KB	Adam Białapko
załącznik nr 4 - ODKRYCIE SPORTOWE 2018 ROKU	docx	24.41 KB	Adam Białapko
załącznik nr 5 - NAJLEPSZY TRENER 2018 ROKU	docx	24.03 KB	Adam Białapko
załącznik nr 6 - NAJLEPSZA DRUŻYNA W 2018 ROKU	docx	24.70 KB	Adam Białapko
załącznik nr 7 - NAJPOPULARNIEJSZA SPORTOWA DRUŻYNA KLUBOWA W 2018 ROKU	docx	24.77 KB	Adam Białapko
załącznik nr 8 - WYDARZENIE SPORTOWE W 2018 ROKU	docx	24.03 KB	Adam Białapko
Informacja o wyborze najkorzystniejszej oferty	pdf	184.92 KB	Adam Białapko

Historia zmian

Opis zmian	Data	Osoba
Artykuł został utworzony. Dodane załączniki Zapytanie ofertowe Formularz ofertowy	piątek, 22, listopad 2019 11:07	Adam Białapko
Artykuł został zmieniony. Dodane załączniki REGULAMIN PLEBISCYTU NA 10 NAJLEPSZYCH SPORTOWCÓW BIAŁOŁĘKI załącznik nr 4 - ODKRYCIE SPORTOWE 2018 ROKU załącznik nr 8 - WYDARZENIE SPORTOWE W 2018 ROKU załącznik nr 3 - MŁODY TALENT - ROK URODZENIA 2006 I MŁODSI załącznik nr 7 - NAJPOPULARNIEJSZA SPORTOWA DRUŻYNA KLUBOWA W 2018 ROKU załącznik nr 2 - NAJLEPSZY NIEPEŁNOSPRAWNY MŁODY SPORTOWIEC BIAŁOŁĘKI W 2018 ROKU - ROK URODZENIA 2002-2005 załącznik nr 6 - NAJLEPSZA DRUŻYNA W 2018 ROKU załącznik nr 1 - 10 NAJLEPSZYCH MŁODYCH SPORTOWCÓW BIAŁOŁĘKI - ROK URODZENIA 2002-2005 załącznik nr 5 - NAJLEPSZY TRENER 2018 ROKU	piątek, 22, listopad 2019 13:01	Adam Białapko
Artykuł został zmieniony. Dodane załączniki Informacja o wyborze najkorzystniejszej oferty	poniedziałek, 02, grudzień 2019 13:53	Adam Białapko
Artykuł został zmieniony.	poniedziałek, 06, czerwiec 2022 12:00	Adam Białapko

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1750061902,
                "last": 1750061902,
                "now": 1750061902
            },
            "client": {
                "forwarded": "216.73.216.138"
            },
            "token": "zi1mXV7JrR8fiprrnIDAmls8nJwlnSdn"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "5def82bd7f00978210017eae93d9c3583925ea2d": {
                    "link": "https://bip.bos.waw.pl/archiwum-bip/221-zapytanie-ofertowe-zaprojektowanie-wykonanie-oraz-wdrozenie-portalu-internetowego-majacego-na-celu-zbieranie-zgloszen-do-plebiscytu-na-10-najlepszych-sportowcow-bialoleki",
                    "expiry": 1750061902
                }
            }
        }
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 3.24 ms / 3.24 ms Pamięć: 0.403 MB / 0.74 MB Application: afterLoad

Czas: 27.35 ms / 30.59 ms Pamięć: 1.515 MB / 2.26 MB Application: afterInitialise

Czas: 5.03 ms / 35.62 ms Pamięć: 0.310 MB / 2.57 MB Application: afterRoute

Czas: 0.37 ms / 35.99 ms Pamięć: 0.029 MB / 2.59 MB Application: beforeRenderComponent com_govarticle

Czas: 1.46 ms / 37.46 ms Pamięć: 0.159 MB / 2.75 MB Application: Before Access::preloadComponents (all components)

Czas: 0.96 ms / 38.42 ms Pamięć: 0.059 MB / 2.81 MB Application: After Access::preloadComponents (all components)

Czas: 1.02 ms / 39.44 ms Pamięć: 0.045 MB / 2.86 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Czas: 0.14 ms / 39.58 ms Pamięć: 0.008 MB / 2.87 MB Application: After Access::getAssetRules (id:1 name:root.1)

Czas: 30.32 ms / 69.91 ms Pamięć: 1.035 MB / 3.90 MB Application: Before Access::preloadPermissions (com_content)

Czas: 2.48 ms / 72.38 ms Pamięć: 0.612 MB / 4.51 MB Application: After Access::preloadPermissions (com_content)

Czas: 0.41 ms / 72.79 ms Pamięć: -0.025 MB / 4.49 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Czas: 0.05 ms / 72.84 ms Pamięć: 0.007 MB / 4.49 MB Application: After Access::getAssetRules (id:8 name:com_content)

Czas: 5.88 ms / 78.72 ms Pamięć: 0.069 MB / 4.56 MB Application: afterRenderComponent com_govarticle

Czas: 0.24 ms / 78.96 ms Pamięć: 0.006 MB / 4.57 MB Application: afterDispatch

Czas: 8.97 ms / 87.93 ms Pamięć: 0.121 MB / 4.69 MB Application: beforeRenderModule mod_govarticle_category (Popularne w BIP)

Czas: 0.89 ms / 88.82 ms Pamięć: 0.173 MB / 4.86 MB Application: afterRenderModule mod_govarticle_category (Popularne w BIP)

Czas: 0.05 ms / 88.87 ms Pamięć: -0.066 MB / 4.80 MB Application: beforeRenderModule mod_govarticle_category (Niedawno dodane)

Czas: 0.26 ms / 89.13 ms Pamięć: 0.073 MB / 4.87 MB Application: afterRenderModule mod_govarticle_category (Niedawno dodane)

Czas: 1.90 ms / 91.03 ms Pamięć: 0.100 MB / 4.97 MB Application: beforeRenderModule mod_syndicate (RSS Moduł)

Czas: 0.23 ms / 91.26 ms Pamięć: 0.007 MB / 4.98 MB Application: afterRenderModule mod_syndicate (RSS Moduł)

Czas: 1.39 ms / 92.65 ms Pamięć: 0.088 MB / 5.06 MB Application: afterRender

Ogółem zapytań do bazy danych: 25.82 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'3535393661666637366563616538636336376663383764356462643837336438', 1, 1750061902, 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
update	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php: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.28 ms Po ostatnim zapytaniu: 1.17 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.120 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 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.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
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.42 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.132 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.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 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.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/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.46 ms Po ostatnim zapytaniu: 4.12 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 1.575 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.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 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
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.21 ms Po ostatnim zapytaniu: 0.41 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.605 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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.00 ms
freeing items	0.01 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: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.33 ms Po ostatnim zapytaniu: 3.82 ms Pamięć zapytania: 0.010 MB Pamięć przed zapytaniem: 2.057 MB

UPDATE `wpjtx_extensions`

  SET `params` = '{\"mediaversion\":\"7abc289de9bf8c7478158eea28c6f955\"}'

  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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.07 ms
updating	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 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: 1.69 ms Po ostatnim zapytaniu: 2.67 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.219 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Sending data	0.00 ms
executing	0.00 ms
Sending data	1.40 ms
end	0.00 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.01 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.20 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.227 MB Zwróconych wierszy: 0

SELECT *

  FROM `wpjtx_admintools_ipautoban`

  WHERE `ip` = '216.73.216.138'

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.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.00 ms
freeing items	0.01 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.20 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.233 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 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.15 ms Po ostatnim zapytaniu: 0.34 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.243 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 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.19 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.251 MB Zwróconych wierszy: 0

SELECT `source`,`keepurlparams`

  FROM `wpjtx_admintools_redirects`

  WHERE ((`dest` = 'archiwum-bip/221-zapytanie-ofertowe-zaprojektowanie-wykonanie-oraz-wdrozenie-portalu-internetowego-majacego-na-celu-zbieranie-zgloszen-do-plebiscytu-na-10-najlepszych-sportowcow-bialoleki') OR (`dest` = 'archiwum-bip/221-zapytanie-ofertowe-zaprojektowanie-wykonanie-oraz-wdrozenie-portalu-internetowego-majacego-na-celu-zbieranie-zgloszen-do-plebiscytu-na-10-najlepszych-sportowcow-bialoleki') OR ('archiwum-bip/221-zapytanie-ofertowe-zaprojektowanie-wykonanie-oraz-wdrozenie-portalu-internetowego-majacego-na-celu-zbieranie-zgloszen-do-plebiscytu-na-10-najlepszych-sportowcow-bialoleki' 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.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
freeing items	0.01 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.42 ms Po ostatnim zapytaniu: 2.28 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.428 MB Zwróconych wierszy: 0

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 = 221

  ORDER BY c.lft

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.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 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:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
11	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
10	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/router.php:329
9	GovArticleRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.22 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.433 MB Zwróconych wierszy: 1

SELECT `alias`,`catid`

  FROM `wpjtx_govarticle`

  WHERE `id` = 221

Objaśnienie

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 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:1662
10	JDatabaseDriver->loadObject()	JROOT/components/com_govarticle/router.php:345
9	GovArticleRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.33 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.440 MB Zwróconych wierszy: 1

SELECT *

  FROM `wpjtx_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_govarticle') 
  AND `view` IN('','article') 
  AND `task` IN('','article.') 
  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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 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: 0.83 ms Po ostatnim zapytaniu: 3.75 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 2.759 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.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.42 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/article.php:60
15	GovArticleModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_govarticle/models/article.php:80
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.23 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 2.828 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.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.01 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:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
20	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
19	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/article.php:60
15	GovArticleModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_govarticle/models/article.php:80
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.20 ms Po ostatnim zapytaniu: 0.18 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 2.852 MB Zwróconych wierszy: 0

Duplikaty zapytań: #20 #21 #22

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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
19	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/article.php:60
15	GovArticleModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_govarticle/models/article.php:80
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.17 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 2.871 MB Zwróconych wierszy: 0

Duplikaty zapytań: #19 #21 #22

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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
20	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
19	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/article.php:60
15	GovArticleModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_govarticle/models/article.php:80
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.15 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.886 MB Zwróconych wierszy: 0

Duplikaty zapytań: #19 #20 #22

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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
18	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
17	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/article.php:134
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.16 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.895 MB Zwróconych wierszy: 0

Duplikaty zapytań: #19 #20 #21

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.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
18	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
17	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_govarticle/models/article.php:134
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.51 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.902 MB Zwróconych wierszy: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, a.produced_by, a.produced_by_position, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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

  FROM wpjtx_govarticle AS a

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

  LEFT JOIN wpjtx_users AS u 
  on u.id = a.created_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 <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 221 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-16 08:18:22') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-16 08:18:22') 
  AND (a.state = 1 OR a.state =2)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	119	32.77	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.15 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.02 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.69 ms
Creating sort index	0.06 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_govarticle/models/article.php:165
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.15 ms Pamięć zapytania: 0.035 MB Pamięć przed zapytaniem: 2.918 MB Zwróconych wierszy: 33

SHOW FULL COLUMNS 
  FROM `wpjtx_govarticle`

Objaśnienie

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 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/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_govarticle/tables/content.php:36
19	GovArticleTableContent->__construct()	JROOT/libraries/src/Table/Table.php:320
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110
17	Joomla\CMS\MVC\Factory\LegacyFactory->createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/components/com_govarticle/models/article.php:387
14	GovArticleModelArticle->bindAttachments()	JROOT/components/com_govarticle/models/article.php:178
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.26 ms Po ostatnim zapytaniu: 0.54 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.975 MB Zwróconych wierszy: 1

Duplikaty zapytań: #41

SELECT *

  FROM wpjtx_govarticle

  WHERE `id` = '221'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
15	Joomla\CMS\Table\Table->load()	JROOT/components/com_govarticle/models/article.php:390
14	GovArticleModelArticle->bindAttachments()	JROOT/components/com_govarticle/models/article.php:178
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.39 ms Po ostatnim zapytaniu: 0.13 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 2.988 MB Zwróconych wierszy: 10

SHOW FULL COLUMNS 
  FROM `wpjtx_ucm_history`

Objaśnienie

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 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/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
18	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/ContentHistory.php:48
17	Joomla\CMS\Table\ContentHistory->__construct()	JROOT/libraries/src/Table/Table.php:320
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_govarticle/models/article.php:497
15	GovArticleModelArticle->getVersionFromData()	JROOT/components/com_govarticle/models/article.php:397
14	GovArticleModelArticle->bindAttachments()	JROOT/components/com_govarticle/models/article.php:178
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.33 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 3.014 MB Zwróconych wierszy: 8

SHOW FULL COLUMNS 
  FROM `wpjtx_content_types`

Objaśnienie

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 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/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
18	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/ContentType.php:29
17	Joomla\CMS\Table\ContentType->__construct()	JROOT/libraries/src/Table/Table.php:320
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_govarticle/models/article.php:500
15	GovArticleModelArticle->getVersionFromData()	JROOT/components/com_govarticle/models/article.php:397
14	GovArticleModelArticle->bindAttachments()	JROOT/components/com_govarticle/models/article.php:178
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.05 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.035 MB Zwróconych wierszy: 1

SELECT *

  FROM wpjtx_content_types

  WHERE `type_alias` = 'com_govarticle.article'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_content_types	NULL	ref	idx_alias	idx_alias	402	const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 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:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
16	Joomla\CMS\Table\Table->load()	JROOT/components/com_govarticle/models/article.php:501
15	GovArticleModelArticle->getVersionFromData()	JROOT/components/com_govarticle/models/article.php:397
14	GovArticleModelArticle->bindAttachments()	JROOT/components/com_govarticle/models/article.php:178
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.61 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.048 MB Zwróconych wierszy: 1

SELECT *

  FROM wpjtx_ucm_history

  WHERE `sha1_hash` = '53a1a57a8bb7b4fcdb26c3018d2f00f02b149730' 
  AND `ucm_type_id` = '10000'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wpjtx_ucm_history	NULL	ref	idx_ucm_item_id	idx_ucm_item_id	4	const	732	10.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	2.38 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 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:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
16	Joomla\CMS\Table\Table->load()	JROOT/components/com_govarticle/models/article.php:509
15	GovArticleModelArticle->getVersionFromData()	JROOT/components/com_govarticle/models/article.php:397
14	GovArticleModelArticle->bindAttachments()	JROOT/components/com_govarticle/models/article.php:178
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.82 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.046 MB Zwróconych wierszy: 12

SELECT f.*,a.content_id,u.name AS `created_by_name`

  FROM wpjtx_govarticle_files AS f

  LEFT JOIN wpjtx_govarticle_attachments AS a 
  ON a.id=f.id

  LEFT JOIN wpjtx_users AS u 
  ON u.id=f.created_by

  WHERE a.content_id=221 
  AND f.version=707

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	PRIMARY,fk_govartcile_attachment-article_idx	fk_govartcile_attachment-article_idx	4	const	12	100.00	Using where; Using index
1	SIMPLE	f	NULL	eq_ref	uq_govarticle_attachment-version,fk_govarticle_attachment_version-attachment_idx	uq_govarticle_attachment-version	8	02129658_0000005.a.id,const	1	100.00	NULL
1	SIMPLE	u	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_govarticle/models/article.php:420
14	GovArticleModelArticle->bindAttachments()	JROOT/components/com_govarticle/models/article.php:178
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.53 ms Po ostatnim zapytaniu: 0.59 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.084 MB Zwróconych wierszy: 4

SELECT l.*, a.title AS `article_title`,u.name AS `user_name`,hn.version_note,hn.save_date AS `version_new_date`,ho.save_date AS `version_old_date`

  FROM wpjtx_govarticle_log AS l

  LEFT JOIN wpjtx_govarticle AS a 
  ON a.id=l.content_id

  LEFT JOIN wpjtx_users AS u 
  ON u.id=l.created_by

  LEFT JOIN wpjtx_ucm_history AS hn 
  ON hn.version_id=l.version_new

  LEFT JOIN wpjtx_ucm_history AS ho 
  ON ho.version_id=l.version_old

  WHERE l.content_id=221

  ORDER BY l.created ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	ref	fk_govarticle_log-article_idx	fk_govarticle_log-article_idx	4	const	4	100.00	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	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	hn	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.l.version_new	1	100.00	NULL
1	SIMPLE	ho	NULL	eq_ref	PRIMARY	PRIMARY	4	02129658_0000005.l.version_old	1	100.00	NULL

Profile

Status	Duration
starting	0.05 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.02 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.10 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_govarticle/models/article.php:550
14	GovArticleModelArticle->bindHistory()	JROOT/components/com_govarticle/models/article.php:179
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.04 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.100 MB Zwróconych wierszy: 37

SELECT f.*

  FROM wpjtx_govarticle_attachments AS a

  LEFT JOIN wpjtx_govarticle_files AS f 
  ON f.id=a.id

  WHERE a.content_id=221

  ORDER BY f.version ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	fk_govartcile_attachment-article_idx	fk_govartcile_attachment-article_idx	4	const	12	100.00	Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	f	NULL	ref	uq_govarticle_attachment-version,fk_govarticle_attachment_version-attachment_idx	uq_govarticle_attachment-version	4	02129658_0000005.a.id	3	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_govarticle/models/article.php:584
15	GovArticleModelArticle->bindAttachmentsHistory()	JROOT/components/com_govarticle/models/article.php:551
14	GovArticleModelArticle->bindHistory()	JROOT/components/com_govarticle/models/article.php:179
13	GovArticleModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_govarticle/views/article/view.html.php:47
11	GovArticleViewArticle->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.56 ms Po ostatnim zapytaniu: 0.41 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.196 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.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.07 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_govarticle/helpers/route.php:49
12	GovArticleHelperRoute::getArticleRoute()	JROOT/components/com_govarticle/views/article/view.html.php:76
11	GovArticleViewArticle->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.48 ms Po ostatnim zapytaniu: 0.32 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 3.222 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` = 221 
  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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_govarticle/views/article/view.html.php:160
11	GovArticleViewArticle->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.56 ms Po ostatnim zapytaniu: 0.99 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.266 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.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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/article/view.html.php:165
11	GovArticleViewArticle->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.14 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.101 MB Pamięć przed zapytaniem: 3.279 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.10 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.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	2.77 ms
Creating sort index	0.63 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 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/article/view.html.php:165
11	GovArticleViewArticle->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.73 ms Po ostatnim zapytaniu: 0.67 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.604 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` = '221'

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.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.47 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 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/article/view.html.php:165
11	GovArticleViewArticle->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.72 ms Po ostatnim zapytaniu: 11.20 ms Pamięć zapytania: 0.127 MB Pamięć przed zapytaniem: 3.902 MB Zwróconych wierszy: 683

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

  FROM `wpjtx_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' 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	996	20.13	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.17 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 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/plugins/content/pagenavigation/pagenavigation.php:56
14	PlgContentPagenavigation->onContentBeforeDisplay()	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/article/view.html.php:171
11	GovArticleViewArticle->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.79 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 4.520 MB Zwróconych wierszy: 0

SELECT *

  FROM wpjtx_assets

  WHERE `name` = 'com_content.article.221'

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.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
freeing items	0.01 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:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
19	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
18	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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/plugins/content/pagenavigation/pagenavigation.php:56
14	PlgContentPagenavigation->onContentBeforeDisplay()	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/article/view.html.php:171
11	GovArticleViewArticle->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.56 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 4.505 MB Zwróconych wierszy: 0

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM wpjtx_content AS a

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

  WHERE a.catid = 116 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-06-16 08:18:22') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-06-16 08:18:22')

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	11.80	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
14	PlgContentPagenavigation->onContentBeforeDisplay()	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/article/view.html.php:171
11	GovArticleViewArticle->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.39 ms Po ostatnim zapytaniu: 0.35 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 4.508 MB Zwróconych wierszy: 1

Duplikaty zapytań: #25

SELECT *

  FROM wpjtx_govarticle

  WHERE `id` = '221'

Objaśnienie

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 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.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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_govarticle/models/article.php:274
12	GovArticleModelArticle->hit()	JROOT/components/com_govarticle/views/article/view.html.php:181
11	GovArticleViewArticle->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.29 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 4.515 MB

UPDATE wpjtx_govarticle

  SET `hits` = (`hits` + 1)

  WHERE `id` = '221'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	wpjtx_govarticle	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1256
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_govarticle/models/article.php:275
12	GovArticleModelArticle->hit()	JROOT/components/com_govarticle/views/article/view.html.php:181
11	GovArticleViewArticle->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.45 ms Po ostatnim zapytaniu: 9.65 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.620 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.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.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]

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

WYBRANE tabele:

```
5 × SELECT * 
  FROM wpjtx_assets
```

3 × 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)

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

```
2 × SELECT * 
  FROM wpjtx_govarticle
```

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM wpjtx_content AS a 
  LEFT JOIN wpjtx_categories AS cc 
  ON cc.id = a.catid

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

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 `m`.`tag_id`,`t`.* 
  FROM `wpjtx_contentitem_tag_map` AS m  
  INNER JOIN `wpjtx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT f.* 
  FROM wpjtx_govarticle_attachments AS a 
  LEFT JOIN wpjtx_govarticle_files AS f 
  ON f.id=a.id

1 × SELECT l.*, a.title AS `article_title`,u.name AS `user_name`,hn.version_note,hn.save_date AS `version_new_date`,ho.save_date AS `version_old_date` 
  FROM wpjtx_govarticle_log AS l 
  LEFT JOIN wpjtx_govarticle AS a 
  ON a.id=l.content_id 
  LEFT JOIN wpjtx_users AS u 
  ON u.id=l.created_by 
  LEFT JOIN wpjtx_ucm_history AS hn 
  ON hn.version_id=l.version_new 
  LEFT JOIN wpjtx_ucm_history AS ho 
  ON ho.version_id=l.version_old

1 × SELECT f.*,a.content_id,u.name AS `created_by_name` 
  FROM wpjtx_govarticle_files AS f 
  LEFT JOIN wpjtx_govarticle_attachments AS a 
  ON a.id=f.id 
  LEFT JOIN wpjtx_users AS u 
  ON u.id=f.created_by

1 × SELECT * 
  FROM wpjtx_ucm_history

1 × SELECT * 
  FROM wpjtx_content_types

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, a.produced_by, a.produced_by_position, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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 
  FROM wpjtx_govarticle AS a 
  LEFT JOIN wpjtx_categories AS c 
  on c.id = a.catid 
  LEFT JOIN wpjtx_users AS u 
  on u.id = a.created_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 `alias`,`catid` 
  FROM `wpjtx_govarticle`

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 id 
  FROM wpjtx_template_styles

INNE tabele:

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

1 × UPDATE `wpjtx_extensions` 
  SET `params` = '{\"mediaversion\":\"7abc289de9bf8c7478158eea28c6f955\"}'

1 × SHOW VARIABLES LIKE "collation_database

1 × SHOW FULL COLUMNS 
  FROM `wpjtx_assets

1 × SHOW FULL COLUMNS 
  FROM `wpjtx_govarticle

1 × SHOW FULL COLUMNS 
  FROM `wpjtx_ucm_history

1 × SHOW FULL COLUMNS 
  FROM `wpjtx_content_types

1 × UPDATE wpjtx_govarticle 
  SET `hits` = (`hits` + 1)

Zapytanie ofertowe: Zaprojektowanie, wykonanie oraz wdrożenie portalu internetowego mającego na celu zbieranie zgłoszeń do Plebiscytu na 10 Najlepszych Sportowców Białołęki.

Dodane załączniki

Dodane załączniki

Dodane załączniki

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

43 zapytań zarejestrowanych 25.82 ms

6 znalezionych duplikatów!

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

WYBRANE tabele:

INNE tabele: