Время запроса: 1.28 ms Память запроса: 0.023 MB Память до запроса: 3.883 MB Выбрано строк: 0
SELECT `data`
FROM `smkrs_session`
WHERE `session_id` = X'6136313631656162356239363230306334383338393761383261376432346662'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.90 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Так же, как вызов в строке ниже. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.27 ms После последнего запроса: 2.89 ms Память запроса: 0.020 MB Память до запроса: 4.041 MB Выбрано строк: 0
SELECT `session_id`
FROM `smkrs_session`
WHERE `session_id` = X'6136313631656162356239363230306334383338393761383261376432346662'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 2.98 ms После последнего запроса: 0.08 ms Память запроса: 0.004 MB Память до запроса: 4.047 MB
INSERT INTO `smkrs_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6136313631656162356239363230306334383338393761383261376432346662', 1, 1775714271, 0, '', 0)
EXPLAIN не доступен для запроса: INSERT INTO `smkrs_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6136313631656162356239363230306334383338393761383261376432346662', 1, 1775714271, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| update | 0.11 ms |
| end | 0.01 ms |
| query end | 2.65 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.58 ms После последнего запроса: 6.25 ms Память запроса: 0.111 MB Память до запроса: 4.262 MB Выбрано строк: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `smkrs_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_extensions | NULL | ref | extension | extension | 82 | const | 43 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.21 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.02 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.28 ms После последнего запроса: 4.61 ms Память запроса: 0.021 MB Память до запроса: 4.498 MB Выбрано строк: 5
SELECT id, rules
FROM `smkrs_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_viewlevels | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.30 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB Память до запроса: 4.509 MB Выбрано строк: 1
SELECT b.id
FROM smkrs_usergroups AS a
LEFT JOIN smkrs_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.10 ms После последнего запроса: 0.77 ms Память запроса: 0.051 MB Память до запроса: 4.578 MB Выбрано строк: 162
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM smkrs_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_extensions | NULL | ref | extension | extension | 82 | const | 228 | 0.40 | Using index condition; Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.75 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 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:359 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 11.08 ms После последнего запроса: 57.41 ms Память запроса: 3.919 MB Память до запроса: 8.219 MB Выбрано строк: 1182
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 smkrs_menu AS m
LEFT JOIN smkrs_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
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 1247 | 10.00 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | demooz.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 10.49 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.03 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:76 |
| 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:131 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 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:491 |
| 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:1073 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.99 ms После последнего запроса: 59.44 ms Память запроса: 0.047 MB Память до запроса: 17.771 MB Выбрано строк: 140
SHOW FULL COLUMNS
FROM `smkrs_jshopping_config`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_config`
| Status | Duration |
|---|
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.20 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.04 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 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:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.45 ms После последнего запроса: 3.31 ms Память запроса: 0.076 MB Память до запроса: 18.019 MB Выбрано строк: 1
SELECT *
FROM smkrs_jshopping_config
WHERE `id` = '1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_config | NULL | system | PRIMARY | Индекс не используется | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 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:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.52 ms После последнего запроса: 0.75 ms Память запроса: 0.027 MB Память до запроса: 18.022 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `smkrs_jshopping_currencies`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_currencies`
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 20 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/currency.php:14 |
| 19 | jshopCurrency->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 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:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.32 ms После последнего запроса: 0.06 ms Память запроса: 0.024 MB Память до запроса: 18.041 MB Выбрано строк: 2
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `smkrs_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_currencies | NULL | ref | currency_publish | currency_publish | 1 | const | 1 | 100.00 | Using index condition; Используется filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 42.88 ms После последнего запроса: 5.28 ms Память запроса: 1.479 MB Память до запроса: 18.120 MB Выбрано строк: 18782
select product_id as id, `alias_ru-RU` as alias
from smkrs_jshopping_products
where `alias_ru-RU`!=''
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 18810 | 90.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 42.09 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:303 |
| 11 | JSFactory::getAliasProduct() | JROOT/components/com_jshopping/router.php:290 |
| 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:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.80 ms После последнего запроса: 52.40 ms Память запроса: 0.026 MB Память до запроса: 21.330 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `smkrs_jshopping_addons`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_addons`
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.24 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 15 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/addon.php:20 |
| 14 | jshopAddon->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 13 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9 |
| 12 | eval() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code(1) : eval()'d code(1) : eval()'d code:1 |
| 11 | eval() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code(1) : eval()'d code:1 |
| 10 | eval() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code:1 |
| 9 | plgSystemUnijax_Filter->{closure}() | JROOT/plugins/system/unijax_filter/unijax_filter.php:18 |
| 8 | plgSystemUnijax_Filter->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.38 ms После последнего запроса: 0.12 ms Память запроса: 0.023 MB Память до запроса: 21.350 MB Выбрано строк: 1
Повторяющиеся запросы:
#24SELECT *
FROM smkrs_jshopping_addons
WHERE `alias` = 'addon_universal_ajax_filter'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_addons | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/tables/addon.php:36 |
| 13 | jshopAddon->loadAlias() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:10 |
| 12 | eval() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code(1) : eval()'d code(1) : eval()'d code:1 |
| 11 | eval() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code(1) : eval()'d code:1 |
| 10 | eval() | JROOT/plugins/system/unijax_filter/unijax_filter.php(18) : eval()'d code:1 |
| 9 | plgSystemUnijax_Filter->{closure}() | JROOT/plugins/system/unijax_filter/unijax_filter.php:18 |
| 8 | plgSystemUnijax_Filter->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.40 ms После последнего запроса: 1.19 ms Память запроса: 0.022 MB Память до запроса: 21.360 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `smkrs_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:1130 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 5.45 ms После последнего запроса: 0.15 ms Память запроса: 0.005 MB Память до запроса: 21.353 MB
UPDATE `smkrs_extensions`
SET `params` = '{\"mediaversion\":\"0562d759327d7597a6ecedd2d07b330a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | smkrs_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.05 ms |
| updating | 0.08 ms |
| end | 0.01 ms |
| query end | 5.11 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 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:1130 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.39 ms После последнего запроса: 3.14 ms Память запроса: 0.019 MB Память до запроса: 21.589 MB Выбрано строк: 1
SELECT *
FROM smkrs_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_languages | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 1 | 100.00 | Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.56 ms После последнего запроса: 0.27 ms Память запроса: 0.175 MB Память до запроса: 21.598 MB Выбрано строк: 5
SELECT id, home, template, s.params
FROM smkrs_template_styles as s
LEFT JOIN smkrs_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
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 7 | 1.00 | Using index condition; Using where |
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | demooz.e.element | 1 | 75.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.20 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.43 ms После последнего запроса: 39.21 ms Память запроса: 0.021 MB Память до запроса: 21.900 MB Выбрано строк: 2
select *
from smkrs_jshopping_languages
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_languages | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 2 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.16 ms После последнего запроса: 34.16 ms Память запроса: 0.029 MB Память до запроса: 23.642 MB Выбрано строк: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `smkrs_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jlsitemap','com_joomlaupdate','com_jotcache','com_jshopping','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 42 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.17 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.49 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 18 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 16 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 15 | Joomla\CMS\User\User->authorise() | JROOT/plugins/jshoppingcheckout/order_gift/order_gift.php:15 |
| 14 | plgJshoppingCheckoutOrder_Gift->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 13 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 12 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jshopping/models/productshop.php:21 |
| 11 | jshopProductShop->__construct() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() | JROOT/components/com_jshopping/lib/factory.php:628 |
| 9 | JSFactory::getModel() | JROOT/components/com_jshopping/controllers/product.php:25 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.39 ms После последнего запроса: 5.21 ms Память запроса: 0.006 MB Память до запроса: 24.233 MB
UPDATE `smkrs_jshopping_products`
SET `product_price`=`product_old_price`, `product_old_price`='0.00', `price_date_end`='0000-00-00 00:00:00'
WHERE product_old_price > product_price
AND price_date_end <= '2026-04-09 08:57:51'
AND price_date_end <> '0000-00-00 00:00:00'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | smkrs_jshopping_products | NULL | range | price_date_end | price_date_end | 5 | const | 2 | 100.00 | Using where; Using temporary |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.06 ms |
| Searching rows for update | 0.07 ms |
| updating | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/jshoppingproducts/price_time/price_time.php:42 |
| 11 | plgJshoppingProductsPrice_time->onBeforeLoadProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 9 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/controllers/product.php:42 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.27 ms После последнего запроса: 3.63 ms Память запроса: 0.060 MB Память до запроса: 24.828 MB Выбрано строк: 27
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM smkrs_modules AS m
LEFT JOIN smkrs_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN smkrs_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-04-09 05:57:51')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-09 05:57:51')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 620 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 6 | NULL | 38 | 1.60 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | demooz.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | demooz.m.id | 46 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.67 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 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:432 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 13 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
| 12 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:493 |
| 11 | plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 9 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/controllers/product.php:42 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.51 ms После последнего запроса: 21.99 ms Память запроса: 0.025 MB Память до запроса: 25.783 MB Выбрано строк: 1
Повторяющиеся запросы:
#15SELECT *
FROM smkrs_jshopping_addons
WHERE `alias` = 'addon_universal_ajax_filter'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_addons | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 20 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 19 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/tables/addon.php:36 |
| 18 | jshopAddon->loadAlias() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:10 |
| 17 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code:1 |
| 16 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code:1 |
| 15 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code:1 |
| 14 | modJshopping_Unijax_FilterHelper->{closure}() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:604 |
| 13 | modJshopping_Unijax_FilterHelper->__construct() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:23 |
| 12 | modJshopping_Unijax_FilterHelper::getInstance() | JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:496 |
| 11 | plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 9 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/controllers/product.php:42 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.17 ms После последнего запроса: 1.23 ms Память запроса: 0.035 MB Память до запроса: 25.862 MB Выбрано строк: 54
Повторяющиеся запросы:
#36SHOW FULL COLUMNS
FROM `smkrs_jshopping_users`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_users`
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.24 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.03 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 21 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/usershopbase.php:14 |
| 20 | jshopUserShopBase->__construct() | JROOT/components/com_jshopping/models/userguest.php:16 |
| 19 | jshopUserGust->__construct() | JROOT/components/com_jshopping/lib/factory.php:66 |
| 18 | JSFactory::getUserShopGuest() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:39 |
| 17 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code:1 |
| 16 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code:1 |
| 15 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code:1 |
| 14 | modJshopping_Unijax_FilterHelper->{closure}() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:604 |
| 13 | modJshopping_Unijax_FilterHelper->__construct() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:23 |
| 12 | modJshopping_Unijax_FilterHelper::getInstance() | JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:496 |
| 11 | plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 9 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/controllers/product.php:42 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.57 ms После последнего запроса: 0.75 ms Память запроса: 0.029 MB Память до запроса: 25.953 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `smkrs_jshopping_usergroups`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_usergroups`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 25 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 24 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 23 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/usergroup.php:14 |
| 22 | jshopUserGroup->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 21 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 20 | JSFactory::getTable() | JROOT/components/com_jshopping/models/userguest.php:30 |
| 19 | jshopUserGust->load() | JROOT/components/com_jshopping/lib/factory.php:67 |
| 18 | JSFactory::getUserShopGuest() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:39 |
| 17 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code:1 |
| 16 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code:1 |
| 15 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code:1 |
| 14 | modJshopping_Unijax_FilterHelper->{closure}() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:604 |
| 13 | modJshopping_Unijax_FilterHelper->__construct() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:23 |
| 12 | modJshopping_Unijax_FilterHelper::getInstance() | JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:496 |
| 11 | plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 9 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/controllers/product.php:42 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 4.76 ms После последнего запроса: 1.18 ms Память запроса: 0.175 MB Память до запроса: 25.994 MB Выбрано строк: 1029
select id,link
from smkrs_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)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_menu | NULL | ref | idx_client_id_parent_id_alias_language,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 1248 | 0.13 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 4.36 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:141 |
| 23 | shopItemMenu->getList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:47 |
| 22 | shopItemMenu->init() | JROOT/components/com_jshopping/lib/shop_item_menu.php:40 |
| 21 | shopItemMenu::getInstance() | JROOT/components/com_jshopping/lib/functions.php:403 |
| 20 | getShopMainPageItemid() | JROOT/components/com_jshopping/lib/functions.php:422 |
| 19 | getDefaultItemid() | JROOT/components/com_jshopping/lib/functions.php:481 |
| 18 | SEFLink() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:127 |
| 17 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code(1) : eval()'d code:1 |
| 16 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code(1) : eval()'d code:1 |
| 15 | eval() | JROOT/modules/mod_jshopping_unijax_filter/helper.php(604) : eval()'d code:1 |
| 14 | modJshopping_Unijax_FilterHelper->{closure}() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:604 |
| 13 | modJshopping_Unijax_FilterHelper->__construct() | JROOT/modules/mod_jshopping_unijax_filter/helper.php:23 |
| 12 | modJshopping_Unijax_FilterHelper::getInstance() | JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:496 |
| 11 | plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 9 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/controllers/product.php:42 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.38 ms После последнего запроса: 6.72 ms Память запроса: 0.036 MB Память до запроса: 27.439 MB Выбрано строк: 84
SHOW FULL COLUMNS
FROM `smkrs_jshopping_products`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_products`
| Status | Duration |
|---|
| Opening tables | 0.19 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.14 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/product.php:15 |
| 11 | jshopProduct->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 9 | JSFactory::getTable() | JROOT/components/com_jshopping/controllers/product.php:44 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.50 ms После последнего запроса: 0.21 ms Память запроса: 0.040 MB Память до запроса: 27.547 MB Выбрано строк: 1
SELECT *
FROM smkrs_jshopping_products
WHERE `product_id` = '13775'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/controllers/product.php:45 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.76 ms После последнего запроса: 1.02 ms Память запроса: 0.027 MB Память до запроса: 27.601 MB Выбрано строк: 28
SHOW FULL COLUMNS
FROM `smkrs_jshopping_categories`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_categories`
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/category.php:15 |
| 11 | jshopCategory->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.27 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB Память до запроса: 27.641 MB Выбрано строк: 1
SELECT *
FROM smkrs_jshopping_categories
WHERE `category_id` = '51'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/controllers/product.php:52 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 27.645 MB Выбрано строк: 3
SELECT *
FROM `smkrs_jshopping_products_to_categories`
WHERE product_id=13775
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_to_categories | NULL | ref | PRIMARY,product_id,product_id_2 | product_id_2 | 4 | const | 2 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.52 ms После последнего запроса: 0.71 ms Память запроса: 0.028 MB Память до запроса: 27.673 MB Выбрано строк: 11
SHOW FULL COLUMNS
FROM `smkrs_jshopping_attr`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_attr`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.06 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/attribut.php:14 |
| 16 | jshopAttribut->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.70 ms После последнего запроса: 0.06 ms Память запроса: 0.031 MB Память до запроса: 27.697 MB Выбрано строк: 46
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 `smkrs_jshopping_attr` as A
left join `smkrs_jshopping_attr_groups` as G
on A.`
group`=G.id
ORDER BY G.ordering, A.attr_ordering| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | A | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 46 | 100.00 | Using temporary; Используется filesort |
| 1 | SIMPLE | G | NULL | ALL | PRIMARY | Индекс не используется | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.19 ms |
| Creating sort index | 0.14 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.34 ms После последнего запроса: 0.09 ms Память запроса: 0.040 MB Память до запроса: 27.744 MB Выбрано строк: 0
SELECT *
FROM `smkrs_jshopping_products_attr`
WHERE product_id=13775
ORDER BY product_attr_id
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_attr | NULL | ref | product_id | product_id | 4 | const | 1 | 100.00 | Using index condition; Используется filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:159 |
| 13 | jshopProduct->getAttributes() | JROOT/components/com_jshopping/tables/product.php:133 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.94 ms После последнего запроса: 0.53 ms Память запроса: 0.033 MB Память до запроса: 27.772 MB Выбрано строк: 54
Повторяющиеся запросы:
#25SHOW FULL COLUMNS
FROM `smkrs_jshopping_users`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_users`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.52 ms После последнего запроса: 0.77 ms Память запроса: 0.028 MB Память до запроса: 27.851 MB Выбрано строк: 11
SHOW FULL COLUMNS
FROM `smkrs_jshopping_products_extra_fields`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_products_extra_fields`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.04 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 19 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 18 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/productfield.php:14 |
| 17 | jshopProductField->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 16 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 15 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:496 |
| 14 | JSFactory::getAllProductExtraField() | JROOT/components/com_jshopping/lib/functions.php:1136 |
| 13 | getQueryListProductsExtraFields() | JROOT/components/com_jshopping/lib/jtableauto.php:214 |
| 12 | JTableAvto->getBuildQueryListProductSimpleList() | JROOT/components/com_jshopping/tables/product.php:856 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.53 ms После последнего запроса: 0.07 ms Память запроса: 0.063 MB Память до запроса: 27.873 MB Выбрано строк: 27
SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_ru-RU` as groupname, multilist
FROM `smkrs_jshopping_products_extra_fields` as F
left join `smkrs_jshopping_products_extra_field_groups` as G
on G.id=F.
group
order by G.ordering, F.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | G | NULL | system | PRIMARY | Индекс не используется | NULL | NULL | 0 | 0.00 | const row not found |
| 1 | SIMPLE | F | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 27 | 100.00 | Используется filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.30 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfield.php:48 |
| 15 | jshopProductField->getList() | JROOT/components/com_jshopping/lib/factory.php:497 |
| 14 | JSFactory::getAllProductExtraField() | JROOT/components/com_jshopping/lib/functions.php:1136 |
| 13 | getQueryListProductsExtraFields() | JROOT/components/com_jshopping/lib/jtableauto.php:214 |
| 12 | JTableAvto->getBuildQueryListProductSimpleList() | JROOT/components/com_jshopping/tables/product.php:856 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.31 ms После последнего запроса: 1.45 ms Память запроса: 0.025 MB Память до запроса: 28.171 MB Выбрано строк: 1
SELECT *
FROM smkrs_jshopping_addons
WHERE `alias` = 'addon_bonus_system'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_addons | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 17 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/tables/addon.php:36 |
| 16 | jshopAddon->loadAlias() | JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:23 |
| 15 | plgJshoppingProductsBonus_System->init() | JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:290 |
| 14 | plgJshoppingProductsBonus_System->onBeforeQueryGetProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/tables/product.php:859 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 0.11 ms Память запроса: 0.024 MB Память до запроса: 28.192 MB Выбрано строк: 1
SELECT `usergroup_id`
FROM `smkrs_jshopping_usergroups`
WHERE `usergroup_is_default`= '1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_usergroups | NULL | ref | usergroup_is_default | usergroup_is_default | 1 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_jshopping/tables/usergroup.php:21 |
| 16 | jshopUserGroup->getDefaultUsergroup() | JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:32 |
| 15 | plgJshoppingProductsBonus_System->init() | JROOT/plugins/jshoppingproducts/bonus_system/bonus_system.php:290 |
| 14 | plgJshoppingProductsBonus_System->onBeforeQueryGetProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/tables/product.php:859 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.02 ms После последнего запроса: 0.05 ms Память запроса: 0.026 MB Память до запроса: 28.198 MB Выбрано строк: 7
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, prod.delivery_times_id, prod.`extra_field_1` , prod.`extra_field_2` , prod.unlimited, IF(prod.product_quantity>0,1,0) as qflag, prod.product_bonus_add, prod.product_bonus_sub
FROM `smkrs_jshopping_products_relations` AS relation
INNER JOIN `smkrs_jshopping_products` AS prod
ON relation.product_related_id = prod.product_id
LEFT JOIN `smkrs_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `smkrs_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE relation.product_id=13775
AND cat.category_publish=1
AND prod.product_publish=1
AND prod.access IN (1,1)
AND cat.access IN (1,1)
group by prod.product_id
ORDER BY qflag DESC, name ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | relation | NULL | ref | product_id,product_id_2,product_related_id | product_id | 4 | const | 8 | 100.00 | Using index; Using temporary; Используется filesort |
| 1 | SIMPLE | prod | NULL | eq_ref | PRIMARY,product_publish,access | PRIMARY | 4 | demooz.relation.product_related_id | 1 | 65.97 | Using where |
| 1 | SIMPLE | pr_cat | NULL | ref | PRIMARY,category_id,product_id,product_id_2 | PRIMARY | 4 | demooz.relation.product_related_id | 6 | 100.00 | Using index |
| 1 | SIMPLE | cat | NULL | eq_ref | PRIMARY,category_publish,access,category_publish_2 | PRIMARY | 4 | demooz.pr_cat.category_id | 1 | 96.51 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.68 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.79 ms |
| Creating sort index | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.03 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.19 ms После последнего запроса: 0.17 ms Память запроса: 0.049 MB Память до запроса: 28.230 MB Выбрано строк: 391
select category_id as id, `alias_ru-RU` as alias
from smkrs_jshopping_categories
where `alias_ru-RU`!=''
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_categories | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 1144 | 90.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.94 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.49 ms После последнего запроса: 1.44 ms Память запроса: 0.026 MB Память до запроса: 28.284 MB Выбрано строк: 3
SHOW FULL COLUMNS
FROM `smkrs_jshopping_taxes`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_taxes`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.05 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/tax.php:14 |
| 16 | jshopTax->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 0.06 ms Память запроса: 0.024 MB Память до запроса: 28.298 MB Выбрано строк: 1
SELECT tax_id, tax_name, tax_value
FROM `smkrs_jshopping_taxes`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_taxes | NULL | system | NULL | Индекс не используется | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 0.04 ms Память запроса: 0.023 MB Память до запроса: 28.304 MB Выбрано строк: 10
select id, `name_ru-RU` as name
from smkrs_jshopping_delivery_times
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_delivery_times | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 10 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:466 |
| 13 | JSFactory::getAllDeliveryTime() | JROOT/components/com_jshopping/lib/functions.php:672 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.48 ms После последнего запроса: 0.65 ms Память запроса: 0.026 MB Память до запроса: 28.323 MB Выбрано строк: 5
SHOW FULL COLUMNS
FROM `smkrs_jshopping_products_extra_field_values`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_products_extra_field_values`
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 19 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 18 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/productfieldvalue.php:15 |
| 17 | jshopProductFieldValue->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 16 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 15 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:505 |
| 14 | JSFactory::getAllProductExtraFieldValue() | JROOT/components/com_jshopping/lib/functions.php:821 |
| 13 | getProductExtraFieldForProduct() | JROOT/components/com_jshopping/lib/functions.php:746 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.42 ms После последнего запроса: 0.05 ms Память запроса: 0.047 MB Память до запроса: 28.339 MB Выбрано строк: 326
SELECT id, `name_ru-RU` as name, field_id
FROM `smkrs_jshopping_products_extra_field_values`
order by ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_extra_field_values | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 326 | 100.00 | Используется filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.21 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productfieldvalue.php:26 |
| 15 | jshopProductFieldValue->getAllList() | JROOT/components/com_jshopping/lib/factory.php:506 |
| 14 | JSFactory::getAllProductExtraFieldValue() | JROOT/components/com_jshopping/lib/functions.php:821 |
| 13 | getProductExtraFieldForProduct() | JROOT/components/com_jshopping/lib/functions.php:746 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.54 ms После последнего запроса: 1.08 ms Память запроса: 0.026 MB Память до запроса: 28.401 MB Выбрано строк: 6
SHOW FULL COLUMNS
FROM `smkrs_jshopping_product_labels`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_product_labels`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/productlabel.php:14 |
| 16 | jshopProductLabel->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 14 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/functions.php:633 |
| 13 | getNameImageLabel() | JROOT/components/com_jshopping/lib/functions.php:785 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.54 ms После последнего запроса: 0.06 ms Память запроса: 0.026 MB Память до запроса: 28.418 MB Выбрано строк: 41
SELECT id, image, `name_ru-RU` as name
FROM `smkrs_jshopping_product_labels`
ORDER BY name
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_product_labels | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 41 | 100.00 | Используется filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.31 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productlabel.php:22 |
| 14 | jshopProductLabel->getListLabels() | JROOT/components/com_jshopping/lib/functions.php:634 |
| 13 | getNameImageLabel() | JROOT/components/com_jshopping/lib/functions.php:785 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.46 ms После последнего запроса: 1.07 ms Память запроса: 0.026 MB Память до запроса: 28.452 MB Выбрано строк: 5
SHOW FULL COLUMNS
FROM `smkrs_jshopping_products_prices`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_products_prices`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/productprice.php:14 |
| 16 | jshopProductPrice->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 14 | JSFactory::getTable() | JROOT/components/com_jshopping/tables/product.php:709 |
| 13 | jshopProduct->getAddPrices() | JROOT/components/com_jshopping/tables/product.php:616 |
| 12 | jshopProduct->getPrice() | JROOT/components/com_jshopping/tables/product.php:587 |
| 11 | jshopProduct->getPricePreview() | JROOT/components/com_jshopping/tables/product.php:538 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.56 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB Память до запроса: 28.468 MB Выбрано строк: 5
SELECT *
FROM `smkrs_jshopping_products_prices`
WHERE product_id = '13775'
ORDER BY product_quantity_start DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_prices | NULL | ref | product_id | product_id | 4 | const | 5 | 100.00 | Using index condition; Используется filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.20 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.15 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productprice.php:21 |
| 14 | jshopProductPrice->getAddPrices() | JROOT/components/com_jshopping/tables/product.php:710 |
| 13 | jshopProduct->getAddPrices() | JROOT/components/com_jshopping/tables/product.php:616 |
| 12 | jshopProduct->getPrice() | JROOT/components/com_jshopping/tables/product.php:587 |
| 11 | jshopProduct->getPricePreview() | JROOT/components/com_jshopping/tables/product.php:538 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.48 ms После последнего запроса: 0.65 ms Память запроса: 0.026 MB Память до запроса: 28.485 MB Выбрано строк: 5
SHOW FULL COLUMNS
FROM `smkrs_jshopping_unit`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_unit`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 19 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 18 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/unit.php:14 |
| 17 | jshopUnit->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 16 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 15 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:345 |
| 14 | JSFactory::getAllUnits() | JROOT/components/com_jshopping/tables/product.php:725 |
| 13 | jshopProduct->getAddPrices() | JROOT/components/com_jshopping/tables/product.php:616 |
| 12 | jshopProduct->getPrice() | JROOT/components/com_jshopping/tables/product.php:587 |
| 11 | jshopProduct->getPricePreview() | JROOT/components/com_jshopping/tables/product.php:538 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.21 ms После последнего запроса: 0.05 ms Память запроса: 0.024 MB Память до запроса: 28.501 MB Выбрано строк: 3
SELECT id, `name_ru-RU` as name, qty
FROM `smkrs_jshopping_unit`
ORDER BY id
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_unit | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 3 | 100.00 | Используется filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/unit.php:22 |
| 15 | jshopUnit->getAllUnits() | JROOT/components/com_jshopping/lib/factory.php:346 |
| 14 | JSFactory::getAllUnits() | JROOT/components/com_jshopping/tables/product.php:725 |
| 13 | jshopProduct->getAddPrices() | JROOT/components/com_jshopping/tables/product.php:616 |
| 12 | jshopProduct->getPrice() | JROOT/components/com_jshopping/tables/product.php:587 |
| 11 | jshopProduct->getPricePreview() | JROOT/components/com_jshopping/tables/product.php:538 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.53 ms После последнего запроса: 0.72 ms Память запроса: 0.026 MB Память до запроса: 28.518 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `smkrs_jshopping_products_reviews`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_products_reviews`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 14 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 13 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/review.php:14 |
| 12 | jshopReview->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.82 ms После последнего запроса: 1.32 ms Память запроса: 0.053 MB Память до запроса: 28.615 MB Выбрано строк: 377
select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from smkrs_jshopping_manufacturers
where manufacturer_publish='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_manufacturers | NULL | ref | manufacturer_publish | manufacturer_publish | 1 | const | 416 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 2.47 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:422 |
| 11 | JSFactory::getAllManufacturer() | JROOT/components/com_jshopping/tables/product.php:439 |
| 10 | jshopProduct->getManufacturerInfo() | JROOT/components/com_jshopping/models/productshop.php:133 |
| 9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:59 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.28 ms После последнего запроса: 0.53 ms Память запроса: 0.021 MB Память до запроса: 28.831 MB Выбрано строк: 0
SELECT FA.id, FA.required, FA.`name_ru-RU` as name, FA.`description_ru-RU` as description, FA.type
FROM `smkrs_jshopping_products_free_attr` as PFA
left join `smkrs_jshopping_free_attr` as FA
on FA.id=PFA.attr_id
WHERE PFA.product_id=13775
order by FA.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:258 |
| 10 | jshopProduct->getListFreeAttributes() | JROOT/components/com_jshopping/models/productshop.php:161 |
| 9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:59 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.49 ms После последнего запроса: 2.94 ms Память запроса: 0.005 MB Память до запроса: 28.931 MB
UPDATE smkrs_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '13775'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | smkrs_jshopping_products | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.03 ms |
| updating | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.15 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1245 |
| 9 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_jshopping/controllers/product.php:72 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.55 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB Память до запроса: 28.934 MB Выбрано строк: 1
SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `smkrs_jshopping_products_images` as I
left join `smkrs_jshopping_products` as P
on P.product_id=I.product_id
WHERE I.product_id=13775
ORDER BY sort, I.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | I | NULL | ref | product_id | product_id | 4 | const | 1 | 100.00 | Using temporary; Используется filesort |
| 1 | SIMPLE | P | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.20 ms |
| Creating sort index | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.21 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB Память до запроса: 28.941 MB Выбрано строк: 0
SELECT video_name, video_id, video_preview, video_code
FROM `smkrs_jshopping_products_videos`
WHERE product_id=13775
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_videos | NULL | ref | product_id | product_id | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 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:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.23 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB Память до запроса: 28.946 MB Выбрано строк: 0
SELECT *
FROM `smkrs_jshopping_products_files`
WHERE product_id=13775
and demo!=''
order by `ordering`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_files | NULL | ref | product_id | product_id | 4 | const | 1 | 50.00 | Using index condition; Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:419 |
| 9 | jshopProduct->getDemoFiles() | JROOT/components/com_jshopping/controllers/product.php:84 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 0.16 ms Память запроса: 0.023 MB Память до запроса: 28.960 MB Выбрано строк: 1
SELECT *
FROM smkrs_jshopping_addons
WHERE `alias` = 'inform_availability'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_addons | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/tables/addon.php:36 |
| 13 | jshopAddon->loadAlias() | JROOT/plugins/jshoppingproducts/inform_availability_product/inform_availability_product.php:89 |
| 12 | plgJshoppingProductsInform_availability_product->getParams() | JROOT/plugins/jshoppingproducts/inform_availability_product/inform_availability_product.php:71 |
| 11 | plgJshoppingProductsInform_availability_product->onBeforeDisplayProductList() | JROOT/libraries/joomla/event/event.php:70 |
| 10 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 9 | JEventDispatcher->trigger() | JROOT/components/com_jshopping/controllers/product.php:86 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.26 ms После последнего запроса: 3.19 ms Память запроса: 0.022 MB Память до запроса: 29.048 MB Выбрано строк: 1
SELECT count(review_id)
FROM `smkrs_jshopping_products_reviews`
WHERE product_id=13775
and publish=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_reviews | NULL | ref | product_id,publish | product_id | 4 | const | 1 | 77.76 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 11 | JDatabaseDriver->loadResult() | JROOT/components/com_jshopping/tables/product.php:1110 |
| 10 | jshopProduct->getReviewsCount() | JROOT/components/com_jshopping/models/productreviewlist.php:86 |
| 9 | jshopProductReviewList->load() | JROOT/components/com_jshopping/controllers/product.php:136 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.32 ms После последнего запроса: 1.80 ms Память запроса: 0.021 MB Память до запроса: 29.136 MB Выбрано строк: 0
SELECT *
FROM `smkrs_jshopping_products_reviews`
WHERE product_id=13775
and publish=1
order by review_id desc
LIMIT 0, 20
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_products_reviews | NULL | ref | product_id,publish | product_id | 4 | const | 1 | 77.76 | Using index condition; Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:1101 |
| 10 | jshopProduct->getReviews() | JROOT/components/com_jshopping/models/productreviewlist.php:88 |
| 9 | jshopProductReviewList->load() | JROOT/components/com_jshopping/controllers/product.php:136 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.67 ms После последнего запроса: 6.27 ms Память запроса: 0.058 MB Память до запроса: 29.338 MB Выбрано строк: 605
select manufacturer_id as id, `alias_ru-RU` as alias
from smkrs_jshopping_manufacturers
where `alias_ru-RU`!=''
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_manufacturers | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 788 | 90.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.38 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:279 |
| 22 | JSFactory::getAliasManufacturer() | JROOT/components/com_jshopping/router.php:110 |
| 21 | jshoppingBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 20 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 19 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 18 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 15 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 14 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jshopping/lib/functions.php:496 |
| 13 | SEFLink() | JROOT/components/com_jshopping/templates/nvg_jsuk3/product/product_default.php:189 |
| 12 | include JROOT/components/com_jshopping/templates/nvg_jsuk3/product/product_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jshopping/views/product/view.html.php:13 |
| 9 | JshoppingViewProduct->display() | JROOT/components/com_jshopping/controllers/product.php:159 |
| 8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.42 ms После последнего запроса: 78.23 ms Память запроса: 0.028 MB Память до запроса: 30.092 MB Выбрано строк: 1
SELECT related
FROM smkrs_jshopping_related_buy_product
WHERE `product_id` = '13775'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_related_buy_product | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/modules/mod_jshopping_related_buy_product/helper.php:11 |
| 14 | ModJshoppingRelatedBuyProductHelper::getRelatedBuyProducts() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:15 |
| 13 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code(1) : eval()'d code:1 |
| 12 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code:1 |
| 11 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php:1 |
| 10 | include JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.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:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.31 ms После последнего запроса: 0.10 ms Память запроса: 0.048 MB Память до запроса: 30.113 MB Выбрано строк: 19
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.image as 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 `smkrs_jshopping_products` AS prod
INNER JOIN `smkrs_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = prod.product_id
LEFT JOIN `smkrs_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE prod.product_publish = 1
AND cat.category_publish=1
AND prod.product_id IN (30327, 30400, 1333, 1560, 8823, 1737, 29376, 593, 1137, 1290, 1772, 4292, 24039, 29482, 3407, 3479, 3331, 6555, 4959)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 19| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | prod | NULL | range | PRIMARY,product_publish,access | PRIMARY | 4 | NULL | 19 | 65.97 | Using index condition; Using where |
| 1 | SIMPLE | pr_cat | NULL | ref | PRIMARY,category_id,product_id,product_id_2 | PRIMARY | 4 | demooz.prod.product_id | 6 | 100.00 | Using index |
| 1 | SIMPLE | cat | NULL | eq_ref | PRIMARY,category_publish,access,category_publish_2 | PRIMARY | 4 | demooz.pr_cat.category_id | 1 | 96.51 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.50 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.42 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_jshopping_related_buy_product/helper.php:63 |
| 15 | ModJshoppingRelatedBuyProductHelper::getProducts() | JROOT/modules/mod_jshopping_related_buy_product/helper.php:20 |
| 14 | ModJshoppingRelatedBuyProductHelper::getRelatedBuyProducts() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:15 |
| 13 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code(1) : eval()'d code:1 |
| 12 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php(1) : eval()'d code:1 |
| 11 | eval() | JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.php:1 |
| 10 | include JROOT/modules/mod_jshopping_related_buy_product/mod_jshopping_related_buy_product.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:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.95 ms После последнего запроса: 197.46 ms Память запроса: 0.027 MB Память до запроса: 30.621 MB Выбрано строк: 21
SHOW FULL COLUMNS
FROM `smkrs_jshopping_manufacturers`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_manufacturers`
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.23 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.06 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 14 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 13 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/manufacturer.php:15 |
| 12 | jshopManufacturer->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 11 | Joomla\CMS\Table\Table::getInstance() | JROOT/modules/mod_jshopping_abc_manufacturers/mod_jshopping_abc_manufacturers.php:37 |
| 10 | include JROOT/modules/mod_jshopping_abc_manufacturers/mod_jshopping_abc_manufacturers.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:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 6.16 ms После последнего запроса: 0.10 ms Память запроса: 0.088 MB Память до запроса: 30.652 MB Выбрано строк: 377
SELECT manufacturer_id, manufacturer_url, manufacturer_logo, manufacturer_publish, `name_ru-RU` as name, `description_ru-RU` as description, `short_description_ru-RU` as short_description
FROM `smkrs_jshopping_manufacturers`
WHERE manufacturer_publish = '1'
ORDER BY name asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | smkrs_jshopping_manufacturers | NULL | ref | manufacturer_publish | manufacturer_publish | 1 | const | 416 | 100.00 | Using index condition; Используется filesort |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 5.77 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/manufacturer.php:30 |
| 11 | jshopManufacturer->getAllManufacturers() | JROOT/modules/mod_jshopping_abc_manufacturers/mod_jshopping_abc_manufacturers.php:38 |
| 10 | include JROOT/modules/mod_jshopping_abc_manufacturers/mod_jshopping_abc_manufacturers.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:501 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
4 × SELECT *
FROM smkrs_jshopping_addons
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `smkrs_extensions`
1 × SELECT `data`
FROM `smkrs_session`
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from smkrs_jshopping_manufacturers
1 × select category_id as id, `alias_ru-RU` as alias
from smkrs_jshopping_categories
1 × SELECT tax_id, tax_name, tax_value
FROM `smkrs_jshopping_taxes
1 × select id, `name_ru-RU` as name
from smkrs_jshopping_delivery_time
1 × SELECT id, `name_ru-RU` as name, field_id
FROM `smkrs_jshopping_products_extra_field_values`
1 × SELECT id, image, `name_ru-RU` as name
FROM `smkrs_jshopping_product_labels`
1 × SELECT *
FROM `smkrs_jshopping_products_prices`
1 × SELECT id, `name_ru-RU` as name, qty
FROM `smkrs_jshopping_unit`
1 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `smkrs_jshopping_products_images` as I
left join `smkrs_jshopping_products` as P
on P.product_id=I.product_id
1 × SELECT FA.id, FA.required, FA.`name_ru-RU` as name, FA.`description_ru-RU` as description, FA.type
FROM `smkrs_jshopping_products_free_attr` as PFA
left join `smkrs_jshopping_free_attr` as FA
on FA.id=PFA.attr_id1 × SELECT `usergroup_id`
FROM `smkrs_jshopping_usergroups`
1 × SELECT video_name, video_id, video_preview, video_code
FROM `smkrs_jshopping_products_videos`
1 × SELECT *
FROM `smkrs_jshopping_products_files`
1 × SELECT count(review_id)
FROM `smkrs_jshopping_products_reviews`
1 × SELECT *
FROM `smkrs_jshopping_products_reviews`
1 × select manufacturer_id as id, `alias_ru-RU` as alias
from smkrs_jshopping_manufacturers
1 × SELECT related
FROM smkrs_jshopping_related_buy_product
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.image as 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 `smkrs_jshopping_products` AS prod
INNER JOIN `smkrs_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = prod.product_id
LEFT JOIN `smkrs_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id1 × 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, prod.delivery_times_id, prod.`extra_field_1` , prod.`extra_field_2` , prod.unlimited, IF(prod.product_quantity>0,1,0) as qflag, prod.product_bonus_add, prod.product_bonus_sub
FROM `smkrs_jshopping_products_relations` AS relation
INNER JOIN `smkrs_jshopping_products` AS prod
ON relation.product_related_id = prod.product_id
LEFT JOIN `smkrs_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `smkrs_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
1 × SELECT *
FROM `smkrs_jshopping_products_attr`
1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_ru-RU` as groupname, multilist
FROM `smkrs_jshopping_products_extra_fields` as F
left join `smkrs_jshopping_products_extra_field_groups` as G
on G.id=F.
group
1 × SELECT *
FROM smkrs_languages
1 × SELECT id, rules
FROM `smkrs_viewlevels
1 × SELECT b.id
FROM smkrs_usergroups AS a
LEFT JOIN smkrs_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 smkrs_extensions
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 smkrs_menu AS m
LEFT JOIN smkrs_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM smkrs_jshopping_config
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `smkrs_jshopping_currencies`
1 × select product_id as id, `alias_ru-RU` as alias
from smkrs_jshopping_products
1 × SELECT id, home, template, s.params
FROM smkrs_template_styles as s
LEFT JOIN smkrs_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `session_id`
FROM `smkrs_session`
1 × select *
from smkrs_jshopping_language
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `smkrs_assets`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM smkrs_modules AS m
LEFT JOIN smkrs_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN smkrs_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × select id,link
from smkrs_menu
1 × SELECT *
FROM smkrs_jshopping_products
1 × SELECT *
FROM smkrs_jshopping_categories
1 × SELECT *
FROM `smkrs_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 `smkrs_jshopping_attr` as A
left join `smkrs_jshopping_attr_groups` as G
on A.`
group`=G.id1 × SELECT manufacturer_id, manufacturer_url, manufacturer_logo, manufacturer_publish, `name_ru-RU` as name, `description_ru-RU` as description, `short_description_ru-RU` as short_description
FROM `smkrs_jshopping_manufacturers`
