Виртуальная выставка «Время жить и время умирать»

Национальная электронная библиотека

крупнейшее собрание книг, диссертаций, музыкальных нот, карт и прочих материалов.

«НЭБ Свет» - мобильное приложение

Художественная литература и современный научпоп — в одном приложении.

WWW.КУЛЬТУРА.РФ - Твой гид по культуре.

Узнайте больше об истории страны, искусстве и планируйте культурные выходные на портале «Культура.РФ»

Покупка билетов

в театры, музеи, филармонии, кинотеатры и др. на средства из федерального бюджета.

Пушкинская карта

Как получить. Где и как использовать.

Виртуальная выставка «Время жить и время умирать»

Автор Гулова В. - заведующая информационно-библиографическим отделом

размер шрифта уменьшить размер шрифта увеличить размер шрифта
Печать

Оцените материал

(0 голосов)

Вернуться назад Наверх

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1791266257,
                "last": 1791266257,
                "now": 1791266257
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "dc372db7e968c7c5212a45066134f2e62a4fa52f": {
                    "link": "https://sedlib.ru/index.php/deyatelnost/virtualnye-vystavki/item/549-virtualnaya-vystavka-vremya-zhit-i-vremya-umirat",
                    "expiry": 1791266258
                }
            }
        }
    }
}

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

Время

Память

Время: 20.40 ms / 20.40 ms Память: 0.408 MB / 0.75 MB Application: afterLoad

Время: 88.23 ms / 108.63 ms Память: 1.270 MB / 2.02 MB Application: afterInitialise

Время: 42.69 ms / 151.32 ms Память: 0.465 MB / 2.49 MB Application: afterRoute

Время: 1.65 ms / 152.97 ms Память: 0.018 MB / 2.50 MB Application: beforeRenderComponent com_k2

Время: 0.32 ms / 153.29 ms Память: 0.018 MB / 2.52 MB Application: Before Access::preloadComponents (all components)

Время: 1.38 ms / 154.67 ms Память: 0.055 MB / 2.58 MB Application: After Access::preloadComponents (all components)

Время: 0.04 ms / 154.71 ms Память: -0.002 MB / 2.58 MB Application: Before Access::getAssetRules (id:57 name:com_k2)

Время: 1.18 ms / 155.89 ms Память: 0.010 MB / 2.59 MB Application: After Access::getAssetRules (id:57 name:com_k2)

Время: 51.28 ms / 207.17 ms Память: 0.654 MB / 3.24 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.03 ms / 207.21 ms Память: 0.002 MB / 3.24 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 29.54 ms / 236.75 ms Память: 0.286 MB / 3.53 MB Application: afterRenderComponent com_k2

Время: 8.70 ms / 245.45 ms Память: 0.008 MB / 3.54 MB Application: afterDispatch

Время: 9.17 ms / 254.61 ms Память: 0.155 MB / 3.69 MB Application: beforeRenderModule mod_custom (Подвал)

Время: 2.27 ms / 256.88 ms Память: 0.007 MB / 3.70 MB Application: afterRenderModule mod_custom (Подвал)

Время: 0.06 ms / 256.94 ms Память: -0.002 MB / 3.70 MB Application: beforeRenderModule mod_easycookieinfo (EasyCookieInfo)

Время: 2.17 ms / 259.10 ms Память: 0.015 MB / 3.71 MB Application: afterRenderModule mod_easycookieinfo (EasyCookieInfo)

Время: 0.09 ms / 259.19 ms Память: -0.000 MB / 3.71 MB Application: beforeRenderModule mod_custom (Результаты независимой оценки)

Время: 0.95 ms / 260.15 ms Память: 0.004 MB / 3.72 MB Application: afterRenderModule mod_custom (Результаты независимой оценки)

Время: 0.08 ms / 260.23 ms Память: -0.001 MB / 3.71 MB Application: beforeRenderModule mod_custom (Книжные новинки)

Время: 59.23 ms / 319.46 ms Память: 0.283 MB / 4.00 MB Application: afterRenderModule mod_custom (Книжные новинки)

Время: 0.14 ms / 319.60 ms Память: -0.002 MB / 4.00 MB Application: beforeRenderModule mod_custom (Календарь событий)

Время: 0.95 ms / 320.55 ms Память: 0.004 MB / 4.00 MB Application: afterRenderModule mod_custom (Календарь событий)

Время: 0.08 ms / 320.63 ms Память: -0.001 MB / 4.00 MB Application: beforeRenderModule mod_custom (Банеры)

Время: 20.65 ms / 341.28 ms Память: 0.104 MB / 4.10 MB Application: afterRenderModule mod_custom (Банеры)

Время: 0.10 ms / 341.38 ms Память: -0.001 MB / 4.10 MB Application: beforeRenderModule mod_custom (Поиск по сайту)

Время: 0.79 ms / 342.16 ms Память: 0.003 MB / 4.11 MB Application: afterRenderModule mod_custom (Поиск по сайту)

Время: 0.04 ms / 342.20 ms Память: -0.001 MB / 4.10 MB Application: beforeRenderModule mod_custom (Год чего в России)

Время: 0.77 ms / 342.97 ms Память: 0.003 MB / 4.11 MB Application: afterRenderModule mod_custom (Год чего в России)

Время: 0.12 ms / 343.09 ms Память: 0.024 MB / 4.13 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)

Время: 8.19 ms / 351.28 ms Память: 0.107 MB / 4.24 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)

Время: 0.17 ms / 351.45 ms Память: -0.057 MB / 4.18 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu)

Время: 60.32 ms / 411.77 ms Память: 0.290 MB / 4.47 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu)

Время: 0.13 ms / 411.90 ms Память: -0.031 MB / 4.44 MB Application: beforeRenderModule mod_custom (Логотип правый)

Время: 0.78 ms / 412.68 ms Память: 0.006 MB / 4.45 MB Application: afterRenderModule mod_custom (Логотип правый)

Время: 0.05 ms / 412.72 ms Память: 0.001 MB / 4.45 MB Application: beforeRenderModule mod_ext_css_panel (EXT CSS Panel)

Время: 1.74 ms / 414.47 ms Память: 0.010 MB / 4.46 MB Application: afterRenderModule mod_ext_css_panel (EXT CSS Panel)

Время: 0.05 ms / 414.52 ms Память: -0.005 MB / 4.45 MB Application: beforeRenderModule mod_custom (Логотип левый)

Время: 0.73 ms / 415.24 ms Память: 0.003 MB / 4.45 MB Application: afterRenderModule mod_custom (Логотип левый)

Время: 25.69 ms / 440.93 ms Память: 0.318 MB / 4.77 MB Application: afterRender

Всего запросов к базе данных: 42.68 ms

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:604
10	JDatabaseDriverPdomysql->hasQueryCacheEnabled()	JROOT/libraries/joomla/database/driver/pdomysql.php:160
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:590
10	JDatabaseDriverPdomysql->hasProfiling()	JROOT/libraries/joomla/database/driver/pdomysql.php:165
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_session	const	PRIMARY	PRIMARY	194	const	1

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverPdo->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:854
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverPdo->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:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverPdo->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:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 1.02 ms После последнего запроса: 4.85 ms

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

  FROM `lib_extensions`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.41 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverPdo->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.35 ms После последнего запроса: 3.53 ms

SELECT id, rules

  FROM `lib_viewlevels`

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

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

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.54 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverPdo->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.41 ms После последнего запроса: 0.16 ms

SELECT b.id

  FROM lib_usergroups AS a

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

  WHERE a.id = 9

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

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

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverPdo->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 для получения ссылок на файлы]

Время запроса: 1.00 ms После последнего запроса: 0.35 ms

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

  FROM lib_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_extensions	ALL	extension	INDEX KEY не используется	NULL	NULL	279	Using where; Используется сортировка файлов

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.06 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverPdo->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.68 ms После последнего запроса: 32.90 ms

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

  FROM `lib_extensions`

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

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

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

Профиль

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.40 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverPdo->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/k2/k2.php:47
8	plgSystemK2->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:696
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.35 ms После последнего запроса: 0.26 ms

UPDATE `lib_extensions`

  SET `params` = '{\"mediaversion\":\"629e6863cb2267c4de4f3aa4ac0a91f6\"}'

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

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

EXPLAIN недоступен для: UPDATE `lib_extensions` SET `params` = '{\"mediaversion\":\"629e6863cb2267c4de4f3aa4ac0a91f6\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профиль

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverPdo->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/k2/k2.php:47
8	plgSystemK2->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:696
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 для получения ссылок на файлы]

Время запроса: 1.09 ms После последнего запроса: 17.01 ms

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

  LEFT JOIN lib_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	63	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.m.component_id	1	Using where

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	3.79 ms
Reset for next command	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverPdo->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:445
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1169
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.40 ms После последнего запроса: 20.69 ms

SELECT *

  FROM lib_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

Профиль

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.16 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.10 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:235
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->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:1218
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.49 ms После последнего запроса: 4.09 ms

SELECT id, home, template, s.params

  FROM lib_template_styles as s

  LEFT JOIN lib_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX KEY не используется	NULL	NULL	7	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	cl478957_sedlib.s.template,const	1	Using index condition; Using where

Профиль

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.09 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Такой же, как вызов в строке ниже
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:259
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->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:1218
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 для получения ссылок на файлы]

Время запроса: 1.01 ms После последнего запроса: 12.70 ms

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

  FROM `lib_assets`

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

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

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

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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.54 ms После последнего запроса: 10.65 ms

SELECT id 
  FROM lib_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_k2_categories	range	access,category,published,trash	category	8	NULL	13	Using where; Using index

Профиль

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.33 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.10 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.48 ms После последнего запроса: 0.13 ms

SELECT * 
  FROM lib_k2_items 
  WHERE id=549 
  LIMIT 1

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

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

Профиль

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.90 ms После последнего запроса: 1.16 ms

SHOW FULL COLUMNS 
  FROM `lib_k2_categories`

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

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `lib_k2_categories`

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	2.89 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
17	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.45 ms После последнего запроса: 2.29 ms

SELECT * 
  FROM lib_k2_categories 
  WHERE id = '10'

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

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

Профиль

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.35 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.09 ms
closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.01 ms
Removing tmp table	0.13 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.58 ms После последнего запроса: 6.13 ms

SELECT * 
  FROM lib_k2_rating 
  WHERE itemID = 549

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

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

Профиль

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:887
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:931
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:161
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.96 ms После последнего запроса: 2.79 ms

SHOW FULL COLUMNS 
  FROM `lib_users`

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

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `lib_users`

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
22	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.33 ms После последнего запроса: 0.17 ms

Повторяющиеся запросы: #27

SELECT *

  FROM `lib_users`

  WHERE `id` = 572

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

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

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.52 ms После последнего запроса: 1.64 ms

Повторяющиеся запросы: #28

SELECT `g`.`id`,`g`.`title`

  FROM `lib_usergroups` AS g

  INNER JOIN `lib_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 572

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.m.group_id	1

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.43 ms После последнего запроса: 1.36 ms

Повторяющиеся запросы: #25

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM lib_k2_users 
  WHERE userID=572

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_k2_users	ref	userID	userID	4	const	1

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1668
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:204
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.29 ms После последнего запроса: 0.09 ms

Повторяющиеся запросы: #24

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM lib_k2_users 
  WHERE userID=572

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_k2_users	ref	userID	userID	4	const	1

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1668
13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:205
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.35 ms После последнего запроса: 0.10 ms

SELECT COUNT(*) 
  FROM lib_k2_comments 
  WHERE itemID=549 
  AND published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_k2_comments	ref	countComments,itemID,latestComments,published	countComments	8	const,const	1	Using index

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1457
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.66 ms После последнего запроса: 23.22 ms

Повторяющиеся запросы: #22

SELECT *

  FROM `lib_users`

  WHERE `id` = 572

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

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

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
20	Joomla\CMS\Table\User->load()	JROOT/plugins/system/sourcerer/src/Security.php:62
19	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/src/Helper.php:35
18	RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare()	Такой же, как вызов в строке ниже
17	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:106
16	RegularLabs\Plugin\System\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/sourcerer.php:51
15	PlgSystemSourcerer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.43 ms После последнего запроса: 0.16 ms

Повторяющиеся запросы: #23

SELECT `g`.`id`,`g`.`title`

  FROM `lib_usergroups` AS g

  INNER JOIN `lib_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 572

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.m.group_id	1

Профиль

Status	Duration
Starting	0.26 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.07 ms
Statistics	0.22 ms
Preparing	0.06 ms
Creating tmp table	0.11 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.41 ms
Creating sort index	0.04 ms
Removing tmp table	0.09 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	2.99 ms
Reset for next command	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
20	Joomla\CMS\Table\User->load()	JROOT/plugins/system/sourcerer/src/Security.php:62
19	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/src/Helper.php:35
18	RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare()	Такой же, как вызов в строке ниже
17	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:106
16	RegularLabs\Plugin\System\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/sourcerer.php:51
15	PlgSystemSourcerer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.41 ms После последнего запроса: 0.11 ms

SELECT b.id

  FROM lib_user_usergroup_map AS map

  LEFT JOIN lib_usergroups AS a 
  ON a.id = map.group_id

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

  WHERE map.user_id = 572

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	2	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.map.group_id	1
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	INDEX KEY не используется	NULL	NULL	9	Range checked for each record (index map: 0x10)

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
21	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
20	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/plugins/system/sourcerer/src/Security.php:67
19	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/src/Helper.php:35
18	RegularLabs\Plugin\System\Sourcerer\Helper->onContentPrepare()	Такой же, как вызов в строке ниже
17	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:106
16	RegularLabs\Plugin\System\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/sourcerer.php:51
15	PlgSystemSourcerer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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 для получения ссылок на файлы]

Время запроса: 1.86 ms После последнего запроса: 6.91 ms

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM lib_fields AS a

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

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

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

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

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

  LEFT JOIN `lib_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (10,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	cl478957_sedlib.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.id	1	Using where; Using index; Distinct

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.64 ms После последнего запроса: 5.28 ms

Повторяющиеся запросы: #32

SELECT *

  FROM `lib_itemrating_group`

  WHERE `customcategory` like '%\\\"com_k2\\\":[%\\\"10\\\"%]%' 
  AND `state`=1

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

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

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.30 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.13 ms
closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.13 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_itemrating/helpers/itemrating.php:1220
16	ItemratingHelper::allowCategory()	JROOT/plugins/k2/itemrating/itemrating.php:43
15	plgK2ItemRating->onK2BeforeDisplayContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:751
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.36 ms После последнего запроса: 0.16 ms

Повторяющиеся запросы: #31

SELECT *

  FROM `lib_itemrating_group`

  WHERE `customcategory` like '%\\\"com_k2\\\":[%\\\"10\\\"%]%' 
  AND `state`=1

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

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

Профиль

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.07 ms
Updating	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.36 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_itemrating/helpers/itemrating.php:1220
16	ItemratingHelper::allowCategory()	JROOT/plugins/k2/itemrating/itemrating.php:93
15	plgK2ItemRating->onK2AfterDisplayContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:758
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.93 ms После последнего запроса: 0.70 ms

SHOW FULL COLUMNS 
  FROM `lib_k2_items`

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

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `lib_k2_items`

Профиль

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.54 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
17	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
14	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:812
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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.76 ms После последнего запроса: 0.23 ms

UPDATE lib_k2_items

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

  WHERE `id` = '549'

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

EXPLAIN недоступен для: UPDATE lib_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '549'

Профиль

Status	Duration
Starting	0.25 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.07 ms
Statistics	0.18 ms
Preparing	0.06 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.38 ms
Creating sort index	0.04 ms
Removing tmp table	0.10 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Table/Table.php:1264
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:813
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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 для получения ссылок на файлы]

Время запроса: 1.47 ms После последнего запроса: 17.63 ms

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

  FROM lib_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-06 05:57:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-06 05:57:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 143 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	26	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	cl478957_sedlib.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	cl478957_sedlib.m.module,const	1	Using index condition; Using where

Профиль

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/sedlib/index.php:57
7	require JROOT/templates/sedlib/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.74 ms После последнего запроса: 12.91 ms

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM lib_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	cl478957_sedlib.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.a.group_id	1	Using where

Профиль

Status	Duration
Starting	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.58 ms После последнего запроса: 4.52 ms

SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `lib_sigplus_folder` 
  WHERE `folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/News/Novelties/022026'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_folder	const	folderurl	folderurl	769	const	1

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1773
24	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3073
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.43 ms После последнего запроса: 1.38 ms

SELECT viewid

  FROM lib_sigplus_view

  WHERE folderid = 822 
  AND hash = 0x426441e1675de428adc0d1073e66edf3

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_view	const	hash,lib_FK_sigplus_view_folder	hash	16	const	1

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.36 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1211
28	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1216
27	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1897
26	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1951
25	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
24	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3081
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.99 ms После последнего запроса: 0.11 ms

SELECT
i.`fileurl`,
i.`imageid`

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  WHERE h.`ancestorid` = 822 
  AND NOT EXISTS (SELECT * 
  FROM `lib_sigplus_imageview` AS v 
  WHERE i.`imageid` = v.`imageid` 
  AND v.`viewid` = 755) 
  AND depthnum <= 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	PRIMARY	i	ref	lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2	Using where
2	DEPENDENT SUBQUERY	v	unique_subquery	PRIMARY,lib_FK_sigplus_imageview_view	PRIMARY	8	func,const	1	Using index; Using where

Профиль

Status	Duration
Starting	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1811
28	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1813
27	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1900
26	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1951
25	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
24	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3081
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.26 ms После последнего запроса: 0.27 ms

Повторяющиеся запросы: #48

SELECT
`langid`

  FROM `lib_sigplus_language`

  WHERE
`lang` = 'ru'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_language	const	lang	lang	2	const	1	Using index

Профиль

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:317
24	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3159
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.27 ms После последнего запроса: 0.06 ms

Повторяющиеся запросы: #49

SELECT
`countryid`

  FROM `lib_sigplus_country`

  WHERE
`country` = 'RU'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_country	const	country	country	2	const	1	Using index

Профиль

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:332
24	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3160
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.65 ms После последнего запроса: 0.25 ms

Повторяющиеся запросы: #43

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `lib_sigplus_property` AS mp

  INNER JOIN `lib_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `lib_sigplus_property` AS mp

  INNER JOIN `lib_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `lib_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 136 
  AND 
p.`countryid` = 160 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `lib_sigplus_property` AS mp

  INNER JOIN `lib_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `lib_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 136 
  AND 
p.`countryid` = 160 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `lib_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `lib_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `lib_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 136 
  AND 
c.`countryid` = 160

  WHERE
a.`folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/News/Novelties/022026' 
  AND 
`viewid` = 755

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, RAND()

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Используется сортировка файлов
1	PRIMARY	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2
1	PRIMARY	v	eq_ref	PRIMARY,lib_FK_sigplus_imageview_view	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,lib_FK_sigplus_caption_language,lib_FK_sigplus_caption_country	PRIMARY	8	cl478957_sedlib.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,lib_FK_sigplus_foldercaption_language,lib_FK_sigplus_foldercaption_country	lib_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,lib_FK_sigplus_data_property	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,lib_FK_sigplus_foldercaption_language,lib_FK_sigplus_foldercaption_country	lib_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,lib_FK_sigplus_data_property	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,lib_FK_sigplus_data_property	PRIMARY	8	cl478957_sedlib.i.imageid,const	1

Профиль

Status	Duration
Starting	0.28 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.15 ms
Optimizing	0.05 ms
Statistics	0.20 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.03 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	1.05 ms
Creating sort index	0.70 ms
End of update loop	0.02 ms
Removing tmp table	0.17 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverPdo->execute()	JROOT/plugins/content/sigplus/core/core.php:3322
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.87 ms После последнего запроса: 0.12 ms

Повторяющиеся запросы: #42

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `lib_sigplus_property` AS mp

  INNER JOIN `lib_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `lib_sigplus_property` AS mp

  INNER JOIN `lib_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `lib_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 136 
  AND 
p.`countryid` = 160 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `lib_sigplus_property` AS mp

  INNER JOIN `lib_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `lib_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 136 
  AND 
p.`countryid` = 160 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `lib_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `lib_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `lib_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 136 
  AND 
c.`countryid` = 160

  WHERE
a.`folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/News/Novelties/022026' 
  AND 
`viewid` = 755

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, RAND()

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Используется сортировка файлов
1	PRIMARY	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2
1	PRIMARY	v	eq_ref	PRIMARY,lib_FK_sigplus_imageview_view	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,lib_FK_sigplus_caption_language,lib_FK_sigplus_caption_country	PRIMARY	8	cl478957_sedlib.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,lib_FK_sigplus_foldercaption_language,lib_FK_sigplus_foldercaption_country	lib_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,lib_FK_sigplus_data_property	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,lib_FK_sigplus_foldercaption_language,lib_FK_sigplus_foldercaption_country	lib_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,lib_FK_sigplus_data_property	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,lib_FK_sigplus_data_property	PRIMARY	8	cl478957_sedlib.i.imageid,const	1

Профиль

Status	Duration
Starting	0.35 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.16 ms
Optimizing	0.06 ms
Statistics	0.23 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	1.09 ms
Creating sort index	0.74 ms
End of update loop	0.01 ms
Removing tmp table	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1811
24	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3329
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.94 ms После последнего запроса: 0.43 ms

SELECT
MAX(i.`width`),
MAX(i.`height`),
MAX(`thumb_width`),
MAX(`thumb_height`),
MAX(`preview_width`),
MAX(`preview_height`),
MAX(`retina_width`),
MAX(`retina_height`)

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `lib_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `lib_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  WHERE
a.`folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/News/Novelties/022026' 
  AND 
`viewid` = 755

 
  AND `depthnum` <= 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index
1	SIMPLE	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	SIMPLE	i	ref	PRIMARY,lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2
1	SIMPLE	v	eq_ref	PRIMARY,lib_FK_sigplus_imageview_view	PRIMARY	8	cl478957_sedlib.i.imageid,const	1

Профиль

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.12 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1773
24	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3372
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.74 ms После последнего запроса: 40.48 ms

SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `lib_sigplus_folder` 
  WHERE `folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/banners/panel'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_folder	const	folderurl	folderurl	769	const	1

Профиль

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.09 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1773
24	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3073
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.31 ms После последнего запроса: 0.98 ms

SELECT viewid

  FROM lib_sigplus_view

  WHERE folderid = 823 
  AND hash = 0xf3b79c2795c67e4755691b2c7d91029a

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_view	const	hash,lib_FK_sigplus_view_folder	hash	16	const	1

Профиль

Status	Duration
Starting	0.02 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1211
28	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1216
27	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1897
26	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1951
25	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
24	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3081
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.67 ms После последнего запроса: 0.07 ms

SELECT
i.`fileurl`,
i.`imageid`

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  WHERE h.`ancestorid` = 823 
  AND NOT EXISTS (SELECT * 
  FROM `lib_sigplus_imageview` AS v 
  WHERE i.`imageid` = v.`imageid` 
  AND v.`viewid` = 756) 
  AND depthnum <= 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	PRIMARY	i	ref	lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2	Using where
2	MATERIALIZED	v	ref	PRIMARY,lib_FK_sigplus_imageview_view	lib_FK_sigplus_imageview_view	4	const	8	Using index

Профиль

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1811
28	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1813
27	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1900
26	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1951
25	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
24	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3081
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 0.20 ms

Повторяющиеся запросы: #40

SELECT
`langid`

  FROM `lib_sigplus_language`

  WHERE
`lang` = 'ru'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_language	const	lang	lang	2	const	1	Using index

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:317
24	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3159
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.32 ms После последнего запроса: 0.04 ms

Повторяющиеся запросы: #41

SELECT
`countryid`

  FROM `lib_sigplus_country`

  WHERE
`country` = 'RU'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_sigplus_country	const	country	country	2	const	1	Using index

Профиль

Status	Duration
Starting	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:332
24	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3160
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.51 ms После последнего запроса: 0.21 ms

Повторяющиеся запросы: #51

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
c.`title` AS `title`,
c.`summary` AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `lib_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `lib_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `lib_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 136 
  AND 
c.`countryid` = 160

  WHERE
a.`folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/banners/panel' 
  AND 
`viewid` = 756

 
  AND `depthnum` <= 0
 
  AND (NOT ISNULL(`title`) OR NOT ISNULL(`summary`))

  ORDER BY `depthnum` ASC, `ordnum` ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Используется сортировка файлов
1	SIMPLE	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	SIMPLE	i	ref	PRIMARY,lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2
1	SIMPLE	v	eq_ref	PRIMARY,lib_FK_sigplus_imageview_view	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
1	SIMPLE	c	eq_ref	PRIMARY,lib_FK_sigplus_caption_language,lib_FK_sigplus_caption_country	PRIMARY	8	cl478957_sedlib.i.imageid,const,const	1	Using where

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.05 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverPdo->execute()	JROOT/plugins/content/sigplus/core/core.php:3322
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.26 ms После последнего запроса: 0.04 ms

Повторяющиеся запросы: #50

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
c.`title` AS `title`,
c.`summary` AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `lib_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `lib_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `lib_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 136 
  AND 
c.`countryid` = 160

  WHERE
a.`folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/banners/panel' 
  AND 
`viewid` = 756

 
  AND `depthnum` <= 0
 
  AND (NOT ISNULL(`title`) OR NOT ISNULL(`summary`))

  ORDER BY `depthnum` ASC, `ordnum` ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Используется сортировка файлов
1	SIMPLE	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	SIMPLE	i	ref	PRIMARY,lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2
1	SIMPLE	v	eq_ref	PRIMARY,lib_FK_sigplus_imageview_view	PRIMARY	8	cl478957_sedlib.i.imageid,const	1
1	SIMPLE	c	eq_ref	PRIMARY,lib_FK_sigplus_caption_language,lib_FK_sigplus_caption_country	PRIMARY	8	cl478957_sedlib.i.imageid,const,const	1	Using where

Профиль

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1811
24	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3329
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.58 ms После последнего запроса: 0.09 ms

SELECT
MAX(i.`width`),
MAX(i.`height`),
MAX(`thumb_width`),
MAX(`thumb_height`),
MAX(`preview_width`),
MAX(`preview_height`),
MAX(`retina_width`),
MAX(`retina_height`)

  FROM `lib_sigplus_image` AS i

  INNER JOIN `lib_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `lib_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `lib_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `lib_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  WHERE
a.`folderurl` = '/var/www/cl478957/data/www/sedlib.ru/images/banners/panel' 
  AND 
`viewid` = 756

 
  AND `depthnum` <= 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index
1	SIMPLE	h	ref	PRIMARY,lib_FK_sigplus_hierarchy_descendant,lib_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	cl478957_sedlib.h.descendantid	1	Using index
1	SIMPLE	i	ref	PRIMARY,lib_FK_sigplus_image_folder	lib_FK_sigplus_image_folder	5	cl478957_sedlib.h.descendantid	2
1	SIMPLE	v	eq_ref	PRIMARY,lib_FK_sigplus_imageview_view	PRIMARY	8	cl478957_sedlib.i.imageid,const	1

Профиль

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.21 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.45 ms
Creating sort index	0.09 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1773
24	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3372
23	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:358
22	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
21	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
20	plgContentSigPlusNovo->{closure}()	Такой же, как вызов в строке ниже
19	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
18	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:133
17	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.69 ms После последнего запроса: 26.64 ms

SELECT manifest_cache 
  FROM lib_extensions 
  WHERE element='mod_djmegamenu' 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lib_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition

Профиль

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.16 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.05 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.36 ms
Creating sort index	0.08 ms
Removing tmp table	0.10 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_djmegamenu/helpers/helper.php:398
11	modDJMMHelper::getVersion()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:84
10	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

2 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM lib_k2_users

2 × SELECT viewid 
  FROM lib_sigplus_view

2 × SELECT `g`.`id`,`g`.`title` 
  FROM `lib_usergroups` AS g 
  INNER JOIN `lib_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
2 × SELECT * 
  FROM `lib_users`
```

2 × SELECT * 
  FROM `lib_itemrating_group`

2 × SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `lib_sigplus_folder`

2 × SELECT i.`fileurl`, i.`imageid` 
  FROM `lib_sigplus_image` AS i 
  INNER JOIN `lib_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `lib_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid`

2 × SELECT `langid` 
  FROM `lib_sigplus_language`

2 × SELECT `countryid` 
  FROM `lib_sigplus_country`

2 × SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT  md.`textvalue` 
  FROM `lib_sigplus_property` AS mp 
  INNER JOIN `lib_sigplus_data` AS md 
  ON mp.`propertyid` = md.`propertyid`

2 × SELECT MAX(i.`width`), MAX(i.`height`), MAX(`thumb_width`), MAX(`thumb_height`), MAX(`preview_width`), MAX(`preview_height`), MAX(`retina_width`), MAX(`retina_height`) 
  FROM `lib_sigplus_image` AS i 
  INNER JOIN `lib_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `lib_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid` 
  INNER JOIN `lib_sigplus_folder` AS a 
  ON a.`folderid` = h.`ancestorid` 
  INNER JOIN `lib_sigplus_imageview` AS v 
  ON i.`imageid` = v.`imageid`

2 × SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, c.`title` AS `title`, c.`summary` AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl` 
  FROM `lib_sigplus_image` AS i 
  INNER JOIN `lib_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `lib_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid` 
  INNER JOIN `lib_sigplus_folder` AS a 
  ON a.`folderid` = h.`ancestorid` 
  INNER JOIN `lib_sigplus_imageview` AS v 
  ON i.`imageid` = v.`imageid` 
  LEFT JOIN `lib_sigplus_caption` AS c 
  ON c.`imageid` = i.`imageid` 
  AND  c.`langid` = 136 
  AND  c.`countryid` = 160

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

1 × SELECT b.id 
  FROM lib_user_usergroup_map AS map 
  LEFT JOIN lib_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN lib_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM lib_fields AS a 
  LEFT JOIN `lib_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN lib_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN lib_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN lib_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN lib_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM lib_fields AS a 
  LEFT JOIN `lib_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN lib_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN lib_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN lib_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN lib_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `lib_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `data` 
  FROM `lib_session`

1 × SELECT COUNT(*) 
  FROM lib_k2_comments

1 × SELECT `session_id` 
  FROM `lib_session`

```
1 × SELECT * 
  FROM lib_k2_rating
```

1 × SELECT * 
  FROM lib_k2_categories

```
1 × SELECT * 
  FROM lib_k2_items
```

1 × SELECT id 
  FROM lib_k2_categories

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

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

```
1 × SELECT * 
  FROM lib_languages
```

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

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

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

1 × SELECT id, rules 
  FROM `lib_viewlevels

1 × SELECT manifest_cache 
  FROM lib_extensions

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

1 × SHOW VARIABLES LIKE 'query_cache_type

1 × SHOW VARIABLES LIKE 'have_profiling

1 × INSERT INTO `lib_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3063303032633962346562643636633162646464333635306664633632396136', 1, 1791266257, 0, '', 0

1 × UPDATE `lib_extensions` 
  SET `params` = '{\"mediaversion\":\"629e6863cb2267c4de4f3aa4ac0a91f6\"}'

1 × SHOW FULL COLUMNS 
  FROM `lib_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `lib_users

1 × SHOW FULL COLUMNS 
  FROM `lib_k2_items

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

Виртуальная выставка «Время жить и время умирать»

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

Сессия

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

Время

Память

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

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

53 запросов зарегистрировано 42.68 ms

16 повторяющихся запросов зарегистрировано

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

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

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