-
Главная
-
Ворота секционные
- Секционные ворота Ryterna
Экспресс Ворота
Монтаж в любом городе!
Товары
Товары связанные с Секционные ворота Ryterna
Отзыв
sergeybelokon896@gmail.com, 22.05.2021
Нужен размнр 2.5*2.2 автоматика
Василь, 10.04.2020
Скільки коштуватимуть ворода для навісу не утеплені секційні розміром 3000*2700 з автоматикою і монтажем? Дякую!
Роман, 11.04.2019
Здравствуйте , можно заказать ворота Ryterna с калиткой 90х190 , на сколько это удорожит стоимость в сравнении с указанной на сайте ?
Валерий, 23.07.2018
какая цена ворот будет по размеру 2750х2250 без автоматики, я хочу купить две пары.
Максим, 08.09.2017
Возможно ли сделать ворота 3000 на 2500? И сколько будут стоить?
Экспресс Ворота, 16.02.2016
Дмитрий Петрович, если заказывать ворота в одном из стандартных цветов 5 - 7 дней. Если такого цвета или структуры нет в Украине, то это будет Литовский заказ со сроками 3 - 4 недели
Дмитрий Петрович, 16.02.2016
Реальный срок изготовления?
Экспресс Ворота, 21.01.2016
Ворота со структурой "Филенка" стоят немного дороже, примерно на 5% - для более точного расчета укажите размер ворот которые вас интересуют
Елена, 21.01.2016
здравствуйте. плитка шоколода дороже или столько же стоит?
Экспресс Ворота, 27.11.2015
Людмила, только у Ритерна курс НБУ. Евро мы не имеем права принимать - расчет в национальной валюте по курсу на день подписания договора/внесения предоплаты
Людмила, 27.11.2015
480 евро это по какому курсу? Евро принимаете?
Виктор, 07.11.2015
Какая цена 2.66 на 2.3 коричневые?
Ирина, 02.11.2015
Спасибо мальчикам, отличные ворота!
Экспресс Ворота, 12.10.2015
Эдуард, спасибо за обращение! Коммерческое у Вас на почте
Эдуард, 12.10.2015
Здравствуйте! Сколько будут стоять ворота Филенка Old Oak, высота 2.1, ширина 2.62 с автоматикой
Экспресс Ворота, 03.10.2015
Пётр, да - действует
пётр, 03.10.2015
установить надо будет в киеве
пётр, 03.10.2015
акция приведи друга на эти ворота действует?
Экспресс Ворота, 09.09.2015
Валерий Иванович, было приятно с Вами работать! Черные ворота оказались популярны в этом месяце
Валерий Иванович, 09.09.2015
Заказл чёрные ворота. Сделали за 3 недели. Все супер. Спасибо
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1657148829,
"last": 1657148829,
"now": 1657148829
},
"client": {
"forwarded": "3.238.24.209"
},
"token": "Zm1scdMw8mQ6fj5RlYKlrucmmLBPYDJQ"
},
"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": "/vorota-sektsionnye/ryterna",
"product_back_value": []
}
}
Время
Память
Время: 28.59 ms / 28.59 ms Память: 2.085 MB / 2.46 MB Application: afterLoad
Время: 69.97 ms / 98.56 ms Память: 4.239 MB / 6.70 MB Application: afterInitialise
Время: 48.39 ms / 146.95 ms Память: 2.516 MB / 9.22 MB Application: Before Access::preloadComponents (all components)
Время: 1.38 ms / 148.33 ms Память: 0.061 MB / 9.28 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 148.37 ms Память: -0.003 MB / 9.27 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.71 ms / 149.07 ms Память: 0.026 MB / 9.30 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 4.27 ms / 153.34 ms Память: 0.252 MB / 9.55 MB Application: afterRoute
Время: 0.86 ms / 154.20 ms Память: 0.018 MB / 9.57 MB Application: beforeRenderComponent com_jshopping
Время: 77.54 ms / 231.74 ms Память: 3.857 MB / 13.43 MB Application: afterRenderComponent com_jshopping
Время: 0.72 ms / 232.46 ms Память: 0.005 MB / 13.43 MB Application: afterDispatch
Время: 11.85 ms / 244.31 ms Память: 0.287 MB / 13.72 MB Application: beforeRenderModule mod_mel_cart (Mel Cart)
Время: 1.02 ms / 245.33 ms Память: 0.045 MB / 13.76 MB Application: afterRenderModule mod_mel_cart (Mel Cart)
Время: 0.12 ms / 245.45 ms Память: 0.000 MB / 13.76 MB Application: beforeRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 1.61 ms / 247.06 ms Память: 0.057 MB / 13.82 MB Application: afterRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 0.45 ms / 247.51 ms Память: 0.018 MB / 13.84 MB Application: beforeRenderModule mod_menu (Товары)
Время: 11.62 ms / 259.13 ms Память: 0.095 MB / 13.93 MB Application: afterRenderModule mod_menu (Товары)
Время: 0.65 ms / 259.78 ms Память: -0.005 MB / 13.93 MB Application: beforeRenderModule mod_menu (Города)
Время: 6.75 ms / 266.53 ms Память: 0.044 MB / 13.97 MB Application: afterRenderModule mod_menu (Города)
Время: 289.84 ms / 556.37 ms Память: 0.300 MB / 14.27 MB Application: afterRender
Всего SQL-запросов: 38.40 ms
15.07 MB (15,797,488 Байт)
46 SQL-запросов зафиксировано 38.40 ms
- Время запроса: 0.55 ms Память запроса: 0.007 MB Память до запроса: 4.190 MB Выбрано строк: 0
SELECT `data`
FROM `u2bez_session`
WHERE `session_id` = X'6535613062343464633338353039626331646161623362616635373332663637'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.37 ms После последнего запроса: 1.67 ms Память запроса: 0.004 MB Память до запроса: 4.286 MB Выбрано строк: 0
SELECT `session_id`
FROM `u2bez_session`
WHERE `session_id` = X'6535613062343464633338353039626331646161623362616635373332663637'
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.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.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.02 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.63 ms После последнего запроса: 0.13 ms Память запроса: 0.004 MB Память до запроса: 4.291 MB
INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6535613062343464633338353039626331646161623362616635373332663637', 1, 1657148829, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6535613062343464633338353039626331646161623362616635373332663637', 1, 1657148829, 0, '', 0)Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init for update 0.03 ms Update 0.26 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.08 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 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.46 ms После последнего запроса: 7.45 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.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 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.07 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.03 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.54 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.06 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.88 ms После последнего запроса: 62.03 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.12 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.45 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms Checking permissions 0.37 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.20 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.23 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 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.94 ms После последнего запроса: 1.88 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.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.03 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 14 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/lib/factory.php:27 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.94 ms После последнего запроса: 1.06 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.04 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.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.07 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.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.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/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.51 ms После последнего запроса: 0.11 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.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.03 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.12 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.05 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 - Время запроса: 1.06 ms После последнего запроса: 2.59 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.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.71 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 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 - Время запроса: 1.11 ms После последнего запроса: 9.57 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.10 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.06 ms Optimizing 0.03 ms Statistics 0.17 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.41 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.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.73 ms После последнего запроса: 1.83 ms Память запроса: 0.006 MB Память до запроса: 9.314 MB
UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"151cce49a0713e1d79c9ab9c27d51542\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `u2bez_extensions` SET `params` = '{\"mediaversion\":\"151cce49a0713e1d79c9ab9c27d51542\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 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 for update 0.14 ms Updating 0.15 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.03 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 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.41 ms После последнего запроса: 7.62 ms Память запроса: 0.006 MB Память до запроса: 9.650 MB Выбрано строк: 3
select *
from u2bez_jshopping_languagesid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_languages ALL NULL Индекс не используется NULL NULL 2 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.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.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms 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.32 ms После последнего запроса: 10.87 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.08 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.32 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 Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms Checking permissions 0.25 ms Closing tables 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.02 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.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.10 ms После последнего запроса: 0.30 ms Память запроса: 0.006 MB Память до запроса: 10.656 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_products
WHERE `product_id` = '78'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.54 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.03 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:41 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.11 ms Память запроса: 0.006 MB Память до запроса: 10.670 MB Выбрано строк: 1
SELECT *
FROM `u2bez_jshopping_products_to_categories`
WHERE product_id='78'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.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.08 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:228 9 jshopProduct->getCategories() JROOT/components/com_jshopping/controllers/product.php:42 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.85 ms После последнего запроса: 0.33 ms Память запроса: 0.009 MB Память до запроса: 10.689 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.27 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.11 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 14 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/attribut.php:16 13 jshopAttribut->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:364 11 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:95 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.60 ms После последнего запроса: 0.12 ms Память запроса: 0.007 MB Память до запроса: 10.716 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.05 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.24 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.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.01 ms После последнего запроса: 0.13 ms Память запроса: 0.006 MB Память до запроса: 10.778 MB Выбрано строк: 6
SELECT *
FROM `u2bez_jshopping_products_attr`
WHERE product_id = '78'
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.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.65 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:126 11 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:100 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.74 ms После последнего запроса: 0.12 ms Память запроса: 0.006 MB Память до запроса: 10.820 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_attr2`
WHERE product_id = '78'
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.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 Sorting result 0.01 ms Executing 0.01 ms Sending data 0.45 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.72 ms После последнего запроса: 0.08 ms Память запроса: 0.006 MB Память до запроса: 10.792 MB Выбрано строк: 2
SELECT distinct PA.attr_38 as val_id, V.`name_ru-RU` as value_name, V.image
FROM `u2bez_jshopping_products_attr` as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_38=V.value_id
WHERE PA.product_id = '78'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 247 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_38 1 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 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.26 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.01 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:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.61 ms После последнего запроса: 0.07 ms Память запроса: 0.006 MB Память до запроса: 10.800 MB Выбрано строк: 3
SELECT distinct PA.attr_40 as val_id, V.`name_ru-RU` as value_name, V.image
FROM `u2bez_jshopping_products_attr` as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_40=V.value_id
WHERE PA.product_id = '78'
and PA.attr_38='313'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 247 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_40 1 Status Duration Starting 0.08 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.19 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 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:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.58 ms После последнего запроса: 0.07 ms Память запроса: 0.006 MB Память до запроса: 10.809 MB Выбрано строк: 1
SELECT distinct PA.attr_39 as val_id, V.`name_ru-RU` as value_name, V.image
FROM `u2bez_jshopping_products_attr` as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_39=V.value_id
WHERE PA.product_id = '78'
and PA.attr_38='313'
and PA.attr_40='262'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 247 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_39 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.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.21 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 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 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 10 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:168 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.92 ms После последнего запроса: 0.10 ms Память запроса: 0.006 MB Память до запроса: 10.815 MB Выбрано строк: 1
select PA.*
from `u2bez_jshopping_products_attr` as PA
where PA.product_id = '78'
and PA.attr_38 = '313'
and PA.attr_40 = '262'
and PA.attr_39 = '260'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 247 Using where Status Duration Starting 0.04 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.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.54 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/components/com_jshopping/tables/product.php:40 9 jshopProduct->setAttributeActive() JROOT/components/com_jshopping/controllers/product.php:49 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.81 ms После последнего запроса: 1.45 ms Память запроса: 0.007 MB Память до запроса: 10.911 MB Выбрано строк: 7
SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr_values`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_attr_values`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.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.06 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/attributvalue.php:16 10 jshopAttributValue->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.39 ms После последнего запроса: 0.08 ms Память запроса: 0.006 MB Память до запроса: 10.928 MB Выбрано строк: 402
SELECT value_id, image, `name_ru-RU` as name, attr_id, value_ordering
FROM `u2bez_jshopping_attr_values`
ORDER BY value_ordering, value_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_attr_values ALL NULL Индекс не используется NULL NULL 402 Используется filesort Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.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/attributvalue.php:47 9 jshopAttributValue->getAllAttributeValues() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.73 ms После последнего запроса: 0.74 ms Память запроса: 0.009 MB Память до запроса: 11.262 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.01 ms Opening tables 0.20 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.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.07 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.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 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfield.php:16 15 jshopProductField->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:551 13 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1038 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:198 11 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:725 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.82 ms После последнего запроса: 0.10 ms Память запроса: 0.007 MB Память до запроса: 11.290 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.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.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.31 ms Creating sort index 0.08 ms Removing tmp table 0.08 ms Creating sort index 0.01 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/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.81 ms После последнего запроса: 0.23 ms Память запроса: 0.006 MB Память до запроса: 11.333 MB Выбрано строк: 2
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 = '78'
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.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.76 ms Creating sort index 0.14 ms Removing tmp table 0.17 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.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 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 - Время запроса: 1.16 ms После последнего запроса: 0.12 ms Память запроса: 0.009 MB Память до запроса: 11.346 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.10 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.74 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.39 ms После последнего запроса: 0.70 ms Память запроса: 0.010 MB Память до запроса: 11.388 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.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.03 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.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.95 ms После последнего запроса: 1.39 ms Память запроса: 0.009 MB Память до запроса: 11.474 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.02 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.16 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.11 ms Closing tables 0.01 ms Unlocking tables 0.03 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.63 ms После последнего запроса: 0.37 ms Память запроса: 0.010 MB Память до запроса: 11.564 MB Выбрано строк: 3
SHOW FULL COLUMNS
FROM `u2bez_jshopping_taxes`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_taxes`Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.18 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.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.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/tax.php:17 14 jshopTax->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:417 12 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:617 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.30 ms После последнего запроса: 0.09 ms Память запроса: 0.007 MB Память до запроса: 11.579 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.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.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.44 ms После последнего запроса: 0.09 ms Память запроса: 0.007 MB Память до запроса: 11.585 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.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.15 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/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.31 ms Память запроса: 0.009 MB Память до запроса: 11.615 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.04 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.19 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.08 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms 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.62 ms После последнего запроса: 0.11 ms Память запроса: 0.007 MB Память до запроса: 11.633 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.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.30 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.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.87 ms После последнего запроса: 1.48 ms Память запроса: 0.007 MB Память до запроса: 11.757 MB Выбрано строк: 32
SHOW FULL COLUMNS
FROM `u2bez_jshopping_categories`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_categories`Status Duration Starting 0.04 ms Checking permissions 0.02 ms Closing tables 0.02 ms Opening tables 0.20 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.15 ms Closing tables 0.02 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 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.86 ms После последнего запроса: 0.17 ms Память запроса: 0.006 MB Память до запроса: 11.812 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_categories
WHERE `category_id` = '1'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.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.12 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.31 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.05 ms Freeing items 0.02 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: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.57 ms После последнего запроса: 1.60 ms Память запроса: 0.005 MB Память до запроса: 11.891 MB
UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '78'EXPLAIN не доступен для запроса: UPDATE u2bez_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '78'Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.08 ms Updating 0.13 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.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.91 ms После последнего запроса: 1.45 ms Память запроса: 0.007 MB Память до запроса: 11.988 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.29 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.03 ms Filling schema table 0.02 ms Opening tables 0.02 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.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 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.39 ms После последнего запроса: 6.96 ms Память запроса: 0.009 MB Память до запроса: 12.501 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.15 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.16 ms Preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.36 ms Creating sort index 0.04 ms Removing tmp table 0.08 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.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.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/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.77 ms После последнего запроса: 0.32 ms Память запроса: 0.006 MB Память до запроса: 12.509 MB Выбрано строк: 8
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 = '78'
ORDER BY sort, I.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE I ALL NULL Индекс не используется NULL NULL 246 Using where; Using temporary; Используется filesort 1 SIMPLE P eq_ref PRIMARY PRIMARY 4 expressv_main.I.product_id 1 Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.24 ms Creating sort index 0.04 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.93 ms После последнего запроса: 0.77 ms Память запроса: 0.006 MB Память до запроса: 12.529 MB Выбрано строк: 1
SELECT count(review_id)
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '78'
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.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.59 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: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 - Время запроса: 1.03 ms После последнего запроса: 0.08 ms Память запроса: 0.006 MB Память до запроса: 12.534 MB Выбрано строк: 20
SELECT *
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '78'
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.05 ms Checking permissions 0.03 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.67 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: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.28 ms После последнего запроса: 24.09 ms Память запроса: 0.007 MB Память до запроса: 13.709 MB Выбрано строк: 4
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM u2bez_modules AS m
LEFT JOIN u2bez_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN u2bez_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-07-06 23:07:09')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-07-06 23:07:09')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 111 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 7 Using index condition; Using where; Используется filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 expressv_main.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 expressv_main.m.module,const 1 Using index condition; Using where Status Duration Starting 0.14 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.40 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/emailmarketing_22/library/Artx/Page.php:43 8 ArtxPage->containsModules() JROOT/templates/emailmarketing_22/index.php:110 7 require JROOT/templates/emailmarketing_22/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
46 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
1 × SELECT `data`
FROM `u2bez_session`1 × select PA.*
from `u2bez_jshopping_products_attr` as PA1 × SELECT *
FROM `u2bez_jshopping_products_reviews`1 × 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 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 value_id, image, `name_ru-RU` as name, attr_id, value_ordering
FROM `u2bez_jshopping_attr_values`1 × SELECT distinct PA.attr_39 as val_id, V.`name_ru-RU` as value_name, V.image
FROM `u2bez_jshopping_products_attr` as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_39=V.value_id1 × SELECT `session_id`
FROM `u2bez_session`1 × SELECT distinct PA.attr_40 as val_id, V.`name_ru-RU` as value_name, V.image
FROM `u2bez_jshopping_products_attr` as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_40=V.value_id1 × SELECT distinct PA.attr_38 as val_id, V.`name_ru-RU` as value_name, V.image
FROM `u2bez_jshopping_products_attr` as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_38=V.value_id1 × SELECT *
FROM `u2bez_jshopping_products_attr2`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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM u2bez_modules AS m
LEFT JOIN u2bez_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN u2bez_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Прочие SQL-запросы:
1 × INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6535613062343464633338353039626331646161623362616635373332663637', 1, 1657148829, 0, '', 01 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_config1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_currencies1 × UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"151cce49a0713e1d79c9ab9c27d51542\"}'1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr_values1 × 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_reviews