Консоль налагодження Joomla

Сесія

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1750149415,
                "last": 1750149415,
                "now": 1750149415
            },
            "client": {
                "forwarded": "10.2.165.164"
            },
            "token": "YDi0KczFoa25NgGERidyiUbonGgcfbIr"
        },
        "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": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Інформація облікового запису

Використання пам'яті

Запити до бази даних

21 запитів для зареєстрованих користувачів 16.36 ms

Витрачений час на запит: 0.69 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 0.874 MB Повернуто рядків: 0

SELECT `data`

  FROM `icsz9_session`

  WHERE `session_id` = 'cvmbl13k7vj98knd8vm86dk3g7'

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	icsz9_session	const	PRIMARY	PRIMARY	766	const	1

Профіль

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
Init	0.02 ms
Checking query cache for query	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.09 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Такий самий, як і виклик у нижньому рядку.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 2.11 ms Після останнього запиту: 1.81 ms Запит пам'яті: 0.008 MB пам'ять до запиту: 0.937 MB

DELETE 

  FROM `icsz9_session`

  WHERE `time` < '1750148515'

Роз'яснення

EXPLAIN не можливий для запиту: DELETE FROM `icsz9_session` WHERE `time` < '1750148515'

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.12 ms
Updating	0.31 ms
End of update loop	0.03 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	1.34 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:765
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.46 ms Після останнього запиту: 0.21 ms Запит пам'яті: 0.012 MB пам'ять до запиту: 0.949 MB Повернуто рядків: 0

SELECT `session_id`

  FROM `icsz9_session`

  WHERE `session_id` = 'cvmbl13k7vj98knd8vm86dk3g7' 
  LIMIT 0, 1

Роз'яснення

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

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.04 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.82 ms Після останнього запиту: 0.23 ms Запит пам'яті: 0.009 MB пам'ять до запиту: 0.961 MB

INSERT INTO `icsz9_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('cvmbl13k7vj98knd8vm86dk3g7', 0, '1750149415')

Роз'яснення

EXPLAIN не можливий для запиту: INSERT INTO `icsz9_session` (`session_id`, `client_id`, `time`) VALUES ('cvmbl13k7vj98knd8vm86dk3g7', 0, '1750149415')

Профіль

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.01 ms
Update	0.06 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.46 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.17 ms Після останнього запиту: 3.57 ms Запит пам'яті: 0.014 MB пам'ять до запиту: 1.083 MB Повернуто рядків: 2

SELECT b.id

  FROM icsz9_usergroups AS a

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

  WHERE a.id = 9

Роз'яснення

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.16 ms Після останнього запиту: 0.25 ms Запит пам'яті: 0.013 MB пам'ять до запиту: 1.103 MB Повернуто рядків: 4

SELECT id, rules

  FROM `icsz9_viewlevels`

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	icsz9_viewlevels	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	4

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 1.22 ms Після останнього запиту: 15.74 ms Запит пам'яті: 0.031 MB пам'ять до запиту: 1.928 MB Повернуто рядків: 32

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

  LEFT JOIN icsz9_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

Роз'яснення

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	48	Using index condition; Using where; Використовуючи filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c2wwwgipernet.m.component_id	1	Using where

Профіль

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
Init	0.02 ms
Checking query cache for query	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.27 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.19 ms Після останнього запиту: 4.39 ms Запит пам'яті: 0.024 MB пам'ять до запиту: 2.429 MB Повернуто рядків: 0

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

  FROM icsz9_categories as c

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

  LEFT JOIN icsz9_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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 badcats.id is null 
  AND s.id=209

  GROUP BY 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

  ORDER BY c.lft

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	21	Using index condition; Using where

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
11	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
10	JCategories->get()	JROOT/components/com_content/router.php:351
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.52 ms Після останнього запиту: 0.15 ms Запит пам'яті: 0.016 MB пам'ять до запиту: 2.442 MB Повернуто рядків: 1

SELECT `alias`,`catid`

  FROM `icsz9_content`

  WHERE `id` = 209

Роз'яснення

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

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.07 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
10	JDatabaseDriver->loadObject()	JROOT/components/com_content/router.php:367
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 1.86 ms Після останнього запиту: 1.31 ms Запит пам'яті: 0.012 MB пам'ять до запиту: 2.462 MB

UPDATE `icsz9_extensions`

  SET `params` = '{\"mediaversion\":\"350a037a936fa66a6f7025a27eb5d7a0\"}'

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

Роз'яснення

EXPLAIN не можливий для запиту: UPDATE `icsz9_extensions` SET `params` = '{\"mediaversion\":\"350a037a936fa66a6f7025a27eb5d7a0\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.11 ms
Updating	0.08 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	1.40 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.16 ms Після останнього запиту: 9.15 ms Запит пам'яті: 0.020 MB пам'ять до запиту: 2.759 MB Повернуто рядків: 1

SELECT a.rules

  FROM icsz9_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.16 ms Після останнього запиту: 0.72 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 2.788 MB Повернуто рядків: 2

SELECT b.rules

  FROM icsz9_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	Using temporary; Використовуючи filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	10	Using where

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 1.24 ms Після останнього запиту: 0.68 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 2.834 MB Повернуто рядків: 30

SHOW FULL COLUMNS 
  FROM `icsz9_content`

Роз'яснення

EXPLAIN не можливий для запиту: SHOW FULL COLUMNS FROM `icsz9_content`

Профіль

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.49 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.13 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.15 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.59 ms Після останнього запиту: 2.72 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 2.972 MB Повернуто рядків: 1

SELECT *

  FROM icsz9_content

  WHERE `id` = '209'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.08 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 1.74 ms Після останнього запиту: 0.25 ms Запит пам'яті: 0.014 MB пам'ять до запиту: 2.989 MB

UPDATE icsz9_content

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

  WHERE `id` = '209'

Роз'яснення

EXPLAIN не можливий для запиту: UPDATE icsz9_content SET `hits` = (`hits` + 1) WHERE `id` = '209'

Профіль

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.05 ms
Updating	0.07 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.18 ms
Query end	0.01 ms
Commit	1.20 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 1.38 ms Після останнього запиту: 4.22 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 3.087 MB Повернуто рядків: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  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 icsz9_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM icsz9_categories AS cat JOIN icsz9_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 209 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-17 08:36:55') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-17 08:36:55') 
  AND (a.state = 1 OR a.state =2)

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	20	Using index condition; Using where

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.17 ms
Checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
Init	0.09 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.20 ms
Preparing	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.06 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:401
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.19 ms Після останнього запиту: 1.41 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 3.165 MB Повернуто рядків: 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 icsz9_categories as c

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

  LEFT JOIN icsz9_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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 badcats.id is null 
  AND s.id=37

  GROUP BY 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

  ORDER BY c.lft

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Використовуючи filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	38	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c2wwwgipernet.c.id	2	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	c2wwwgipernet.c.id	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	21	Using index condition; Using where

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
12	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.15 ms Після останнього запиту: 1.02 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 3.205 MB Повернуто рядків: 0

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

  FROM `icsz9_contentitem_tag_map` AS m 

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

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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2wwwgipernet.m.tag_id	1	Using where

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 0.23 ms Після останнього запиту: 6026.73 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 3.307 MB Повернуто рядків: 4

SELECT b.rules

  FROM icsz9_assets AS a

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

  WHERE (a.name = 'com_content.article.209')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	Using temporary; Використовуючи filesort
1	SIMPLE	b	ALL	idx_lft_rgt	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	302	Using where

Профіль

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
16	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
15	PlgContentPagenavigation->onContentBeforeDisplay()	Такий самий, як і виклик у нижньому рядку.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 1.32 ms Після останнього запиту: 0.46 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 3.350 MB Повернуто рядків: 55

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

  FROM icsz9_content AS a

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

  WHERE a.catid = 37 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-06-17 08:36:55') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-06-17 08:36:55')

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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	58	Using where; Використовуючи filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.44 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:152
15	PlgContentPagenavigation->onContentBeforeDisplay()	Такий самий, як і виклик у нижньому рядку.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

Витрачений час на запит: 1.01 ms Після останнього запиту: 13.23 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 3.513 MB Повернуто рядків: 15

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

  FROM icsz9_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-06-17 08:36:55') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-17 08:36:55') 
  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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	19	Using index condition; Using where; Використовуючи filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	c2wwwgipernet.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	c2wwwgipernet.m.id	1	Using where; Using index

Профіль

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Checking query cache for query	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.33 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.04 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
9	JDocumentHtml->countModules()	JROOT/templates/as002035/params.php:155
8	include JROOT/templates/as002035/params.php	JROOT/templates/as002035/index.php:46
7	require JROOT/templates/as002035/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

[Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

19 типи запитів: зареєстрований, відсортований за знайденим

Вибірка таблиць:

2 &#215; SELECT b.rules 
  FROM icsz9_assets AS a 
  LEFT JOIN icsz9_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

2 &#215; 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 icsz9_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM icsz9_categories AS cat JOIN icsz9_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 &#215; SELECT * 
  FROM icsz9_content

1 &#215; SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  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 icsz9_content AS a 
  LEFT JOIN icsz9_categories AS c 
  on c.id = a.catid 
  LEFT JOIN icsz9_users AS u 
  on u.id = a.created_by 
  LEFT JOIN icsz9_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN icsz9_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM icsz9_categories AS cat JOIN icsz9_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 &#215; SELECT `m`.`tag_id`,`t`.* 
  FROM `icsz9_contentitem_tag_map` AS m  
  INNER JOIN `icsz9_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 &#215; SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM icsz9_modules AS m 
  LEFT JOIN icsz9_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN icsz9_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 &#215; SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM icsz9_content AS a 
  LEFT JOIN icsz9_categories AS cc 
  ON cc.id = a.catid

1 &#215; SELECT `alias`,`catid` 
  FROM `icsz9_content`

1 &#215; SELECT b.id 
  FROM icsz9_usergroups AS a 
  LEFT JOIN icsz9_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 &#215; SELECT `session_id` 
  FROM `icsz9_session`

1 &#215; SELECT id, rules 
  FROM `icsz9_viewlevels

1 &#215; 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 icsz9_menu AS m 
  LEFT JOIN icsz9_extensions AS e 
  ON m.component_id = e.extension_id

1 &#215; SELECT `data` 
  FROM `icsz9_session`

1 &#215; SELECT a.rules 
  FROM icsz9_assets AS a

Інші таблиці:

1 &#215; UPDATE icsz9_content 
  SET `hits` = (`hits` + 1)

1 &#215; SHOW FULL COLUMNS 
  FROM `icsz9_content

1 &#215; UPDATE `icsz9_extensions` 
  SET `params` = '{\"mediaversion\":\"350a037a936fa66a6f7025a27eb5d7a0\"}'

1 &#215; INSERT INTO `icsz9_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('cvmbl13k7vj98knd8vm86dk3g7', 0, '1750149415'

1 &#215; DELETE  
  FROM `icsz9_session`

Технічні роботи c. Ковалівка с. Доброводи

Послуги

Допомога

Контакти

Note

Консоль налагодження Joomla

Сесія

Інформація облікового запису

Час

Пам'ять

Використання пам'яті

Запити до бази даних

21 запитів для зареєстрованих користувачів 16.36 ms

19 типи запитів: зареєстрований, відсортований за знайденим

Вибірка таблиць:

Інші таблиці: