Budżet obywatelski

Jesteś tutaj: Uncategorised >> Budżet obywatelski

Budżet obywatelski

Szczegóły: Opublikowano: piątek, 30, sierpień 2013 20:54; Odsłony: 532

Budżet obywatelski

w Halembie

Idea tzw." budżetu obywatelskiego" umożliwia obywatelom zadecydowaniu o inwestycjach.Władze naszego miasta na ten cel przeznaczyły 2 mln zł a okręg Halemba, Bielszowice i część Czarnego Lasu 506 tyś zł.

Pan Stanisław Kiermes złożył formularz zgłoszeniowy propozycji projektu odbudowy pomnika Powstańców Śląskich w Halembie I.Treść wniosku kliknij tutaj

Lokalizacja pomnika kliknij tutaj

Pan Alfred Gilner zgłosił propozycję projektu zakupu i wybudowania fontanny w dzielnicy Halemba II.Treść wniosku kliknij tutaj

Lokalizacja fontanny kliknij tutaj

Liczymy na akceptacje decydentów projektów zgłoszonych przez Panów Stanisława Kiermesa i Alfreda Gilnera.

A mieszkańcom dajemy możliwość zapoznania się z tymi projektami. Projekty te są bardzo potrzebne mieszkańcom Halemby.Odbudowanie pomnika to według Pana Kiermesa i wielu halembian,tu zacytuję fragment treści z wniosku "Odbudowa pomnika pozwoli zrealizować wolę naszych przodków,a pomnik byłby dowodem pamięci o przodkach dzisiejszych mieszkańców Halemby".

Z kolei propozycja Pana Gilnera potrzebna jest dziś nam.Taka fontanna upiększyła by estetykę osiedla Halemba II.

Relacja foto z dnia złożenia formularzy-kliknij tutaj

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1778521370,
                "last": 1778521370,
                "now": 1778521371
            },
            "token": "vr2pwfGf2Idx1qt0OlMzKedfpXBubJPL"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 25.83 ms / 25.83 ms Pamięć: 1.990 MB / 2.37 MB Application: afterLoad

Czas: 51.28 ms / 77.10 ms Pamięć: 3.360 MB / 5.73 MB Application: afterInitialise

Czas: 11.11 ms / 88.22 ms Pamięć: 1.166 MB / 6.89 MB Application: afterRoute

Czas: 9.13 ms / 97.34 ms Pamięć: 0.238 MB / 7.13 MB Application: beforeRenderComponent com_content

Czas: 7.24 ms / 104.59 ms Pamięć: 0.457 MB / 7.59 MB Application: Before Access::preloadComponents (all components)

Czas: 2.15 ms / 106.73 ms Pamięć: 0.057 MB / 7.64 MB Application: After Access::preloadComponents (all components)

Czas: 0.05 ms / 106.78 ms Pamięć: -0.004 MB / 7.64 MB Application: Before Access::preloadPermissions (com_content)

Czas: 3.10 ms / 109.88 ms Pamięć: 0.431 MB / 8.07 MB Application: After Access::preloadPermissions (com_content)

Czas: 0.05 ms / 109.94 ms Pamięć: -0.019 MB / 8.05 MB Application: Before Access::getAssetRules (id:241 name:com_content.article.162)

Czas: 0.75 ms / 110.69 ms Pamięć: 0.027 MB / 8.08 MB Application: After Access::getAssetRules (id:241 name:com_content.article.162)

Czas: 46.36 ms / 157.05 ms Pamięć: 1.938 MB / 10.02 MB Application: afterRenderComponent com_content

Czas: 2.28 ms / 159.33 ms Pamięć: 0.097 MB / 10.11 MB Application: afterDispatch

Czas: 8.74 ms / 168.07 ms Pamięć: 0.235 MB / 10.35 MB Application: beforeRenderModule mod_stats (Statystyki)

Czas: 4.29 ms / 172.36 ms Pamięć: 0.066 MB / 10.42 MB Application: afterRenderModule mod_stats (Statystyki)

Czas: 0.12 ms / 172.48 ms Pamięć: -0.001 MB / 10.42 MB Application: beforeRenderModule mod_menu (Witamy)

Czas: 4.81 ms / 177.29 ms Pamięć: 0.110 MB / 10.53 MB Application: afterRenderModule mod_menu (Witamy)

Czas: 0.09 ms / 177.38 ms Pamięć: -0.004 MB / 10.52 MB Application: beforeRenderModule mod_breadcrumbs (Ścieżka powrotu)

Czas: 1.21 ms / 178.60 ms Pamięć: 0.039 MB / 10.56 MB Application: afterRenderModule mod_breadcrumbs (Ścieżka powrotu)

Czas: 0.09 ms / 178.68 ms Pamięć: -0.003 MB / 10.56 MB Application: beforeRenderModule mod_search (Search)

Czas: 1.37 ms / 180.05 ms Pamięć: 0.018 MB / 10.58 MB Application: afterRenderModule mod_search (Search)

Czas: 0.08 ms / 180.14 ms Pamięć: -0.004 MB / 10.57 MB Application: beforeRenderModule mod_menu (Aktualności)

Czas: 1.63 ms / 181.77 ms Pamięć: 0.034 MB / 10.61 MB Application: afterRenderModule mod_menu (Aktualności)

Czas: 2.30 ms / 184.06 ms Pamięć: 0.086 MB / 10.69 MB Application: afterRender

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

Użycie pamięci

Zapytania do bazy danych

20 zapytań zarejestrowanych 30.88 ms

Czas zapytania: 0.85 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 4.106 MB Zwróconych wierszy: 1

SELECT `data`

  FROM `jo30_session`

  WHERE `session_id` = X'6334373039373261303630616233313239353764306432326335613238353439'

Objaśnienie

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

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.05 ms
freeing items	0.15 ms
cleaning up	0.03 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: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

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

Czas zapytania: 1.33 ms Po ostatnim zapytaniu: 3.67 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 4.407 MB Zwróconych wierszy: 35

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

  FROM `jo30_extensions`

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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jo30_extensions	ref	extension	extension	82	const	35	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.46 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.17 ms
cleaning up	0.03 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.74 ms Po ostatnim zapytaniu: 2.15 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 4.661 MB Zwróconych wierszy: 5

SELECT id, rules

  FROM `jo30_viewlevels`

Objaśnienie

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

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.12 ms
logging slow query	0.03 ms
cleaning up	0.03 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.85 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 4.673 MB Zwróconych wierszy: 2

SELECT b.id

  FROM jo30_usergroups AS a

  LEFT JOIN jo30_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profile

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

Stos wywołania

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

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

Czas zapytania: 1.91 ms Po ostatnim zapytaniu: 0.71 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 4.741 MB Zwróconych wierszy: 75

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

  FROM jo30_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	filtered	Extra
1	SIMPLE	jo30_extensions	ref	extension	extension	82	const	95	100.00	Using index condition; Using where; Uruchomiono metodę filesort

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	1.03 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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: 1.82 ms Po ostatnim zapytaniu: 15.77 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 6.289 MB Zwróconych wierszy: 22

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 jo30_menu AS m

  LEFT JOIN jo30_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	27	100.00	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	zghalemb_jo30.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.31 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
init	0.08 ms
System lock	0.03 ms
optimizing	0.06 ms
statistics	0.12 ms
preparing	0.07 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.58 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.06 ms
freeing items	0.15 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/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:445
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:561
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:1169
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.25 ms Po ostatnim zapytaniu: 7.43 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 6.927 MB Zwróconych wierszy: 1

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

  FROM `jo30_extensions`

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

Objaśnienie

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

Profile

Status	Duration
starting	0.19 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.03 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:1131
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: 1.78 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 6.918 MB

UPDATE `jo30_extensions`

  SET `params` = '{\"mediaversion\":\"57e73ae7e34aee6628270fd90883840c\"}'

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

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jo30_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.11 ms
updating	0.12 ms
end	0.03 ms
query end	1.06 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.03 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:1131
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.80 ms Po ostatnim zapytaniu: 2.66 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 7.105 MB Zwróconych wierszy: 1

SELECT *

  FROM jo30_languages

  WHERE published=1

  ORDER BY ordering ASC

Objaśnienie

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

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.10 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
logging slow query	0.02 ms
cleaning up	0.02 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: 1.12 ms Po ostatnim zapytaniu: 0.35 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 7.119 MB Zwróconych wierszy: 3

SELECT id, home, template, s.params

  FROM jo30_template_styles as s

  LEFT JOIN jo30_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	filtered	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	5	60.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	zghalemb_jo30.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.15 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.12 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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.83 ms Po ostatnim zapytaniu: 8.03 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 7.592 MB Zwróconych wierszy: 33

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

  FROM `jo30_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','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_installer','com_joomlaupdate','com_jupgradepro','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Objaśnienie

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

Profile

Status	Duration
starting	0.28 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.11 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.26 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.67 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 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: 1.79 ms Po ostatnim zapytaniu: 0.30 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 7.641 MB Zwróconych wierszy: 440

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

  FROM `jo30_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	filtered	Extra
1	SIMPLE	jo30_assets	ALL	idx_asset_name,idx_parent_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	506	100.00	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	1.06 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.10 ms
logging slow query	0.03 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/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: 2.90 ms Po ostatnim zapytaniu: 2.95 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 8.120 MB Zwróconych wierszy: 31

SHOW FULL COLUMNS 
  FROM `jo30_content`

Objaśnienie

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

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.41 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Opening tables	0.04 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.07 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
Sending data	0.12 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.15 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 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: 1.84 ms Po ostatnim zapytaniu: 4.36 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 8.366 MB

UPDATE jo30_content

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

  WHERE `id` = '162'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jo30_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.07 ms
updating	0.12 ms
end	0.03 ms
query end	1.10 ms
closing tables	0.05 ms
freeing items	0.12 ms
cleaning up	0.03 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: 1.39 ms Po ostatnim zapytaniu: 2.25 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 8.489 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 jo30_content AS a

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

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

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

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

  WHERE a.id = 162 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-11 17:42:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-11 17:42:51') 
  AND (a.state = 1 OR a.state =2)

Objaśnienie

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

Profile

Status	Duration
starting	0.32 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.11 ms
System lock	0.03 ms
optimizing	0.06 ms
statistics	0.20 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.13 ms
cleaning up	0.03 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: 1.17 ms Po ostatnim zapytaniu: 3.18 ms Pamięć zapytania: 0.011 MB Pamięć przed zapytaniem: 8.704 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 `jo30_categories` AS `s`

  INNER JOIN `jo30_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	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	2	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.22 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.12 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 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.89 ms Po ostatnim zapytaniu: 1.03 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 8.760 MB Zwróconych wierszy: 0

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

  FROM `jo30_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 162 
  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	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	zghalemb_jo30.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
logging slow query	0.02 ms
cleaning up	0.03 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: 2.52 ms Po ostatnim zapytaniu: 7.65 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 9.201 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 jo30_fields AS a

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

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

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

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

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

  LEFT JOIN `jo30_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	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	zghalemb_jo30.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	zghalemb_jo30.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	zghalemb_jo30.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	zghalemb_jo30.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	zghalemb_jo30.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	zghalemb_jo30.a.id	1	100.00	Using where; Using index; Distinct

Profile

Status	Duration
starting	0.38 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.23 ms
preparing	0.09 ms
Creating tmp table	0.11 ms
Sorting result	0.03 ms
executing	0.03 ms
Sending data	0.59 ms
Creating sort index	0.06 ms
end	0.02 ms
removing tmp table	0.13 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/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: 1.76 ms Po ostatnim zapytaniu: 20.68 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 10.322 MB Zwróconych wierszy: 5

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

  FROM jo30_modules AS m

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

  LEFT JOIN jo30_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 <= '2026-05-11 17:42:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-11 17:42:51') 
  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	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	11	100.00	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	zghalemb_jo30.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	zghalemb_jo30.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.28 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.07 ms
init	0.08 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.15 ms
preparing	0.07 ms
Sorting result	0.03 ms
executing	0.03 ms
Sending data	0.03 ms
Creating sort index	0.47 ms
end	0.07 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.03 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:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/beez3/index.php:18
7	require JROOT/templates/beez3/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:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.34 ms Po ostatnim zapytaniu: 5.88 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 10.390 MB Zwróconych wierszy: 1

SELECT SUM(hits) AS count_hits

  FROM jo30_content

  WHERE state = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jo30_content	ref	idx_state	idx_state	1	const	411	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:129
11	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
10	include JROOT/modules/mod_stats/mod_stats.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:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

WYBRANE tabele:

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

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

1 × SELECT `data` 
  FROM `jo30_session`

1 × SELECT id, rules 
  FROM `jo30_viewlevels

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

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

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

```
1 × SELECT * 
  FROM jo30_languages
```

1 × SELECT id, home, template, s.params 
  FROM jo30_template_styles as s 
  LEFT JOIN jo30_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_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 jo30_content AS a 
  INNER JOIN jo30_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jo30_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jo30_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jo30_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 `jo30_categories` AS `s` 
  INNER JOIN `jo30_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 `m`.`tag_id`,`t`.* 
  FROM `jo30_contentitem_tag_map` AS m  
  INNER JOIN `jo30_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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 jo30_fields AS a 
  LEFT JOIN `jo30_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jo30_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jo30_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jo30_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jo30_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jo30_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT SUM(hits) AS count_hits 
  FROM jo30_content

INNE tabele:

1 × UPDATE `jo30_extensions` 
  SET `params` = '{\"mediaversion\":\"57e73ae7e34aee6628270fd90883840c\"}'

1 × SHOW FULL COLUMNS 
  FROM `jo30_content

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

Open Source Content Management

Nawigacja i wyszukiwanie

Nawigacja

Szukaj