Рюкзак BASEG Spider

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1785725556,
                "last": 1785725556,
                "now": 1785725556
            },
            "token": "NdiAc9l9zY1mcGf9V4Pp5tz9NZDXdwFV"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "js_id_currency_orig": "2",
        "js_id_currency": "2",
        "js_history_sel_lang": "ru-RU",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB",
            "ru-RU"
        ],
        "jshop_end_page_buy_product": "/ryukzak-baseg-spider.html",
        "product_back_value": []
    }
}

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

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

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.06 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init for update	0.06 ms
Update	0.15 ms
Waiting for query cache lock	0.05 ms
Update	0.04 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.07 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 6.10 ms После последнего запроса: 7.45 ms Память запроса: 0.021 MB. Память перед запросом: 1.308 MB Возвращено строк: 37

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

  FROM `bsg_extensions`

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

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	4.42 ms
Preparing	0.08 ms
Executing	0.05 ms
Sending data	0.51 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.05 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.06 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.05 ms

Стек вызовов

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

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

Время запроса: 1.00 ms После последнего запроса: 6.93 ms Память запроса: 0.020 MB. Память перед запросом: 1.319 MB Возвращено строк: 5

SELECT id, rules

  FROM `bsg_viewlevels`

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.07 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 1.20 ms После последнего запроса: 0.10 ms Память запроса: 0.020 MB. Память перед запросом: 1.328 MB Возвращено строк: 2

SELECT b.id

  FROM bsg_usergroups AS a

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

  WHERE a.id = 9

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

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

Профиль

Status	Duration
Starting	0.08 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.04 ms
Unlocking tables	0.03 ms
Preparing	0.06 ms
Executing	0.04 ms
Sending data	0.06 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 2.29 ms После последнего запроса: 1.91 ms Память запроса: 0.022 MB. Память перед запросом: 1.349 MB Возвращено строк: 88

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

  FROM bsg_extensions

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

  ORDER BY ordering

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

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

Профиль

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.08 ms
Sorting result	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	1.02 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.05 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 36.68 ms После последнего запроса: 39.39 ms Память запроса: 0.020 MB. Память перед запросом: 1.846 MB Возвращено строк: 1

SELECT `template`

  FROM `bsg_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsg_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

Профиль

Status	Duration
Starting	0.19 ms
Checking permissions	0.06 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.06 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	35.34 ms
Preparing	0.08 ms
Executing	0.10 ms
Sending data	0.15 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 1.94 ms После последнего запроса: 15.34 ms Память запроса: 0.024 MB. Память перед запросом: 1.938 MB Возвращено строк: 4

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM bsg_menu AS m

  LEFT JOIN bsg_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	4	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	baseg_db.m.component_id	1	Using where

Профиль

Status	Duration
Starting	0.25 ms
Checking permissions	0.06 ms
Opening tables	0.07 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.05 ms
Init	0.08 ms
Optimizing	0.07 ms
Statistics	0.18 ms
Preparing	0.09 ms
Sorting result	0.06 ms
Executing	0.05 ms
Sending data	0.06 ms
Creating sort index	0.25 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.05 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.06 ms

Стек вызовов

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

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

Время запроса: 3.23 ms После последнего запроса: 51.15 ms Память запроса: 0.026 MB. Память перед запросом: 2.200 MB Возвращено строк: 140

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_config`

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

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

Профиль

Status	Duration
Starting	0.19 ms
Checking permissions	0.05 ms
Closing tables	0.05 ms
Opening tables	0.48 ms
After opening tables	0.07 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
Checking permissions	0.53 ms
Closing tables	0.06 ms
Executing	0.05 ms
Sending data	0.36 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Removing tmp table	0.23 ms
Closing tables	0.08 ms
Unlocking tables	0.05 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.05 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/config.php:14
15	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.65 ms После последнего запроса: 2.79 ms Память запроса: 0.097 MB. Память перед запросом: 2.386 MB Возвращено строк: 1

SELECT *

  FROM bsg_jshopping_config

  WHERE `id` = '1'

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.06 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.05 ms
Init	0.13 ms
Optimizing	0.07 ms
Statistics	0.09 ms
Preparing	0.05 ms
Unlocking tables	0.12 ms
Preparing	0.06 ms
Executing	0.05 ms
Sending data	0.20 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.05 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.06 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
15	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/lib/factory.php:30
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.09 ms После последнего запроса: 0.60 ms Память запроса: 0.025 MB. Память перед запросом: 2.389 MB Возвращено строк: 8

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_currencies`

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

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

Профиль

Status	Duration
Starting	0.08 ms
Checking permissions	0.05 ms
Closing tables	0.05 ms
Opening tables	0.37 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.06 ms
Executing	0.05 ms
Filling schema table	0.05 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
Checking permissions	0.14 ms
Closing tables	0.06 ms
Executing	0.05 ms
Sending data	0.09 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Removing tmp table	0.15 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.05 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
19	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
17	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:569
16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.06 ms После последнего запроса: 0.12 ms Память запроса: 0.024 MB. Память перед запросом: 2.407 MB Возвращено строк: 2

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `bsg_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

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

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

Профиль

Status	Duration
Starting	0.08 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.06 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
17	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:570
16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.77 ms После последнего запроса: 4.00 ms Память запроса: 0.069 MB. Память перед запросом: 2.482 MB Возвращено строк: 812

select product_id as id, `alias_ru-RU` as alias 
  from bsg_jshopping_products 
  where `alias_ru-RU`!=''

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	1.82 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:303
14	JSFactory::getAliasProduct()	JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:42
13	plgJshoppingRouterJshopping_product_seo->onBeforeParseRoute()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/router.php:232
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.02 ms После последнего запроса: 8.76 ms Память запроса: 0.025 MB. Память перед запросом: 2.585 MB Возвращено строк: 52

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_products`

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

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

Профиль

Status	Duration
Starting	0.11 ms
Checking permissions	0.04 ms
Closing tables	0.03 ms
Opening tables	0.32 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
Checking permissions	0.26 ms
Closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.13 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.17 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/product.php:15
15	jshopProduct->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:60
13	plgJshoppingRouterJshopping_product_seo->onAfterParseRoute()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/router.php:371
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.47 ms После последнего запроса: 0.32 ms Память запроса: 0.039 MB. Память перед запросом: 2.653 MB Возвращено строк: 1

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

SELECT *

  FROM bsg_jshopping_products

  WHERE `product_id` = '155'

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	1.51 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:61
13	plgJshoppingRouterJshopping_product_seo->onAfterParseRoute()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/router.php:371
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.23 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB. Память перед запросом: 2.659 MB Возвращено строк: 1

SELECT pr_cat.category_id 
  FROM `bsg_jshopping_products_to_categories` AS pr_cat
                
  LEFT JOIN `bsg_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
  WHERE pr_cat.product_id=155 
  AND cat.category_publish=1  
  AND cat.access IN (1,1,5)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cat	ALL	NULL	INDEX KEY не используется	NULL	NULL	75	Using where
1	SIMPLE	pr_cat	ALL	NULL	INDEX KEY не используется	NULL	NULL	996	Using where; Using join buffer (flat, BNL join)

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.06 ms
Executing	0.04 ms
Sending data	0.22 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/product.php:467
14	jshopProduct->getCategory()	JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:62
13	plgJshoppingRouterJshopping_product_seo->onAfterParseRoute()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/router.php:371
10	jshoppingParseRoute()	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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.17 ms После последнего запроса: 1.07 ms Память запроса: 0.022 MB. Память перед запросом: 2.675 MB Возвращено строк: 1

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

  FROM `bsg_extensions`

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

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

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

Профиль

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.17 ms
Preparing	0.06 ms
Executing	0.04 ms
Sending data	0.11 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.02 ms После последнего запроса: 0.16 ms Память запроса: 0.004 MB. Память перед запросом: 2.665 MB

UPDATE `bsg_extensions`

  SET `params` = '{\"mediaversion\":\"249917b3d15ef159b1d9401bb0ae4190\"}'

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

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

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

Профиль

Status	Duration
Starting	0.08 ms
Checking permissions	0.05 ms
Opening tables	0.10 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.10 ms
Updating	0.12 ms
End of update loop	0.04 ms
Waiting for query cache lock	0.03 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.07 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.17 ms После последнего запроса: 5.15 ms Память запроса: 0.019 MB. Память перед запросом: 2.736 MB Возвращено строк: 1

SELECT *

  FROM bsg_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.14 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 1.21 ms После последнего запроса: 0.26 ms Память запроса: 0.018 MB. Память перед запросом: 2.746 MB Возвращено строк: 3

SELECT id, home, template, s.params

  FROM bsg_template_styles as s

  LEFT JOIN bsg_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	baseg_db.s.template,const	1	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.15 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 0.94 ms После последнего запроса: 3.76 ms Память запроса: 0.020 MB. Память перед запросом: 2.844 MB Возвращено строк: 2

select * 
  from bsg_jshopping_languages

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.05 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/functions.php:297
8	installNewLanguages()	JROOT/components/com_jshopping/loadparams.php:33
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.70 ms После последнего запроса: 18.42 ms Память запроса: 0.037 MB. Память перед запросом: 2.941 MB Возвращено строк: 1

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

SELECT *

  FROM bsg_jshopping_products

  WHERE `product_id` = '155'

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

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

Профиль

Status	Duration
Starting	0.13 ms
Checking permissions	0.12 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	1.58 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/product.php:45
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.89 ms После последнего запроса: 2.14 ms Память запроса: 0.023 MB. Память перед запросом: 2.945 MB Возвращено строк: 25

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_categories`

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.05 ms
Closing tables	0.04 ms
Opening tables	0.33 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
Checking permissions	0.17 ms
Closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.14 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/category.php:15
11	jshopCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/product.php:51
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT *

  FROM bsg_jshopping_categories

  WHERE `category_id` = '42'

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

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

Профиль

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.13 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/product.php:52
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `bsg_jshopping_products_to_categories` 
  WHERE product_id=155

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

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

Профиль

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.14 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:282
10	jshopProduct->getCategories()	JROOT/components/com_jshopping/models/productshop.php:81
9	jshopProductShop->getCategories()	JROOT/components/com_jshopping/controllers/product.php:57
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.66 ms После последнего запроса: 0.75 ms Память запроса: 0.025 MB. Память перед запросом: 2.992 MB Возвращено строк: 11

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_attr`

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

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

Профиль

Status	Duration
Starting	0.08 ms
Checking permissions	0.05 ms
Closing tables	0.03 ms
Opening tables	0.26 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
Checking permissions	0.11 ms
Closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.12 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/attribut.php:14
16	jshopAttribut->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:317
13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:128
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:207
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:235
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:95
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname
                  
  FROM `bsg_jshopping_attr` as A 
  left join `bsg_jshopping_attr_groups` as G 
  on A.`
  group`=G.id
                  
  ORDER BY G.ordering, A.attr_ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	G	system	NULL	INDEX KEY не используется	NULL	NULL	0	Const row not found
1	SIMPLE	A	ALL	NULL	INDEX KEY не используется	NULL	NULL	7	Используется сортировка файлов

Профиль

Status	Duration
Starting	0.11 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Sorting result	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Creating sort index	0.10 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/attribut.php:28
14	jshopAttribut->getAllAttributes()	JROOT/components/com_jshopping/lib/factory.php:318
13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:128
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:207
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:235
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:95
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.11 ms После последнего запроса: 0.07 ms Память запроса: 0.022 MB. Память перед запросом: 3.023 MB Возвращено строк: 0

SELECT * 
  FROM `bsg_jshopping_products_attr2` 
  WHERE product_id=155 
  ORDER BY id

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

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

Профиль

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.12 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:168
13	jshopProduct->getAttributes2()	JROOT/components/com_jshopping/tables/product.php:144
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:207
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:235
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:95
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.97 ms После последнего запроса: 3.91 ms Память запроса: 0.025 MB. Память перед запросом: 3.030 MB Возвращено строк: 53

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_users`

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Closing tables	0.03 ms
Opening tables	0.27 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
Checking permissions	0.25 ms
Closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.14 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.14 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
14	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
13	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
12	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/product.php:1145
11	jshopProduct->getBuildSelectAttributes()	JROOT/components/com_jshopping/tables/product.php:239
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:95
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 201.09 ms После последнего запроса: 0.27 ms Память запроса: 0.021 MB. Память перед запросом: 3.099 MB Возвращено строк: 4

SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices 
  FROM `bsg_jshopping_products_relations` AS relation
                
  INNER JOIN `bsg_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                
  LEFT JOIN `bsg_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                
  LEFT JOIN `bsg_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
                
  WHERE relation.product_id=155 
  AND cat.category_publish=1 
  AND prod.product_publish=1  
  AND prod.access IN (1,1,5) 
  AND cat.access IN (1,1,5)
				
  group by prod.product_id 
  order by relation.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cat	ALL	NULL	INDEX KEY не используется	NULL	NULL	75	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	relation	ALL	NULL	INDEX KEY не используется	NULL	NULL	586	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	prod	ALL	NULL	INDEX KEY не используется	NULL	NULL	812	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	pr_cat	ALL	NULL	INDEX KEY не используется	NULL	NULL	996	Using where; Using join buffer (incremental, BNL join)

Профиль

Status	Duration
Starting	0.18 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.09 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.06 ms
Creating tmp table	0.07 ms
Sorting result	0.06 ms
Executing	0.03 ms
Sending data	199.31 ms
Creating sort index	0.24 ms
Removing tmp table	0.18 ms
Creating sort index	0.04 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:869
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:535
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:104
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.22 ms После последнего запроса: 0.25 ms Память запроса: 0.024 MB. Память перед запросом: 3.114 MB Возвращено строк: 2

select id,link 
  from bsg_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='ru-RU') 
  and access IN (1,1,5)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bsg_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	5	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.17 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.18 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
17	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
16	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
15	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:403
14	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:422
13	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:481
12	SEFLink()	JROOT/components/com_jshopping/tables/product.php:871
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:535
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:104
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.02 ms После последнего запроса: 1.05 ms Память запроса: 0.027 MB. Память перед запросом: 3.129 MB Возвращено строк: 75

select category_id as id, `alias_ru-RU` as alias 
  from bsg_jshopping_categories 
  where `alias_ru-RU`!=''

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.13 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:255
21	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:82
20	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_jshopping/lib/functions.php:496
12	SEFLink()	JROOT/components/com_jshopping/tables/product.php:871
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:535
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:104
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.79 ms После последнего запроса: 1.02 ms Память запроса: 0.025 MB. Память перед запросом: 3.153 MB Возвращено строк: 3

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_taxes`

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

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

Профиль

Status	Duration
Starting	0.08 ms
Checking permissions	0.04 ms
Closing tables	0.03 ms
Opening tables	0.38 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
Checking permissions	0.09 ms
Closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.16 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
16	jshopTax->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:369
13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:664
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:873
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:535
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:104
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT tax_id, tax_name, tax_value 
  FROM `bsg_jshopping_taxes`

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

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

Профиль

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.14 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
15	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:355
14	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:370
13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:664
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:873
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:535
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:104
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url 
  from bsg_jshopping_manufacturers 
  where manufacturer_publish='1'

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

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

Профиль

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.12 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:422
13	JSFactory::getAllManufacturer()	JROOT/components/com_jshopping/lib/functions.php:666
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:873
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:535
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:104
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.78 ms После последнего запроса: 1.07 ms Память запроса: 0.023 MB. Память перед запросом: 3.271 MB Возвращено строк: 10

SHOW FULL COLUMNS 
  FROM `bsg_jshopping_products_reviews`

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

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

Профиль

Status	Duration
Starting	0.08 ms
Checking permissions	0.04 ms
Closing tables	0.03 ms
Opening tables	0.30 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.04 ms
Filling schema table	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
Checking permissions	0.11 ms
Closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.14 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/review.php:14
12	jshopReview->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
10	JSFactory::getTable()	JROOT/components/com_jshopping/models/productshop.php:117
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:59
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.05 ms После последнего запроса: 1.45 ms Память запроса: 0.022 MB. Память перед запросом: 3.294 MB Возвращено строк: 1

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

SELECT *

  FROM bsg_jshopping_categories

  WHERE `category_id` = '33'

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

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

Профиль

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.13 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
11	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/tables/category.php:81
10	jshopCategory->getTreeChild()	JROOT/components/com_jshopping/helpers/metadata.php:201
9	JshopHelpersMetadata::product()	JROOT/components/com_jshopping/controllers/product.php:70
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.80 ms После последнего запроса: 1.80 ms Память запроса: 0.004 MB. Память перед запросом: 3.300 MB

UPDATE bsg_jshopping_products

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

  WHERE `product_id` = '155'

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

EXPLAIN недоступен для UPDATE bsg_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '155'

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.06 ms
Updating	2.92 ms
End of update loop	0.05 ms
Waiting for query cache lock	0.03 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Waiting for query cache lock	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
9	Joomla\CMS\Table\Table->hit()	JROOT/components/com_jshopping/controllers/product.php:72
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `bsg_jshopping_products_images` as I
				 
  left join `bsg_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=155 
  ORDER BY sort, I.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ALL	NULL	INDEX KEY не используется	NULL	NULL	2478	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	P	ALL	NULL	INDEX KEY не используется	NULL	NULL	812	Using where; Using join buffer (flat, BNL join)

Профиль

Status	Duration
Starting	0.09 ms
Checking permissions	0.07 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.09 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	1.85 ms
Creating sort index	0.06 ms
Removing tmp table	0.03 ms
Creating sort index	0.03 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:371
9	jshopProduct->getImages()	JROOT/components/com_jshopping/controllers/product.php:82
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT  video_name, video_id, video_preview, video_code 
  FROM `bsg_jshopping_products_videos` 
  WHERE product_id=155

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

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

Профиль

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.05 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:391
9	jshopProduct->getVideos()	JROOT/components/com_jshopping/controllers/product.php:83
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.81 ms После последнего запроса: 39.16 ms Память запроса: 0.023 MB. Память перед запросом: 3.604 MB Возвращено строк: 6

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

  FROM bsg_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-03 02:52:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-03 02:52:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

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

Профиль

Status	Duration
Starting	0.24 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.10 ms
Optimizing	0.08 ms
Statistics	0.18 ms
Preparing	0.11 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.35 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

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

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

Время запроса: 1.38 ms После последнего запроса: 15.70 ms Память запроса: 0.022 MB. Память перед запросом: 3.679 MB Возвращено строк: 1

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

SELECT *

  FROM bsg_jshopping_categories

  WHERE `category_id` = '42'

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

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

Профиль

Status	Duration
Starting	0.18 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.06 ms
Executing	0.04 ms
Sending data	0.21 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

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

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

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

SELECT category_parent_id 
  FROM `bsg_jshopping_categories` 
  WHERE category_id = '42' 
  and category_publish = '1' 
  and  access IN (1,1,5)

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.14 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:146
11	jshopCategory->getTreeParentCategories()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:41
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT category_parent_id 
  FROM `bsg_jshopping_categories` 
  WHERE category_id = '33' 
  and category_publish = '1' 
  and  access IN (1,1,5)

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.05 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.14 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:146
11	jshopCategory->getTreeParentCategories()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:41
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.08 ms После последнего запроса: 0.15 ms Память запроса: 0.023 MB. Память перед запросом: 3.700 MB Возвращено строк: 1

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

SELECT *

  FROM bsg_jshopping_categories

  WHERE `category_id` = '33'

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.16 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
13	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_jshopping_categories/helper.php:8
12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.24 ms После последнего запроса: 0.09 ms Память запроса: 0.022 MB. Память перед запросом: 3.705 MB Возвращено строк: 6

SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `bsg_jshopping_categories`
                   
  WHERE category_parent_id = '0'  
  AND category_publish = '1'  
  AND access IN (1,1,5)
                   
  ORDER BY ordering asc

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

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

Профиль

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.21 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
14	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:123
13	jshopCategory->getSisterCategories()	JROOT/modules/mod_jshopping_categories/helper.php:10
12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.06 ms После последнего запроса: 0.92 ms Память запроса: 0.023 MB. Память перед запросом: 3.728 MB Возвращено строк: 1

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

SELECT *

  FROM bsg_jshopping_categories

  WHERE `category_id` = '42'

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.16 ms
End of update loop	0.04 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_jshopping_categories/helper.php:8
13	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:26
12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.32 ms После последнего запроса: 0.08 ms Память запроса: 0.023 MB. Память перед запросом: 3.734 MB Возвращено строк: 10

SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `bsg_jshopping_categories`
                   
  WHERE category_parent_id = '33'  
  AND category_publish = '1'  
  AND access IN (1,1,5)
                   
  ORDER BY ordering asc

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

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

Профиль

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.25 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
15	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:123
14	jshopCategory->getSisterCategories()	JROOT/modules/mod_jshopping_categories/helper.php:10
13	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:26
12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.33 ms После последнего запроса: 1.35 ms Память запроса: 0.023 MB. Память перед запросом: 3.761 MB Возвращено строк: 1

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

SELECT *

  FROM bsg_jshopping_categories

  WHERE `category_id` = '42'

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

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

Профиль

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.17 ms
End of update loop	0.08 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.08 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.19 ms
Reset for next command	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_jshopping_categories/helper.php:18
13	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:26
12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `bsg_jshopping_categories`
                   
  WHERE category_parent_id = '42'  
  AND category_publish = '1'  
  AND access IN (1,1,5)
                   
  ORDER BY ordering asc

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

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

Профиль

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.14 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
15	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
14	jshopCategory->getChildCategories()	JROOT/modules/mod_jshopping_categories/helper.php:20
13	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:26
12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

6 × SELECT * 
  FROM bsg_jshopping_categories

3 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `bsg_jshopping_categories`

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

2 × SELECT * 
  FROM bsg_jshopping_products

2 × SELECT category_parent_id 
  FROM `bsg_jshopping_categories`

1 × SELECT `data` 
  FROM `bsg_session`

1 × SELECT `session_id` 
  FROM `bsg_session`

1 × SELECT id, rules 
  FROM `bsg_viewlevels

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

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

1 × SELECT `template` 
  FROM `bsg_template_styles`

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

1 × SELECT * 
  FROM bsg_jshopping_config

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `bsg_jshopping_currencies`

1 × select product_id as id, `alias_ru-RU` as alias 
  from bsg_jshopping_products

1 × SELECT pr_cat.category_id 
  FROM `bsg_jshopping_products_to_categories` AS pr_cat                 
  LEFT JOIN `bsg_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

```
1 × SELECT * 
  FROM bsg_languages
```

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

1 × select * 
  from bsg_jshopping_language

1 × SELECT * 
  FROM `bsg_jshopping_products_to_categories`

1 × SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname                   
  FROM `bsg_jshopping_attr` as A 
  left join `bsg_jshopping_attr_groups` as G 
  on A.`
  group`=G.id

1 × SELECT * 
  FROM `bsg_jshopping_products_attr2`

1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices 
  FROM `bsg_jshopping_products_relations` AS relation                 
  INNER JOIN `bsg_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id                 
  LEFT JOIN `bsg_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id                 
  LEFT JOIN `bsg_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

```
1 × select id,link 
  from bsg_menu
```

1 × select category_id as id, `alias_ru-RU` as alias 
  from bsg_jshopping_categories

1 × SELECT tax_id, tax_name, tax_value 
  FROM `bsg_jshopping_taxes

1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url 
  from bsg_jshopping_manufacturers

1 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `bsg_jshopping_products_images` as I      
  left join `bsg_jshopping_products` as P 
  on P.product_id=I.product_id

1 × SELECT  video_name, video_id, video_preview, video_code 
  FROM `bsg_jshopping_products_videos`

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

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

1 × INSERT INTO `bsg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6331383366636165613134613865306266323138636632333433653163396533', 1, 1785725556, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_currencies

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_products

1 × UPDATE `bsg_extensions` 
  SET `params` = '{\"mediaversion\":\"249917b3d15ef159b1d9401bb0ae4190\"}'

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_categories

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_attr

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_users

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `bsg_jshopping_products_reviews

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

Товары

Корзина

Рюкзак BASEG Spider

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

Сессия

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

Время

Память

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

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

51 запросов зарегистрировано 409.62 ms

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

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

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

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

Итоговая сумма:	0.00 Руб
В корзину