Content

×** [Flexisystem PLG: Adding css classes to BODY: 0.000 s]

0.000 seconds (0.000); 3.06 MB (3.064) - START: FLEXIcontent component
0.023 seconds (0.023); 3.62 MB (0.552) - END: FLEXIcontent component: (VIEW: flexicontent)

-- [Initialize component: 0.00 s]
-- [FC "flexicontent" view Template Rendering: 0.00 s]

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714363066,
                "last": 1714363066,
                "now": 1714363066
            },
            "token": "KrdQmN7cFcZORVP9w83NmSVX6k5qkMvs"
        },
        "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
        }
    }
}

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

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Такой же, как вызов в строке ниже
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN недоступен для: INSERT INTO `k0nc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6430623361313061613838383534666662613731373833313235323431393230', 1, 1714363066, 0, '', 0)

Профиль

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.02 ms
update	0.09 ms
end	0.00 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.69 ms После последнего запроса: 1.63 ms Память запроса: 0.040 MB. Память перед запросом: 1.373 MB Возвращено строк: 36

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

  FROM `k0nc_extensions`

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_extensions	NULL	ref	extension	extension	82	const	36	1.00	Using where

Профиль

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Такой же, как вызов в строке ниже
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 1.01 ms Память запроса: 0.021 MB. Память перед запросом: 1.414 MB Возвращено строк: 5

SELECT id, rules

  FROM `k0nc_viewlevels`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_viewlevels	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	5	100.00	NULL

Профиль

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.30 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB. Память перед запросом: 1.426 MB Возвращено строк: 2

SELECT b.id

  FROM k0nc_usergroups AS a

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

  WHERE a.id = 9

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.75 ms После последнего запроса: 1.09 ms Память запроса: 0.077 MB. Память перед запросом: 1.452 MB Возвращено строк: 116

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

  FROM k0nc_extensions

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

  ORDER BY ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_extensions	NULL	ref	extension	extension	82	const	138	0.60	Using index condition; Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.59 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.42 ms После последнего запроса: 3.35 ms Память запроса: 0.021 MB. Память перед запросом: 1.947 MB Возвращено строк: 1

SELECT lft,rgt 
  FROM k0nc_categories 
  WHERE id=1

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

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

Профиль

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/defineconstants.php:100
8	require_once JROOT/administrator/components/com_flexicontent/defineconstants.php	JROOT/plugins/system/flexisystem/flexisystem.php:19
7	require_once JROOT/plugins/system/flexisystem/flexisystem.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.53 ms После последнего запроса: 7.39 ms Память запроса: 0.021 MB. Память перед запросом: 2.177 MB Возвращено строк: 0

SELECT DISTINCT userid 
  FROM k0nc_session 
  WHERE guest=0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_session	NULL	index	userid	userid	5	NULL	119	10.00	Using where

Профиль

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.37 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/flexisystem/flexisystem.php:1382
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 0.03 ms Память запроса: 0.021 MB. Память перед запросом: 2.182 MB Возвращено строк: 0

SELECT id, checked_out, checked_out_time 
  FROM k0nc_content 
  WHERE checked_out > 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_content	NULL	range	idx_checkout	idx_checkout	4	NULL	1	100.00	Using index condition

Профиль

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.13 ms После последнего запроса: 0.02 ms Память запроса: 0.021 MB. Память перед запросом: 2.187 MB Возвращено строк: 0

SELECT id, checked_out, checked_out_time 
  FROM k0nc_categories 
  WHERE checked_out > 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_categories	NULL	range	idx_checkout	idx_checkout	4	NULL	1	100.00	Using index condition

Профиль

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.28 ms После последнего запроса: 0.02 ms Память запроса: 0.021 MB. Память перед запросом: 2.192 MB Возвращено строк: 0

SELECT id, checked_out, checked_out_time 
  FROM k0nc_modules 
  WHERE checked_out > 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_modules	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	32	33.33	Using where

Профиль

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.37 ms После последнего запроса: 0.02 ms Память запроса: 0.021 MB. Память перед запросом: 2.197 MB Возвращено строк: 0

SELECT id, checked_out, checked_out_time 
  FROM k0nc_menu 
  WHERE checked_out > 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_menu	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	65	33.33	Using where

Профиль

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.42 ms После последнего запроса: 1.55 ms Память запроса: 0.048 MB. Память перед запросом: 2.238 MB Возвращено строк: 23

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

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	INDEX KEY не используется	NULL	NULL	65	4.00	Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	keuees_konc.m.component_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.22 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Такой же, как вызов в строке ниже
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.26 ms После последнего запроса: 3.29 ms Память запроса: 0.024 MB. Память перед запросом: 2.488 MB Возвращено строк: 1

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

  FROM `k0nc_extensions`

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

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

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

Профиль

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Такой же, как вызов в строке ниже
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/flexisystem/flexisystem.php:251
8	plgSystemFlexisystem->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.19 ms Память запроса: 0.006 MB. Память перед запросом: 2.480 MB

UPDATE `k0nc_extensions`

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

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

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/flexisystem/flexisystem.php:251
8	plgSystemFlexisystem->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.52 ms После последнего запроса: 0.95 ms Память запроса: 0.022 MB. Память перед запросом: 2.508 MB Возвращено строк: 7

SELECT id, home, template, s.params

  FROM k0nc_template_styles as s

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	keuees_konc.e.element	1	77.78	Using index condition; Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:195
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.32 ms После последнего запроса: 5.47 ms Память запроса: 0.023 MB. Память перед запросом: 2.852 MB Возвращено строк: 3

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM k0nc_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'g5_hydrogen'

  ORDER BY s.id

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	const	3	77.78	Using index condition; Using where

Профиль

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:304
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.52 ms После последнего запроса: 3.80 ms Память запроса: 0.019 MB. Память перед запросом: 2.985 MB Возвращено строк: 2

SELECT *

  FROM k0nc_languages

  WHERE published=1

  ORDER BY ordering ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_languages	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	50.00	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.69 ms После последнего запроса: 12.09 ms Память запроса: 0.028 MB. Память перед запросом: 3.249 MB Возвращено строк: 36

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

  FROM `k0nc_assets`

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	k0nc_assets	NULL	ALL	idx_asset_name	INDEX KEY не используется	NULL	NULL	135	27.41	Using where

Профиль

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_flexicontent/models/flexicontent.php:223
14	FlexicontentModelFlexicontent->_buildQuery()	JROOT/components/com_flexicontent/models/flexicontent.php:139
13	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.06 ms После последнего запроса: 0.46 ms Память запроса: 0.041 MB. Память перед запросом: 3.330 MB Возвращено строк: 5

SELECT c.*, u.name as author, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'ru-RU' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assigneditems 
  FROM k0nc_categories AS c 
  LEFT JOIN k0nc_users AS u 
  ON u.id = c.created_user_id 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 1 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title 
  LIMIT 0, 100

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where; Используется сортировка файлов
1	PRIMARY	u	NULL	eq_ref	PRIMARY	PRIMARY	4	keuees_konc.c.created_user_id	1	100.00	Using where
2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	keuees_konc.c.id	1	10.00	Using where
2	DEPENDENT SUBQUERY	rel	NULL	ref	PRIMARY,catid,itemid	catid	4	keuees_konc.c.id	9	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	i	NULL	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	keuees_konc.rel.itemid	1	16.00	Using where
2	DEPENDENT SUBQUERY	ty	NULL	eq_ref	PRIMARY,access	PRIMARY	4	keuees_konc.i.type_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.86 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
Sorting result	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
executing	0.00 ms
Sending data	0.10 ms
executing	0.00 ms
Sending data	0.12 ms
executing	0.00 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.02 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_flexicontent/models/flexicontent.php:139
13	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.71 ms После последнего запроса: 0.12 ms Память запроса: 0.023 MB. Память перед запросом: 3.381 MB Возвращено строк: 0

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'ru-RU' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM k0nc_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM k0nc_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 2 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where; Используется сортировка файлов
3	DEPENDENT SUBQUERY	sc	NULL	ALL	idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where
2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	keuees_konc.c.id	1	10.00	Using where
2	DEPENDENT SUBQUERY	rel	NULL	ref	PRIMARY,catid,itemid	catid	4	keuees_konc.c.id	9	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	i	NULL	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	keuees_konc.rel.itemid	1	16.00	Using where
2	DEPENDENT SUBQUERY	ty	NULL	eq_ref	PRIMARY,access	PRIMARY	4	keuees_konc.i.type_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.07 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
14	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
13	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.49 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB. Память перед запросом: 3.390 MB Возвращено строк: 0

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'ru-RU' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM k0nc_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM k0nc_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 8 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where; Используется сортировка файлов
3	DEPENDENT SUBQUERY	sc	NULL	ALL	idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where
2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	keuees_konc.c.id	1	10.00	Using where
2	DEPENDENT SUBQUERY	rel	NULL	ref	PRIMARY,catid,itemid	catid	4	keuees_konc.c.id	9	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	i	NULL	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	keuees_konc.rel.itemid	1	16.00	Using where
2	DEPENDENT SUBQUERY	ty	NULL	eq_ref	PRIMARY,access	PRIMARY	4	keuees_konc.i.type_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
14	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
13	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.56 ms После последнего запроса: 0.04 ms Память запроса: 0.023 MB. Память перед запросом: 3.399 MB Возвращено строк: 0

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'ru-RU' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM k0nc_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM k0nc_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 9 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where; Используется сортировка файлов
3	DEPENDENT SUBQUERY	sc	NULL	ALL	idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where
2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	keuees_konc.c.id	1	10.00	Using where
2	DEPENDENT SUBQUERY	rel	NULL	ref	PRIMARY,catid,itemid	catid	4	keuees_konc.c.id	9	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	i	NULL	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	keuees_konc.rel.itemid	1	16.00	Using where
2	DEPENDENT SUBQUERY	ty	NULL	eq_ref	PRIMARY,access	PRIMARY	4	keuees_konc.i.type_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
14	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
13	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.69 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB. Память перед запросом: 3.407 MB Возвращено строк: 0

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'ru-RU' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM k0nc_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM k0nc_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 10 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where; Используется сортировка файлов
3	DEPENDENT SUBQUERY	sc	NULL	ALL	idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where
2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	keuees_konc.c.id	1	10.00	Using where
2	DEPENDENT SUBQUERY	rel	NULL	ref	PRIMARY,catid,itemid	catid	4	keuees_konc.c.id	9	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	i	NULL	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	keuees_konc.rel.itemid	1	16.00	Using where
2	DEPENDENT SUBQUERY	ty	NULL	eq_ref	PRIMARY,access	PRIMARY	4	keuees_konc.i.type_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.14 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
14	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
13	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.67 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB. Память перед запросом: 3.415 MB Возвращено строк: 0

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'ru-RU' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM k0nc_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM k0nc_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 11 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where; Используется сортировка файлов
3	DEPENDENT SUBQUERY	sc	NULL	ALL	idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where
2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	keuees_konc.c.id	1	10.00	Using where
2	DEPENDENT SUBQUERY	rel	NULL	ref	PRIMARY,catid,itemid	catid	4	keuees_konc.c.id	9	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	i	NULL	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	keuees_konc.rel.itemid	1	16.00	Using where
2	DEPENDENT SUBQUERY	ty	NULL	eq_ref	PRIMARY,access	PRIMARY	4	keuees_konc.i.type_id	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
14	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
13	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.21 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB. Память перед запросом: 3.421 MB Возвращено строк: 5

SELECT c.id 
  FROM k0nc_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 1 
  AND c.access IN (0,1,1,5)

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access	INDEX KEY не используется	NULL	NULL	10	10.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_flexicontent/models/flexicontent.php:326
13	FlexicontentModelFlexicontent->getTotal()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:55
11	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.42 ms После последнего запроса: 13.00 ms Память запроса: 0.035 MB. Память перед запросом: 4.089 MB Возвращено строк: 2

SELECT a.menutype

  FROM k0nc_menu_types AS a

  WHERE a.client_id = 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	50.00	Using where

Профиль

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
43	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
42	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
41	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
39	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/04/044a99fc4afe831c278d59c760d3754c5501b763e076cbe22b2d3adc478ef54e.php:32
38	__TwigTemplate_abe408e5806812acde8de3b2ddae4f06b7d350277865e863347db8c8323e8a4c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/bf/bfc721f933e8dbc421175ff417c73c9dd70c1417a9d21048f4317f536124a923.php:71
35	__TwigTemplate_b03bdd93e11c8f0a454a4c4a94f59b6567b38a90017902ebb1e0af97d9e07690->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/e8/e8a7820de124bf69728a19f34f61992fdc1c43ab0fd0542c209abc8d6843c2cf.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/8d/8da9c74876eba78eb8aef4f7a95e3838449d7ef48c73532b8526c5268febf94d.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/81/8185070b0fb05aa12b3d83b5556f245a99ef880efa5e9468dd59cadefccbcfb3.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:23
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.77 ms После последнего запроса: 7.10 ms Память запроса: 0.038 MB. Память перед запросом: 4.594 MB Возвращено строк: 6

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

  FROM k0nc_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-29 03:57:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-29 03:57:46') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 117 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	INDEX KEY не используется	NULL	NULL	32	3.12	Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	keuees_konc.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	keuees_konc.m.id	1	40.00	Using where; Using index

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
51	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
50	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
49	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
48	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
47	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
46	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
44	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/8a/8aa5ed13afe614290bdbe5802a199e9e06543065eb1031106ac09341b9555df7.php:43
43	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
42	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/2b/2b7057a53c7fae43dedb18c6597d67a67503946ea7f781a45fc50e72ff8abdec.php:73
41	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/8a/8aa5ed13afe614290bdbe5802a199e9e06543065eb1031106ac09341b9555df7.php:35
38	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/47/47363a3d3a79d6d5090c614f67325a2ea4e4ddd366b811676d5468c5cdb53c60.php:53
35	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/e8/e8a7820de124bf69728a19f34f61992fdc1c43ab0fd0542c209abc8d6843c2cf.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/8d/8da9c74876eba78eb8aef4f7a95e3838449d7ef48c73532b8526c5268febf94d.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/81/8185070b0fb05aa12b3d83b5556f245a99ef880efa5e9468dd59cadefccbcfb3.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:23
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

24 типов запросов зарегистрировано (отсортировано по вхождениям)

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

5 × SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid

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

1 × SELECT `data` 
  FROM `k0nc_session`

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

1 × SELECT a.menutype 
  FROM k0nc_menu_types AS a

1 × SELECT c.id 
  FROM k0nc_categories AS c

1 × SELECT c.*, u.name as author, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN k0nc_categories AS cc 
  ON cc.id = rel.catid

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `k0nc_assets`

```
1 × SELECT * 
  FROM k0nc_languages
```

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM k0nc_template_styles AS s

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

1 × SELECT id, checked_out, checked_out_time 
  FROM k0nc_menu

1 × SELECT `session_id` 
  FROM `k0nc_session`

1 × SELECT id, checked_out, checked_out_time 
  FROM k0nc_modules

1 × SELECT id, checked_out, checked_out_time 
  FROM k0nc_categories

1 × SELECT id, checked_out, checked_out_time 
  FROM k0nc_content

1 × SELECT DISTINCT userid 
  FROM k0nc_session

1 × SELECT lft,rgt 
  FROM k0nc_categories

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

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

1 × SELECT id, rules 
  FROM `k0nc_viewlevels

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

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

1 × INSERT INTO `k0nc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6430623361313061613838383534666662613731373833313235323431393230', 1, 1714363066, 0, '', 0

1 × UPDATE `k0nc_extensions` 
  SET `params` = '{\"mediaversion\":\"f1fe5fc9c428300d27618d70ed17fdc2\"}'

Categories

Uncategorised

Сведения об образовательной организации

Новости

Направления деятельности

Семинары

teamlab

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

Сессия

Профилирование

Время

Память

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

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

29 запросов зарегистрировано 14.31 ms

24 типов запросов зарегистрировано (отсортировано по вхождениям)

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

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