Руководитель рекламного агентства «РП Бизнес» ответила на вопросы газеты «Metro»

Москвичи и гости столицы неоднократно обращали внимание на то, что реклама в метро полностью исчезла. Примерно с августа прошлого года по всей территории московского метро были демонтированы щиты, плакаты, наклейки и прочие элементы визуального информирования. Что же послужило причиной, и как долго метро будет пустовать без ярких призывных рекламных картинок?

На вопросы редакции газеты «Metro» ответила генеральный директор «РП Бизнес» Виктория Полякова.

Прочитать на сайте газеты «Metro»

Консоль отладки Joomla!

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1751012795,
                "last": 1751012795,
                "now": 1751012795
            },
            "client": {
                "forwarded": "216.73.216.225"
            },
            "token": "Rc25iY1qWkV2MI9Q01JvKaNxRRCjB58G"
        },
        "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": [
                "1"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__easycalccheck": {
        "redirect_url": null
    }
}

Результаты профилирования

Использование памяти

Запросы к базе данных

26 SQL-запросов зафиксировано 22.35 ms

Время запроса: 0.84 ms Память запроса: 0.018 MB Память до запроса: 0.898 MB Выбрано строк: 0

SELECT `data`

  FROM `d8ujd_session`

  WHERE `session_id` = 'qofv7r2rsccc0t2hp6t1fv5933'

План SQL-запросов (Explain)

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

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.02 ms
starting	0.06 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.07 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.02 ms
query end	0.07 ms
closing tables	0.05 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.07 ms

Стек вызовов

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
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:54

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

Время запроса: 0.45 ms После последнего запроса: 1.42 ms Память запроса: 0.008 MB Память до запроса: 0.963 MB

DELETE 

  FROM `d8ujd_session`

  WHERE `time` < '1751009195'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	d8ujd_session	NULL	range	time	time	59	const	1	100.00	Using where

Профилирование SQL-запросов

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

Стек вызовов

#	Caller	File and line number
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:54

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

Время запроса: 0.76 ms После последнего запроса: 0.32 ms Память запроса: 0.012 MB Память до запроса: 0.975 MB Выбрано строк: 0

SELECT `session_id`

  FROM `d8ujd_session`

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

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Профилирование SQL-запросов

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.14 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:54

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

Время запроса: 0.45 ms После последнего запроса: 0.32 ms Память запроса: 0.009 MB Память до запроса: 0.987 MB

INSERT INTO `d8ujd_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('qofv7r2rsccc0t2hp6t1fv5933', 0, '1751012795')

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: INSERT INTO `d8ujd_session` (`session_id`, `client_id`, `time`) VALUES ('qofv7r2rsccc0t2hp6t1fv5933', 0, '1751012795')

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
update	0.10 ms
Waiting for query cache lock	0.02 ms
update	0.02 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.05 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:54

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

Время запроса: 0.79 ms После последнего запроса: 1.87 ms Память запроса: 0.018 MB Память до запроса: 1.067 MB Выбрано строк: 37

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

  FROM d8ujd_extensions

  WHERE `type` = 'component'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_extensions	NULL	ref	extension	extension	82	const	21	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.11 ms
cleaning up	0.14 ms

Стек вызовов

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
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:57

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

Время запроса: 0.27 ms После последнего запроса: 1.12 ms Память запроса: 0.014 MB Память до запроса: 1.130 MB Выбрано строк: 1

SELECT b.id

  FROM d8ujd_usergroups AS a

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

  WHERE a.id = 1

План SQL-запросов (Explain)

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

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.34 ms После последнего запроса: 0.37 ms Память запроса: 0.013 MB Память до запроса: 1.149 MB Выбрано строк: 4

SELECT id, rules

  FROM `d8ujd_viewlevels`

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_viewlevels	NULL	ALL	NULL	Индекс не используется	NULL	NULL	4	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaning up	0.03 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.85 ms После последнего запроса: 0.41 ms Память запроса: 0.013 MB Память до запроса: 1.168 MB Выбрано строк: 76

SELECT folder AS type, element AS name, params

  FROM d8ujd_extensions

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

  ORDER BY ordering

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_extensions	NULL	ref	extension	extension	82	const	123	0.48	Using index condition; Using where; Используется filesort

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.06 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
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:57

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

Время запроса: 0.41 ms После последнего запроса: 8.72 ms Память запроса: 0.013 MB Память до запроса: 1.591 MB Выбрано строк: 1

SELECT `enabled`

  FROM `d8ujd_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:61
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
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:57

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

Время запроса: 0.38 ms После последнего запроса: 20.11 ms Память запроса: 0.024 MB Память до запроса: 2.383 MB Выбрано строк: 1

SELECT id,template 
  FROM d8ujd_template_styles 
  WHERE client_id=0 
  AND home=1

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_template_styles	NULL	ALL	idx_home	Индекс не используется	NULL	NULL	22	4.55	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
17	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Container.php:240
16	YOOtheme\Widgetkit\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
15	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
14	call_user_func_array()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113
13	YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:149
12	YOOtheme\Widgetkit\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:92
11	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
10	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
9	plgSystemWidgetkit->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:71
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
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:57

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

Время запроса: 0.77 ms После последнего запроса: 9.69 ms Память запроса: 0.031 MB Память до запроса: 2.668 MB Выбрано строк: 43

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

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

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	45	10.00	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	u403161_reklama.m.component_id	1	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.07 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.07 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.50 ms После последнего запроса: 5.91 ms Память запроса: 0.025 MB Память до запроса: 3.140 MB Выбрано строк: 7

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 d8ujd_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM d8ujd_categories AS cat JOIN d8ujd_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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null

  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

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	range	cat_idx,idx_access	cat_idx	207	NULL	7	100.00	Using index condition; Using temporary; Используется filesort
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	u403161_reklama.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	38	100.00	Using index condition; Using temporary; Используется filesort
2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	Индекс не используется	NULL	NULL	93	11.11	Range checked for each record (index map: 0x11)

Профилирование SQL-запросов

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.22 ms После последнего запроса: 0.83 ms Память запроса: 0.015 MB Память до запроса: 3.207 MB Выбрано строк: 0

SELECT `alias`,`catid`

  FROM `d8ujd_content`

  WHERE `id` = 0

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 1.57 ms После последнего запроса: 0.26 ms Память запроса: 0.015 MB Память до запроса: 3.222 MB Выбрано строк: 1

SELECT `id`

  FROM d8ujd_content

  WHERE `catid` = 99 
  AND `alias` = 'rukovoditel-reklamnogo-agentstva-rp-biznes-otvetila-na-voprosy-gazety-metro'

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_content	NULL	ref	idx_catid	idx_catid	4	const	81	10.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.09 ms
checking permissions	0.10 ms
Opening tables	0.26 ms
init	0.05 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.43 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.03 ms
freeing items	0.03 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
10	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:453
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:57

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

Время запроса: 0.42 ms После последнего запроса: 0.57 ms Память запроса: 0.018 MB Память до запроса: 3.239 MB Выбрано строк: 15

SELECT id, home, template, s.params

  FROM d8ujd_template_styles as s

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

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	Индекс не используется	NULL	NULL	22	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	u403161_reklama.s.template,const	1	5.00	Using index condition; Using where

Профилирование SQL-запросов

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.07 ms
cleaning up	0.18 ms

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
11	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:310
10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
9	plgSystemT3->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:71
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
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:57

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

Время запроса: 1.31 ms После последнего запроса: 22.22 ms Память запроса: 0.019 MB Память до запроса: 3.960 MB Выбрано строк: 1

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

  FROM d8ujd_extensions

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

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.13 ms
Waiting for query cache lock	0.03 ms
starting	0.02 ms
checking query cache for query	0.12 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.28 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.09 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
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:57

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

Время запроса: 0.64 ms После последнего запроса: 0.40 ms Память запроса: 0.013 MB Память до запроса: 3.963 MB

UPDATE `d8ujd_extensions`

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

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

План SQL-запросов (Explain)

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

Профилирование SQL-запросов

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.21 ms
updating	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.26 ms После последнего запроса: 1.11 ms Память запроса: 0.013 MB Память до запроса: 4.057 MB Выбрано строк: 1

SELECT *

  FROM d8ujd_languages

  WHERE published=1

  ORDER BY ordering ASC

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_languages	NULL	system	NULL	Индекс не используется	NULL	NULL	1	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.03 ms
starting	0.03 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
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:57

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

Время запроса: 0.33 ms После последнего запроса: 4.33 ms Память запроса: 0.020 MB Память до запроса: 4.260 MB Выбрано строк: 1

SELECT a.rules

  FROM d8ujd_assets AS a

  WHERE (a.id = 1)

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

План SQL-запросов (Explain)

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

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.03 ms
starting	0.03 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.03 ms
checking permissions	0.03 ms
sending cached result to clien	0.06 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.30 ms После последнего запроса: 0.61 ms Память запроса: 0.021 MB Память до запроса: 4.291 MB Выбрано строк: 2

SELECT b.rules

  FROM d8ujd_assets AS a

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

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	202	const	1	100.00	Using temporary; Используется filesort
1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	38	100.00	Using where

Профилирование SQL-запросов

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.06 ms
cleaning up	0.14 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 2.52 ms После последнего запроса: 0.51 ms Память запроса: 0.025 MB Память до запроса: 4.337 MB Выбрано строк: 30

SHOW FULL COLUMNS 
  FROM `d8ujd_content`

План SQL-запросов (Explain)

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `d8ujd_content`

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.65 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.04 ms
Opening tables	0.06 ms
checking permissions	0.19 ms
checking permissions	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.08 ms
checking permissions	0.10 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
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.03 ms
checking permissions	0.03 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
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.09 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.96 ms После последнего запроса: 3.00 ms Память запроса: 0.026 MB Память до запроса: 4.482 MB Выбрано строк: 1

SELECT *

  FROM d8ujd_content

  WHERE `id` = '173'

План SQL-запросов (Explain)

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

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.30 ms
Waiting for query cache lock	0.02 ms
freeing items	0.07 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 0.65 ms После последнего запроса: 0.44 ms Память запроса: 0.014 MB Память до запроса: 4.501 MB

UPDATE d8ujd_content

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

  WHERE `id` = '173'

План SQL-запросов (Explain)

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

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.18 ms
updating	0.08 ms
end	0.02 ms
Waiting for query cache lock	0.02 ms
end	0.05 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
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:57

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

Время запроса: 4.31 ms После последнего запроса: 2.01 ms Память запроса: 0.028 MB Память до запроса: 4.588 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 d8ujd_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM d8ujd_categories AS cat JOIN d8ujd_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 = 173 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-27 08:26:35') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-27 08:26:35') 
  AND (a.state = 1 OR a.state =2)

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	v	NULL	system	PRIMARY	Индекс не используется	NULL	NULL	0	0.00	const row not found
1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	system	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	37	100.00	Using index condition; Using temporary; Используется filesort
2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	Индекс не используется	NULL	NULL	93	11.11	Range checked for each record (index map: 0x11)

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.02 ms
starting	0.03 ms
checking query cache for query	0.29 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
init	0.12 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.03 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.04 ms
Sending data	0.04 ms
executing	0.02 ms
Sending data	1.04 ms
Creating sort index	0.23 ms
end	0.02 ms
query end	0.08 ms
removing tmp table	0.65 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.42 ms
closing tables	0.04 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.09 ms
cleaning up	0.02 ms

Стек вызовов

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
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:57

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

Время запроса: 0.87 ms После последнего запроса: 2.09 ms Память запроса: 0.024 MB Память до запроса: 4.671 MB Выбрано строк: 0

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

  FROM `d8ujd_contentitem_tag_map` AS m 

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

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

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Профилирование SQL-запросов

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.07 ms
checking permissions	0.02 ms
checking permissions	0.07 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.03 ms
Waiting for query cache lock	0.08 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.10 ms

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
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:57

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

Время запроса: 1.17 ms После последнего запроса: 61.67 ms Память запроса: 0.020 MB Память до запроса: 6.034 MB Выбрано строк: 141

SELECT * 
  FROM d8ujd_acymailing_config

План SQL-запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d8ujd_acymailing_config	NULL	ALL	NULL	Индекс не используется	NULL	NULL	141	100.00	NULL

Профилирование SQL-запросов

Status	Duration
starting	0.13 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.03 ms
sending cached result to clien	0.07 ms
cleaning up	0.03 ms

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:461
10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1183
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
8	plgSystemRegacymailing->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:71
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1074
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:57

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

25 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM d8ujd_extensions

1 × SELECT a.rules 
  FROM d8ujd_assets AS a

```
1 × SELECT * 
  FROM d8ujd_languages
```

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

1 × SELECT id, home, template, s.params 
  FROM d8ujd_template_styles as s 
  LEFT JOIN d8ujd_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, 
  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 d8ujd_content AS a 
  LEFT JOIN d8ujd_categories AS c 
  on c.id = a.catid 
  LEFT JOIN d8ujd_users AS u 
  on u.id = a.created_by 
  LEFT JOIN d8ujd_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN d8ujd_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM d8ujd_categories AS cat JOIN d8ujd_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT * 
  FROM d8ujd_acymailing_confi

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

```
1 × SELECT `id` 
  FROM d8ujd_content
```
```
1 × SELECT * 
  FROM d8ujd_content
```

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 d8ujd_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM d8ujd_categories AS cat JOIN d8ujd_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT id, rules 
  FROM `d8ujd_viewlevels

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

1 × SELECT `session_id` 
  FROM `d8ujd_session`

1 × SELECT folder AS type, element AS name, params 
  FROM d8ujd_extensions

1 × SELECT `enabled` 
  FROM `d8ujd_extensions`

1 × SELECT `data` 
  FROM `d8ujd_session`

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 d8ujd_menu AS m 
  LEFT JOIN d8ujd_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id,template 
  FROM d8ujd_template_styles

1 × SELECT `alias`,`catid` 
  FROM `d8ujd_content`

Прочие SQL-запросы:

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

1 × SHOW FULL COLUMNS 
  FROM `d8ujd_content

1 × UPDATE `d8ujd_extensions` 
  SET `params` = '{\"mediaversion\":\"adf672d3bd6e7bd2bf966a9ec3dcd04b\"}'

1 × INSERT INTO `d8ujd_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('qofv7r2rsccc0t2hp6t1fv5933', 0, '1751012795'

```
1 × DELETE  
  FROM `d8ujd_session`
```