Часы мужские «Восток» Коллекция Партнер.

Описание
Характеристики
Комментарии
Опубликовать комментарий

Часы мужские «Восток» Коллекция Партнер с автоподзаводом. Чистопольского часового завода «Восток» Модель: 251249 Механизм механический «Восток 2416Б». Корпус: часовая латунь. Органическое стекло. Водозащита: 2 атмосферы - 20 метров.

Производитель: Восток

Контакты

Адрес:

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

Телефон:

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

E-mail:

info@slavtime.ru

Сайт:

www.slavtime.ru

Календарь

		Октябрь 2021

Погода

Суббота 16 октября 2021

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1634338631,
                "last": 1634338631,
                "now": 1634338631
            },
            "token": "SKCr5LWf8yWBghlMLOaEJ6PS5HNhfsiN"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "176",
                "vote": {
                    "list_limit": "20"
                }
            }
        },
        "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
        }
    }
}

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

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

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

Зафиксировано 66 SQL-запросов 19.65 ms

7 повторяющийся запрос!

3 повторов: #11 #54 #62

2 повторов: #40 #46

2 повторов: #41 #47

Время запроса: 0.11 ms Память запроса: 0.020 MB Память до запроса: 1.312 MB Выбрано строк: 0

SELECT `session_id`

  FROM `flu_session`

  WHERE `session_id` = X'6461616139613839343938313130623537356666376462303837323930333636' 
  LIMIT 1

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

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

Профилирование 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.02 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
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.13 ms После последнего запроса: 0.05 ms Память запроса: 0.004 MB Память до запроса: 1.318 MB

INSERT INTO `flu_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6461616139613839343938313130623537356666376462303837323930333636', 1, 1634338631, 0, '', 0)

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
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.11 ms После последнего запроса: 10.41 ms Память запроса: 0.021 MB Память до запроса: 1.467 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.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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

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

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

Время запроса: 0.15 ms После последнего запроса: 0.04 ms Память запроса: 0.021 MB Память до запроса: 1.479 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.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

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

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

Время запроса: 0.28 ms После последнего запроса: 82.04 ms Память запроса: 0.008 MB Память до запроса: 3.806 MB

UPDATE `flu_extensions`

  SET `params` = '{\"mediaversion\":\"34813c0ca6fcb2f27927a6265f360cb1\"}'

  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.02 ms
init	0.02 ms
System lock	0.06 ms
updating	0.05 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
17	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
16	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
13	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3083
12	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:153
11	_HikashopParseRoute()	JROOT/components/com_hikashop/router.php:142
10	HikashopParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.32 ms После последнего запроса: 10.30 ms Память запроса: 0.097 MB Память до запроса: 4.050 MB Выбрано строк: 361

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	361	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.20 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/administrator/components/com_hikashop/classes/config.php:16
14	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1268
13	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3102
12	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:153
11	_HikashopParseRoute()	JROOT/components/com_hikashop/router.php:142
10	HikashopParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.00 ms После последнего запроса: 4.99 ms Память запроса: 0.022 MB Память до запроса: 4.312 MB Выбрано строк: 1

SELECT product_id 
  FROM flu_hikashop_product 
  WHERE product_alias = 'vostok-partner-251249'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_hikashop_product	NULL	ALL	NULL	Индекс не используется	NULL	NULL	3262	10.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	1.86 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/router.php:313
12	hikashop_retrieve_url_id()	JROOT/components/com_hikashop/router.php:226
11	_HikashopParseRoute()	JROOT/components/com_hikashop/router.php:142
10	HikashopParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 34.75 ms Память запроса: 0.023 MB Память до запроса: 4.802 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.05 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.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

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

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

Время запроса: 0.31 ms После последнего запроса: 17.99 ms Память запроса: 0.041 MB Память до запроса: 4.933 MB Выбрано строк: 1

SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering  
  FROM flu_hikashop_product AS product  
  LEFT JOIN flu_hikashop_product_category AS product_category 
  ON product.product_id = product_category.product_id  
  WHERE (product.product_id = 1739) 
  AND ((product.product_access = 'all' OR product.product_access LIKE '%,9,%')) 
  LIMIT 0, 1

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

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

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

Status	Duration
starting	0.05 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.05 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_hikashop/views/product/view.html.php:1204
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.20 ms После последнего запроса: 0.96 ms Память запроса: 0.023 MB Память до запроса: 4.947 MB Выбрано строк: 1

SELECT * 
  FROM flu_modules 
  WHERE id IN (647,0) 
  AND language IN ('*', '', 'ru-RU')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_modules	NULL	range	PRIMARY,idx_language	PRIMARY	4	NULL	2	30.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/helpers/module.php:123
14	hikashopModuleHelper->setModuleData()	JROOT/components/com_hikashop/views/product/view.html.php:1209
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.28 ms После последнего запроса: 39.18 ms Память запроса: 0.024 MB Память до запроса: 5.116 MB Выбрано строк: 0

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

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

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
16	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:131
15	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:505
14	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:1250
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.12 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 5.125 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_currency 
  WHERE currency_id IN (128)

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1870
14	hikashopCurrencyClass->getCurrencies()	JROOT/components/com_hikashop/views/product/view.html.php:1253
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.17 ms После последнего запроса: 45.64 ms Память запроса: 0.007 MB Память до запроса: 5.485 MB

UPDATE flu_hikashop_product 
  SET product_hit = product_hit + 1, product_last_seen_date = 1634338631 
  WHERE product_id = 1739

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	flu_hikashop_product	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.02 ms
updating	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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_hikashop/classes/product.php:4086
14	hikashopProductClass->hit()	JROOT/components/com_hikashop/views/product/view.html.php:1293
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.*  
  FROM flu_hikashop_product_related AS pr  
  LEFT JOIN flu_hikashop_product AS p 
  ON pr.product_related_id = p.product_id  
  WHERE (pr.product_id = 1739) 
  AND (pr.product_related_type = 'options') 
  AND (p.product_published = 1) 
  AND ((p.product_sale_start = '' OR p.product_sale_start <= 1634338631)) 
  AND ((p.product_sale_end = '' OR p.product_sale_end > 1634338631)) 
  AND ((p.product_access = 'all' OR p.product_access LIKE '%,9,%'))  
  ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1315
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.*, pr.product_related_quantity  
  FROM flu_hikashop_product_related AS pr  
  INNER JOIN flu_hikashop_product AS p 
  ON pr.product_related_id = p.product_id  
  WHERE pr.product_id = 1739 
  AND pr.product_related_type = 'bundle' 
  ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

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

Status	Duration
starting	0.02 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.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1324
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.16 ms После последнего запроса: 0.04 ms Память запроса: 0.039 MB Память до запроса: 5.506 MB Выбрано строк: 0

SELECT * 
  FROM flu_hikashop_product 
  WHERE (product_parent_id IN (1739)) 
  AND (product_published = 1) 
  AND ((product_access = 'all' OR product_access LIKE '%,9,%'))

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_hikashop_product	NULL	ref	product_parent_id	product_parent_id	4	const	1	5.00	Using where

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1352
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT v.*, c.*  
  FROM flu_hikashop_variant AS v  
  INNER JOIN flu_hikashop_characteristic AS c 
  ON v.variant_characteristic_id = c.characteristic_id  
  WHERE v.variant_product_id IN (1739)  
  ORDER BY v.ordering ASC, c.characteristic_ordering ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1393
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.86 ms После последнего запроса: 0.02 ms Память запроса: 0.023 MB Память до запроса: 5.523 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_file 
  WHERE file_ref_id IN (1739) 
  AND file_type IN ('product','file')  
  ORDER BY file_ordering ASC, file_id ASC

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

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

Профилирование 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.26 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.51 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1436
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT currency_id 
  FROM flu_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 128

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:471
16	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:1553
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1442
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.* 
  FROM flu_hikashop_price as p 
  WHERE (p.price_currency_id IN (128)) 
  AND (p.price_start_date < 1634338631) 
  AND ((p.price_end_date < 1 OR p.price_end_date > 1634338631)) 
  AND (p.price_product_id IN (1739)) 
  AND ((p.price_access = 'all' OR p.price_access LIKE '%,9,%')) 
  AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) 
  ORDER BY p.price_site_id ASC, p.price_value DESC

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

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

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

Status	Duration
starting	0.03 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.02 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.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1597
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1442
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.*,c.* 
  FROM flu_hikashop_category AS a 
  LEFT JOIN flu_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN flu_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey 
  WHERE a.category_id = 11 
  AND b.taxation_published=1 
  AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
  AND b.taxation_date_start <= 1634338631 
  AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1634338631) 
  AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
  ORDER BY b.taxation_id ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	system	NULL	Индекс не используется	NULL	NULL	1	100.00	NULL
1	SIMPLE	a	NULL	const	PRIMARY,category_namekey	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	system	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:197
19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2628
17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1689
16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1607
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1442
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.13 ms После последнего запроса: 0.03 ms Память запроса: 0.026 MB Память до запроса: 5.570 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_zone 
  WHERE zone_id = 176

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_hikashop_zone	NULL	const	PRIMARY	PRIMARY	4	const	1	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.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/currency.php:218
19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2628
17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1689
16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1607
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1442
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM flu_hikashop_discount 
  WHERE (discount_type = 'discount') 
  AND (discount_published = 1) 
  AND (discount_quota > discount_used_times OR discount_quota = 0) 
  AND (discount_start < 1634338631) 
  AND (discount_end > 1634338631 OR discount_end = 0) 
  AND (discount_product_id IN ('','0','1739') OR discount_product_id LIKE '%,1739,%') 
  AND (discount_flat_amount != 0 OR discount_percent_amount != 0) 
  AND ((discount_flat_amount = 0 OR discount_currency_id =128)) 
  AND ((discount_access = 'all' OR discount_access LIKE '%,9,%')) 
  AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1657
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1442
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT category_id 
  FROM flu_hikashop_product_category 
  WHERE product_id IN (1739) 
  ORDER BY ordering ASC

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

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

Профилирование 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.02 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/product.php:1150
16	hikashopProductClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:275
15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:160
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1445
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 0.03 ms Память запроса: 0.026 MB Память до запроса: 5.674 MB Выбрано строк: 5

SELECT hk_parent.* 
  FROM flu_hikashop_category AS hk_cat  
  LEFT JOIN flu_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id IN (122)  
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:756
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:280
15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:160
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1445
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.22 ms После последнего запроса: 0.06 ms Память запроса: 0.024 MB Память до запроса: 5.695 MB Выбрано строк: 0

SELECT * 
  FROM flu_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='product' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')  
  AND ((((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,122,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,41,%' OR field_categories LIKE '%,49,%' OR field_categories LIKE '%,122,%'))) 
  AND field_products="") OR (field_products LIKE '%,1739,%')) 
  ORDER BY a.`field_ordering` ASC

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:141
15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:161
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1445
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.20 ms После последнего запроса: 0.05 ms Память запроса: 0.024 MB Память до запроса: 5.705 MB Выбрано строк: 0

SELECT * 
  FROM flu_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='item' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')  
  AND ((((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,122,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,41,%' OR field_categories LIKE '%,49,%' OR field_categories LIKE '%,122,%'))) 
  AND field_products="") OR (field_products LIKE '%,1739,%')) 
  ORDER BY a.`field_ordering` ASC

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:141
15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:161
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1449
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.* 
  FROM flu_hikashop_badge AS a 
  WHERE a.badge_start <= 1634338631 
  AND (a.badge_end >= 1634338631 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 64504091) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '117' OR badge_category_id LIKE '%,117,%' OR badge_category_id = '122' OR badge_category_id LIKE '%,122,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '41' OR badge_category_id LIKE '%,41,%' OR badge_category_id = '49' OR badge_category_id LIKE '%,49,%' OR badge_category_id = '122' OR badge_category_id LIKE '%,122,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 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.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/administrator/components/com_hikashop/classes/badge.php:151
14	hikashopBadgeClass->loadBadges()	JROOT/components/com_hikashop/views/product/view.html.php:1584
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT category_id 
  FROM flu_hikashop_category 
  WHERE category_type='root' 
  LIMIT 1

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/category.php:462
16	hikashopCategoryClass->getRoot()	JROOT/administrator/components/com_hikashop/classes/category.php:479
15	hikashopCategoryClass->getMainElement()	JROOT/administrator/components/com_hikashop/classes/category.php:27
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:1633
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.14 ms После последнего запроса: 0.02 ms Память запроса: 0.024 MB Память до запроса: 5.746 MB Выбрано строк: 0

SELECT category_id 
  FROM flu_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='0' 
  LIMIT 1

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.06 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/administrator/components/com_hikashop/classes/category.php:481
15	hikashopCategoryClass->getMainElement()	JROOT/administrator/components/com_hikashop/classes/category.php:27
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:1633
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.12 ms После последнего запроса: 0.02 ms Память запроса: 0.023 MB Память до запроса: 5.754 MB Выбрано строк: 1

SELECT a.category_id 
  FROM flu_hikashop_product_category AS a 
  WHERE a.product_id=1739 
  ORDER BY a.product_category_id ASC 
  LIMIT 0, 1

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

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

Профилирование 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.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/views/product/view.html.php:1643
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.46 ms После последнего запроса: 0.04 ms Память запроса: 0.024 MB Память до запроса: 5.762 MB Выбрано строк: 42

SELECT DISTINCT a.product_id  
  FROM flu_hikashop_product_category AS a  
  LEFT JOIN flu_hikashop_product AS b 
  ON a.product_id=b.product_id  
  WHERE (b.product_published = 1) 
  AND (b.product_type = 'main') 
  AND (a.category_id = 122) 
  AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%'))  
  GROUP BY a.product_id 
  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	category_id,product_id	category_id	4	const	35	100.00	Using index condition; Using temporary; Используется filesort
1	SIMPLE	b	NULL	eq_ref	PRIMARY,product_main_index	PRIMARY	4	khanalex_slav1.a.product_id	1	5.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_hikashop/views/product/view.html.php:1688
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.15 ms После последнего запроса: 0.04 ms Память запроса: 0.042 MB Память до запроса: 5.781 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_product 
  WHERE product_id = '1770' 
  LIMIT 0, 1

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2380
15	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/product.php:30
14	hikashopProductClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:1704
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.14 ms После последнего запроса: 0.43 ms Память запроса: 0.041 MB Память до запроса: 5.799 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_product 
  WHERE product_id = '1755' 
  LIMIT 0, 1

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2380
15	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/product.php:30
14	hikashopProductClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:1716
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.22 ms После последнего запроса: 5.01 ms Память запроса: 0.023 MB Память до запроса: 5.817 MB Выбрано строк: 1

SELECT b.*  
  FROM flu_hikashop_product_category AS a  
  LEFT JOIN flu_hikashop_category AS b 
  ON a.category_id = b.category_id  
  WHERE a.product_id = 1739 
  ORDER BY a.product_category_id ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	product_id	product_id	4	const	1	100.00	Using index condition; Используется filesort
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.category_id	1	100.00	NULL

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

Status	Duration
starting	0.03 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.00 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1754
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.45 ms После последнего запроса: 3.44 ms Память запроса: 0.024 MB Память до запроса: 5.834 MB Выбрано строк: 0

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:206
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:1789
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.35 ms После последнего запроса: 0.05 ms Память запроса: 0.026 MB Память до запроса: 5.843 MB Выбрано строк: 44

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

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.19 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:211
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:1789
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*, c.currency_symbol 
  FROM flu_hikashop_shipping AS a  
  INNER JOIN flu_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id  
  WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%') 
  ORDER BY a.shipping_id

План 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	4	43.75	Using where; Используется filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.a.shipping_currency_id	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45
18	plgHikashopShippingmanual_prices->_getShippings()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:324
17	plgHikashopShippingmanual_prices->onHikaShopBeforeDisplayView()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2444
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM flu_extensions 
  WHERE folder='hikashop' 
  AND element='shippingmanual_prices' 
  AND type='plugin'

План 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,extension	element_clientid	402	const	1	5.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
18	hikashopPluginsClass->getByName()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:328
17	plgHikashopShippingmanual_prices->onHikaShopBeforeDisplayView()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2444
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.21 ms После последнего запроса: 13.37 ms Память запроса: 0.028 MB Память до запроса: 6.040 MB Выбрано строк: 1

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

SELECT product_average_score, product_total_vote 
  FROM flu_hikashop_product 
  WHERE product_id = 1739

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_hikashop/views/vote/view.html.php:346
23	VoteViewvote->mini()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:23
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT * 
  FROM flu_hikashop_vote 
  WHERE (vote_type = 'product') 
  AND (vote_rating != 0) 
  AND (vote_ref_id = 1739) 
  AND (vote_ip = '3.239.50.33') 
  AND (vote_user_id = '')

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/vote.php:687
24	hikashopVoteClass->getUserRating()	JROOT/components/com_hikashop/views/vote/view.html.php:366
23	VoteViewvote->mini()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:23
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.16 ms После последнего запроса: 0.98 ms Память запроса: 0.028 MB Память до запроса: 6.068 MB Выбрано строк: 1

SELECT COUNT(*) 
  FROM `flu_hikashop_vote` AS hika_vote 
  LEFT JOIN `flu_hikashop_user` AS hika_user 
  ON hika_vote.vote_user_id=hika_user.user_id 
  LEFT JOIN `flu_users`AS users 
  ON hika_user.user_cms_id=users.id  
  WHERE vote_published = 1 
  AND vote_type = 'product' 
  AND vote_ref_id = 1739 
  AND vote_comment != ''

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hika_vote	NULL	ALL	NULL	Индекс не используется	NULL	NULL	14	7.14	Using where
1	SIMPLE	hika_user	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.hika_vote.vote_user_id	1	100.00	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.hika_user.user_cms_id	1	100.00	Using where; Using index

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/views/vote/view.html.php:109
23	VoteViewvote->listing()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:24
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `flu_hikashop_vote` AS hika_vote 
  LEFT JOIN `flu_hikashop_user` AS hika_user 
  ON hika_vote.vote_user_id=hika_user.user_id 
  LEFT JOIN `flu_users`AS users 
  ON hika_user.user_cms_id=users.id  
  WHERE vote_published = 1 
  AND vote_type = 'product' 
  AND vote_ref_id = 1739 
  AND vote_comment != '' 
  ORDER BY `vote_date` ASC 
  LIMIT 0,20

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hika_vote	NULL	ALL	NULL	Индекс не используется	NULL	NULL	14	7.14	Using where; Используется filesort
1	SIMPLE	hika_user	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.hika_vote.vote_user_id	1	100.00	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	khanalex_slav1.hika_user.user_cms_id	1	100.00	Using where

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

Status	Duration
starting	0.04 ms
checking permissions	0.00 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.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/vote/view.html.php:115
23	VoteViewvote->listing()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:24
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT product_id 
  FROM flu_hikashop_product 
  WHERE product_parent_id = 1739

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
24	JDatabaseDriver->loadColumn()	JROOT/components/com_hikashop/views/vote/view.html.php:120
23	VoteViewvote->listing()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:24
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.24 ms После последнего запроса: 3.02 ms Память запроса: 0.045 MB Память до запроса: 6.120 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_product 
  WHERE product_id = '1739' 
  LIMIT 0, 1

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2380
25	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/product.php:30
24	hikashopProductClass->get()	JROOT/components/com_hikashop/views/vote/view.html.php:188
23	VoteViewvote->listing()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:24
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.11 ms После последнего запроса: 1.30 ms Память запроса: 0.028 MB Память до запроса: 6.132 MB Выбрано строк: 1

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

SELECT product_average_score, product_total_vote 
  FROM flu_hikashop_product 
  WHERE product_id = 1739

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_hikashop/views/vote/view.html.php:243
23	VoteViewvote->form()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:25
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT * 
  FROM flu_hikashop_vote 
  WHERE (vote_type = 'product') 
  AND (vote_rating != 0) 
  AND (vote_ref_id = 1739) 
  AND (vote_ip = '3.239.50.33') 
  AND (vote_user_id = '')

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/vote.php:687
24	hikashopVoteClass->getUserRating()	JROOT/components/com_hikashop/views/vote/view.html.php:290
23	VoteViewvote->form()	JROOT/components/com_hikashop/views/vote/view.html.php:16
22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
21	hikashop_getLayout()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:25
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.16 ms После последнего запроса: 1.15 ms Память запроса: 0.029 MB Память до запроса: 6.154 MB Выбрано строк: 1

SELECT * 
  FROM flu_hikashop_category 
  WHERE category_id = '117' 
  LIMIT 0, 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	flu_hikashop_category	NULL	const	PRIMARY	PRIMARY	4	const	1	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.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2380
25	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:37
24	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/tmpl/show_block_dimensions.php:57
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_dimensions.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:29
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.45 ms После последнего запроса: 0.08 ms Память запроса: 0.029 MB Память до запроса: 6.171 MB Выбрано строк: 21

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

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

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

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

Status	Duration
starting	0.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.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.21 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
24	hikashopMenusClass->loadAMenuItemId()	JROOT/components/com_hikashop/views/product/tmpl/show_block_dimensions.php:60
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_dimensions.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:29
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.14 ms После последнего запроса: 0.04 ms Память запроса: 0.029 MB Память до запроса: 6.186 MB Выбрано строк: 13

SELECT category_id 
  FROM flu_hikashop_category 
  WHERE category_type = 'manufacturer'

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

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

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

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.06 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/menus.php:296
24	hikashopMenusClass->loadAMenuItemId()	JROOT/components/com_hikashop/views/product/tmpl/show_block_dimensions.php:60
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_dimensions.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:29
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.21 ms После последнего запроса: 1.40 ms Память запроса: 0.029 MB Память до запроса: 6.377 MB Выбрано строк: 1

SELECT * 
  FROM flu_extensions 
  WHERE folder='system' 
  AND element='hikashopsocial' 
  AND type='plugin'

План 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,extension	element_clientid	402	const	1	5.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.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
24	hikashopPluginsClass->getByName()	JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php:12
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:56
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM flu_extensions 
  WHERE folder='content' 
  AND element='hikashopsocial' 
  AND type='plugin'

План 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,extension	element_clientid	402	const	1	5.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.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
24	hikashopPluginsClass->getByName()	JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php:16
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:56
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `flu_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_hikashop.product' 
  AND `m`.`content_item_id` = 1739 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
24	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php:29
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php:210
20	include JROOT/components/com_hikashop/views/product/tmpl/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT cart.cart_id 
  FROM flu_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = 'daaa9a89498110b575ff7db087290366')  
  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.06 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.06 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.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
25	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:131
24	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:505
23	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:587
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:394
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.14 ms После последнего запроса: 0.07 ms Память запроса: 0.027 MB Память до запроса: 6.687 MB Выбрано строк: 1

SELECT category_id 
  FROM flu_hikashop_category 
  WHERE (category_access = 'all' OR category_access LIKE '%,9,%') 
  AND category_id IN ('2')

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/components/com_hikashop/views/product/view.html.php:611
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:394
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.29 ms После последнего запроса: 9.44 ms Память запроса: 0.029 MB Память до запроса: 6.781 MB Выбрано строк: 3

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/filter.php:295
24	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:185
23	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:637
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:394
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.48 ms После последнего запроса: 0.06 ms Память запроса: 0.029 MB Память до запроса: 6.801 MB Выбрано строк: 2

SELECT hk_parent.* 
  FROM flu_hikashop_category AS hk_cat  
  LEFT JOIN flu_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id = 2 
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:756
25	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/filter.php:315
24	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:185
23	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:637
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:859
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:394
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2512
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2480
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2218
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1959
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2196
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php

Пн	Вт	Ср	Чт	Пт	Сб	Вс
27	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

Часы мужские «Восток» Коллекция Партнер. 251249

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

Сессия

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

Время

Память

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

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

Зафиксировано 66 SQL-запросов 19.65 ms

7 повторяющийся запрос!