Время запроса: 0.46 ms Память запроса: 0.023 MB Память до запроса: 3.884 MB Выбрано строк: 1
SELECT `data`
FROM `smkrs_session`
WHERE `session_id` = X'6634366563323331306663323231326166623938353463366139633531326262'
| 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.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| init | 0.03 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.01 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.63 ms После последнего запроса: 7.59 ms Память запроса: 0.111 MB Память до запроса: 4.248 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.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.24 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.30 ms После последнего запроса: 4.46 ms Память запроса: 0.021 MB Память до запроса: 4.484 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.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.01 ms |
| Sending data | 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.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php: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.36 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB Память до запроса: 4.495 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.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.05 ms |
| preparing | 0.02 ms |
| executing | 0.01 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.13 ms После последнего запроса: 0.75 ms Память запроса: 0.051 MB Память до запроса: 4.564 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.01 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.03 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.87 ms После последнего запроса: 57.35 ms Память запроса: 3.919 MB Память до запроса: 8.205 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.13 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 11.21 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 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 |
Время запроса: 2.17 ms После последнего запроса: 56.77 ms Память запроса: 0.047 MB Память до запроса: 17.757 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.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 |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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.20 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.14 ms Память запроса: 0.076 MB Память до запроса: 18.004 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.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.01 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.59 ms После последнего запроса: 0.76 ms Память запроса: 0.028 MB Память до запроса: 18.008 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `smkrs_jshopping_currencies`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_currencies`
| Status | Duration |
|---|
| starting | 0.04 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.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/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.37 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB Память до запроса: 18.027 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.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.01 ms |
| executing | 0.01 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.02 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 |
Время запроса: 45.58 ms После последнего запроса: 5.20 ms Память запроса: 1.479 MB Память до запроса: 18.107 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 | 44.76 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 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/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.77 ms После последнего запроса: 41.76 ms Память запроса: 0.026 MB Память до запроса: 21.316 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `smkrs_jshopping_addons`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_addons`
| Status | Duration |
|---|
| starting | 0.05 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.05 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.04 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.03 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.33 ms После последнего запроса: 0.12 ms Память запроса: 0.023 MB Память до запроса: 21.336 MB Выбрано строк: 1
Повторяющиеся запросы:
#21SELECT *
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.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.06 ms |
| preparing | 0.02 ms |
| executing | 0.01 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.39 ms После последнего запроса: 2.06 ms Память запроса: 0.022 MB Память до запроса: 21.346 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.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.01 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 |
Время запроса: 2.49 ms После последнего запроса: 0.15 ms Память запроса: 0.005 MB Память до запроса: 21.337 MB
UPDATE `smkrs_extensions`
SET `params` = '{\"mediaversion\":\"16071baee0b029d50ab3eb25fae0e7ad\"}'
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.07 ms |
| end | 0.01 ms |
| query end | 2.12 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 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.36 ms После последнего запроса: 3.53 ms Память запроса: 0.019 MB Память до запроса: 21.510 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.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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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 |
Время запроса: 3.64 ms После последнего запроса: 0.73 ms Память запроса: 0.176 MB Память до запроса: 21.521 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.09 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.23 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.87 ms После последнего запроса: 82.23 ms Память запроса: 0.029 MB Память до запроса: 23.608 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.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.14 ms |
| preparing | 0.01 ms |
| executing | 0.01 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.47 ms После последнего запроса: 5.34 ms Память запроса: 0.006 MB Память до запроса: 24.198 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-06 00:57:29'
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.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for table level lock | 0.07 ms |
| System lock | 0.05 ms |
| Searching rows for update | 0.05 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 |
Время запроса: 1.97 ms После последнего запроса: 3.71 ms Память запроса: 0.060 MB Память до запроса: 24.792 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-05 21:57:29')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-05 21:57:29')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1150 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.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.44 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 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 После последнего запроса: 22.22 ms Память запроса: 0.025 MB Память до запроса: 25.748 MB Выбрано строк: 1
Повторяющиеся запросы:
#13SELECT *
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.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.03 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.23 ms После последнего запроса: 1.30 ms Память запроса: 0.035 MB Память до запроса: 25.827 MB Выбрано строк: 54
Повторяющиеся запросы:
#33SHOW 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.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.04 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.02 ms |
| checking permissions | 0.05 ms |
| checking permissions | 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 |
| 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 |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.04 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/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.58 ms После последнего запроса: 0.80 ms Память запроса: 0.029 MB Память до запроса: 25.906 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `smkrs_jshopping_usergroups`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_usergroups`
| Status | Duration |
|---|
| starting | 0.03 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.03 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.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.86 ms После последнего запроса: 1.32 ms Память запроса: 0.175 MB Память до запроса: 25.958 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.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 4.34 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.37 ms После последнего запроса: 6.42 ms Память запроса: 0.036 MB Память до запроса: 27.341 MB Выбрано строк: 84
SHOW FULL COLUMNS
FROM `smkrs_jshopping_products`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_products`
| Status | Duration |
|---|
| Opening tables | 0.18 ms |
| init | 0.02 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 |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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 |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking 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.13 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.03 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.40 ms После последнего запроса: 0.23 ms Память запроса: 0.040 MB Память до запроса: 27.449 MB Выбрано строк: 1
SELECT *
FROM smkrs_jshopping_products
WHERE `product_id` = '31326'
| 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.01 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.06 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.72 ms После последнего запроса: 1.06 ms Память запроса: 0.027 MB Память до запроса: 27.559 MB Выбрано строк: 28
SHOW FULL COLUMNS
FROM `smkrs_jshopping_categories`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_categories`
| 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.04 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 |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking 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.06 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.28 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB Память до запроса: 27.599 MB Выбрано строк: 1
SELECT *
FROM smkrs_jshopping_categories
WHERE `category_id` = '556'
| 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.01 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.29 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 27.603 MB Выбрано строк: 9
SELECT *
FROM `smkrs_jshopping_products_to_categories`
WHERE product_id=31326
| 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 | 7 | 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.08 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.72 ms После последнего запроса: 0.71 ms Память запроса: 0.027 MB Память до запроса: 27.628 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.01 ms |
| Opening tables | 0.15 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.03 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.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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.80 ms После последнего запроса: 0.08 ms Память запроса: 0.031 MB Память до запроса: 27.650 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.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.23 ms |
| Creating sort index | 0.15 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.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.13 ms Память запроса: 0.040 MB Память до запроса: 27.697 MB Выбрано строк: 0
SELECT *
FROM `smkrs_jshopping_products_attr`
WHERE product_id=31326
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.01 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.03 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.96 ms После последнего запроса: 0.54 ms Память запроса: 0.034 MB Память до запроса: 27.731 MB Выбрано строк: 54
Повторяющиеся запросы:
#22SHOW 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.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 |
| 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.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/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.55 ms После последнего запроса: 0.83 ms Память запроса: 0.028 MB Память до запроса: 27.812 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.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.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.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.03 ms |
| cleaning up | 0.02 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.69 ms После последнего запроса: 0.08 ms Память запроса: 0.063 MB Память до запроса: 27.834 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.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.02 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.35 ms |
| end | 0.08 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 |
Время запроса: 5.91 ms После последнего запроса: 1.51 ms Память запроса: 0.025 MB Память до запроса: 28.132 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.153 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.02 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.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 |
Время запроса: 4.94 ms После последнего запроса: 0.06 ms Память запроса: 0.046 MB Память до запроса: 28.159 MB Выбрано строк: 16
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=31326
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 | 10 | 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.11 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.57 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 3.62 ms |
| Creating sort index | 0.20 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 |
Время запроса: 3.57 ms После последнего запроса: 0.20 ms Память запроса: 0.049 MB Память до запроса: 28.216 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.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 | 1.11 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.95 ms После последнего запроса: 2.37 ms Память запроса: 0.026 MB Память до запроса: 28.280 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.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 |
| 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.24 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB Память до запроса: 28.295 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.03 ms |
| checking permissions | 0.02 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.01 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.301 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.01 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.45 ms После последнего запроса: 0.69 ms Память запроса: 0.026 MB Память до запроса: 28.320 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.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/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.47 ms После последнего запроса: 0.05 ms Память запроса: 0.047 MB Память до запроса: 28.336 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.25 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.48 ms После последнего запроса: 2.23 ms Память запроса: 0.026 MB Память до запроса: 28.417 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.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 |
| 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.62 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 28.433 MB Выбрано строк: 5
SELECT *
FROM `smkrs_jshopping_products_prices`
WHERE product_id = '31326'
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 | 6 | 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.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.43 ms После последнего запроса: 0.65 ms Память запроса: 0.026 MB Память до запроса: 28.450 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.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 |
| 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.23 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB Память до запроса: 28.466 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.55 ms После последнего запроса: 0.75 ms Память запроса: 0.026 MB Память до запроса: 28.484 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.04 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 |
| 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.72 ms После последнего запроса: 1.29 ms Память запроса: 0.053 MB Память до запроса: 28.580 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.43 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/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.25 ms После последнего запроса: 0.95 ms Память запроса: 0.021 MB Память до запроса: 28.797 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=31326
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.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 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/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.32 ms После последнего запроса: 3.01 ms Память запроса: 0.005 MB Память до запроса: 28.835 MB
UPDATE smkrs_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '31326'
| 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.02 ms |
| init | 0.02 ms |
| System lock | 0.03 ms |
| updating | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 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.52 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB Память до запроса: 28.838 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=31326
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 | 2 | 100.00 | Using temporary; Используется filesort |
| 1 | SIMPLE | P | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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.05 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.17 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.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.02 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.20 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB Память до запроса: 28.845 MB Выбрано строк: 0
SELECT video_name, video_id, video_preview, video_code
FROM `smkrs_jshopping_products_videos`
WHERE product_id=31326
| 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.02 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.24 ms После последнего запроса: 0.04 ms Память запроса: 0.021 MB Память до запроса: 28.850 MB Выбрано строк: 0
SELECT *
FROM `smkrs_jshopping_products_files`
WHERE product_id=31326
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.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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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.21 ms Память запроса: 0.023 MB Память до запроса: 28.867 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.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/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.18 ms Память запроса: 0.022 MB Память до запроса: 29.018 MB Выбрано строк: 1
SELECT count(review_id)
FROM `smkrs_jshopping_products_reviews`
WHERE product_id=31326
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.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.01 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.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.29 ms После последнего запроса: 1.74 ms Память запроса: 0.021 MB Память до запроса: 29.106 MB Выбрано строк: 0
SELECT *
FROM `smkrs_jshopping_products_reviews`
WHERE product_id=31326
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.04 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.03 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.64 ms После последнего запроса: 6.33 ms Память запроса: 0.058 MB Память до запроса: 29.308 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.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.37 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.04 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.35 ms После последнего запроса: 77.95 ms Память запроса: 0.023 MB Память до запроса: 30.148 MB Выбрано строк: 1
SELECT related
FROM smkrs_jshopping_related_buy_product
WHERE `product_id` = '31326'
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.07 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.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 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.82 ms После последнего запроса: 0.08 ms Память запроса: 0.052 MB Память до запроса: 30.163 MB Выбрано строк: 31
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 (29453, 794, 31533, 31623, 31536, 1185, 31648, 1630, 25781, 1731, 31620, 773, 397, 496, 1200, 1201, 1183, 1195, 1204, 926, 1215, 1385, 8757, 1387, 30003, 31532, 31548, 775, 31535, 2427, 7164)
AND prod.access IN (1,1)
AND cat.access IN (1,1)
LIMIT 31| 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 | 31 | 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.11 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.87 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.59 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/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.60 ms После последнего запроса: 0.88 ms Память запроса: 0.028 MB Память до запроса: 30.188 MB Выбрано строк: 6
SHOW FULL COLUMNS
FROM `smkrs_jshopping_product_labels`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_product_labels`
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.19 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.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.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/productlabel.php:14 |
| 20 | jshopProductLabel->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 19 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:621 |
| 18 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/functions.php:633 |
| 17 | getNameImageLabel() | JROOT/components/com_jshopping/lib/functions.php:785 |
| 16 | listProductUpdateData() | JROOT/modules/mod_jshopping_related_buy_product/helper.php:81 |
| 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.52 ms После последнего запроса: 0.07 ms Память запроса: 0.028 MB Память до запроса: 30.206 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.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.33 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 |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productlabel.php:22 |
| 18 | jshopProductLabel->getListLabels() | JROOT/components/com_jshopping/lib/functions.php:634 |
| 17 | getNameImageLabel() | JROOT/components/com_jshopping/lib/functions.php:785 |
| 16 | listProductUpdateData() | JROOT/modules/mod_jshopping_related_buy_product/helper.php:81 |
| 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 |
Время запроса: 1.03 ms После последнего запроса: 195.92 ms Память запроса: 0.027 MB Память до запроса: 30.727 MB Выбрано строк: 21
SHOW FULL COLUMNS
FROM `smkrs_jshopping_manufacturers`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `smkrs_jshopping_manufacturers`
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.23 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Opening tables | 0.03 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.02 ms |
| checking permissions | 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.02 ms |
| checking permissions | 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 |
| checking permissions | 0.02 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.04 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 |
Время запроса: 5.47 ms После последнего запроса: 0.09 ms Память запроса: 0.094 MB Память до запроса: 30.767 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.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.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 5.18 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 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
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 *
FROM `smkrs_jshopping_products_prices`
1 × SELECT id, `name_ru-RU` as name, qty
FROM `smkrs_jshopping_unit`
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from smkrs_jshopping_manufacturers
1 × SELECT `data`
FROM `smkrs_session`
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 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_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_id
1 × SELECT id, image, `name_ru-RU` as name
FROM `smkrs_jshopping_product_labels`
1 × SELECT video_name, video_id, video_preview, video_code
FROM `smkrs_jshopping_products_videos`
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 `usergroup_id`
FROM `smkrs_jshopping_usergroups`
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 *
FROM `smkrs_jshopping_products_attr`
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.id
1 × 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`