Przedszkole Samorządowe w Wielkiej Wsi z Oddziałem Zamiejscowym w Biały Kościele

Informacja o wyborze oferty

Dotyczy postępowania przetargowego poniżej 214.000,00 euro w trybie przetargu nieograniczonego:

„Usługa cateringu dla dzieci, które będą uczęszczać do przedszkola Samorządowego w Wielkiej Wsi

z oddziałem zamiejscowym w Białym Kościele w roku szkolnym 2020/2021”

Zgodnie z art. 92 ust. 2 ustawy z dnia 29 stycznia 2004 r. Prawo Zamówień Publicznych (tj. Dz. U. z 2019 r., poz. 1843, z póź. zm.) Dyrektor Przedszkola Samorządowego w Wielkiej Wsi z oddziałem zamiejscowym w Białym Kościele informuje, że w powyższym postępowaniu:

Za najkorzystniejszą została uznana oferta nr 2 złożona przez Wykonawcę: JACEK spółka jawna Szpak & Sobczyk, Nawojowa Góra, ul. Nawoja 67, 32 – 065 Krzeszowice. Cena oferty wynosi 282.541,20 zł brutto. Doświadczenie dietetyka wykazane w ofercie – 179 miesięcy. Termin płatności faktury – 23 dni. Oferta spełnia wszystkie wymagania ustawy Prawo Zamówień Publicznych oraz Specyfikacji Istotnych Warunków Zamówienia. Spośród złożonych ofert, niepodlegających odrzuceniu oferta przedstawia najkorzystniejszy bilans z punktu widzenia przyjętych kryteriów oceny ofert. Oferta otrzymała 100 pkt.
Przewidywany termin podpisania umowy to: 08.2020 r.
Zestawienie Firm biorących udział w postępowaniu przetargowym i punktacja przyznana ofertom zgodnie z kryterium najniższa cena – 60% znaczenia, doświadczenie dietetyka – 35% znaczenia, termin płatności faktury – 5% znaczenia.

- JACEK Spółka jawna Szpak & Sobczyk, Nawojowa Góra, ul. Nawoja 67, 32 – 065 Krzeszowice – 282.541,20 zł brutto, doświadczenie dietetyka wykazane w ofercie – 179 miesięcy, termin płatności faktury – 23 dni. Kryterium najniższa cena – 60 pkt., kryterium długość udzielonej gwarancji – 35 pkt., kryterium termin płatności faktury – 5 pkt., łączna punktacja – 100,00 pkt.

- Przedsiębiorstwo Wielobranżowe „Gastropol”, ul. Bronowicka 73, 30 – 091 Kraków – 366.850,00 zł brutto, doświadczenie dietetyka wykazane w ofercie – 42 miesiące, termin płatności faktury – 23 dni. Kryterium najniższa cena – 46,21 pkt., kryterium długość udzielonej gwarancji – 35 pkt., kryterium termin płatności faktury – 5 pkt., łączna punktacja – 86,21 pkt.

Załączniki:
Informacja o wyborze oferty WW.pdf

tel/fax: 12 380-11-15

e-mail: pswielkawies@wielka-wies.pl

od poniedziałku do piątku od 8:00 do 16:00

Ta strona używa plików cookies Dowiedz się więcej

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713512725,
                "last": 1713512725,
                "now": 1713512725
            },
            "token": "CjdoIkOvmBw0VPhMgc3nwPYKtQE5Y7kL"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3ByemVkc3prb2xlLnd3LndpZWxrYS13aWVzLnBsLzItdW5jYXRlZ29yaXNlZC80NzUtaW5mb3JtYWNqYS1vLXd5Ym9yemUtb2ZlcnR5Pw%3D%3D"
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 0,00 ms / 0,85 ms Pamięć: 0,000 MB / 0,74 MB Application: afterLoad

Czas: 9,00 ms / 10,11 ms Pamięć: 0,000 MB / 1,55 MB Application: afterInitialise

Czas: 2,00 ms / 12,80 ms Pamięć: 0,000 MB / 1,87 MB Application: afterRoute

Czas: 1,00 ms / 13,89 ms Pamięć: 0,000 MB / 1,92 MB Application: beforeRenderComponent com_content

Czas: 1,00 ms / 15,70 ms Pamięć: 0,000 MB / 1,97 MB Application: Before Access::preloadComponents (all components)

Czas: 0,00 ms / 16,24 ms Pamięć: 0,000 MB / 2,03 MB Application: After Access::preloadComponents (all components)

Czas: 0,00 ms / 16,26 ms Pamięć: 0,000 MB / 2,03 MB Application: Before Access::preloadPermissions (com_content)

Czas: 0,00 ms / 16,97 ms Pamięć: 0,000 MB / 2,54 MB Application: After Access::preloadPermissions (com_content)

Czas: 0,00 ms / 16,99 ms Pamięć: 0,000 MB / 2,51 MB Application: Before Access::getAssetRules (id:563 name:com_content.article.475)

Czas: 0,00 ms / 17,32 ms Pamięć: 0,000 MB / 2,52 MB Application: After Access::getAssetRules (id:563 name:com_content.article.475)

Czas: 19,00 ms / 37,14 ms Pamięć: 0,000 MB / 3,09 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Czas: 0,00 ms / 37,16 ms Pamięć: 0,000 MB / 3,09 MB Application: After Access::getAssetRules (id:8 name:com_content)

Czas: 1,00 ms / 38,23 ms Pamięć: 0,000 MB / 3,11 MB Application: Before Access::getAssetRules (id:92 name:com_attachments)

Czas: 0,00 ms / 38,26 ms Pamięć: 0,000 MB / 3,12 MB Application: After Access::getAssetRules (id:92 name:com_attachments)

Czas: 0,00 ms / 38,27 ms Pamięć: 0,000 MB / 3,12 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Czas: 0,00 ms / 38,27 ms Pamięć: 0,000 MB / 3,12 MB Application: After Access::getAssetRules (id:1 name:root.1)

Czas: 5,00 ms / 43,41 ms Pamięć: 0,000 MB / 3,22 MB Application: afterRenderComponent com_content

Czas: 0,00 ms / 43,88 ms Pamięć: 0,000 MB / 3,23 MB Application: afterDispatch

Czas: 2,00 ms / 46,08 ms Pamięć: 0,000 MB / 3,33 MB Application: beforeRenderModule mod_custom (Stopka prawa)

Czas: 1,00 ms / 47,33 ms Pamięć: 0,000 MB / 3,34 MB Application: afterRenderModule mod_custom (Stopka prawa)

Czas: 0,00 ms / 47,36 ms Pamięć: 0,000 MB / 3,34 MB Application: beforeRenderModule mod_custom (Stopka lewa)

Czas: 0,00 ms / 47,40 ms Pamięć: 0,000 MB / 3,34 MB Application: afterRenderModule mod_custom (Stopka lewa)

Czas: 0,00 ms / 47,43 ms Pamięć: 0,000 MB / 3,34 MB Application: beforeRenderModule mod_menu (Lewe Menu)

Czas: 1,00 ms / 49,42 ms Pamięć: 0,000 MB / 3,43 MB Application: afterRenderModule mod_menu (Lewe Menu)

Czas: 0,00 ms / 49,45 ms Pamięć: 0,000 MB / 3,43 MB Application: beforeRenderModule mod_menu (Górne menu)

Czas: 0,00 ms / 50,21 ms Pamięć: 0,000 MB / 3,55 MB Application: afterRenderModule mod_menu (Górne menu)

Czas: 0,00 ms / 50,24 ms Pamięć: 0,000 MB / 3,55 MB Application: beforeRenderModule mod_djimageslider (Slider)

Czas: 2,00 ms / 52,41 ms Pamięć: 0,000 MB / 3,59 MB Application: afterRenderModule mod_djimageslider (Slider)

Czas: 0,00 ms / 53,02 ms Pamięć: 0,000 MB / 3,62 MB Application: afterRender

Ogółem zapytań do bazy danych: 9,60 ms

Użycie pamięci

Zapytania do bazy danych

29 zapytań zarejestrowanych 9,60 ms

2 znalezionych duplikatów!

2 duplikatów: #24 #25

Czas zapytania: 0,22 ms Pamięć zapytania: 0,023 MB Pamięć przed zapytaniem: 1,021 MB Zwróconych wierszy: 0

SELECT `data`

  FROM `pj_session`

  WHERE `session_id` = X'6469696a623431386731643772667230307138386b7238756375'

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,02 ms
After opening tables	0,02 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,00 ms
executing	0,01 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

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

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

Czas zapytania: 0,15 ms Po ostatnim zapytaniu: 0,14 ms Pamięć zapytania: 0,020 MB Pamięć przed zapytaniem: 1,035 MB Zwróconych wierszy: 0

SELECT `session_id`

  FROM `pj_session`

  WHERE `session_id` = X'6469696a623431386731643772667230307138386b7238756375' 
  LIMIT 1

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,00 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,00 ms
statistics	0,01 ms
preparing	0,00 ms
executing	0,00 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 0,62 ms Po ostatnim zapytaniu: 0,04 ms Pamięć zapytania: 0,004 MB Pamięć przed zapytaniem: 1,040 MB

INSERT INTO `pj_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6469696a623431386731643772667230307138386b7238756375', 1, 1713512725, 0, '', 0)

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `pj_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6469696a623431386731643772667230307138386b7238756375', 1, 1713512725, 0, '', 0)

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,02 ms
init	0,01 ms
update	0,03 ms
end	0,00 ms
query end	0,40 ms
closing tables	0,02 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 0,30 ms Po ostatnim zapytaniu: 0,19 ms Pamięć zapytania: 0,040 MB Pamięć przed zapytaniem: 1,071 MB Zwróconych wierszy: 39

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pj_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pj_extensions	ref	extension	extension	82	const	39	Using index condition; Using where

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,01 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,01 ms
executing	0,00 ms
Sending data	0,09 ms
end	0,01 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Identyczny z wywołaniem linii niżej.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,14 ms Po ostatnim zapytaniu: 0,23 ms Pamięć zapytania: 0,021 MB Pamięć przed zapytaniem: 1,109 MB Zwróconych wierszy: 5

SELECT id, rules

  FROM `pj_viewlevels`

Objaśnienie

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

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,00 ms
optimizing	0,00 ms
statistics	0,00 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,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,20 ms Po ostatnim zapytaniu: 0,04 ms Pamięć zapytania: 0,021 MB Pamięć przed zapytaniem: 1,121 MB Zwróconych wierszy: 2

SELECT b.id

  FROM pj_usergroups AS a

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

  WHERE a.id = 9

Objaśnienie

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

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,00 ms
Unlocking tables	0,01 ms
executing	0,00 ms
Sending data	0,01 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,40 ms Po ostatnim zapytaniu: 0,07 ms Pamięć zapytania: 0,030 MB Pamięć przed zapytaniem: 1,142 MB Zwróconych wierszy: 97

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM pj_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pj_extensions	ref	extension	extension	82	const	121	Using index condition; Using where; Uruchomiono metodę filesort

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,01 ms
preparing	0,01 ms
executing	0,00 ms
Sorting result	0,17 ms
Sending data	0,06 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Identyczny z wywołaniem linii niżej.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,63 ms Po ostatnim zapytaniu: 4,04 ms Pamięć zapytania: 0,068 MB Pamięć przed zapytaniem: 1,575 MB Zwróconych wierszy: 37

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM pj_menu AS m

  LEFT JOIN pj_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	82	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	wielka-wies_2.m.component_id	1	Using where

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
Opening tables	0,03 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,01 ms
executing	0,00 ms
Sorting result	0,11 ms
Sending data	0,07 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,40 ms Po ostatnim zapytaniu: 1,12 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 1,794 MB Zwróconych wierszy: 3

SELECT id, home, template, s.params

  FROM pj_template_styles as s

  LEFT JOIN pj_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,01 ms
executing	0,00 ms
Sending data	0,03 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1018
9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,20 ms Po ostatnim zapytaniu: 0,45 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 1,886 MB Zwróconych wierszy: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pj_extensions`

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

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,01 ms
executing	0,00 ms
Sending data	0,01 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Identyczny z wywołaniem linii niżej.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,30 ms Po ostatnim zapytaniu: 0,07 ms Pamięć zapytania: 0,005 MB Pamięć przed zapytaniem: 1,877 MB

UPDATE `pj_extensions`

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

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

Objaśnienie

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

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,02 ms
updating	0,02 ms
end	0,00 ms
query end	0,14 ms
closing tables	0,01 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,19 ms Po ostatnim zapytaniu: 0,16 ms Pamięć zapytania: 0,019 MB Pamięć przed zapytaniem: 1,905 MB Zwróconych wierszy: 2

SELECT *

  FROM pj_languages

  WHERE published=1

  ORDER BY ordering ASC

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,01 ms
preparing	0,01 ms
executing	0,00 ms
Sorting result	0,01 ms
Sending data	0,01 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,44 ms Po ostatnim zapytaniu: 1,96 ms Pamięć zapytania: 0,027 MB Pamięć przed zapytaniem: 1,977 MB Zwróconych wierszy: 39

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

  FROM `pj_assets`

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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pj_assets	range	idx_asset_name	idx_asset_name	202	NULL	40	Using index condition

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,02 ms
optimizing	0,01 ms
statistics	0,05 ms
preparing	0,02 ms
executing	0,00 ms
Sending data	0,16 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,45 ms Po ostatnim zapytaniu: 0,09 ms Pamięć zapytania: 0,091 MB Pamięć przed zapytaniem: 2,026 MB Zwróconych wierszy: 592

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

  FROM `pj_assets`

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

Objaśnienie

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

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,01 ms
executing	0,00 ms
Sending data	0,25 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,57 ms Po ostatnim zapytaniu: 0,81 ms Pamięć zapytania: 0,031 MB Pamięć przed zapytaniem: 2,589 MB Zwróconych wierszy: 31

SHOW FULL COLUMNS 
  FROM `pj_content`

Objaśnienie

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

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
closing tables	0,00 ms
Opening tables	0,10 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,00 ms
optimizing	0,00 ms
statistics	0,01 ms
preparing	0,01 ms
executing	0,00 ms
Filling schema table	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
checking permissions	0,02 ms
checking permissions	0,01 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,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,00 ms
checking permissions	0,00 ms
closing tables	0,00 ms
executing	0,00 ms
Sending data	0,02 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
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 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/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,44 ms Po ostatnim zapytaniu: 1,20 ms Pamięć zapytania: 0,005 MB Pamięć przed zapytaniem: 2,639 MB

UPDATE pj_content

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

  WHERE `id` = '475'

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE pj_content SET `hits` = (`hits` + 1) WHERE `id` = '475'

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,02 ms
updating	0,02 ms
end	0,00 ms
query end	0,24 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,34 ms Po ostatnim zapytaniu: 0,58 ms Pamięć zapytania: 0,023 MB Pamięć przed zapytaniem: 2,665 MB Zwróconych wierszy: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, 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 pj_content AS a

  INNER JOIN pj_categories AS c 
  on c.id = a.catid

  LEFT JOIN pj_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 475 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 07:45:25') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:45:25') 
  AND (a.state = 1 OR a.state =2)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

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
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,02 ms
optimizing	0,02 ms
statistics	0,04 ms
preparing	0,00 ms
Unlocking tables	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
Unlocking tables	0,01 ms
freeing items	0,01 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,32 ms Po ostatnim zapytaniu: 1,26 ms Pamięć zapytania: 0,027 MB Pamięć przed zapytaniem: 2,703 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 `pj_categories` AS `s`

  INNER JOIN `pj_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 = 2

  ORDER BY c.lft

Objaśnienie

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

Profile

Status	Duration
starting	0,04 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,02 ms
optimizing	0,01 ms
statistics	0,04 ms
preparing	0,00 ms
Unlocking tables	0,01 ms
executing	0,00 ms
Sorting result	0,00 ms
Sending data	0,03 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,01 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,38 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 2,731 MB Zwróconych wierszy: 0

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

  FROM `pj_contentitem_tag_map` AS m 

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

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

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,01 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,02 ms
preparing	0,01 ms
executing	0,00 ms
Sending data	0,01 ms
end	0,01 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 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/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,57 ms Po ostatnim zapytaniu: 8,47 ms Pamięć zapytania: 0,025 MB Pamięć przed zapytaniem: 2,859 MB Zwróconych wierszy: 0

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

  FROM pj_fields AS a

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

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

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

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

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

  LEFT JOIN `pj_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 (2,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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	wielka-wies_2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	wielka-wies_2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	wielka-wies_2.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	wielka-wies_2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	wielka-wies_2.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	wielka-wies_2.a.id	1	Using where; Using index; Distinct

Profile

Status	Duration
starting	0,04 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,04 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,02 ms
optimizing	0,01 ms
statistics	0,04 ms
preparing	0,02 ms
executing	0,00 ms
Creating tmp table	0,12 ms
Copying to tmp table	0,01 ms
Sorting result	0,01 ms
Sending data	0,02 ms
end	0,00 ms
removing tmp table	0,02 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,01 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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: 4,53 ms Pamięć zapytania: 0,023 MB Pamięć przed zapytaniem: 3,079 MB Zwróconych wierszy: 1

SELECT created_by, catid

  FROM pj_content

  WHERE id = 475

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,01 ms
preparing	0,00 ms
Unlocking tables	0,01 ms
executing	0,00 ms
Sending data	0,01 ms
end	0,00 ms
query end	0,01 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 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/attachments/attachments_for_content/attachments_for_content.php:809
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:319
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,41 ms Po ostatnim zapytaniu: 1,50 ms Pamięć zapytania: 0,025 MB Pamięć przed zapytaniem: 3,117 MB Zwróconych wierszy: 1

SELECT a.*, u.name as creator_name

  FROM pj_attachments AS a

  LEFT JOIN pj_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=475 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1,5)

  ORDER BY modified DESC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	437	Using where; Uruchomiono metodę filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	wielka-wies_2.a.created_by	1

Profile

Status	Duration
starting	0,03 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,01 ms
preparing	0,01 ms
executing	0,00 ms
Sorting result	0,12 ms
Sending data	0,02 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,36 ms Po ostatnim zapytaniu: 0,30 ms Pamięć zapytania: 0,029 MB Pamięć przed zapytaniem: 3,188 MB Zwróconych wierszy: 8

SHOW FULL COLUMNS 
  FROM `pj_assets`

Objaśnienie

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

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
closing tables	0,00 ms
Opening tables	0,07 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,00 ms
optimizing	0,00 ms
statistics	0,01 ms
preparing	0,01 ms
executing	0,00 ms
Filling schema table	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
checking permissions	0,02 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
closing tables	0,00 ms
executing	0,00 ms
Sending data	0,02 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
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
23	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
18	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,21 ms Po ostatnim zapytaniu: 0,06 ms Pamięć zapytania: 0,027 MB Pamięć przed zapytaniem: 3,212 MB Zwróconych wierszy: 0

Duplikaty zapytań: #25

SELECT *

  FROM pj_assets

  WHERE `name` = 'edit'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
Opening tables	0,02 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,01 ms
statistics	0,01 ms
preparing	0,00 ms
executing	0,01 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,02 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
18	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,12 ms Po ostatnim zapytaniu: 0,08 ms Pamięć zapytania: 0,027 MB Pamięć przed zapytaniem: 3,223 MB Zwróconych wierszy: 0

Duplikaty zapytań: #24

SELECT *

  FROM pj_assets

  WHERE `name` = 'edit'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,00 ms
statistics	0,01 ms
preparing	0,00 ms
executing	0,01 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
18	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,19 ms Po ostatnim zapytaniu: 0,91 ms Pamięć zapytania: 0,025 MB Pamięć przed zapytaniem: 3,198 MB Zwróconych wierszy: 1

SELECT id

  FROM pj_content

  WHERE id=475 
  LIMIT 1

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,00 ms
statistics	0,01 ms
preparing	0,00 ms
Unlocking tables	0,01 ms
executing	0,00 ms
Sending data	0,00 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:648
19	AttachmentsPlugin->parentExists()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:344
18	AttachmentsPlugin->getTitle()	JROOT/components/com_attachments/models/attachments.php:254
17	AttachmentsModelAttachments->getParentTitle()	JROOT/components/com_attachments/views/attachments/view.html.php:152
16	AttachmentsViewAttachments->display()	JROOT/components/com_attachments/controllers/attachments.php:133
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,02 ms Pamięć zapytania: 0,025 MB Pamięć przed zapytaniem: 3,208 MB Zwróconych wierszy: 1

SELECT title

  FROM pj_content

  WHERE id=475

Objaśnienie

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

Profile

Status	Duration
starting	0,01 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,00 ms
optimizing	0,00 ms
statistics	0,01 ms
preparing	0,00 ms
Unlocking tables	0,00 ms
executing	0,00 ms
Sending data	0,00 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,00 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:359
18	AttachmentsPlugin->getTitle()	JROOT/components/com_attachments/models/attachments.php:254
17	AttachmentsModelAttachments->getParentTitle()	JROOT/components/com_attachments/views/attachments/view.html.php:152
16	AttachmentsViewAttachments->display()	JROOT/components/com_attachments/controllers/attachments.php:133
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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,40 ms Po ostatnim zapytaniu: 3,32 ms Pamięć zapytania: 0,024 MB Pamięć przed zapytaniem: 3,265 MB Zwróconych wierszy: 7

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

  FROM pj_modules AS m

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

  LEFT JOIN pj_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-19 07:45:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 07:45:25') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	9	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	wielka-wies_2.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	wielka-wies_2.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0,03 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,02 ms
optimizing	0,02 ms
statistics	0,03 ms
preparing	0,02 ms
executing	0,00 ms
Sorting result	0,03 ms
Sending data	0,05 ms
end	0,00 ms
query end	0,01 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,01 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Identyczny z wywołaniem linii niżej.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
9	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/templates/przedszkoleww/utils.php:12
8	require JROOT/templates/przedszkoleww/utils.php	JROOT/templates/przedszkoleww/index.php:32
7	require JROOT/templates/przedszkoleww/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0,26 ms Po ostatnim zapytaniu: 7,02 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 3,595 MB Zwróconych wierszy: 1

SELECT manifest_cache 
  FROM pj_extensions 
  WHERE element='mod_djimageslider' 
  LIMIT 1

Objaśnienie

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

Profile

Status	Duration
starting	0,02 ms
checking permissions	0,00 ms
Opening tables	0,01 ms
After opening tables	0,00 ms
System lock	0,00 ms
Table lock	0,00 ms
init	0,01 ms
optimizing	0,00 ms
statistics	0,02 ms
preparing	0,01 ms
executing	0,00 ms
Sending data	0,01 ms
end	0,00 ms
query end	0,00 ms
closing tables	0,00 ms
Unlocking tables	0,01 ms
freeing items	0,00 ms
updating status	0,01 ms
cleaning up	0,00 ms

Stos wywołania

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

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

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

WYBRANE tabele:

```
2 × SELECT * 
  FROM pj_assets
```

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

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

1 × SELECT `data` 
  FROM `pj_session`

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `pj_contentitem_tag_map` AS m  
  INNER JOIN `pj_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

```
1 × SELECT title 
  FROM pj_content
```
```
1 × SELECT id 
  FROM pj_content
```

1 × SELECT a.*, u.name as creator_name 
  FROM pj_attachments AS a 
  LEFT JOIN pj_users AS u 
  ON u.id = a.created_by

1 × SELECT created_by, catid 
  FROM pj_content

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 pj_fields AS a 
  LEFT JOIN `pj_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN pj_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN pj_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN pj_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN pj_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `pj_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, 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 pj_content AS a 
  INNER JOIN pj_categories AS c 
  on c.id = a.catid 
  LEFT JOIN pj_users AS u 
  on u.id = a.created_by 
  LEFT JOIN pj_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pj_content_rating AS v 
  ON a.id = v.content_id

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 `pj_categories` AS `s` 
  INNER JOIN `pj_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `session_id` 
  FROM `pj_session`

```
1 × SELECT * 
  FROM pj_languages
```

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

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

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

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

1 × SELECT id, rules 
  FROM `pj_viewlevels

1 × SELECT manifest_cache 
  FROM pj_extensions

INNE tabele:

1 × INSERT INTO `pj_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6469696a623431386731643772667230307138386b7238756375', 1, 1713512725, 0, '', 0

1 × UPDATE `pj_extensions` 
  SET `params` = '{\"mediaversion\":\"c610044eff5bcdc1746c04b71baa40ba\"}'

1 × SHOW FULL COLUMNS 
  FROM `pj_content

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

1 × SHOW FULL COLUMNS 
  FROM `pj_assets