-
Главная
-
Откатные ворота
- Откатные ворота Doorhan
Экспресс Ворота
Монтаж в любом городе!
Товары
Товары связанные с Откатные ворота Doorhan
Отзыв
Оставить отзыв
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1657149554,
"last": 1657149554,
"now": 1657149554
},
"client": {
"forwarded": "3.238.24.209"
},
"token": "Nkeve7T6WMf3vuwyCwtPQaNiQmedCYfm"
},
"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": "/otkatnye-vorota/doorhan",
"product_back_value": []
}
}
Время
Память
Время: 20.25 ms / 20.25 ms Память: 2.085 MB / 2.46 MB Application: afterLoad
Время: 73.98 ms / 94.23 ms Память: 4.239 MB / 6.70 MB Application: afterInitialise
Время: 43.61 ms / 137.83 ms Память: 2.516 MB / 9.22 MB Application: Before Access::preloadComponents (all components)
Время: 2.10 ms / 139.94 ms Память: 0.061 MB / 9.28 MB Application: After Access::preloadComponents (all components)
Время: 0.04 ms / 139.98 ms Память: -0.003 MB / 9.27 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.68 ms / 140.65 ms Память: 0.026 MB / 9.30 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 4.60 ms / 145.25 ms Память: 0.252 MB / 9.55 MB Application: afterRoute
Время: 1.19 ms / 146.44 ms Память: 0.018 MB / 9.57 MB Application: beforeRenderComponent com_jshopping
Время: 409.72 ms / 556.16 ms Память: 3.401 MB / 12.97 MB Application: afterRenderComponent com_jshopping
Время: 0.69 ms / 556.86 ms Память: 0.005 MB / 12.98 MB Application: afterDispatch
Время: 8.93 ms / 565.79 ms Память: 0.277 MB / 13.25 MB Application: beforeRenderModule mod_mel_cart (Mel Cart)
Время: 1.91 ms / 567.70 ms Память: 0.045 MB / 13.30 MB Application: afterRenderModule mod_mel_cart (Mel Cart)
Время: 0.16 ms / 567.87 ms Память: 0.000 MB / 13.30 MB Application: beforeRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 2.14 ms / 570.01 ms Память: 0.057 MB / 13.36 MB Application: afterRenderModule mod_krizalys_breadcrumbs (Krizalys Breadcrumbs)
Время: 206.02 ms / 776.03 ms Память: 0.282 MB / 13.64 MB Application: afterRender
Всего SQL-запросов: 369.59 ms
14.31 MB (15,005,704 Байт)
39 SQL-запросов зафиксировано 369.59 ms
- Время запроса: 0.68 ms Память запроса: 0.007 MB Память до запроса: 4.190 MB Выбрано строк: 0
SELECT `data`
FROM `u2bez_session`
WHERE `session_id` = X'3237373263373065323836623937623866363137656165626534346665633632'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.01 ms Executing 0.03 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.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 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.56 ms После последнего запроса: 2.43 ms Память запроса: 0.004 MB Память до запроса: 4.286 MB Выбрано строк: 0
SELECT `session_id`
FROM `u2bez_session`
WHERE `session_id` = X'3237373263373065323836623937623866363137656165626534346665633632'
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.06 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.04 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.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 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.69 ms После последнего запроса: 0.20 ms Память запроса: 0.004 MB Память до запроса: 4.291 MB
INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3237373263373065323836623937623866363137656165626534346665633632', 1, 1657149554, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3237373263373065323836623937623866363137656165626534346665633632', 1, 1657149554, 0, '', 0)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 for update 0.02 ms Update 0.20 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.12 ms Closing tables 0.01 ms Unlocking tables 0.02 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.92 ms После последнего запроса: 7.63 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.04 ms Checking permissions 0.01 ms Opening tables 0.16 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.19 ms Preparing 0.03 ms Executing 0.04 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 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 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.78 ms После последнего запроса: 0.20 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.09 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.16 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.67 ms После последнего запроса: 53.93 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.10 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.51 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.03 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.06 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms Checking permissions 0.69 ms Closing tables 0.02 ms Executing 0.02 ms Sending data 0.35 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.25 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/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 - Время запроса: 1.11 ms После последнего запроса: 2.49 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.07 ms Checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.04 ms Init 0.10 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.21 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.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 - Время запроса: 1.27 ms После последнего запроса: 1.49 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.05 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.42 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.09 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.15 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.05 ms Freeing items 0.01 ms Updating status 0.03 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.64 ms После последнего запроса: 0.18 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.07 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.09 ms End of update loop 0.03 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/currency.php:30 16 jshopCurrency->getAllCurrencies() JROOT/components/com_jshopping/lib/factory.php:625 15 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:48 14 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:29 13 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:220 12 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:243 11 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/router.php:192 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.04 ms После последнего запроса: 2.83 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.06 ms Checking permissions 0.01 ms Opening tables 0.17 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 Executing 0.01 ms Sending data 0.49 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.78 ms После последнего запроса: 7.78 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.14 ms Checking permissions 0.01 ms Opening tables 0.21 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.02 ms Statistics 0.19 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.61 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.04 ms Closing tables 0.03 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 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.87 ms После последнего запроса: 1.97 ms Память запроса: 0.006 MB Память до запроса: 9.314 MB
UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"21637a9d1b8e9a5be408350ea57d2281\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `u2bez_extensions` SET `params` = '{\"mediaversion\":\"21637a9d1b8e9a5be408350ea57d2281\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 ms Checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.13 ms Updating 0.13 ms End of update loop 0.05 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.10 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.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 После последнего запроса: 8.26 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.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/functions.php:236 8 installNewLanguages() JROOT/components/com_jshopping/loadparams.php:40 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:15 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.17 ms После последнего запроса: 11.13 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.04 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.28 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.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.23 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.12 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/product.php:14 10 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/controllers/product.php:40 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 324.50 ms После последнего запроса: 0.48 ms Память запроса: 0.006 MB Память до запроса: 10.656 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_products
WHERE `product_id` = '112'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.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 323.63 ms Preparing 0.03 ms Unlocking tables 0.01 ms Preparing 0.04 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.04 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.65 ms После последнего запроса: 0.25 ms Память запроса: 0.006 MB Память до запроса: 10.669 MB Выбрано строк: 1
SELECT *
FROM `u2bez_jshopping_products_to_categories`
WHERE product_id='112'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.08 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.11 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 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 - Время запроса: 1.61 ms После последнего запроса: 0.66 ms Память запроса: 0.009 MB Память до запроса: 10.689 MB Выбрано строк: 12
SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_attr`Status Duration Starting 0.06 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.50 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms Checking permissions 0.14 ms Closing tables 0.02 ms Executing 0.03 ms Sending data 0.13 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.21 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 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 - Время запроса: 1.05 ms После последнего запроса: 0.20 ms Память запроса: 0.007 MB Память до запроса: 10.715 MB Выбрано строк: 43
SELECT attr_id, `name_ru-RU` as name, `description_ru-RU` as description, attr_type, independent, allcats, cats, attr_ordering
FROM `u2bez_jshopping_attr`
ORDER BY attr_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_attr ALL NULL Индекс не используется NULL NULL 43 Используется filesort Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.50 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/attribut.php:32 12 jshopAttribut->getAllAttributes() JROOT/components/com_jshopping/lib/factory.php:365 11 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:95 10 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:165 9 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.59 ms После последнего запроса: 0.25 ms Память запроса: 0.006 MB Память до запроса: 10.778 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_attr`
WHERE product_id = '112'
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.05 ms Checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.03 ms Init 0.06 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.96 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.03 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.29 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/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 - Время запроса: 1.29 ms После последнего запроса: 0.13 ms Память запроса: 0.006 MB Память до запроса: 10.784 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_attr2`
WHERE product_id = '112'
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.07 ms Checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.72 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 1.02 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/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 - Время запроса: 1.54 ms После последнего запроса: 0.90 ms Память запроса: 0.009 MB Память до запроса: 10.798 MB Выбрано строк: 13
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_fields`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_extra_fields`Status Duration Starting 0.04 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.43 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.03 ms Filling schema table 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms Checking permissions 0.13 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.03 ms Commit 0.02 ms Closing tables 0.03 ms Removing tmp table 0.23 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.03 ms Freeing items 0.02 ms Updating status 0.33 ms Reset for next command 0.06 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfield.php:16 15 jshopProductField->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:551 13 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1038 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:198 11 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:725 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.59 ms После последнего запроса: 0.22 ms Память запроса: 0.007 MB Память до запроса: 10.826 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.08 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.04 ms Executing 0.01 ms Sending data 0.55 ms Creating sort index 0.17 ms Removing tmp table 0.16 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.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.42 ms Reset for next command 0.04 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfield.php:50 14 jshopProductField->getList() JROOT/components/com_jshopping/lib/factory.php:552 13 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1038 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:198 11 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:725 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.19 ms После последнего запроса: 0.31 ms Память запроса: 0.006 MB Память до запроса: 10.869 MB Выбрано строк: 3
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_21`
FROM `u2bez_jshopping_products_relations` AS relation
INNER JOIN `u2bez_jshopping_products` AS prod
ON relation.product_related_id = prod.product_id
LEFT JOIN `u2bez_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `u2bez_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE relation.product_id = '112'
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.15 ms Checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.03 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.84 ms Creating sort index 0.11 ms Removing tmp table 0.24 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.03 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.30 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:739 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.49 ms После последнего запроса: 0.19 ms Память запроса: 0.009 MB Память до запроса: 10.885 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.07 ms Checking permissions 0.01 ms Opening tables 0.11 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.80 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.85 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/shop_item_menu.php:125 16 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:41 15 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:35 14 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:388 13 getShopMainPageItemid() JROOT/components/com_jshopping/lib/functions.php:407 12 getDefaultItemid() JROOT/components/com_jshopping/lib/functions.php:465 11 SEFLink() JROOT/components/com_jshopping/tables/product.php:741 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.53 ms После последнего запроса: 1.14 ms Память запроса: 0.010 MB Память до запроса: 10.927 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.06 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 1.15 ms Reset for next command 0.02 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:316 20 JSFactory::getAliasCategory() JROOT/components/com_jshopping/router.php:52 19 jshoppingBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 18 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/components/com_jshopping/lib/functions.php:477 11 SEFLink() JROOT/components/com_jshopping/tables/product.php:741 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.64 ms После последнего запроса: 2.64 ms Память запроса: 0.009 MB Память до запроса: 11.014 MB Выбрано строк: 49
SHOW FULL COLUMNS
FROM `u2bez_jshopping_users`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_users`Status Duration Starting 0.05 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.41 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.13 ms After opening tables 0.02 ms Checking permissions 0.28 ms Closing tables 0.02 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.23 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.74 ms Reset for next command 0.02 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 - Время запроса: 1.25 ms После последнего запроса: 0.62 ms Память запроса: 0.009 MB Память до запроса: 11.098 MB Выбрано строк: 3
SHOW FULL COLUMNS
FROM `u2bez_jshopping_taxes`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_taxes`Status Duration Starting 0.04 ms Checking permissions 0.05 ms Closing tables 0.01 ms Opening tables 0.34 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.06 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms Checking permissions 0.08 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.02 ms Closing tables 0.01 ms Removing tmp table 0.18 ms Closing tables 0.05 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.22 ms Reset for next command 0.02 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.44 ms После последнего запроса: 0.13 ms Память запроса: 0.007 MB Память до запроса: 11.111 MB Выбрано строк: 1
SELECT tax_id, tax_name, tax_value
FROM `u2bez_jshopping_taxes`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_taxes ALL NULL Индекс не используется NULL NULL 1 Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.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.04 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.21 ms Reset for next command 0.02 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.68 ms После последнего запроса: 0.12 ms Память запроса: 0.007 MB Память до запроса: 11.118 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.10 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.64 ms Reset for next command 0.02 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 - Время запроса: 1.29 ms После последнего запроса: 0.47 ms Память запроса: 0.009 MB Память до запроса: 11.147 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.34 ms After opening tables 0.03 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 Filling schema table 0.01 ms Opening tables 0.04 ms After opening tables 0.02 ms Checking permissions 0.09 ms Closing tables 0.02 ms Executing 0.06 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.17 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.24 ms Reset for next command 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfieldvalue.php:16 15 jshopProductFieldValue->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:560 13 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/lib/functions.php:751 12 getProductExtraFieldForProduct() JROOT/components/com_jshopping/lib/functions.php:678 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.87 ms После последнего запроса: 0.15 ms Память запроса: 0.007 MB Память до запроса: 11.166 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.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.42 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.96 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfieldvalue.php:27 14 jshopProductFieldValue->getAllList() JROOT/components/com_jshopping/lib/factory.php:561 13 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/lib/functions.php:751 12 getProductExtraFieldForProduct() JROOT/components/com_jshopping/lib/functions.php:678 11 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:743 10 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:471 9 jshopProduct->getExtendsData() JROOT/components/com_jshopping/controllers/product.php:61 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.42 ms После последнего запроса: 2.68 ms Память запроса: 0.007 MB Память до запроса: 11.230 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.01 ms Closing tables 0.01 ms Opening tables 0.33 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.21 ms Closing tables 0.03 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.06 ms Query end 0.02 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.15 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.39 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/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.95 ms После последнего запроса: 0.27 ms Память запроса: 0.007 MB Память до запроса: 11.291 MB Выбрано строк: 1
SELECT *
FROM u2bez_jshopping_categories
WHERE `category_id` = '8'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u2bez_jshopping_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.17 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.33 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.03 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 1.70 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:64 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:27 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.79 ms После последнего запроса: 1.59 ms Память запроса: 0.005 MB Память до запроса: 11.418 MB
UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '112'EXPLAIN не доступен для запроса: UPDATE u2bez_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '112'Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.07 ms Updating 0.19 ms End of update loop 0.02 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.03 ms Commit 0.15 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 2.13 ms Reset for next command 0.02 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 - Время запроса: 1.13 ms После последнего запроса: 2.06 ms Память запроса: 0.007 MB Память до запроса: 11.500 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_reviews`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `u2bez_jshopping_products_reviews`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.31 ms After opening tables 0.01 ms System lock 0.03 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 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.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 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.98 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 - Время запроса: 1.96 ms После последнего запроса: 10.99 ms Память запроса: 0.009 MB Память до запроса: 12.102 MB Выбрано строк: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM u2bez_fields AS a
LEFT JOIN `u2bez_languages` AS l
ON l.lang_code = a.language
LEFT JOIN u2bez_users AS uc
ON uc.id=a.checked_out
LEFT JOIN u2bez_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN u2bez_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN u2bez_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.article'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 expressv_main.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 expressv_main.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 expressv_main.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 expressv_main.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 expressv_main.a.group_id 1 Using where Status Duration Starting 0.17 ms Checking permissions 0.01 ms Opening tables 0.17 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.09 ms Statistics 0.22 ms Preparing 0.10 ms Creating tmp table 0.12 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.44 ms Creating sort index 0.05 ms Removing tmp table 0.09 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.07 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.87 ms После последнего запроса: 0.30 ms Память запроса: 0.006 MB Память до запроса: 12.110 MB Выбрано строк: 2
SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `u2bez_jshopping_products_images` as I
left join `u2bez_jshopping_products` as P
on P.product_id=I.product_id
WHERE I.product_id = '112'
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.08 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.28 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.03 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 - Время запроса: 1.36 ms После последнего запроса: 1.33 ms Память запроса: 0.006 MB Память до запроса: 12.122 MB Выбрано строк: 1
SELECT count(review_id)
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '112'
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.06 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.87 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.02 ms Freeing items 0.01 ms Updating status 0.25 ms Reset for next command 0.02 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 - Время запроса: 2.31 ms После последнего запроса: 0.14 ms Память запроса: 0.006 MB Память до запроса: 12.128 MB Выбрано строк: 0
SELECT *
FROM `u2bez_jshopping_products_reviews`
WHERE product_id = '112'
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.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.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 1.82 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 4.24 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php: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
39 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
1 × SELECT `data`
FROM `u2bez_session`1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_ru-RU` as groupname, multilist
FROM `u2bez_jshopping_products_extra_fields` as F
left join `u2bez_jshopping_products_extra_field_groups` as G
on G.id=F.
group1 × SELECT count(review_id)
FROM `u2bez_jshopping_products_reviews`1 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `u2bez_jshopping_products_images` as I
left join `u2bez_jshopping_products` as P
on P.product_id=I.product_id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM u2bez_fields AS a
LEFT JOIN `u2bez_languages` AS l
ON l.lang_code = a.language
LEFT JOIN u2bez_users AS uc
ON uc.id=a.checked_out
LEFT JOIN u2bez_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN u2bez_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN u2bez_fields_groups AS g
ON g.id = a.group_id1 × SELECT *
FROM u2bez_jshopping_categories1 × SELECT id, `name_ru-RU` as name, field_id
FROM `u2bez_jshopping_products_extra_field_values`1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from u2bez_jshopping_manufacturers1 × SELECT tax_id, tax_name, tax_value
FROM `u2bez_jshopping_taxes1 × select category_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_categories1 × select id,link
from u2bez_menu1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_21`
FROM `u2bez_jshopping_products_relations` AS relation
INNER JOIN `u2bez_jshopping_products` AS prod
ON relation.product_related_id = prod.product_id
LEFT JOIN `u2bez_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `u2bez_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id1 × SELECT *
FROM `u2bez_jshopping_products_attr2`1 × SELECT `session_id`
FROM `u2bez_session`1 × SELECT *
FROM `u2bez_jshopping_products_attr`1 × SELECT attr_id, `name_ru-RU` as name, `description_ru-RU` as description, attr_type, independent, allcats, cats, attr_ordering
FROM `u2bez_jshopping_attr`1 × SELECT *
FROM `u2bez_jshopping_products_to_categories`1 × SELECT *
FROM u2bez_jshopping_products1 × select *
from u2bez_jshopping_language1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `u2bez_assets`1 × select product_id as id, `alias_ru-RU` as alias
from u2bez_jshopping_products1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `u2bez_jshopping_currencies`1 × SELECT *
FROM u2bez_jshopping_config1 × SELECT b.id
FROM u2bez_usergroups AS a
LEFT JOIN u2bez_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `u2bez_viewlevels1 × SELECT *
FROM `u2bez_jshopping_products_reviews`
Прочие SQL-запросы:
1 × INSERT INTO `u2bez_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3237373263373065323836623937623866363137656165626534346665633632', 1, 1657149554, 0, '', 01 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_config1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_currencies1 × UPDATE `u2bez_extensions`
SET `params` = '{\"mediaversion\":\"21637a9d1b8e9a5be408350ea57d2281\"}'1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_attr1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_fields1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_users1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_taxes1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_extra_field_values1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_categories1 × UPDATE u2bez_jshopping_products
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `u2bez_jshopping_products_reviews