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

Сессия

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

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

Время

Память

Время: 8.13 ms / 8.13 ms Память: 0.716 MB / 0.93 MB Application: afterLoad

Время: 50.81 ms / 58.95 ms Память: 4.539 MB / 5.47 MB Application: afterInitialise

Время: 20.05 ms / 79.00 ms Память: 1.306 MB / 6.77 MB Application: afterRoute

Время: 0.97 ms / 79.97 ms Память: 0.042 MB / 6.82 MB Application: beforeRenderComponent com_k2

Время: 7.68 ms / 87.65 ms Память: 0.603 MB / 7.42 MB Application: Start JAccess::getAssetRules Old (1)

Время: 1.26 ms / 88.91 ms Память: 0.053 MB / 7.47 MB Application: Finish JAccess::getAssetRules Old (1)

Время: 0.05 ms / 88.96 ms Память: 0.000 MB / 7.47 MB Application: Start JAccess::preload(components)

Время: 3.26 ms / 92.21 ms Память: 0.274 MB / 7.74 MB Application: Finish JAccess::preload(components)

Время: 79.21 ms / 171.43 ms Память: 2.705 MB / 10.45 MB Application: afterRenderComponent com_k2

Время: 1.55 ms / 172.98 ms Память: 0.138 MB / 10.58 MB Application: afterDispatch

Время: 4.56 ms / 177.54 ms Память: 0.194 MB / 10.78 MB Application: beforeRenderModule mod_menu (Footer menu)

Время: 4.24 ms / 181.78 ms Память: 0.151 MB / 10.93 MB Application: afterRenderModule mod_menu (Footer menu)

Время: 0.12 ms / 181.90 ms Память: 0.000 MB / 10.92 MB Application: beforeRenderModule mod_custom (О нас!)

Время: 0.58 ms / 182.47 ms Память: 0.010 MB / 10.93 MB Application: afterRenderModule mod_custom (О нас!)

Время: 0.23 ms / 182.70 ms Память: 0.016 MB / 10.95 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)

Время: 5.07 ms / 187.77 ms Память: 0.442 MB / 11.39 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)

Время: 0.14 ms / 187.91 ms Память: 0.000 MB / 11.37 MB Application: beforeRenderModule mod_menu (Main Menu)

Время: 1.89 ms / 189.80 ms Память: 0.011 MB / 11.38 MB Application: afterRenderModule mod_menu (Main Menu)

Время: 0.13 ms / 189.93 ms Память: 0.000 MB / 11.37 MB Application: beforeRenderModule mod_jak2filter (JAK2 Extra fields Filter and Search)

Время: 2.79 ms / 192.72 ms Память: 0.199 MB / 11.57 MB Application: afterRenderModule mod_jak2filter (JAK2 Extra fields Filter and Search)

Время: 5.30 ms / 198.02 ms Память: 0.086 MB / 11.66 MB Application: afterRender

Всего SQL-запросов: 39.53 ms

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

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

36 SQL-запросов зафиксировано 39.53 ms

Время запроса: 1.27 ms Память запроса: 0.017 MB Память до запроса: 2.945 MB Выбрано строк: 0

SELECT `data`

  FROM `ulkb1_session`

  WHERE `session_id` = 't5g0ddar67krhvarh5bkdj4631'

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	PLG_DEBUG_CALL_STACK_SAME_FILE
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
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 для получения ссылок на файлы]

Время запроса: 0.38 ms После последнего запроса: 2.15 ms Память запроса: 0.010 MB Память до запроса: 3.151 MB Выбрано строк: 0

SELECT `session_id`

  FROM `ulkb1_session`

  WHERE `session_id` = 't5g0ddar67krhvarh5bkdj4631' 
  LIMIT 1

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
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.92 ms После последнего запроса: 0.13 ms Память запроса: 0.009 MB Память до запроса: 3.163 MB

INSERT INTO `ulkb1_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('t5g0ddar67krhvarh5bkdj4631', 0, '1503386552')

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.47 ms
update	0.04 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
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 для получения ссылок на файлы]

Время запроса: 2.64 ms После последнего запроса: 3.50 ms Память запроса: 0.012 MB Память до запроса: 3.536 MB Выбрано строк: 34

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

  FROM ulkb1_extensions

  WHERE `type` = 'component'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_extensions	ref	extension	extension	82	const	34	100.00	Using index condition

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	PLG_DEBUG_CALL_STACK_SAME_FILE
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
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:49

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

Время запроса: 0.84 ms После последнего запроса: 1.85 ms Память запроса: 0.014 MB Память до запроса: 3.745 MB Выбрано строк: 2

SELECT b.id

  FROM ulkb1_usergroups AS a

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

  WHERE a.id = 9

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:852
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:594
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.67 ms После последнего запроса: 0.71 ms Память запроса: 0.012 MB Память до запроса: 3.822 MB Выбрано строк: 4

SELECT id, rules

  FROM `ulkb1_viewlevels`

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:938
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:594
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.93 ms После последнего запроса: 0.21 ms Память запроса: 0.010 MB Память до запроса: 3.841 MB Выбрано строк: 49

SELECT folder AS type, element AS name, params

  FROM ulkb1_extensions

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

  ORDER BY ordering

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

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

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

Status	Duration
starting	0.03 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.05 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.07 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.04 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:594
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.40 ms После последнего запроса: 17.68 ms Память запроса: 0.019 MB Память до запроса: 5.700 MB Выбрано строк: 10

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

  LEFT JOIN ulkb1_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	12	100.00	Using index condition; Using where; Используется filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	mehoffby_base.m.component_id	1	100.00	Using where

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

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.58 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.05 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
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:1091
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
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.02 ms После последнего запроса: 4.75 ms Память запроса: 0.026 MB Память до запроса: 6.212 MB Выбрано строк: 1

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

  FROM ulkb1_extensions

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

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

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

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

Status	Duration
starting	0.08 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.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.19 ms
Waiting for query cache lock	0.02 ms
freeing items	0.13 ms
Waiting for query cache lock	1.19 ms
freeing items	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
22	JDatabaseDriver->loadObject()	PLG_DEBUG_CALL_STACK_SAME_FILE
21	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
20	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
19	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
18	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
17	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
16	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
15	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
14	JFactory::getDocument()	JROOT/libraries/cms/html/behavior.php:349
13	JHtmlBehavior::modal()	PLG_DEBUG_CALL_STACK_SAME_FILE
12	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/plugins/system/k2/k2.php:41
9	plgSystemK2->onAfterRoute()	PLG_DEBUG_CALL_STACK_SAME_FILE
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
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.84 ms После последнего запроса: 0.39 ms Память запроса: 0.021 MB Память до запроса: 6.224 MB

UPDATE `ulkb1_extensions`

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

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

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

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

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

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.07 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.06 ms
end	0.47 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
18	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
17	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
16	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
15	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
14	JFactory::getDocument()	JROOT/libraries/cms/html/behavior.php:349
13	JHtmlBehavior::modal()	PLG_DEBUG_CALL_STACK_SAME_FILE
12	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/plugins/system/k2/k2.php:41
9	plgSystemK2->onAfterRoute()	PLG_DEBUG_CALL_STACK_SAME_FILE
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
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.92 ms После последнего запроса: 2.23 ms Память запроса: 0.025 MB Память до запроса: 6.465 MB Выбрано строк: 2

SELECT id, home, template, s.params

  FROM ulkb1_template_styles as s

  LEFT JOIN ulkb1_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	Индекс не используется	NULL	NULL	4	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	mehoffby_base.s.template,const	1	100.00	Using index condition; Using where

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

Status	Duration
starting	0.05 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
checking permissions	0.01 ms
Opening tables	0.35 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
21	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:335
20	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:680
19	JHtml::script()	PLG_DEBUG_CALL_STACK_SAME_FILE
18	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
17	JHtml::call()	JROOT/libraries/cms/html/html.php:139
16	JHtml::_()	JROOT/libraries/cms/html/behavior.php:61
15	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:58
14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:355
13	JHtmlBehavior::modal()	PLG_DEBUG_CALL_STACK_SAME_FILE
12	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/plugins/system/k2/k2.php:41
9	plgSystemK2->onAfterRoute()	PLG_DEBUG_CALL_STACK_SAME_FILE
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
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.34 ms После последнего запроса: 3.41 ms Память запроса: 0.018 MB Память до запроса: 6.746 MB Выбрано строк: 1

SELECT *

  FROM ulkb1_languages

  WHERE published=1

  ORDER BY ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_languages	ALL	NULL	Индекс не используется	NULL	NULL	1	100.00	Using where; Используется filesort

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.11 ms
Waiting for query cache lock	0.54 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:323
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:55
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:47
9	plgSystemK2->onAfterRoute()	PLG_DEBUG_CALL_STACK_SAME_FILE
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
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.10 ms После последнего запроса: 6.47 ms Память запроса: 0.020 MB Память до запроса: 7.345 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `ulkb1_assets`

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

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

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

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.32 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
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/joomla/table/asset.php:60
11	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:304
10	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:714
9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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.85 ms После последнего запроса: 0.72 ms Память запроса: 0.015 MB Память до запроса: 7.409 MB Выбрано строк: 1

SELECT *

  FROM ulkb1_assets

  WHERE `id` = '1'

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
10	JTable->load()	JROOT/libraries/joomla/access/access.php:715
9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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.51 ms После последнего запроса: 0.22 ms Память запроса: 0.013 MB Память до запроса: 7.421 MB Выбрано строк: 1

SELECT a.rules

  FROM ulkb1_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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.53 ms После последнего запроса: 0.78 ms Память запроса: 0.015 MB Память до запроса: 7.470 MB Выбрано строк: 34

SELECT element

  FROM ulkb1_extensions

  WHERE type = 'component' 
  AND enabled = '1'

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:412
10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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.62 ms После последнего запроса: 0.23 ms Память запроса: 0.015 MB Память до запроса: 7.494 MB Выбрано строк: 34

SELECT a.name, a.rules

  FROM ulkb1_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jak2filter','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_mapyandex','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	idx_asset_name	Индекс не используется	NULL	NULL	44	79.55	Using where

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

Status	Duration
starting	0.04 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.01 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.36 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:439
10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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 для получения ссылок на файлы]

Время запроса: 2.43 ms После последнего запроса: 11.80 ms Память запроса: 0.022 MB Память до запроса: 8.893 MB Выбрано строк: 14

SHOW FULL COLUMNS 
  FROM `ulkb1_k2_categories`

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
13	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:304
12	JTable::getInstance()	JROOT/components/com_k2/views/latest/view.html.php:45
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.73 ms После последнего запроса: 0.40 ms Память запроса: 0.017 MB Память до запроса: 8.942 MB Выбрано строк: 1

SELECT * 
  FROM ulkb1_k2_categories 
  WHERE id = '27'

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

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

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

Status	Duration
starting	0.05 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.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.20 ms
cleaning up	0.03 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
12	TableK2Category->load()	JROOT/components/com_k2/views/latest/view.html.php:46
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.70 ms После последнего запроса: 0.62 ms Память запроса: 0.017 MB Память до запроса: 8.993 MB Выбрано строк: 1

SELECT * 
  FROM ulkb1_k2_categories 
  WHERE id = '7'

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
12	TableK2Category->load()	JROOT/components/com_k2/views/latest/view.html.php:71
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.99 ms После последнего запроса: 11.11 ms Память запроса: 0.018 MB Память до запроса: 9.907 MB Выбрано строк: 3

SELECT id
						
  FROM ulkb1_k2_categories 
						
  WHERE parent IN (27) 
						
  AND id NOT IN (27) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1,5)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	3	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:622
13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:112
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/latest/view.html.php:118
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.66 ms После последнего запроса: 0.13 ms Память запроса: 0.018 MB Память до запроса: 9.927 MB Выбрано строк: 0

SELECT id
						
  FROM ulkb1_k2_categories 
						
  WHERE parent IN (16,17,20) 
						
  AND id NOT IN (16,17,20) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1,5)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_categories	ref	PRIMARY,category,parent,published,access,trash	category	2	const	14	100.00	Using index condition; Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:622
13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:112
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/latest/view.html.php:118
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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 для получения ссылок на файлы]

Время запроса: 4.45 ms После последнего запроса: 0.19 ms Память запроса: 0.017 MB Память до запроса: 9.947 MB Выбрано строк: 8

SELECT i.*, 
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM ulkb1_k2_items as i 
  LEFT JOIN ulkb1_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-08-22 07:22:32' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-08-22 07:22:32' ) 
  AND c.id IN (27,16,17,20) 
  ORDER BY i.created DESC 
  LIMIT 0, 8

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	index	item,catid	created	5	NULL	10	1600.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	mehoffby_base.i.catid	1	100.00	Using index condition; Using where

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.90 ms
init	0.02 ms
checking query cache for query	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.66 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.14 ms
Waiting for query cache lock	0.01 ms
Sending data	0.36 ms
Waiting for query cache lock	0.01 ms
Sending data	0.08 ms
Waiting for query cache lock	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
freeing items	0.57 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:342
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/latest/view.html.php:118
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.53 ms После последнего запроса: 0.76 ms Память запроса: 0.021 MB Память до запроса: 10.074 MB Выбрано строк: 1

SELECT * 
  FROM ulkb1_k2_categories 
  WHERE id = '17'

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:70
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.96 ms После последнего запроса: 1.75 ms Память запроса: 0.021 MB Память до запроса: 10.150 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=207 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

Status	Duration
starting	0.05 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	1.44 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.73 ms После последнего запроса: 4.40 ms Память запроса: 0.022 MB Память до запроса: 10.219 MB Выбрано строк: 1

SELECT * 
  FROM ulkb1_k2_categories 
  WHERE id = '16'

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:70
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.52 ms После последнего запроса: 1.51 ms Память запроса: 0.021 MB Память до запроса: 10.288 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=204 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.44 ms После последнего запроса: 2.82 ms Память запроса: 0.022 MB Память до запроса: 10.281 MB Выбрано строк: 1

SELECT * 
  FROM ulkb1_k2_categories 
  WHERE id = '20'

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

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

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:70
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.47 ms После последнего запроса: 1.59 ms Память запроса: 0.021 MB Память до запроса: 10.349 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=183 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.55 ms После последнего запроса: 3.85 ms Память запроса: 0.021 MB Память до запроса: 10.380 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=199 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.56 ms После последнего запроса: 3.81 ms Память запроса: 0.021 MB Память до запроса: 10.411 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=200 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.58 ms После последнего запроса: 3.78 ms Память запроса: 0.021 MB Память до запроса: 10.443 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=202 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.89 ms После последнего запроса: 4.04 ms Память запроса: 0.022 MB Память до запроса: 10.475 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=195 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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 После последнего запроса: 4.38 ms Память запроса: 0.021 MB Память до запроса: 10.506 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM ulkb1_k2_comments 
  WHERE itemID=194 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ulkb1_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

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

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

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1571
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:258
15	K2ModelItem->prepareItem()	PLG_DEBUG_CALL_STACK_SAME_FILE
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/latest/view.html.php:128
11	K2ViewLatest->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/latest.php:32
8	K2ControllerLatest->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:62
6	require_once JROOT/components/com_k2/k2.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.89 ms После последнего запроса: 9.33 ms Память запроса: 0.016 MB Память до запроса: 10.732 MB Выбрано строк: 6

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

  FROM ulkb1_modules AS m

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

  LEFT JOIN ulkb1_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 <= '2017-08-22 07:22:32') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-08-22 07:22:32') 
  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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	14	100.00	Using index condition; Using where; Используется filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	mehoffby_base.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	mehoffby_base.m.module,const	1	100.00	Using index condition; Using where

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

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.57 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.38 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/protostar/index.php:51
7	require JROOT/templates/protostar/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1048
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.10 ms После последнего запроса: 19.45 ms Память запроса: 0.012 MB Память до запроса: 11.648 MB Выбрано строк: 1

SELECT updatetime 
  FROM ulkb1_jak2filter 
  WHERE `name` = 'cron'

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

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

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

Status	Duration
starting	0.08 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	1.55 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	PLG_DEBUG_CALL_STACK_CALLER	PLG_DEBUG_CALL_STACK_FILE_AND_LINE
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/plugins/k2/jak2filter/jak2filter.php:194
8	plgK2Jak2filter->onAfterRender()	PLG_DEBUG_CALL_STACK_SAME_FILE
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

8 × SELECT COUNT(*) 
  FROM ulkb1_k2_comments

5 × SELECT * 
  FROM ulkb1_k2_categories

2 × SELECT id       
  FROM ulkb1_k2_categories

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

1 × SELECT element 
  FROM ulkb1_extensions

1 × SELECT a.name, a.rules 
  FROM ulkb1_assets AS a

1 × SELECT i.*, 
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM ulkb1_k2_items as i 
  LEFT JOIN ulkb1_k2_categories AS c 
  ON c.id = i.catid

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

1 × SELECT a.rules 
  FROM ulkb1_assets AS a

1 × SELECT updatetime 
  FROM ulkb1_jak2filter

```
1 × SELECT * 
  FROM ulkb1_assets
```

1 × SELECT id, rules 
  FROM `ulkb1_viewlevels

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

1 × SELECT `session_id` 
  FROM `ulkb1_session`

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

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

```
1 × SELECT * 
  FROM ulkb1_languages
```

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

1 × SELECT `data` 
  FROM `ulkb1_session`

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

1 × SHOW FULL COLUMNS 
  FROM `ulkb1_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `ulkb1_assets

1 × UPDATE `ulkb1_extensions` 
  SET `params` = '{\"mediaversion\":\"ba39cb07c7ab997b62067aa7312fdb61\"}'

1 × INSERT INTO `ulkb1_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('t5g0ddar67krhvarh5bkdj4631', 0, '1503386552'