Экспресс Ворота
Монтаж в любом городе!
Товары
Отзыв
Оставить отзыв
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1657146575,
"last": 1657146575,
"now": 1657146575
},
"client": {
"forwarded": "3.238.24.209"
},
"token": "WOivQsdjEcvbkH4Gr0DKrDQ4QNms4Yea"
},
"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": "/pulty/roger-h80-e80",
"product_back_value": []
}
}
Время
Память
Время: 21.11 ms / 21.11 ms Память: 2.085 MB / 2.46 MB Application: afterLoad
Время: 55.84 ms / 76.94 ms Память: 4.239 MB / 6.70 MB Application: afterInitialise
Время: 34.19 ms / 111.13 ms Память: 2.516 MB / 9.22 MB Application: Before Access::preloadComponents (all components)
Время: 1.27 ms / 112.41 ms Память: 0.061 MB / 9.28 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 112.44 ms Память: -0.003 MB / 9.27 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.61 ms / 113.05 ms Память: 0.026 MB / 9.30 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 3.56 ms / 116.61 ms Память: 0.252 MB / 9.55 MB Application: afterRoute
Время: 0.83 ms / 117.44 ms Память: 0.018 MB / 9.57 MB Application: beforeRenderComponent com_jshopping
Время: 64.64 ms / 182.08 ms Память: 3.706 MB / 13.28 MB Application: afterRenderComponent com_jshopping
Время: 0.44 ms / 182.53 ms Память: 0.005 MB / 13.28 MB Application: afterDispatch
Время: 5.25 ms / 187.78 ms Память: 0.277 MB / 13.56 MB Application: beforeRenderModule mod_mel_cart (Mel Cart)
Время: 1.00 ms / 188.78 ms Память: 0.045 MB / 13.60 MB Application: afterRenderModule mod_mel_cart (Mel Cart)
Время: 0.13 ms / 188.91 ms Память: 0.000 MB / 13.60 MB Application: beforeRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 1.25 ms / 190.16 ms Память: 0.058 MB / 13.66 MB Application: afterRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 114.91 ms / 305.07 ms Память: 0.267 MB / 13.93 MB Application: afterRender
Всего SQL-запросов: 32.63 ms
14.66 MB (15,370,984 Байт)
43 SQL-запросов зафиксировано 32.63 ms
- Время запроса: 0.45 ms Память запроса: 0.007 MB Память до запроса: 4.190 MB Выбрано строк: 0
SELECT `data`
FROM `u2bez_session`
WHERE `session_id` = X'6333393733353761626333363631336166646333383331383639626430333132'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.06 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.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 После последнего запроса: 2.23 ms Память запроса: 0.004 MB Память до запроса: 4.286 MB Выбрано строк: 0
SELECT `session_id`
FROM `u2bez_session`
WHERE `session_id` = X'6333393733353761626333363631336166646333383331383639626430333132'
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.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 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.02 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.50 ms После последнего запроса: 0.13 ms Память запроса: 0.004 MB Память до запроса: 4.291 MB
INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6333393733353761626333363631336166646333383331383639626430333132', 1, 1657146575, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6333393733353761626333363631336166646333383331383639626430333132', 1, 1657146575, 0, '', 0)Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.03 ms Update 0.11 ms Waiting for query cache lock 0.01 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.07 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 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.43 ms После последнего запроса: 7.01 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.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 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.52 ms После последнего запроса: 0.12 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.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 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.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 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.71 ms После последнего запроса: 42.79 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.09 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.35 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.02 ms Preparing 0.02 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms Checking permissions 0.41 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.18 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.22 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/config.php:15 14 jshopConfig->__construct() JROOT/components/com_jshopping/lib/factory.php:24 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.74 ms После последнего запроса: 1.45 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.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.07 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 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.03 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.80 ms После последнего запроса: 0.99 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.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.23 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.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.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 20 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 18 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/currency.php:22 17 jshopCurrency->__construct() JROOT/libraries/src/Table/Table.php:328 16 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:624 15 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:48 14 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:29 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.15 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.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/currency.php:30 16 jshopCurrency->getAllCurrencies() JROOT/components/com_jshopping/lib/factory.php:625 15 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:48 14 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:29 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.60 ms После последнего запроса: 1.71 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.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.03 ms После последнего запроса: 6.64 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.08 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.02 ms Statistics 0.17 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.38 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.57 ms После последнего запроса: 1.65 ms Память запроса: 0.006 MB Память до запроса: 9.314 MB
UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"e777676b24789b283f9a69a1858ca913\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `u2bez_extensions` SET `params` = '{\"mediaversion\":\"e777676b24789b283f9a69a1858ca913\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.06 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 for update 0.10 ms Updating 0.08 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.09 ms Closing tables 0.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.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.39 ms После последнего запроса: 6.77 ms Память запроса: 0.006 MB Память до запроса: 9.651 MB Выбрано строк: 3
select *
from u2bez_jshopping_languagesid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_languages ALL NULL Индекс не используется NULL NULL 2 Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.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.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.49 ms После последнего запроса: 11.14 ms Память запроса: 0.007 MB Память до запроса: 10.530 MB Выбрано строк: 73
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products`Status Duration Starting 0.07 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.36 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.03 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.28 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.16 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.07 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/product.php:14 10 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:40 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.56 ms После последнего запроса: 0.31 ms Память запроса: 0.006 MB Память до запроса: 10.656 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_products
WHERE `product_id` = '119'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.09 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 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 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.38 ms После последнего запроса: 0.11 ms Память запроса: 0.006 MB Память до запроса: 10.654 MB Выбрано строк: 1
SELECT *
FROM `u2bez_jshopping_products_to_categories`
WHERE product_id='119'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.05 ms Preparing 0.02 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 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.71 ms После последнего запроса: 0.35 ms Память запроса: 0.009 MB Память до запроса: 10.673 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.23 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.07 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.09 ms Память запроса: 0.007 MB Память до запроса: 10.700 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.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 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.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/attribut.php:32 12 jshopAttribut->getAllAttributes() JROOT/components/com_jshopping/lib/factory.php:365 11 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:95 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.82 ms После последнего запроса: 0.13 ms Память запроса: 0.006 MB Память до запроса: 10.762 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_attr`
WHERE product_id = '119'
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.03 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.52 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.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.69 ms После последнего запроса: 0.07 ms Память запроса: 0.006 MB Память до запроса: 10.768 MB Выбрано строк: 3
SELECT *
FROM `u2bez_jshopping_products_attr2`
WHERE product_id = '119'
ORDER BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 index NULL PRIMARY 4 NULL 930 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.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.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.40 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.92 ms После последнего запроса: 0.10 ms Память запроса: 0.006 MB Память до запроса: 10.776 MB Выбрано строк: 3
select PA.attr_value_id as val_id, V.`name_ru-RU` as value_name, V.image, price_mod, addprice
from u2bez_jshopping_products_attr2 as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_value_id=V.value_id
where PA.product_id = '119'
and PA.attr_id='27'
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ALL NULL Индекс не используется NULL NULL 930 Using where; Using temporary; Используется filesort 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 expressv_main.PA.attr_value_id 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.05 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.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.44 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.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.68 ms После последнего запроса: 0.15 ms Память запроса: 0.006 MB Память до запроса: 10.785 MB Выбрано строк: 1
select addprice, price_mod
from u2bez_jshopping_products_attr2
where product_id='119'
and attr_id='27'
and attr_value_id='433'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_attr2 ALL NULL Индекс не используется NULL NULL 930 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.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.36 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.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/components/com_jshopping/tables/product.php:51 9 jshopProduct->setAttributeActive() JROOT/components/com_jshopping/controllers/product.php:49 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.74 ms После последнего запроса: 1.48 ms Память запроса: 0.007 MB Память до запроса: 10.874 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.21 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.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.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 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.36 ms После последнего запроса: 0.08 ms Память запроса: 0.006 MB Память до запроса: 10.891 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.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.02 ms Sending data 0.01 ms Creating sort index 0.99 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.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/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.70 ms После последнего запроса: 0.78 ms Память запроса: 0.009 MB Память до запроса: 11.225 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.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.08 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.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 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.85 ms После последнего запроса: 0.13 ms Память запроса: 0.007 MB Память до запроса: 11.253 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.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.26 ms Creating sort index 0.07 ms Removing tmp table 0.13 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 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.11 ms После последнего запроса: 0.26 ms Память запроса: 0.006 MB Память до запроса: 11.295 MB Выбрано строк: 0
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 = '119'
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.10 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.01 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.34 ms Creating sort index 0.04 ms Removing tmp table 0.06 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:739 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.89 ms После последнего запроса: 1.29 ms Память запроса: 0.009 MB Память до запроса: 11.375 MB Выбрано строк: 49
SHOW FULL COLUMNS
FROM `u2bez_jshopping_users`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_users`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.05 ms After opening tables 0.01 ms Checking permissions 0.15 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.12 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.60 ms После последнего запроса: 0.40 ms Память запроса: 0.009 MB Память до запроса: 11.459 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.01 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.08 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.28 ms После последнего запроса: 0.08 ms Память запроса: 0.007 MB Память до запроса: 11.473 MB Выбрано строк: 1
SELECT tax_id, tax_name, tax_value
FROM `u2bez_jshopping_taxes`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_taxes ALL NULL Индекс не используется NULL NULL 1 Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.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.35 ms После последнего запроса: 0.11 ms Память запроса: 0.007 MB Память до запроса: 11.479 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 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 Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:477 12 JSFactory::getAllManufacturer() JROOT/components/com_jshopping/lib/functions.php:619 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.90 ms После последнего запроса: 0.91 ms Память запроса: 0.007 MB Память до запроса: 11.538 MB Выбрано строк: 32
SHOW FULL COLUMNS
FROM `u2bez_jshopping_categories`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_categories`Status Duration Starting 0.04 ms Checking permissions 0.02 ms Closing tables 0.01 ms Opening tables 0.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.03 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.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.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/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.75 ms После последнего запроса: 0.19 ms Память запроса: 0.007 MB Память до запроса: 11.600 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_categories
WHERE `category_id` = '7'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.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.15 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.19 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.27 ms Reset for next command 0.03 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 - Время запроса: 1.08 ms После последнего запроса: 0.21 ms Память запроса: 0.007 MB Память до запроса: 11.621 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.02 ms Statistics 0.07 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.61 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 1.26 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/shop_item_menu.php:125 12 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:41 11 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:35 10 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:388 9 getShopMainPageItemid() JROOT/components/com_jshopping/controllers/product.php:73 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 После последнего запроса: 1.20 ms Память запроса: 0.005 MB Память до запроса: 11.742 MB
UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '119'EXPLAIN не доступен для запроса: UPDATE u2bez_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '119'Status Duration Starting 0.05 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 for update 0.05 ms Updating 0.11 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.24 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 1.30 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.85 ms После последнего запроса: 1.25 ms Память запроса: 0.007 MB Память до запроса: 11.824 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_reviews`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_reviews`Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.30 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.02 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.07 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Removing tmp table 0.10 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.38 ms Reset for next command 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/review.php:14 10 jshopReview->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:96 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.67 ms После последнего запроса: 0.47 ms Память запроса: 0.008 MB Память до запроса: 11.861 MB Выбрано строк: 6
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_field_values`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_extra_field_values`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.21 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.05 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.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.15 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 15 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 14 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 13 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfieldvalue.php:16 12 jshopProductFieldValue->__construct() JROOT/libraries/src/Table/Table.php:328 11 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:560 10 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/tables/product.php:674 9 jshopProduct->getExtraFields() JROOT/components/com_jshopping/controllers/product.php:136 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.09 ms Память запроса: 0.006 MB Память до запроса: 11.879 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.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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.47 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.02 ms Freeing items 0.01 ms Updating status 2.59 ms Reset for next command 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfieldvalue.php:27 11 jshopProductFieldValue->getAllList() JROOT/components/com_jshopping/lib/factory.php:561 10 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/tables/product.php:674 9 jshopProduct->getExtraFields() JROOT/components/com_jshopping/controllers/product.php:136 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.40 ms После последнего запроса: 7.35 ms Память запроса: 0.009 MB Память до запроса: 12.394 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.14 ms Checking permissions 0.01 ms Opening tables 0.09 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.12 ms Preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.31 ms Creating sort index 0.04 ms Removing tmp table 0.06 ms Creating sort index 0.14 ms End of update loop 0.03 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.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 15 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 13 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 12 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/lib/functions.php:874 9 changeDataUsePluginContent() JROOT/components/com_jshopping/controllers/product.php:200 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.77 ms После последнего запроса: 0.19 ms Память запроса: 0.006 MB Память до запроса: 12.402 MB Выбрано строк: 3
SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `u2bez_jshopping_products_images` as I
left join `u2bez_jshopping_products` as P
on P.product_id=I.product_id
WHERE I.product_id = '119'
ORDER BY sort, I.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE I ALL NULL Индекс не используется NULL NULL 246 Using where; Using temporary; Используется filesort 1 SIMPLE P eq_ref PRIMARY PRIMARY 4 expressv_main.I.product_id 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.03 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.20 ms Creating sort index 0.04 ms Removing tmp table 0.01 ms Creating sort index 0.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.86 ms После последнего запроса: 1.26 ms Память запроса: 0.006 MB Память до запроса: 12.433 MB Выбрано строк: 1
SELECT count(review_id)
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '119'
and publish='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_reviews ALL NULL Индекс не используется NULL NULL 770 Using where Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.52 ms End of update loop 0.03 ms Query end 0.03 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.11 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.20 ms После последнего запроса: 0.06 ms Память запроса: 0.006 MB Память до запроса: 12.438 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '119'
and publish='1'
order by review_id desc
LIMIT 0, 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_products_reviews index NULL PRIMARY 4 NULL 20 Using where Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.87 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.03 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 - Время запроса: 0.38 ms После последнего запроса: 1.98 ms Память запроса: 0.010 MB Память до запроса: 12.631 MB Выбрано строк: 12
select category_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_categories
where `alias_ru-RU`!=''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_categories ALL NULL Индекс не используется NULL NULL 12 Using where Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.88 ms Reset for next command 0.02 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:316 19 JSFactory::getAliasCategory() JROOT/components/com_jshopping/router.php:52 18 jshoppingBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 17 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 16 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 15 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/libraries/src/Pagination/Pagination.php:787 10 Joomla\CMS\Pagination\Pagination->_buildDataObject() JROOT/libraries/src/Pagination/Pagination.php:328 9 Joomla\CMS\Pagination\Pagination->getPagesLinks() JROOT/components/com_jshopping/controllers/product.php:245 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
43 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
1 × SELECT `data`
FROM `u2bez_session`1 × select addprice, price_mod
from u2bez_jshopping_products_attr21 × 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 id, `name_ru-RU` as name, field_id
FROM `u2bez_jshopping_products_extra_field_values`1 × select id,link
from u2bez_menu1 × SELECT *
FROM u2bez_jshopping_categories1 × 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 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 PA.attr_value_id as val_id, V.`name_ru-RU` as value_name, V.image, price_mod, addprice
from u2bez_jshopping_products_attr2 as PA
INNER JOIN u2bez_jshopping_attr_values as V
ON PA.attr_value_id=V.value_id1 × SELECT `session_id`
FROM `u2bez_session`1 × 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 category_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_categories
Прочие SQL-запросы:
1 × INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6333393733353761626333363631336166646333383331383639626430333132', 1, 1657146575, 0, '', 01 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_config1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_currencies1 × UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"e777676b24789b283f9a69a1858ca913\"}'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_categories1 × UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_reviews1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_field_values