-
Главная
-
Автоматика для ворот
-
Автоматика для откатных ворот
- Doorhan Sliding 800, 1300 и 2100
Экспресс Ворота
Монтаж в любом городе!
Товары
Товары связанные с Doorhan Sliding 800, 1300 и 2100
ASL500 - до 500 кг, ASL1000 - до 1000 кг, ASL2000 - до 2000 кг
Производитель: AN-Motors (Китай)
219 €
Отзывов (4)
Отзыв
Виталий, 06.08.2021
Подскажите, можно заказать пульты к этой системе и какая их цена?
Андрей, 02.05.2021
Подскажите такую вещь? На эту автоматику возможно подключить wifi трансмиттер.
Экспресс Ворота, 17.10.2015
Марк, конечно! Сообщите куда высылать, желательно по телефону :)
Марк, 17.10.2015
можете наложенным выслать "Нова Пошта"?
Станислав, 23.10.2013
Уже получил, ставили гипсокартонщики :) вроде все нормально получилось
Станислав, 17.10.2013
Егор, спасибо за совет! Собираюсь заказать.
Егор, 14.10.2013
Очень хороший привод, советую.
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1657149969,
"last": 1657149969,
"now": 1657149969
},
"client": {
"forwarded": "3.238.24.209"
},
"token": "Qbi9kNxYQZI80DTsuirHBzBHjxkyGfaz"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"js_id_currency_orig": "1",
"js_id_currency": "1",
"js_history_sel_lang": "ru-RU",
"js_prev_user_id": 0,
"jshop_checked_language": [
"en-GB",
"ru-RU",
"uk-UA"
],
"jshop_end_page_buy_product": "/privody-dlya-vorot/avtomatika-dlya-otkatnykh-vorot/doorhan-sliding",
"product_back_value": []
}
}
Время
Память
Время: 22.03 ms / 22.03 ms Память: 2.086 MB / 2.46 MB Application: afterLoad
Время: 63.40 ms / 85.43 ms Память: 4.251 MB / 6.71 MB Application: afterInitialise
Время: 48.73 ms / 134.16 ms Память: 2.496 MB / 9.21 MB Application: Before Access::preloadComponents (all components)
Время: 1.19 ms / 135.34 ms Память: 0.061 MB / 9.27 MB Application: After Access::preloadComponents (all components)
Время: 0.05 ms / 135.39 ms Память: -0.003 MB / 9.27 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.58 ms / 135.97 ms Память: 0.026 MB / 9.29 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 4.66 ms / 140.62 ms Память: 0.261 MB / 9.55 MB Application: afterRoute
Время: 3.67 ms / 144.30 ms Память: 0.029 MB / 9.58 MB Application: beforeRenderComponent com_jshopping
Время: 86.96 ms / 231.25 ms Память: 3.863 MB / 13.45 MB Application: afterRenderComponent com_jshopping
Время: 0.55 ms / 231.80 ms Память: 0.005 MB / 13.45 MB Application: afterDispatch
Время: 6.68 ms / 238.48 ms Память: 0.278 MB / 13.73 MB Application: beforeRenderModule mod_mel_cart (Mel Cart)
Время: 1.31 ms / 239.79 ms Память: 0.045 MB / 13.77 MB Application: afterRenderModule mod_mel_cart (Mel Cart)
Время: 0.12 ms / 239.91 ms Память: 0.000 MB / 13.77 MB Application: beforeRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 1.67 ms / 241.58 ms Память: 0.059 MB / 13.83 MB Application: afterRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 250.64 ms / 492.22 ms Память: 0.297 MB / 14.13 MB Application: afterRender
Всего SQL-запросов: 48.56 ms
15.12 MB (15,856,440 Байт)
59 SQL-запросов зафиксировано 48.56 ms
- Время запроса: 0.45 ms Память запроса: 0.007 MB Память до запроса: 4.191 MB Выбрано строк: 0
SELECT `data`
FROM `u2bez_session`
WHERE `session_id` = X'6261313764356336333865636631656234353964393666656439326538653261'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.33 ms После последнего запроса: 1.53 ms Память запроса: 0.004 MB Память до запроса: 4.287 MB Выбрано строк: 0
SELECT `session_id`
FROM `u2bez_session`
WHERE `session_id` = X'6261313764356336333865636631656234353964393666656439326538653261'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.04 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.45 ms После последнего запроса: 0.12 ms Память запроса: 0.004 MB Память до запроса: 4.292 MB
INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6261313764356336333865636631656234353964393666656439326538653261', 1, 1657149969, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6261313764356336333865636631656234353964393666656439326538653261', 1, 1657149969, 0, '', 0)Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init for update 0.02 ms Update 0.10 ms Waiting for query cache lock 0.01 ms Update 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.07 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.75 ms После последнего запроса: 4.00 ms Память запроса: 0.006 MB Память до запроса: 4.640 MB Выбрано строк: 37
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `u2bez_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_extensions ref extension extension 82 const 39 Using index condition; Using where Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.31 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.03 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 5.84 ms Память запроса: 0.005 MB Память до запроса: 4.830 MB Выбрано строк: 4
SELECT id, rules
FROM `u2bez_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_viewlevels ALL NULL Индекс не используется NULL NULL 4 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.43 ms После последнего запроса: 0.12 ms Память запроса: 0.005 MB Память до запроса: 4.842 MB Выбрано строк: 2
SELECT b.id
FROM u2bez_usergroups AS a
LEFT JOIN u2bez_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.26 ms После последнего запроса: 1.06 ms Память запроса: 0.005 MB Память до запроса: 4.914 MB Выбрано строк: 89
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM u2bez_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_extensions ref extension extension 82 const 123 Using index condition; Using where; Используется filesort Status Duration Starting 0.08 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.02 ms Sending data 0.01 ms Creating sort index 0.78 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.48 ms После последнего запроса: 29.49 ms Память запроса: 0.009 MB Память до запроса: 6.903 MB Выбрано строк: 31
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 u2bez_menu AS m
LEFT JOIN u2bez_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.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 54 Using index condition; Using where; Используется filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 expressv_main.m.component_id 1 Using where Status Duration Starting 0.15 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.04 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.58 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.59 ms После последнего запроса: 29.14 ms Память запроса: 0.009 MB Память до запроса: 8.304 MB Выбрано строк: 137
SHOW FULL COLUMNS
FROM `u2bez_jshopping_config`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_config`Status Duration Starting 0.07 ms Checking permissions 0.02 ms Closing tables 0.01 ms Opening tables 0.33 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.37 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.22 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.14 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/config.php:15 14 jshopConfig->__construct() JROOT/components/com_jshopping/lib/factory.php:24 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 1.56 ms Память запроса: 0.007 MB Память до запроса: 8.577 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_config
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_config const PRIMARY PRIMARY 1 const 1 Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 14 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/lib/factory.php:27 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.81 ms После последнего запроса: 1.09 ms Память запроса: 0.010 MB Память до запроса: 8.684 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `u2bez_jshopping_currencies`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_currencies`Status Duration Starting 0.04 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.23 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.06 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 20 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 18 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/currency.php:22 17 jshopCurrency->__construct() JROOT/libraries/src/Table/Table.php:328 16 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:624 15 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:48 14 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:29 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.41 ms После последнего запроса: 0.12 ms Память запроса: 0.008 MB Память до запроса: 8.706 MB Выбрано строк: 2
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `u2bez_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_currencies ALL NULL Индекс не используется NULL NULL 2 Using where; Используется filesort Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/currency.php:30 16 jshopCurrency->getAllCurrencies() JROOT/components/com_jshopping/lib/factory.php:625 15 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:48 14 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:29 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.61 ms После последнего запроса: 1.89 ms Память запроса: 0.006 MB Память до запроса: 8.788 MB Выбрано строк: 127
select product_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_products
where `alias_ru-RU`!=''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products ALL NULL Индекс не используется NULL NULL 100 Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:350 11 JSFactory::getAliasProduct() JROOT/components/com_jshopping/router.php:250 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.98 ms После последнего запроса: 6.69 ms Память запроса: 0.007 MB Память до запроса: 9.216 MB Выбрано строк: 37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `u2bez_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','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_joomlaupdate','com_jshopping','com_languages','com_login','com_mailto','com_media','com_mel_db','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 type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_assets ALL idx_asset_name Индекс не используется NULL NULL 155 Using where Status Duration Starting 0.08 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.38 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 14 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 13 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 12 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 11 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 10 Joomla\CMS\User\User->authorise() JROOT/plugins/system/sourcerer/helper.php:56 9 plgSystemSourcererHelper->__construct() JROOT/plugins/system/sourcerer/sourcerer.php:96 8 plgSystemSourcerer->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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.47 ms После последнего запроса: 1.61 ms Память запроса: 0.009 MB Память до запроса: 9.324 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `u2bez_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55 8 plgSystemJqueryeasy->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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.63 ms После последнего запроса: 0.36 ms Память запроса: 0.006 MB Память до запроса: 9.316 MB
UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"8045f74994f5fc7b2db7c80f52dbf6bb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `u2bez_extensions` SET `params` = '{\"mediaversion\":\"8045f74994f5fc7b2db7c80f52dbf6bb\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.08 ms Updating 0.08 ms End of update loop 0.02 ms Waiting for query cache lock 0.15 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.07 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55 8 plgSystemJqueryeasy->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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.47 ms После последнего запроса: 2.60 ms Память запроса: 0.004 MB Память до запроса: 9.560 MB Выбрано строк: 1
SELECT *
FROM u2bez_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_languages ALL NULL Индекс не используется NULL NULL 1 Using where; Используется filesort Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.58 ms После последнего запроса: 0.56 ms Память запроса: 0.003 MB Память до запроса: 9.573 MB Выбрано строк: 3
SELECT id, home, template, s.params
FROM u2bez_template_styles as s
LEFT JOIN u2bez_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 = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home Индекс не используется NULL NULL 5 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 expressv_main.s.template,const 1 Using index condition; Using where Status Duration Starting 0.10 ms Checking permissions 0.01 ms Opening tables 0.98 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 5.46 ms Память запроса: 0.006 MB Память до запроса: 9.663 MB Выбрано строк: 3
select *
from u2bez_jshopping_languagesid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_languages ALL NULL Индекс не используется NULL NULL 2 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/functions.php:236 8 installNewLanguages() JROOT/components/com_jshopping/loadparams.php:40 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:15 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.29 ms После последнего запроса: 12.24 ms Память запроса: 0.007 MB Память до запроса: 10.543 MB Выбрано строк: 73
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products`Status Duration Starting 0.06 ms Checking permissions 0.01 ms Closing tables 0.02 ms Opening tables 0.34 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.24 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Removing tmp table 0.12 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/product.php:14 10 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:40 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.64 ms После последнего запроса: 0.29 ms Память запроса: 0.006 MB Память до запроса: 10.668 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_products
WHERE `product_id` = '16'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.01 ms Executing 0.03 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:41 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.14 ms Память запроса: 0.006 MB Память до запроса: 10.675 MB Выбрано строк: 1
SELECT *
FROM `u2bez_jshopping_products_to_categories`
WHERE product_id='16'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_to_categories ref PRIMARY,product_id PRIMARY 4 const 1 Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:228 9 jshopProduct->getCategories() JROOT/components/com_jshopping/controllers/product.php:42 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.77 ms После последнего запроса: 0.84 ms Память запроса: 0.009 MB Память до запроса: 10.692 MB Выбрано строк: 12
SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_attr`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.24 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.07 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.10 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 14 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/attribut.php:16 13 jshopAttribut->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:364 11 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:95 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.60 ms После последнего запроса: 0.13 ms Память запроса: 0.007 MB Память до запроса: 10.718 MB Выбрано строк: 43
SELECT attr_id, `name_ru-RU` as name, `description_ru-RU` as description, attr_type, independent, allcats, cats, attr_ordering
FROM `u2bez_jshopping_attr`
ORDER BY attr_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_attr ALL NULL Индекс не используется NULL NULL 43 Используется filesort Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/attribut.php:32 12 jshopAttribut->getAllAttributes() JROOT/components/com_jshopping/lib/factory.php:365 11 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:95 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.03 ms После последнего запроса: 0.20 ms Память запроса: 0.006 MB Память до запроса: 10.781 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_attr`
WHERE product_id = '16'
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr index NULL PRIMARY 4 NULL 247 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.04 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.60 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:126 11 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:100 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.71 ms После последнего запроса: 0.12 ms Память запроса: 0.006 MB Память до запроса: 10.787 MB Выбрано строк: 17
SELECT *
FROM `u2bez_jshopping_products_attr2`
WHERE product_id = '16'
ORDER BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 index NULL PRIMARY 4 NULL 930 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.42 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:133 11 jshopProduct->getAttributes2() JROOT/components/com_jshopping/tables/product.php:111 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.93 ms После последнего запроса: 0.12 ms Память запроса: 0.006 MB Память до запроса: 10.794 MB Выбрано строк: 3
select PA.attr_value_id as val_id, V.`name_ru-RU` as value_name, V.image, price_mod, addprice
from u2bez_jshopping_products_attr2 as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_value_id=V.value_id
where PA.product_id = '16'
and PA.attr_id='27'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 930 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_value_id 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.43 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.90 ms После последнего запроса: 0.09 ms Память запроса: 0.006 MB Память до запроса: 10.804 MB Выбрано строк: 5
select PA.attr_value_id as val_id, V.`name_ru-RU` as value_name, V.image, price_mod, addprice
from u2bez_jshopping_products_attr2 as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_value_id=V.value_id
where PA.product_id = '16'
and PA.attr_id='8'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 930 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_value_id 1 Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.42 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.90 ms После последнего запроса: 0.09 ms Память запроса: 0.006 MB Память до запроса: 10.814 MB Выбрано строк: 5
select PA.attr_value_id as val_id, V.`name_ru-RU` as value_name, V.image, price_mod, addprice
from u2bez_jshopping_products_attr2 as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_value_id=V.value_id
where PA.product_id = '16'
and PA.attr_id='4'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 930 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_value_id 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.45 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.87 ms После последнего запроса: 0.09 ms Память запроса: 0.006 MB Память до запроса: 10.824 MB Выбрано строк: 2
select PA.attr_value_id as val_id, V.`name_ru-RU` as value_name, V.image, price_mod, addprice
from u2bez_jshopping_products_attr2 as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_value_id=V.value_id
where PA.product_id = '16'
and PA.attr_id='3'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 930 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_value_id 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.42 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.88 ms После последнего запроса: 0.09 ms Память запроса: 0.006 MB Память до запроса: 10.832 MB Выбрано строк: 2
select PA.attr_value_id as val_id, V.`name_ru-RU` as value_name, V.image, price_mod, addprice
from u2bez_jshopping_products_attr2 as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_value_id=V.value_id
where PA.product_id = '16'
and PA.attr_id='2'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 930 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_value_id 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.42 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 0.11 ms Память запроса: 0.006 MB Память до запроса: 10.840 MB Выбрано строк: 1
select addprice, price_mod
from u2bez_jshopping_products_attr2
where product_id='16'
and attr_id='27'
and attr_value_id='411'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 ALL NULL Индекс не используется NULL NULL 930 Using where Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.42 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/components/com_jshopping/tables/product.php:51 9 jshopProduct->setAttributeActive() JROOT/components/com_jshopping/controllers/product.php:49 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.68 ms После последнего запроса: 0.11 ms Память запроса: 0.007 MB Память до запроса: 10.852 MB Выбрано строк: 1
select addprice, price_mod
from u2bez_jshopping_products_attr2
where product_id='16'
and attr_id='8'
and attr_value_id='18'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 ALL NULL Индекс не используется NULL NULL 930 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.40 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/components/com_jshopping/tables/product.php:51 9 jshopProduct->setAttributeActive() JROOT/components/com_jshopping/controllers/product.php:49 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.71 ms После последнего запроса: 0.07 ms Память запроса: 0.006 MB Память до запроса: 10.859 MB Выбрано строк: 1
select addprice, price_mod
from u2bez_jshopping_products_attr2
where product_id='16'
and attr_id='4'
and attr_value_id='7'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 ALL NULL Индекс не используется NULL NULL 930 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.03 ms Statistics 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.40 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/components/com_jshopping/tables/product.php:51 9 jshopProduct->setAttributeActive() JROOT/components/com_jshopping/controllers/product.php:49 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.71 ms После последнего запроса: 0.11 ms Память запроса: 0.006 MB Память до запроса: 10.864 MB Выбрано строк: 1
select addprice, price_mod
from u2bez_jshopping_products_attr2
where product_id='16'
and attr_id='3'
and attr_value_id='5'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 ALL NULL Индекс не используется NULL NULL 930 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.02 ms Sending data 0.39 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/components/com_jshopping/tables/product.php:51 9 jshopProduct->setAttributeActive() JROOT/components/com_jshopping/controllers/product.php:49 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.67 ms После последнего запроса: 0.06 ms Память запроса: 0.006 MB Память до запроса: 10.870 MB Выбрано строк: 1
select addprice, price_mod
from u2bez_jshopping_products_attr2
where product_id='16'
and attr_id='2'
and attr_value_id='4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 ALL NULL Индекс не используется NULL NULL 930 Using where Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.38 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/components/com_jshopping/tables/product.php:51 9 jshopProduct->setAttributeActive() JROOT/components/com_jshopping/controllers/product.php:49 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.00 ms После последнего запроса: 2.16 ms Память запроса: 0.007 MB Память до запроса: 10.961 MB Выбрано строк: 7
SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr_values`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_attr_values`Status Duration Starting 0.04 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.34 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.03 ms Opening tables 0.03 ms After opening tables 0.01 ms Checking permissions 0.07 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/attributvalue.php:16 10 jshopAttributValue->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.45 ms После последнего запроса: 0.12 ms Память запроса: 0.006 MB Память до запроса: 10.979 MB Выбрано строк: 402
SELECT value_id, image, `name_ru-RU` as name, attr_id, value_ordering
FROM `u2bez_jshopping_attr_values`
ORDER BY value_ordering, value_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_attr_values ALL NULL Индекс не используется NULL NULL 402 Используется filesort Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/attributvalue.php:47 9 jshopAttributValue->getAllAttributeValues() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.86 ms После последнего запроса: 0.91 ms Память запроса: 0.009 MB Память до запроса: 11.313 MB Выбрано строк: 13
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_fields`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_extra_fields`Status Duration Starting 0.04 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.25 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.09 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.12 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfield.php:16 15 jshopProductField->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:551 13 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1038 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:198 11 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:725 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.96 ms После последнего запроса: 0.14 ms Память запроса: 0.007 MB Память до запроса: 11.341 MB Выбрано строк: 20
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 `u2bez_jshopping_products_extra_fields` as F
left join `u2bez_jshopping_products_extra_field_groups` as G
on G.id=F.
group
order by G.ordering, F.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE F ALL NULL Индекс не используется NULL NULL 20 Using temporary; Используется filesort 1 SIMPLE G eq_ref PRIMARY PRIMARY 4 expressv_main.F.group 1 Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.28 ms Creating sort index 0.08 ms Removing tmp table 0.12 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfield.php:50 14 jshopProductField->getList() JROOT/components/com_jshopping/lib/factory.php:552 13 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1038 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:198 11 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:725 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.59 ms После последнего запроса: 0.21 ms Память запроса: 0.006 MB Память до запроса: 11.383 MB Выбрано строк: 3
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, 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.`extra_field_21`
FROM `u2bez_jshopping_products_relations` AS relation
INNER JOIN `u2bez_jshopping_products` AS prod
ON relation.product_related_id = prod.product_id
LEFT JOIN `u2bez_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `u2bez_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE relation.product_id = '16'
AND cat.category_publish='1'
AND prod.product_publish = '1'
AND prod.access IN (1,1,5)
AND cat.access IN (1,1,5)
group by prod.product_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE relation ALL NULL Индекс не используется NULL NULL 318 Using where; Using temporary; Используется filesort 1 SIMPLE prod eq_ref PRIMARY PRIMARY 4 expressv_main.relation.product_related_id 1 Using where 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id PRIMARY 4 expressv_main.relation.product_related_id 1 Using index 1 SIMPLE cat eq_ref PRIMARY PRIMARY 4 expressv_main.pr_cat.category_id 1 Using where Status Duration Starting 0.13 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.62 ms Creating sort index 0.09 ms Removing tmp table 0.19 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:739 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.79 ms После последнего запроса: 0.15 ms Память запроса: 0.009 MB Память до запроса: 11.399 MB Выбрано строк: 13
select id,link
from u2bez_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='ru-RU')
and access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_menu ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 55 Using index condition; Using where Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.35 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/shop_item_menu.php:125 16 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:41 15 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:35 14 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:388 13 getShopMainPageItemid() JROOT/components/com_jshopping/lib/functions.php:407 12 getDefaultItemid() JROOT/components/com_jshopping/lib/functions.php:465 11 SEFLink() JROOT/components/com_jshopping/tables/product.php:741 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.44 ms После последнего запроса: 0.84 ms Память запроса: 0.010 MB Память до запроса: 11.441 MB Выбрано строк: 12
select category_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_categories
where `alias_ru-RU`!=''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_categories ALL NULL Индекс не используется NULL NULL 12 Using where Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.06 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:316 20 JSFactory::getAliasCategory() JROOT/components/com_jshopping/router.php:52 19 jshoppingBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 18 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/components/com_jshopping/lib/functions.php:477 11 SEFLink() JROOT/components/com_jshopping/tables/product.php:741 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.23 ms После последнего запроса: 1.61 ms Память запроса: 0.009 MB Память до запроса: 11.528 MB Выбрано строк: 49
SHOW FULL COLUMNS
FROM `u2bez_jshopping_users`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_users`Status Duration Starting 0.08 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.29 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.03 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms Checking permissions 0.20 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 14 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/usershop.php:14 13 jshopUserShop->__construct() JROOT/components/com_jshopping/lib/factory.php:125 12 JSFactory::getUserShop() JROOT/components/com_jshopping/lib/functions.php:616 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.82 ms После последнего запроса: 0.47 ms Память запроса: 0.009 MB Память до запроса: 11.612 MB Выбрано строк: 3
SHOW FULL COLUMNS
FROM `u2bez_jshopping_taxes`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_taxes`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.22 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms Checking permissions 0.04 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/tax.php:17 14 jshopTax->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:417 12 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:617 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.27 ms После последнего запроса: 0.10 ms Память запроса: 0.007 MB Память до запроса: 11.626 MB Выбрано строк: 1
SELECT tax_id, tax_name, tax_value
FROM `u2bez_jshopping_taxes`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_taxes ALL NULL Индекс не используется NULL NULL 1 Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/tax.php:24 14 jshopTax->getAllTaxes() JROOT/components/com_jshopping/lib/factory.php:402 13 JSFactory::getAllTaxesOriginal() JROOT/components/com_jshopping/lib/factory.php:418 12 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:617 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.07 ms Память запроса: 0.007 MB Память до запроса: 11.632 MB Выбрано строк: 19
select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from u2bez_jshopping_manufacturers
where manufacturer_publish='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_manufacturers ALL NULL Индекс не используется NULL NULL 20 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:477 12 JSFactory::getAllManufacturer() JROOT/components/com_jshopping/lib/functions.php:619 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.88 ms После последнего запроса: 0.36 ms Память запроса: 0.009 MB Память до запроса: 11.661 MB Выбрано строк: 6
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_field_values`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_extra_field_values`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.21 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms Checking permissions 0.09 ms Closing tables 0.03 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfieldvalue.php:16 15 jshopProductFieldValue->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:560 13 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/lib/functions.php:751 12 getProductExtraFieldForProduct() JROOT/components/com_jshopping/lib/functions.php:678 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.64 ms После последнего запроса: 0.13 ms Память запроса: 0.007 MB Память до запроса: 11.680 MB Выбрано строк: 112
SELECT id, `name_ru-RU` as name, field_id
FROM `u2bez_jshopping_products_extra_field_values`
order by orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_extra_field_values ALL NULL Индекс не используется NULL NULL 112 Используется filesort Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.33 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfieldvalue.php:27 14 jshopProductFieldValue->getAllList() JROOT/components/com_jshopping/lib/factory.php:561 13 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/lib/functions.php:751 12 getProductExtraFieldForProduct() JROOT/components/com_jshopping/lib/functions.php:678 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.13 ms После последнего запроса: 2.11 ms Память запроса: 0.007 MB Память до запроса: 11.806 MB Выбрано строк: 32
SHOW FULL COLUMNS
FROM `u2bez_jshopping_categories`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_categories`Status Duration Starting 0.04 ms Checking permissions 0.02 ms Closing tables 0.01 ms Opening tables 0.25 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.14 ms Closing tables 0.04 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/category.php:15 10 jshopCategory->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:63 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.66 ms После последнего запроса: 0.22 ms Память запроса: 0.006 MB Память до запроса: 11.861 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_categories
WHERE `category_id` = '5'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:64 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.67 ms После последнего запроса: 1.15 ms Память запроса: 0.005 MB Память до запроса: 11.926 MB
UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '16'EXPLAIN не доступен для запроса: UPDATE u2bez_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '16'Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.05 ms Updating 0.16 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.10 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 9 Joomla\CMS\Table\Table->hit() JROOT/components/com_jshopping/controllers/product.php:80 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.87 ms После последнего запроса: 1.79 ms Память запроса: 0.007 MB Память до запроса: 12.023 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_reviews`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_reviews`Status Duration Starting 0.05 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.27 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.08 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/review.php:14 10 jshopReview->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:96 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.81 ms После последнего запроса: 0.53 ms Память запроса: 0.007 MB Память до запроса: 12.060 MB Выбрано строк: 7
SHOW FULL COLUMNS
FROM `u2bez_jshopping_product_labels`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_product_labels`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.26 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.05 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productlabel.php:14 11 jshopProductLabel->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/functions.php:591 9 getNameImageLabel() JROOT/components/com_jshopping/controllers/product.php:159 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 0.10 ms Память запроса: 0.006 MB Память до запроса: 12.078 MB Выбрано строк: 4
SELECT id, image, `name_ru-RU` as name
FROM `u2bez_jshopping_product_labels`
ORDER BY nameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_product_labels ALL NULL Индекс не используется NULL NULL 4 Используется filesort Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 1.43 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productlabel.php:22 10 jshopProductLabel->getListLabels() JROOT/components/com_jshopping/lib/functions.php:592 9 getNameImageLabel() JROOT/components/com_jshopping/controllers/product.php:159 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.68 ms После последнего запроса: 7.53 ms Память запроса: 0.009 MB Память до запроса: 12.568 MB Выбрано строк: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM u2bez_fields AS a
LEFT JOIN `u2bez_languages` AS l
ON l.lang_code = a.language
LEFT JOIN u2bez_users AS uc
ON uc.id=a.checked_out
LEFT JOIN u2bez_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN u2bez_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN u2bez_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.article'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 expressv_main.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 expressv_main.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 expressv_main.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 expressv_main.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 expressv_main.a.group_id 1 Using where Status Duration Starting 0.17 ms Checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.09 ms Creating tmp table 0.13 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.45 ms Creating sort index 0.06 ms Removing tmp table 0.08 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.05 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 15 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 13 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 12 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/lib/functions.php:874 9 changeDataUsePluginContent() JROOT/components/com_jshopping/controllers/product.php:200 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.79 ms После последнего запроса: 0.22 ms Память запроса: 0.006 MB Память до запроса: 12.576 MB Выбрано строк: 2
SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `u2bez_jshopping_products_images` as I
left join `u2bez_jshopping_products` as P
on P.product_id=I.product_id
WHERE I.product_id = '16'
ORDER BY sort, I.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE I ALL NULL Индекс не используется NULL NULL 246 Using where; Using temporary; Используется filesort 1 SIMPLE P eq_ref PRIMARY PRIMARY 4 expressv_main.I.product_id 1 Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.24 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:314 9 jshopProduct->getImages() JROOT/components/com_jshopping/controllers/product.php:211 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.92 ms После последнего запроса: 1.05 ms Память запроса: 0.006 MB Память до запроса: 12.588 MB Выбрано строк: 1
SELECT count(review_id)
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '16'
and publish='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_reviews ALL NULL Индекс не используется NULL NULL 770 Using where