Отправить сообщение

There is no public post yet

Контакты

Адрес:

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": 1603600416,
                "last": 1603600416,
                "now": 1603600416
            },
            "token": "mHyIymcPbz1uYfkvopvUpru77LTuWwRt"
        },
        "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
        }
    },
    "__pgb": {
        "hidden_field_id": "hfnded03b1d3",
        "hidden_field_name": "hfyf2031",
        "hidden_field_class": "pgbi80dca2a",
        "time": 1603600417,
        "captcha_id": "9",
        "captcha_cnt": 1
    },
    "__phocaguestbook": {
        "form_id": "z6f4408d92"
    }
}

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

Время

Память

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

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

Время: 84.08 ms / 289.12 ms Память: 1.151 MB / 4.30 MB Application: afterRoute

Время: 0.95 ms / 290.08 ms Память: 0.036 MB / 4.34 MB Application: beforeRenderComponent com_phocaguestbook

Время: 15.86 ms / 305.94 ms Память: 0.219 MB / 4.56 MB Application: Before Access::preloadComponents (all components)

Время: 0.71 ms / 306.65 ms Память: 0.058 MB / 4.62 MB Application: After Access::preloadComponents (all components)

Время: 0.02 ms / 306.67 ms Память: 0.000 MB / 4.61 MB Application: Before Access::getAssetRules (id:720 name:com_phocaguestbook)

Время: 0.99 ms / 307.67 ms Память: 0.009 MB / 4.62 MB Application: After Access::getAssetRules (id:720 name:com_phocaguestbook)

Время: 3.06 ms / 310.72 ms Память: 0.091 MB / 4.71 MB Application: Before Access::preloadPermissions (com_phocaguestbook)

Время: 0.34 ms / 311.06 ms Память: 0.013 MB / 4.73 MB Application: After Access::preloadPermissions (com_phocaguestbook)

Время: 0.02 ms / 311.08 ms Память: 0.000 MB / 4.73 MB Application: Before Access::getAssetRules (id:721 name:com_phocaguestbook.category.13)

Время: 0.03 ms / 311.11 ms Память: 0.007 MB / 4.73 MB Application: After Access::getAssetRules (id:721 name:com_phocaguestbook.category.13)

Время: 87.69 ms / 398.80 ms Память: 0.409 MB / 5.14 MB Application: afterRenderComponent com_phocaguestbook

Время: 1.92 ms / 400.72 ms Память: 0.004 MB / 5.15 MB Application: afterDispatch

Время: 139.37 ms / 540.09 ms Память: 2.378 MB / 7.52 MB Application: beforeRenderModule mod_rokajaxsearch (RokAjaxSearch)

Время: 5.45 ms / 545.54 ms Память: 0.015 MB / 7.54 MB Application: afterRenderModule mod_rokajaxsearch (RokAjaxSearch)

Время: 0.95 ms / 546.49 ms Память: 0.054 MB / 7.59 MB Application: beforeRenderModule mod_hikashop_cart (HikaShop Cart Module)

Время: 102.53 ms / 649.02 ms Память: 0.590 MB / 8.18 MB Application: afterRenderModule mod_hikashop_cart (HikaShop Cart Module)

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

Время: 1.92 ms / 652.37 ms Память: 0.012 MB / 8.16 MB Application: afterRenderModule mod_breadcrumbs (Навигатор сайта)

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

Время: 2.19 ms / 654.88 ms Память: 0.016 MB / 8.17 MB Application: afterRenderModule mod_login (Авторизация на сайте)

Время: 2.27 ms / 657.16 ms Память: 0.035 MB / 8.21 MB Application: beforeRenderModule mod_newscalendar (Календарь)

Время: 6.65 ms / 663.81 ms Память: 0.195 MB / 8.40 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Время: 0.04 ms / 663.84 ms Память: 0.007 MB / 8.41 MB Application: After Access::getAssetRules (id:8 name:com_content)

Время: 1.14 ms / 664.98 ms Память: 0.018 MB / 8.43 MB Application: afterRenderModule mod_newscalendar (Календарь)

Время: 0.90 ms / 665.88 ms Память: 0.000 MB / 8.41 MB Application: beforeRenderModule mod_custom (Погода)

Время: 2.20 ms / 668.08 ms Память: 0.037 MB / 8.45 MB Application: afterRenderModule mod_custom (Погода)

Время: 185.90 ms / 853.98 ms Память: 0.694 MB / 9.15 MB Application: afterRender

Всего SQL-запросов: 33.86 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'6637373233646165643766326437613133316136306233623461663861643630', 1, 1603600416, 0, '', 0)

Профилирование 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
update	0.19 ms
end	0.00 ms
query end	10.93 ms
closing tables	0.02 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.33 ms После последнего запроса: 16.59 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.30 ms После последнего запроса: 0.08 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.04 ms
checking permissions	0.00 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.11 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.02 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 для получения ссылок на файлы]

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

UPDATE `flu_extensions`

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

  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.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.11 ms
updating	0.06 ms
end	0.01 ms
query end	10.62 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.37 ms После последнего запроса: 12.12 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.12 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.56 ms После последнего запроса: 29.88 ms Память запроса: 0.028 MB Память до запроса: 4.563 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.07 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.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.19 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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_phocaguestbook/models/guestbook.php:167
14	PhocaguestbookModelGuestbook->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:34
11	PhocaguestbookViewGuestbook->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_phocaguestbook/controller.php:45
8	PhocaguestbookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocaguestbook/phocaguestbook.php:18
6	require_once JROOT/components/com_phocaguestbook/phocaguestbook.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.52 ms После последнего запроса: 2.87 ms Память запроса: 0.025 MB Память до запроса: 4.692 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_phocaguestbook' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 13

  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	28.40	Using where

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

Status	Duration
starting	0.10 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.16 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_phocaguestbook/models/guestbook.php:362
13	PhocaguestbookModelGuestbook->getGuestbook()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:35
11	PhocaguestbookViewGuestbook->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_phocaguestbook/controller.php:45
8	PhocaguestbookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocaguestbook/phocaguestbook.php:18
6	require_once JROOT/components/com_phocaguestbook/phocaguestbook.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.26 ms После последнего запроса: 0.80 ms Память запроса: 0.025 MB Память до запроса: 4.714 MB Выбрано строк: 3

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

  FROM `flu_assets`

  WHERE `name` LIKE 'com_phocaguestbook.%' OR `name` = 'com_phocaguestbook' 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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_phocaguestbook/models/guestbook.php:372
13	PhocaguestbookModelGuestbook->getGuestbook()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:35
11	PhocaguestbookViewGuestbook->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_phocaguestbook/controller.php:45
8	PhocaguestbookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocaguestbook/phocaguestbook.php:18
6	require_once JROOT/components/com_phocaguestbook/phocaguestbook.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 После последнего запроса: 11.19 ms Память запроса: 0.023 MB Память до запроса: 4.760 MB Выбрано строк: 0

SELECT *, rgt AS mainOrd 
  FROM `flu_phocaguestbook_items` 
  WHERE catid = 13 
  AND published = 1 
  AND level = 1 
  ORDER BY rgt DESC 
  LIMIT 0,5

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocaguestbook/models/guestbook.php:324
13	PhocaguestbookModelGuestbook->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:113
11	PhocaguestbookViewGuestbook->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_phocaguestbook/controller.php:45
8	PhocaguestbookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocaguestbook/phocaguestbook.php:18
6	require_once JROOT/components/com_phocaguestbook/phocaguestbook.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.12 ms После последнего запроса: 0.09 ms Память запроса: 0.024 MB Память до запроса: 4.775 MB Выбрано строк: 1

SELECT COUNT(*)

  FROM `flu_phocaguestbook_items`

  WHERE catid = 13 
  AND published = 1 
  AND level = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_phocaguestbook_items	NULL	ref	published	published	1	const	1	50.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.01 ms
statistics	0.01 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:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_phocaguestbook/models/guestbook.php:337
14	PhocaguestbookModelGuestbook->getTotal()	JROOT/components/com_phocaguestbook/models/guestbook.php:350
13	PhocaguestbookModelGuestbook->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:114
11	PhocaguestbookViewGuestbook->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_phocaguestbook/controller.php:45
8	PhocaguestbookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocaguestbook/phocaguestbook.php:18
6	require_once JROOT/components/com_phocaguestbook/phocaguestbook.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 для получения ссылок на файлы]

Время запроса: 1.38 ms После последнего запроса: 29.99 ms Память запроса: 0.027 MB Память до запроса: 5.034 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_phocaguestbook.guestbook' 
  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.28 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.15 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 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/administrator/components/com_fields/helpers/fields.php:286
19	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
18	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
15	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
14	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_phocaguestbook/models/guestbook.php:190
13	PhocaguestbookModelGuestbook->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:115
11	PhocaguestbookViewGuestbook->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_phocaguestbook/controller.php:45
8	PhocaguestbookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocaguestbook/phocaguestbook.php:18
6	require_once JROOT/components/com_phocaguestbook/phocaguestbook.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.23 ms После последнего запроса: 36.16 ms Память запроса: 0.026 MB Память до запроса: 5.174 MB Выбрано строк: 1

SELECT element

  FROM flu_extensions

  WHERE element = 'tinymce' 
  AND folder = 'editors' 
  AND enabled = 1 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	5.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.01 ms
statistics	0.04 ms
preparing	0.01 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_phocaguestbook/models/fields/phocaeditor.php:273
20	JFormFieldPhocaEditor->getEditor()	JROOT/components/com_phocaguestbook/models/fields/phocaeditor.php:59
19	JFormFieldPhocaEditor->getInput()	JROOT/libraries/src/Form/FormField.php:425
18	Joomla\CMS\Form\FormField->__get()	JROOT/libraries/src/Form/Form.php:550
17	Joomla\CMS\Form\Form->getInput()	JROOT/components/com_phocaguestbook/views/guestbook/tmpl/default_form_classic.php:66
16	include JROOT/components/com_phocaguestbook/views/guestbook/tmpl/default_form_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_phocaguestbook/views/guestbook/tmpl/default.php:111
14	include JROOT/components/com_phocaguestbook/views/guestbook/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_phocaguestbook/views/guestbook/view.html.php:271
11	PhocaguestbookViewGuestbook->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_phocaguestbook/controller.php:45
8	PhocaguestbookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocaguestbook/phocaguestbook.php:18
6	require_once JROOT/components/com_phocaguestbook/phocaguestbook.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.20 ms После последнего запроса: 114.86 ms Память запроса: 0.035 MB Память до запроса: 6.270 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.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.40 ms После последнего запроса: 21.21 ms Память запроса: 0.113 MB Память до запроса: 6.898 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.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.28 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 для получения ссылок на файлы]

Время запроса: 1.23 ms После последнего запроса: 10.15 ms Память запроса: 0.040 MB Память до запроса: 7.437 MB Выбрано строк: 12

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:33:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-25 04:33:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 282 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.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.81 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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/gantry5/classes/Gantry/Framework/Platform.php:276
47	Gantry\Framework\Platform->getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:269
46	Gantry\Framework\Platform->getModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:183
45	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_fluent/twig/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:43
43	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->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/6d/6da624736dea83302ac1bd2a910aefedd5b4a687dfee919bbce823411635b62a.php:35
38	__TwigTemplate_6adc2f9f2cebabe749c419d348c5a80624f555a27f2155b6765a6b951856ee0d->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.24 ms После последнего запроса: 39.71 ms Память запроса: 0.041 MB Память до запроса: 7.740 MB Выбрано строк: 0

SELECT cart.cart_id 
  FROM flu_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = 'f7723daed7f2d7a131a60b3b4af8ad60')  
  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.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.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.85 ms После последнего запроса: 3.19 ms Память запроса: 0.042 MB Память до запроса: 7.788 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.06 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.02 ms
statistics	0.14 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.48 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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.55 ms После последнего запроса: 0.06 ms Память запроса: 0.043 MB Память до запроса: 7.814 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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.32 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.57 ms После последнего запроса: 79.28 ms Память запроса: 0.045 MB Память до запроса: 8.345 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.10 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.06 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.05 ms
executing	0.00 ms
Sending data	0.03 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.03 ms
executing	0.00 ms
Sending data	0.02 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.41 ms После последнего запроса: 0.80 ms Память запроса: 0.041 MB Память до запроса: 8.407 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:33:37') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-25 04:33:37') 
  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.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.08 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.02 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 для получения ссылок на файлы]

Время запроса: 0.49 ms После последнего запроса: 2.99 ms Память запроса: 0.048 MB Память до запроса: 8.435 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 = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

План 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.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 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.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
65	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
64	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
63	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
62	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
61	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
60	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
59	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
58	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
57	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
56	JHtmlContent::prepare()	Так же, как вызов в строке ниже.
55	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
54	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
53	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
52	include JROOT/modules/mod_custom/mod_custom.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:597
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.59 ms После последнего запроса: 177.91 ms Память запроса: 0.022 MB Память до запроса: 8.819 MB Выбрано строк: 0

SELECT *
 
  FROM flu_jmap_metainfo
 
  WHERE `linkurl` = 'https://slavtime.ru/guestbook.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.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.29 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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.24 ms После последнего запроса: 2.57 ms Память запроса: 0.020 MB Память до запроса: 9.032 MB Выбрано строк: 0

SELECT *
 
  FROM flu_jmap_headings
 
  WHERE `linkurl` = 'https://slavtime.ru/guestbook.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.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 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

Стек вызовов

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

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

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

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

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

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

1 × SELECT `data` 
  FROM `flu_session`

1 × SELECT * 
  FROM flu_hikashop_confi

1 × SELECT *  
  FROM flu_jmap_metainfo

1 × 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

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,( SELECT COUNT(i.`id`) 
  FROM `flu_content` AS `i`

1 × SELECT cart.cart_id 
  FROM flu_hikashop_cart AS cart

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 element 
  FROM flu_extensions

1 × SELECT a.menutype 
  FROM flu_menu_types AS a

1 × SELECT `session_id` 
  FROM `flu_session`

1 × SELECT COUNT(*) 
  FROM `flu_phocaguestbook_items`

1 × SELECT *, rgt AS mainOrd 
  FROM `flu_phocaguestbook_items`

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 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'6637373233646165643766326437613133316136306233623461663861643630', 1, 1603600416, 0, '', 0

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

Отправить сообщение

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

Сессия

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

Время

Память

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

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

Зафиксировано 25 SQL-запросов 33.86 ms

Зафиксировано 22 типов 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