Экспресс Ворота
Монтаж в любом городе!
Товары
Товары связанные с Роллетные ворота
Отзыв
сергей, 05.12.2021
интересует роллетные ворота с автоматикой. 0671358824.
Дмитрий, 18.11.2021
Добрый день цена ворот 3000 на 2500 это с крепежом встроенным?
Игорь, 17.08.2021
2,5х2 метра автоматика с разблокировкой. Одесса, с установкой сколько денег? Спасибо
Олег, 25.04.2021
Роллетные ворота в паркинге.
ширина 3000. высота 2500...
С автоматикой, с аварийным режимом
Сергей, 22.09.2020
накладные гаражныеворота 3000 выс2650 с автоматикой цену подсчитать сможете 05105271185
Александр, 13.09.2020
Ширина 4000, можно с автоматикой?
Алина, 20.05.2020
Цікавлять рулетні ворота, в м.Сміла, Черкаська область,яка буде ціна з установкою і доставкою?
Ярослав, 09.03.2020
Цікавлять гаражні ролети 2.9 висота 4.0 ширина на пульту і щоб можна було відкривати вручну і пультом , приміщення не опалюється
Александр, 19.02.2020
Сколько стоят ролеты высота 2.5 метра ширина 4 метра, автоматические
Елена, 22.10.2019
Просчитайте пожалуйста ворота в автобоксы 3м на 3 м
Вячеслав, 20.06.2019
Купил и установил роллетные ворота с автоматикой Mosel DC115B. Все отлично, единственное, что расстроило, что она работает только с родными двумя брелками. Никакие другие пульты, к ней подшить не удается. Хотя у меня и два света и откатные ворота зашиты в один брелок. Также к этому брелку не добавляются мои ворота. Хотя все на 433мгц. Приходится таскать два пульта.. Такая вот особенность этой автоматики. Учитывайте это.
Альберт, 07.06.2019
Сколько будут стоить въездные ворота с ручным управлением 77-я пена 4500 ширина 4000 накладной монтаж+ установка, спасибо.
Андрей, 10.03.2019
Добрый день,интересуют ворота для въезда во двор на колонах забора. Просвет между колонами:3000-ширина; высота- 2500(размеры обсуждаются).Какие особенности конструкции колон при таком монтаже.Есть ли стандартные размеры ролетных ворот .Спасибо.
Анатолий, 08.01.2019
0730439065
Киев
роллетные ворота (Высота 2300
Ширина 2950)
Пенозаполненный
Внутри помещения
Тетяна, 19.10.2018
Доброго дня! Цікавлять гаражні ролетні ворота 2500х2200. Яка вартість з установкою в Кропивницькому?
Евгений, 23.09.2018
Добрый день. Интересуют рулонные ворота шириной 3300 см на 2500 см. с автоматикой?
игорь, 11.09.2018
Роллета гаражная 5000х2500 ручной механизм изнутри, накладной монтаж
Оксана, 06.08.2018
Цікавлять гаражні ролети 2.9 висота 4.0 ширина на пульту і щоб можна було відкривати вручну і пультом , приміщення не опалюється
Руслан , 20.07.2018
Интересуют ворота с автоматикой, но не в гараж а въезд во двор, получаеться имеем только опоры, без потолка, это возможно, ширина до 3 метров, высота обсуждается.
николай, 10.07.2018
ворота ролетные,
2600 х 2010, автоматика. Какая стоимость с монтажом. Киевская обл. с.Забирье
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1657149479,
"last": 1657149479,
"now": 1657149479
},
"client": {
"forwarded": "3.238.24.209"
},
"token": "R1HWl7wg2Lz1LqdmahCccxv26XKlZngb"
},
"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": "/rollety/rollety-na-garaj",
"product_back_value": []
}
}
Время
Память
Время: 34.15 ms / 34.15 ms Память: 2.085 MB / 2.46 MB Application: afterLoad
Время: 63.44 ms / 97.59 ms Память: 4.239 MB / 6.70 MB Application: afterInitialise
Время: 37.47 ms / 135.05 ms Память: 2.516 MB / 9.22 MB Application: Before Access::preloadComponents (all components)
Время: 1.13 ms / 136.18 ms Память: 0.061 MB / 9.28 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 136.21 ms Память: -0.003 MB / 9.27 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.60 ms / 136.81 ms Память: 0.026 MB / 9.30 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 3.42 ms / 140.23 ms Память: 0.252 MB / 9.55 MB Application: afterRoute
Время: 0.94 ms / 141.17 ms Память: 0.018 MB / 9.57 MB Application: beforeRenderComponent com_jshopping
Время: 79.74 ms / 220.91 ms Память: 3.496 MB / 13.07 MB Application: afterRenderComponent com_jshopping
Время: 0.44 ms / 221.35 ms Память: 0.005 MB / 13.07 MB Application: afterDispatch
Время: 6.55 ms / 227.90 ms Память: 0.277 MB / 13.35 MB Application: beforeRenderModule mod_mel_cart (Mel Cart)
Время: 0.99 ms / 228.89 ms Память: 0.045 MB / 13.39 MB Application: afterRenderModule mod_mel_cart (Mel Cart)
Время: 0.12 ms / 229.01 ms Память: 0.000 MB / 13.39 MB Application: beforeRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 1.26 ms / 230.27 ms Память: 0.057 MB / 13.45 MB Application: afterRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 0.46 ms / 230.73 ms Память: 0.018 MB / 13.47 MB Application: beforeRenderModule mod_menu (Товары)
Время: 9.49 ms / 240.22 ms Память: 0.132 MB / 13.60 MB Application: afterRenderModule mod_menu (Товары)
Время: 0.61 ms / 240.83 ms Память: -0.094 MB / 13.51 MB Application: beforeRenderModule mod_menu (Города)
Время: 5.64 ms / 246.47 ms Память: 0.069 MB / 13.58 MB Application: afterRenderModule mod_menu (Города)
Время: 293.90 ms / 540.37 ms Память: 0.230 MB / 13.81 MB Application: afterRender
Всего SQL-запросов: 32.95 ms
14.49 MB (15,195,376 Байт)
40 SQL-запросов зафиксировано 32.95 ms
- Время запроса: 0.51 ms Память запроса: 0.007 MB Память до запроса: 4.190 MB Выбрано строк: 0
SELECT `data`
FROM `u2bez_session`
WHERE `session_id` = X'3832336438346461656235633337613262613366633538616464326133323063'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.07 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.10 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.02 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.35 ms После последнего запроса: 1.66 ms Память запроса: 0.004 MB Память до запроса: 4.286 MB Выбрано строк: 0
SELECT `session_id`
FROM `u2bez_session`
WHERE `session_id` = X'3832336438346461656235633337613262613366633538616464326133323063'
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.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.03 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 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.51 ms После последнего запроса: 0.15 ms Память запроса: 0.004 MB Память до запроса: 4.291 MB
INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3832336438346461656235633337613262613366633538616464326133323063', 1, 1657149479, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3832336438346461656235633337613262613366633538616464326133323063', 1, 1657149479, 0, '', 0)Status Duration Starting 0.05 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 for update 0.02 ms Update 0.14 ms Waiting for query cache lock 0.01 ms Update 0.01 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.03 ms Reset for next command 0.01 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.42 ms После последнего запроса: 7.40 ms Память запроса: 0.005 MB Память до запроса: 4.834 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.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 Executing 0.02 ms Sending data 0.06 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 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.56 ms После последнего запроса: 0.13 ms Память запроса: 0.005 MB Память до запроса: 4.846 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.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.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 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.02 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.54 ms После последнего запроса: 45.85 ms Память запроса: 0.009 MB Память до запроса: 8.310 MB Выбрано строк: 137
SHOW FULL COLUMNS
FROM `u2bez_jshopping_config`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_config`Status Duration Starting 0.06 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.33 ms After opening tables 0.02 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.02 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.43 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.19 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.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.81 ms После последнего запроса: 1.53 ms Память запроса: 0.007 MB Память до запроса: 8.582 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.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.09 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 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.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 - Время запроса: 1.16 ms После последнего запроса: 1.90 ms Память запроса: 0.010 MB Память до запроса: 8.689 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `u2bez_jshopping_currencies`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_currencies`Status Duration Starting 0.11 ms Checking permissions 0.02 ms Closing tables 0.01 ms Opening tables 0.41 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.01 ms Opening tables 0.03 ms After opening tables 0.02 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.15 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.52 ms После последнего запроса: 0.19 ms Память запроса: 0.009 MB Память до запроса: 8.712 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.06 ms Checking permissions 0.02 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.04 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 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 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.71 ms После последнего запроса: 2.23 ms Память запроса: 0.006 MB Память до запроса: 8.795 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.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.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.35 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 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.92 ms После последнего запроса: 6.89 ms Память запроса: 0.007 MB Память до запроса: 9.222 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.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.07 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.34 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.02 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.50 ms После последнего запроса: 1.47 ms Память запроса: 0.006 MB Память до запроса: 9.314 MB
UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"881d738d3825c85808305f3163ee0544\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `u2bez_extensions` SET `params` = '{\"mediaversion\":\"881d738d3825c85808305f3163ee0544\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.10 ms Updating 0.07 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.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.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.39 ms После последнего запроса: 7.70 ms Память запроса: 0.006 MB Память до запроса: 9.651 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.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.04 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.05 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 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.40 ms После последнего запроса: 19.80 ms Память запроса: 0.007 MB Память до запроса: 10.530 MB Выбрано строк: 73
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products`Status Duration Starting 0.07 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.33 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.03 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.26 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.15 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.15 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 - Время запроса: 1.93 ms После последнего запроса: 0.33 ms Память запроса: 0.006 MB Память до запроса: 10.656 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_products
WHERE `product_id` = '60'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.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.06 ms Optimizing 0.02 ms Statistics 1.25 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.03 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.01 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.49 ms После последнего запроса: 0.17 ms Память запроса: 0.006 MB Память до запроса: 10.678 MB Выбрано строк: 1
SELECT *
FROM `u2bez_jshopping_products_to_categories`
WHERE product_id='60'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.04 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.07 ms Preparing 0.02 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 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 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.90 ms После последнего запроса: 0.79 ms Память запроса: 0.009 MB Память до запроса: 10.697 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.29 ms After opening tables 0.04 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.03 ms After opening tables 0.01 ms Checking permissions 0.10 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.02 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.62 ms После последнего запроса: 0.11 ms Память запроса: 0.007 MB Память до запроса: 10.724 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.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.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.29 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 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.15 ms После последнего запроса: 0.15 ms Память запроса: 0.006 MB Память до запроса: 10.786 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_attr`
WHERE product_id = '60'
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.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.63 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.02 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 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.83 ms После последнего запроса: 0.06 ms Память запроса: 0.006 MB Память до запроса: 10.793 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_attr2`
WHERE product_id = '60'
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.52 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.02 ms Updating status 0.01 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.88 ms После последнего запроса: 0.47 ms Память запроса: 0.009 MB Память до запроса: 10.807 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.03 ms Checking permissions 0.01 ms Closing tables 0.03 ms Opening tables 0.21 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 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.09 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.13 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 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 - Время запроса: 1.14 ms После последнего запроса: 0.13 ms Память запроса: 0.007 MB Память до запроса: 10.835 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.11 ms Checking permissions 0.03 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.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.02 ms Sending data 0.40 ms Creating sort index 0.10 ms Removing tmp table 0.08 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 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.04 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.58 ms После последнего запроса: 0.24 ms Память запроса: 0.006 MB Память до запроса: 10.878 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 = '60'
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.12 ms Checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.62 ms Creating sort index 0.08 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.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: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.78 ms После последнего запроса: 0.15 ms Память запроса: 0.009 MB Память до запроса: 10.893 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.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.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.37 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 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.35 ms После последнего запроса: 0.76 ms Память запроса: 0.010 MB Память до запроса: 10.935 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.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 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.01 ms Updating status 0.01 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 - Время запроса: 0.93 ms После последнего запроса: 1.61 ms Память запроса: 0.009 MB Память до запроса: 11.023 MB Выбрано строк: 49
SHOW FULL COLUMNS
FROM `u2bez_jshopping_users`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_users`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.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.19 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.08 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 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.74 ms После последнего запроса: 0.36 ms Память запроса: 0.009 MB Память до запроса: 11.106 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.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.03 ms After opening tables 0.01 ms Checking permissions 0.04 ms Closing tables 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 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.03 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.32 ms После последнего запроса: 0.10 ms Память запроса: 0.007 MB Память до запроса: 11.120 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.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.02 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 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: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.46 ms После последнего запроса: 0.13 ms Память запроса: 0.007 MB Память до запроса: 11.126 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.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.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.14 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.03 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.74 ms После последнего запроса: 0.34 ms Память запроса: 0.009 MB Память до запроса: 11.156 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.24 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.03 ms End of update loop 0.01 ms Query end 0.03 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 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.56 ms После последнего запроса: 0.09 ms Память запроса: 0.007 MB Память до запроса: 11.174 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.02 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.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: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 - Время запроса: 0.93 ms После последнего запроса: 2.47 ms Память запроса: 0.007 MB Память до запроса: 11.238 MB Выбрано строк: 32
SHOW FULL COLUMNS
FROM `u2bez_jshopping_categories`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_categories`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.01 ms After opening tables 0.01 ms Checking permissions 0.14 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.07 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.13 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/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.65 ms После последнего запроса: 0.20 ms Память запроса: 0.007 MB Память до запроса: 11.300 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_categories
WHERE `category_id` = '9'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.01 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.10 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.16 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.03 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.99 ms Память запроса: 0.005 MB Память до запроса: 11.419 MB
UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '60'EXPLAIN не доступен для запроса: UPDATE u2bez_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '60'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.06 ms Updating 0.17 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.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.03 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.77 ms После последнего запроса: 1.94 ms Память запроса: 0.007 MB Память до запроса: 11.501 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_reviews`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_reviews`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.02 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.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.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/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 - Время запроса: 1.22 ms После последнего запроса: 8.42 ms Память запроса: 0.009 MB Память до запроса: 12.103 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.12 ms Checking permissions 0.02 ms Opening tables 0.06 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.13 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.31 ms Creating sort index 0.04 ms Removing tmp table 0.06 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.02 ms Updating status 0.02 ms Reset for next command 0.03 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.72 ms После последнего запроса: 0.26 ms Память запроса: 0.006 MB Память до запроса: 12.110 MB Выбрано строк: 3
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 = '60'
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.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.03 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.22 ms Creating sort index 0.02 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.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: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.84 ms После последнего запроса: 0.77 ms Память запроса: 0.006 MB Память до запроса: 12.124 MB Выбрано строк: 1
SELECT count(review_id)
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '60'
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 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.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.52 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.02 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/components/com_jshopping/tables/product.php:965 9 jshopProduct->getReviewsCount() JROOT/components/com_jshopping/controllers/product.php:241 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.06 ms Память запроса: 0.006 MB Память до запроса: 12.129 MB Выбрано строк: 20
SELECT *
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '60'
and publish='1'
order by review_id desc
LIMIT 0, 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_reviews index NULL PRIMARY 4 NULL 20 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.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.51 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 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.04 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:959 9 jshopProduct->getReviews() JROOT/components/com_jshopping/controllers/product.php:242 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.60 ms После последнего запроса: 330.19 ms Память запроса: 0.004 MB Память до запроса: 13.793 MB
DELETE
FROM `u2bez_session`
WHERE `time` < 1657148580EXPLAIN не доступен для запроса: DELETE FROM `u2bez_session` WHERE `time` < 1657148580Status Duration Starting 0.11 ms Checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.07 ms Updating 1.06 ms End of update loop 0.02 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.06 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 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/session/storage/database.php:156 7 JSessionStorageDatabase->gc() JROOT/libraries/src/Session/Session.php:837 6 Joomla\CMS\Session\Session->gc() JROOT/plugins/system/sessiongc/sessiongc.php:60 5 PlgSystemSessionGc->onAfterRespond() JROOT/libraries/joomla/event/event.php:70 4 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 3 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 2 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:247 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
40 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
1 × SELECT `data`
FROM `u2bez_session`1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_ru-RU` as groupname, multilist
FROM `u2bez_jshopping_products_extra_fields` as F
left join `u2bez_jshopping_products_extra_field_groups` as G
on G.id=F.
group1 × SELECT count(review_id)
FROM `u2bez_jshopping_products_reviews`1 × 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_id1 × 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_id1 × SELECT *
FROM u2bez_jshopping_categories1 × SELECT id, `name_ru-RU` as name, field_id
FROM `u2bez_jshopping_products_extra_field_values`1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from u2bez_jshopping_manufacturers1 × SELECT tax_id, tax_name, tax_value
FROM `u2bez_jshopping_taxes1 × select category_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_categories1 × select id,link
from u2bez_menu1 × 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_id1 × SELECT *
FROM `u2bez_jshopping_products_attr2`1 × SELECT `session_id`
FROM `u2bez_session`1 × SELECT *
FROM `u2bez_jshopping_products_attr`1 × SELECT attr_id, `name_ru-RU` as name, `description_ru-RU` as description, attr_type, independent, allcats, cats, attr_ordering
FROM `u2bez_jshopping_attr`1 × SELECT *
FROM `u2bez_jshopping_products_to_categories`1 × SELECT *
FROM u2bez_jshopping_products1 × select *
from u2bez_jshopping_language1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `u2bez_assets`1 × select product_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_products1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `u2bez_jshopping_currencies`1 × SELECT *
FROM u2bez_jshopping_config1 × SELECT b.id
FROM u2bez_usergroups AS a
LEFT JOIN u2bez_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `u2bez_viewlevels1 × SELECT *
FROM `u2bez_jshopping_products_reviews`
Прочие SQL-запросы:
1 × INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3832336438346461656235633337613262613366633538616464326133323063', 1, 1657149479, 0, '', 01 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_config1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_currencies1 × UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"881d738d3825c85808305f3163ee0544\"}'1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_fields1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_users1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_taxes1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_field_values1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_categories1 × UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_reviews1 × DELETE
FROM `u2bez_session`