База знаний интересно о часах и их производителях на сайте компании СлавТайм

Контакты

Адрес:

152613, г. Углич Рыбинское шоссе д.20-Б

Телефон:

+7 (485) 324-14-34
+7 (485) 325-62-55

E-mail:

info@slavtime.ru

Сайт:

www.slavtime.ru

Календарь

		Октябрь 2020

Погода

Воскресенье 25 октября 2020

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1603601645,
                "last": 1603601645,
                "now": 1603601645
            },
            "token": "CkXSYnQJkGVhPayCJGIn8fVkYY2ZCDxw"
        },
        "registry": {
            "com_hikashop": {
                "user_id": 0
            }
        },
        "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
        }
    }
}

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

Время

Память

Время: 24.17 ms / 24.17 ms Память: 0.537 MB / 0.89 MB Application: afterLoad

Время: 95.05 ms / 119.22 ms Память: 2.267 MB / 3.15 MB Application: afterInitialise

Время: 65.59 ms / 184.81 ms Память: 1.148 MB / 4.30 MB Application: afterRoute

Время: 0.80 ms / 185.61 ms Память: 0.028 MB / 4.33 MB Application: beforeRenderComponent com_content

Время: 11.67 ms / 197.28 ms Память: 0.182 MB / 4.51 MB Application: Before Access::preloadComponents (all components)

Время: 0.88 ms / 198.16 ms Память: 0.058 MB / 4.57 MB Application: After Access::preloadComponents (all components)

Время: 0.02 ms / 198.18 ms Память: 0.000 MB / 4.57 MB Application: Before Access::preloadPermissions (com_content)

Время: 0.44 ms / 198.62 ms Память: 0.021 MB / 4.59 MB Application: After Access::preloadPermissions (com_content)

Время: 0.02 ms / 198.64 ms Память: 0.001 MB / 4.59 MB Application: Before Access::getAssetRules (id:722 name:com_content.category.14)

Время: 0.91 ms / 199.54 ms Память: 0.010 MB / 4.60 MB Application: After Access::getAssetRules (id:722 name:com_content.category.14)

Время: 6.52 ms / 206.06 ms Память: 0.094 MB / 4.69 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Время: 0.02 ms / 206.08 ms Память: 0.002 MB / 4.69 MB Application: After Access::getAssetRules (id:8 name:com_content)

Время: 45.73 ms / 251.82 ms Память: 0.432 MB / 5.13 MB Application: afterRenderComponent com_content

Время: 5.08 ms / 256.90 ms Память: 0.008 MB / 5.13 MB Application: afterDispatch

Время: 107.70 ms / 364.60 ms Память: 2.306 MB / 7.44 MB Application: beforeRenderModule mod_hikashop_cart (HikaShop Cart Module)

Время: 93.55 ms / 458.15 ms Память: 0.613 MB / 8.05 MB Application: afterRenderModule mod_hikashop_cart (HikaShop Cart Module)

Время: 0.28 ms / 458.43 ms Память: 0.000 MB / 7.98 MB Application: beforeRenderModule mod_breadcrumbs (Навигатор сайта)

Время: 1.72 ms / 460.15 ms Память: 0.013 MB / 8.00 MB Application: afterRenderModule mod_breadcrumbs (Навигатор сайта)

Время: 0.34 ms / 460.49 ms Память: 0.000 MB / 8.00 MB Application: beforeRenderModule mod_hikashop_filter (Параметры поиска)

Время: 21.27 ms / 481.75 ms Память: 0.419 MB / 8.42 MB Application: afterRenderModule mod_hikashop_filter (Параметры поиска)

Время: 0.04 ms / 481.79 ms Память: 0.000 MB / 8.41 MB Application: beforeRenderModule mod_login (Авторизация на сайте)

Время: 5.68 ms / 487.47 ms Память: 0.024 MB / 8.43 MB Application: afterRenderModule mod_login (Авторизация на сайте)

Время: 2.08 ms / 489.55 ms Память: 0.036 MB / 8.47 MB Application: beforeRenderModule mod_newscalendar (Календарь)

Время: 5.45 ms / 495.00 ms Память: 0.148 MB / 8.61 MB Application: afterRenderModule mod_newscalendar (Календарь)

Время: 203.84 ms / 698.84 ms Память: 0.744 MB / 9.36 MB Application: afterRender

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

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

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Так же, как вызов в строке ниже.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN недоступен для запроса: INSERT INTO `flu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6635333065313339656235313438646361373966303432366534323534653438', 1, 1603601645, 0, '', 0)

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.16 ms После последнего запроса: 10.93 ms Память запроса: 0.021 MB Память до запроса: 1.474 MB Выбрано строк: 5

SELECT id, rules

  FROM `flu_viewlevels`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.id

  FROM flu_usergroups AS a

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

  WHERE a.id = 9

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.00 ms После последнего запроса: 94.83 ms Память запроса: 0.008 MB Память до запроса: 4.096 MB

UPDATE `flu_extensions`

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
18	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
17	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163
13	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
12	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/rt_fluent/includes/theme.php:28
11	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118
10	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:239
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:62
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 10.68 ms Память запроса: 0.023 MB Память до запроса: 4.217 MB Выбрано строк: 3

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

  FROM flu_template_styles AS s

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

  ORDER BY s.id

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	index	idx_template,idx_client_id,idx_client_id_home	PRIMARY	4	NULL	7	30.61	Using where

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

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

Стек вызовов

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

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

Время запроса: 0.75 ms После последнего запроса: 22.19 ms Память запроса: 0.028 MB Память до запроса: 4.516 MB Выбрано строк: 40

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

  FROM `flu_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_argensyml','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_gantry5','com_hikashop','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocaguestbook','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 0.12 ms Память запроса: 0.027 MB Память до запроса: 4.568 MB Выбрано строк: 12

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

  FROM `flu_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_assets	NULL	ALL	idx_asset_name,idx_parent_id	Индекс не используется	NULL	NULL	121	26.15	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `flu_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `flu_categories` AS `s`

  INNER JOIN `flu_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id = 14

  ORDER BY c.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_left_right	Индекс не используется	NULL	NULL	13	53.85	Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	khanalex_slav1.c.id	2	100.00	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
14	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.77 ms После последнего запроса: 4.10 ms Память запроса: 0.157 MB Память до запроса: 4.693 MB Выбрано строк: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM flu_content AS a

  LEFT JOIN flu_categories AS c 
  ON c.id = a.catid

  LEFT JOIN flu_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN flu_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 14 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-25 04:54:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-25 04:54:06')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 20

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Используется filesort
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	3	25.00	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.id	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.45 ms После последнего запроса: 1.86 ms Память запроса: 0.025 MB Память до запроса: 4.841 MB Выбрано строк: 1

SELECT COUNT(*)

  FROM flu_content AS a

  LEFT JOIN flu_categories AS c 
  ON c.id = a.catid

  LEFT JOIN flu_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN flu_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 14 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-25 04:54:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-25 04:54:06')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	3	25.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.id	1	100.00	Using where; Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.40 ms После последнего запроса: 2.42 ms Память запроса: 0.023 MB Память до запроса: 4.851 MB Выбрано строк: 0

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

  FROM `flu_contentitem_tag_map` AS m 

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

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	Индекс не используется	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	khanalex_slav1.m.tag_id	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.40 ms После последнего запроса: 8.62 ms Память запроса: 0.027 MB Память до запроса: 4.959 MB Выбрано строк: 2

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

  FROM `flu_categories` AS `s`

  INNER JOIN `flu_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 14

  ORDER BY c.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	13	69.23	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.65 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 4.976 MB Выбрано строк: 0

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 flu_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (14,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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Используется filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	khanalex_slav1.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.id	1	100.00	Using where; Using index; Distinct

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to

  FROM `flu_contact_details` AS `contact`

  WHERE contact.published = 1 
  AND contact.user_id = 804

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	contact	NULL	ref	idx_state	idx_state	1	const	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:125
15	PlgContentContact->getContactData()	JROOT/plugins/content/contact/contact.php:66
14	PlgContentContact->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.54 ms После последнего запроса: 15.03 ms Память запроса: 0.028 MB Память до запроса: 5.118 MB Выбрано строк: 0

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 flu_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Используется filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	khanalex_slav1.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.group_id	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:19
15	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 0.33 ms Память запроса: 0.027 MB Память до запроса: 5.132 MB Выбрано строк: 0

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 flu_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (14,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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Используется filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	khanalex_slav1.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.id	1	100.00	Using where; Using index; Distinct

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
19	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
18	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:22
15	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.86 ms После последнего запроса: 88.85 ms Память запроса: 0.040 MB Память до запроса: 6.422 MB Выбрано строк: 13

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

  FROM flu_modules AS m

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

  LEFT JOIN flu_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 <= '2020-10-25 04:54:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-25 04:54:06') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 298 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	Индекс не используется	NULL	NULL	65	1.54	Using where; Используется filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	khanalex_slav1.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	khanalex_slav1.m.id	2	40.00	Using where; Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
51	JDatabaseDriver->loadObjectList()	Так же, как вызов в строке ниже.
50	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
49	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
48	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
47	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
46	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
43	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
41	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
38	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
35	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.18 ms После последнего запроса: 5.47 ms Память запроса: 0.035 MB Память до запроса: 6.471 MB Выбрано строк: 5

SELECT a.menutype

  FROM flu_menu_types AS a

  WHERE a.client_id = 0

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
43	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
42	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
41	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
39	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:32
38	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/bd/bd74e60015878cd803cc1f53c19691d5d004f34a79994298a66e013d8c36c5cf.php:71
35	__TwigTemplate_5d70c9c7364954f90409c2546e3a830afb6db6f0fc7fc1c1563175ba79802f8e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.30 ms После последнего запроса: 18.73 ms Память запроса: 0.113 MB Память до запроса: 6.852 MB Выбрано строк: 359

SELECT * 
  FROM flu_hikashop_config

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
54	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
53	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1251
52	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3065
51	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:33
50	_HikashopBuildRoute()	JROOT/components/com_hikashop/router.php:26
49	HikashopBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
48	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
47	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
46	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
45	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
44	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
43	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
42	Joomla\CMS\Router\Route::_()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:378
41	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:154
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
39	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:32
38	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/bd/bd74e60015878cd803cc1f53c19691d5d004f34a79994298a66e013d8c36c5cf.php:71
35	__TwigTemplate_5d70c9c7364954f90409c2546e3a830afb6db6f0fc7fc1c1563175ba79802f8e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.33 ms После последнего запроса: 35.87 ms Память запроса: 0.041 MB Память до запроса: 7.581 MB Выбрано строк: 0

SELECT cart.cart_id 
  FROM flu_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = 'f530e139eb5148dca79f0426e4254e48')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cart	NULL	ref	session_id	session_id	767	const	1	10.00	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
60	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
59	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
58	hikashopCartClass->getCurrentCartId()	JROOT/components/com_hikashop/views/product/view.html.php:2136
57	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
56	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
55	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
54	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
53	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
52	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
51	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
50	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:43
49	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
48	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
47	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
46	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
45	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:35
44	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:166
41	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayParticle()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:482
40	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayItem()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:640
39	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayItems()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:83
38	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/bd/bd74e60015878cd803cc1f53c19691d5d004f34a79994298a66e013d8c36c5cf.php:71
35	__TwigTemplate_5d70c9c7364954f90409c2546e3a830afb6db6f0fc7fc1c1563175ba79802f8e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.51 ms После последнего запроса: 2.88 ms Память запроса: 0.042 MB Память до запроса: 7.691 MB Выбрано строк: 0

SELECT a.id 
  FROM flu_menu AS a 
  INNER JOIN `flu_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' 
  AND a.language IN ('*', '', 'ru-RU')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	58	0.97	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	khanalex_slav1.a.menutype	1	80.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
61	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
60	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:206
59	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
58	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:2219
57	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
56	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
55	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
54	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
53	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
52	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
51	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
50	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:43
49	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
48	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
47	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
46	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
45	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:35
44	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:166
41	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayParticle()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:482
40	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayItem()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:640
39	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayItems()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:83
38	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/bd/bd74e60015878cd803cc1f53c19691d5d004f34a79994298a66e013d8c36c5cf.php:71
35	__TwigTemplate_5d70c9c7364954f90409c2546e3a830afb6db6f0fc7fc1c1563175ba79802f8e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.34 ms После последнего запроса: 0.04 ms Память запроса: 0.043 MB Память до запроса: 7.717 MB Выбрано строк: 44

SELECT a.id 
  FROM flu_menu AS a 
  INNER JOIN `flu_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=%' 
  AND a.language IN ('*', '', 'ru-RU')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	58	0.97	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	khanalex_slav1.a.menutype	1	80.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
61	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
60	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:211
59	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
58	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:2219
57	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
56	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
55	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
54	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
53	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
52	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
51	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
50	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:43
49	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
48	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
47	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
46	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
45	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:35
44	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:166
41	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayParticle()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:482
40	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayItem()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:640
39	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->getdisplayItems()	JROOT/cache/gantry5/rt_fluent/twig/c8/c87404bd672c96bc34bd325dcd12e904a152d9b212392558352cfca40b2331f3.php:83
38	__TwigTemplate_7f2ccbd91798b5e6911224d7fcdffef34d28b4e8215e00cca435268eef218e44->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/bd/bd74e60015878cd803cc1f53c19691d5d004f34a79994298a66e013d8c36c5cf.php:71
35	__TwigTemplate_5d70c9c7364954f90409c2546e3a830afb6db6f0fc7fc1c1563175ba79802f8e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.26 ms После последнего запроса: 71.93 ms Память запроса: 0.041 MB Память до запроса: 8.064 MB Выбрано строк: 3

SELECT * 
  FROM flu_hikashop_filter 
  WHERE filter_published = 1 
  AND (filter_access = 'all' OR filter_access LIKE '%,9,%') 
  ORDER BY filter_ordering

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
57	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/filter.php:295
56	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:185
55	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:28
54	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
53	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
52	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
46	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
44	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
41	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
38	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.42 ms После последнего запроса: 0.82 ms Память запроса: 0.043 MB Память до запроса: 8.170 MB Выбрано строк: 21

SELECT a.id 
  FROM flu_menu AS a 
  INNER JOIN `flu_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=category&layout=listing' 
  AND a.language IN ('*', '', 'ru-RU')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	58	0.97	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	khanalex_slav1.a.menutype	1	80.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
61	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
60	hikashopMenusClass->loadAMenuItemId()	JROOT/components/com_hikashop/views/product/tmpl/filter.php:30
59	include JROOT/components/com_hikashop/views/product/tmpl/filter.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
58	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2477
57	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
56	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2460
55	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
54	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
53	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
52	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
46	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
44	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
41	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
38	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.33 ms После последнего запроса: 0.05 ms Память запроса: 0.043 MB Память до запроса: 8.199 MB Выбрано строк: 20

SELECT a.id 
  FROM flu_menu AS a 
  INNER JOIN `flu_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=product&layout=listing' 
  AND a.language IN ('*', '', 'ru-RU')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	58	0.97	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	khanalex_slav1.a.menutype	1	80.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
61	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
60	hikashopMenusClass->loadAMenuItemId()	JROOT/components/com_hikashop/views/product/tmpl/filter.php:33
59	include JROOT/components/com_hikashop/views/product/tmpl/filter.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
58	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2477
57	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
56	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2460
55	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
54	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
53	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
52	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
46	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
44	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
41	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
38	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.34 ms После последнего запроса: 0.03 ms Память запроса: 0.042 MB Память до запроса: 8.226 MB Выбрано строк: 13

SELECT category_id 
  FROM flu_hikashop_category 
  WHERE category_type = 'manufacturer'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
61	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/menus.php:296
60	hikashopMenusClass->loadAMenuItemId()	JROOT/components/com_hikashop/views/product/tmpl/filter.php:35
59	include JROOT/components/com_hikashop/views/product/tmpl/filter.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
58	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2477
57	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
56	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2460
55	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
54	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
53	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
52	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
46	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
44	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
41	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
38	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.19 ms После последнего запроса: 9.19 ms Память запроса: 0.043 MB Память до запроса: 8.401 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_currency 
  WHERE currency_id IN (128)

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
64	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
63	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1862
62	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/filter.php:2279
61	hikashopCursorClass->display()	JROOT/administrator/components/com_hikashop/classes/filter.php:347
60	hikashopFilterClass->displayFilter()	JROOT/components/com_hikashop/views/product/tmpl/filter.php:139
59	include JROOT/components/com_hikashop/views/product/tmpl/filter.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
58	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2477
57	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
56	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2460
55	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
54	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
53	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
52	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
46	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
44	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
41	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
38	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.35 ms После последнего запроса: 0.14 ms Память запроса: 0.056 MB Память до запроса: 8.432 MB Выбрано строк: 12

SELECT a.* 
  FROM flu_hikashop_category AS a  
  WHERE (a.category_type = 'manufacturer') 
  AND (a.category_parent_id != 1 ) 
  AND (a.category_published = 1) 
  AND ((a.category_access = 'all' OR a.category_access LIKE '%,9,%')) 
  ORDER BY a.category_ordering ASC

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
65	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
64	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/filter.php:1408
63	hikashopFilterTypeClass->getManufacturers()	JROOT/administrator/components/com_hikashop/classes/filter.php:1858
62	hikashopRadioClass->display()	JROOT/administrator/components/com_hikashop/classes/filter.php:2503
61	hikashopCheckboxClass->display()	JROOT/administrator/components/com_hikashop/classes/filter.php:347
60	hikashopFilterClass->displayFilter()	JROOT/components/com_hikashop/views/product/tmpl/filter.php:139
59	include JROOT/components/com_hikashop/views/product/tmpl/filter.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
58	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2477
57	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
56	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2460
55	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
54	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
53	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
52	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
46	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
44	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
41	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
38	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `flu_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `flu_categories` AS `c`

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access	Индекс не используется	NULL	NULL	13	69.23	Using where; Используется filesort
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	khanalex_slav1.c.id	2	100.00	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
59	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
58	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
57	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
56	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
55	ContentModelCategories->getItems()	JROOT/modules/mod_newscalendar/helper.php:137
54	modNewsCalendarHelper::getList()	JROOT/modules/mod_newscalendar/helper.php:84
53	modNewsCalendarHelper::getCal()	JROOT/modules/mod_newscalendar/mod_newscalendar.php:19
52	include JROOT/modules/mod_newscalendar/mod_newscalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	Так же, как вызов в строке ниже.
50	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
49	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:619
48	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
47	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
46	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
43	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
41	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
38	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
35	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.42 ms После последнего запроса: 0.75 ms Память запроса: 0.041 MB Память до запроса: 8.596 MB Выбрано строк: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM flu_content AS a

  LEFT JOIN flu_categories AS c 
  ON c.id = a.catid

  LEFT JOIN flu_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN flu_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (0,2,8,9,10,12,14) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-25 04:54:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-25 04:54:06') 
  AND (a.created >= '2020-10-01 00:00:00' 
  AND a.created <= '2020-11-01 00:00:00')

  ORDER BY a.created DESC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	4	25.00	Using index condition; Using where; Используется filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	khanalex_slav1.a.catid	1	10.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.c.parent_id	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.id	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
59	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
58	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
57	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
56	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
55	ContentModelArticles->getItems()	JROOT/modules/mod_newscalendar/helper.php:211
54	modNewsCalendarHelper::getList()	JROOT/modules/mod_newscalendar/helper.php:84
53	modNewsCalendarHelper::getCal()	JROOT/modules/mod_newscalendar/mod_newscalendar.php:19
52	include JROOT/modules/mod_newscalendar/mod_newscalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	Так же, как вызов в строке ниже.
50	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
49	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:619
48	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
47	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
46	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:43
43	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_fluent/twig/c9/c97811f2927c781c8084f97f4eab5858e98f5a4e669769a9b7827e318f04bb1c.php:73
41	__TwigTemplate_8b6d8f513b7521bacfb9defb49ac81917c2eb11ec182b061e7290e1967c6c5de->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6a/6a745b9556a4fdaad47070b0d0392a11dab9f6b14aecc040aa24789cb8f792b9.php:35
38	__TwigTemplate_4c7d534f92e8d0f1b174f3539d567e14c18d33ecc6541e11c9cdaf48de2165fb->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/6e/6e72382e25e395c6110e9e72dec5467f86a3d9dda129e4541c023a7292abaa0e.php:53
35	__TwigTemplate_4a9ef84fb13569ea9adbf5b5a38d8c89b0c6be86ad0ad007d3b4c9b998054ebd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/52/5250bccc794ca52baa225f502774e38b8c66d461139a6b279e7680f4a736478e.php:47
20	__TwigTemplate_52a57671baddda6deea84a20982b6d086472f6110e5494ea3101c48dd5eb9a29->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/86/869c6135d1743a55db16a6b666a2b979a1e77a6afa1b90d3c268e58b3d5f2baf.php:35
17	__TwigTemplate_3a63f4548a7900ac174368bd49d3cd73df9ebb678522ddd5ad81a0af80de828e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_fluent/twig/1d/1d278ce32ea7c2a7b139d7dc74b01e238dce3fca299f0138b899ef926be4216a.php:35
14	__TwigTemplate_2ba2c77140e28b1129c1d5a6767680fa4b06de0d3946fe3db4a614420d5eb58f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_fluent/index.php:23
7	require JROOT/templates/rt_fluent/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.56 ms После последнего запроса: 195.66 ms Память запроса: 0.023 MB Память до запроса: 9.044 MB Выбрано строк: 0

SELECT *
 
  FROM flu_jmap_metainfo
 
  WHERE `linkurl` = 'https://slavtime.ru/baza-znanij.html'
 
  AND `published` = 1

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:407
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.15 ms После последнего запроса: 2.78 ms Память запроса: 0.020 MB Память до запроса: 9.260 MB Выбрано строк: 0

SELECT *
 
  FROM flu_jmap_headings
 
  WHERE `linkurl` = 'https://slavtime.ru/baza-znanij.html'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:720
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

4 × SELECT a.id 
  FROM flu_menu AS a 
  INNER JOIN `flu_menu_types` as b 
  on a.menutype = b.menutype

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

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `flu_assets`

2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM flu_content AS a 
  LEFT JOIN flu_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN flu_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN flu_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN flu_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN flu_content_rating AS v 
  ON a.id = v.content_id

2 × 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 flu_fields AS a 
  LEFT JOIN `flu_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN flu_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN flu_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN flu_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN flu_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `flu_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `data` 
  FROM `flu_session`

1 × SELECT a.menutype 
  FROM flu_menu_types AS a

1 × SELECT *  
  FROM flu_jmap_metainfo

1 × SELECT a.* 
  FROM flu_hikashop_category AS a

1 × SELECT * 
  FROM flu_hikashop_currency

1 × SELECT category_id 
  FROM flu_hikashop_category

1 × SELECT * 
  FROM flu_hikashop_filter

1 × SELECT cart.cart_id 
  FROM flu_hikashop_cart AS cart

1 × SELECT * 
  FROM flu_hikashop_confi

1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to 
  FROM `flu_contact_details` AS `contact`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM flu_modules AS m 
  LEFT JOIN flu_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN flu_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 flu_fields AS a 
  LEFT JOIN `flu_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN flu_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN flu_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN flu_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN flu_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `session_id` 
  FROM `flu_session`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `flu_categories` AS `s` 
  INNER JOIN `flu_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

1 × SELECT COUNT(*) 
  FROM flu_content AS a 
  LEFT JOIN flu_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN flu_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN flu_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN flu_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN flu_content_rating AS v 
  ON a.id = v.content_id

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

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

1 × SELECT id, rules 
  FROM `flu_viewlevels

1 × SELECT *  
  FROM flu_jmap_headings

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

1 × INSERT INTO `flu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6635333065313339656235313438646361373966303432366534323534653438', 1, 1603601645, 0, '', 0

1 × UPDATE `flu_extensions` 
  SET `params` = '{\"mediaversion\":\"a40f6b9a23ff84f4b87e096fa7f2c827\"}'

Фильтры

Фильтры

10 самых дорогих часов в истории, которые были проданы с аукционов

Словарь терминов часового дела

Водостойкость часов

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

Сессия

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

Время

Память

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

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

Зафиксировано 34 SQL-запросов 17.55 ms

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

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

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

Пн	Вт	Ср	Чт	Пт	Сб	Вс
28	29	30	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31	1