Раттлины/вибы
Воблер JACKALL Re/70
1 размер12 цветов
цена от
1 330 руб.
Воблер JACKALL Tn Slim
1 размер11 цветов
цена от
1 730 руб.
Воблер JACKALL TN/60 Trigon
1 размер12 цветов
цена от
1 690 руб.
Воблер JACKALL TN/70 Trigon
1 размер12 цветов
цена от
2 030 руб.
Воблер JACKALL TN80
1 размер13 цветов
цена от
1 810 руб.
Воблер JACKALL TIMON Dartrun
1 размер8 цветов
цена от
1 040 руб.
Консоль отладки Joomla
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1781041471,
"last": 1781041471,
"now": 1781041471
},
"token": "qorccRZXQwlZHluyq7ZBUOYRp2J0tbaD"
},
"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"
],
"jshop_end_page_buy_product": "/katalog/voblery/rattliny-viby",
"jshop_end_page_list_product": "/katalog/voblery/rattliny-viby"
}
}
Время
Память
Время: 19.97 ms / 19.97 ms Память: 0.514 MB / 0.89 MB Application: afterLoad
Время: 56.78 ms / 76.74 ms Память: 1.370 MB / 2.26 MB Application: afterInitialise
Время: 12.79 ms / 89.53 ms Память: 0.449 MB / 2.71 MB Application: Before Access::preloadComponents (all components)
Время: 2.57 ms / 92.10 ms Память: 0.061 MB / 2.77 MB Application: After Access::preloadComponents (all components)
Время: 0.05 ms / 92.16 ms Память: -0.003 MB / 2.77 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Время: 0.48 ms / 92.63 ms Память: 0.010 MB / 2.78 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Время: 0.08 ms / 92.71 ms Память: -0.001 MB / 2.78 MB Application: afterRoute
Время: 5.81 ms / 98.52 ms Память: 0.051 MB / 2.83 MB Application: beforeRenderComponent com_jshopping
Время: 117.16 ms / 215.68 ms Память: 2.200 MB / 5.03 MB Application: afterRenderComponent com_jshopping
Время: 0.59 ms / 216.27 ms Память: 0.007 MB / 5.04 MB Application: afterDispatch
Время: 31.18 ms / 247.44 ms Память: 0.567 MB / 5.60 MB Application: beforeRenderModule mod_adv_jshopping_cartajax (Корзина)
Время: 3.47 ms / 250.91 ms Память: 0.036 MB / 5.64 MB Application: afterRenderModule mod_adv_jshopping_cartajax (Корзина)
Время: 0.09 ms / 251.00 ms Память: -0.003 MB / 5.64 MB Application: beforeRenderModule mod_custom (copyright)
Время: 5.18 ms / 256.18 ms Память: 0.006 MB / 5.64 MB Application: afterRenderModule mod_custom (copyright)
Время: 0.10 ms / 256.28 ms Память: -0.002 MB / 5.64 MB Application: beforeRenderModule mod_custom (paymets)
Время: 0.10 ms / 256.38 ms Память: 0.003 MB / 5.64 MB Application: afterRenderModule mod_custom (paymets)
Время: 0.03 ms / 256.41 ms Память: -0.001 MB / 5.64 MB Application: beforeRenderModule mod_jshopping_cityshops (Наш магазин)
Время: 4.12 ms / 260.53 ms Память: 0.135 MB / 5.78 MB Application: afterRenderModule mod_jshopping_cityshops (Наш магазин)
Время: 0.06 ms / 260.59 ms Память: -0.006 MB / 5.77 MB Application: beforeRenderModule mod_jshopping_cityshops (Наши контакты)
Время: 0.95 ms / 261.54 ms Память: 0.020 MB / 5.79 MB Application: afterRenderModule mod_jshopping_cityshops (Наши контакты)
Время: 0.05 ms / 261.60 ms Память: -0.004 MB / 5.79 MB Application: beforeRenderModule mod_menu (Информация)
Время: 2.92 ms / 264.51 ms Память: 0.063 MB / 5.85 MB Application: afterRenderModule mod_menu (Информация)
Время: 0.04 ms / 264.56 ms Память: -0.005 MB / 5.85 MB Application: beforeRenderModule mod_custom (footer-social)
Время: 0.07 ms / 264.62 ms Память: 0.003 MB / 5.85 MB Application: afterRenderModule mod_custom (footer-social)
Время: 0.02 ms / 264.65 ms Память: -0.000 MB / 5.85 MB Application: beforeRenderModule mod_custom (footer-logo)
Время: 0.05 ms / 264.69 ms Память: 0.003 MB / 5.85 MB Application: afterRenderModule mod_custom (footer-logo)
Время: 0.04 ms / 264.73 ms Память: 0.001 MB / 5.85 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 1.34 ms / 266.07 ms Память: 0.019 MB / 5.87 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.05 ms / 266.11 ms Память: -0.006 MB / 5.86 MB Application: beforeRenderModule mod_jshopping_cityshops (Телефон-ссылка)
Время: 0.96 ms / 267.07 ms Память: 0.020 MB / 5.88 MB Application: afterRenderModule mod_jshopping_cityshops (Телефон-ссылка)
Время: 0.05 ms / 267.12 ms Память: -0.004 MB / 5.88 MB Application: beforeRenderModule mod_menu (Главное меню)
Время: 1.27 ms / 268.39 ms Память: 0.035 MB / 5.92 MB Application: afterRenderModule mod_menu (Главное меню)
Время: 0.04 ms / 268.43 ms Память: -0.003 MB / 5.91 MB Application: beforeRenderModule mod_jshopping_cityshops (Интернет магазин)
Время: 0.90 ms / 269.33 ms Память: 0.022 MB / 5.93 MB Application: afterRenderModule mod_jshopping_cityshops (Интернет магазин)
Время: 0.04 ms / 269.37 ms Память: -0.005 MB / 5.93 MB Application: beforeRenderModule mod_jshopping_search (Поиск по магазину)
Время: 1.16 ms / 270.53 ms Память: 0.010 MB / 5.94 MB Application: afterRenderModule mod_jshopping_search (Поиск по магазину)
Время: 0.04 ms / 270.57 ms Память: -0.000 MB / 5.94 MB Application: beforeRenderModule mod_menu (topmenu-left)
Время: 0.60 ms / 271.17 ms Память: 0.040 MB / 5.98 MB Application: afterRenderModule mod_menu (topmenu-left)
Время: 3.08 ms / 274.26 ms Память: 0.074 MB / 6.05 MB Application: afterRender
Всего запросов к базе данных: 81.96 ms
7.63 MB (7 998 880 Байт)
97 запросов зарегистрировано 81.96 ms
32 повторяющихся запросов зарегистрировано
- Время запроса: 1.05 ms Память запроса: 0.023 MB. Память перед запросом: 1.250 MB Возвращено строк: 0
SELECT `data`
FROM `joo_session`
WHERE `session_id` = X'687469366e6c6463336f317263643636326469686a636a356d39'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.56 ms Preparing 0.02 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Такой же, как вызов в строке ниже 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.29 ms После последнего запроса: 0.45 ms Память запроса: 0.020 MB. Память перед запросом: 1.266 MB Возвращено строк: 0
SELECT `session_id`
FROM `joo_session`
WHERE `session_id` = X'687469366e6c6463336f317263643636326469686a636a356d39'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 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:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.94 ms После последнего запроса: 0.32 ms Память запроса: 0.004 MB. Память перед запросом: 1.271 MB
INSERT INTO `joo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'687469366e6c6463336f317263643636326469686a636a356d39', 1, 1781041471, 0, '', 0)EXPLAIN недоступен для: INSERT INTO `joo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'687469366e6c6463336f317263643636326469686a636a356d39', 1, 1781041471, 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.02 ms Update 0.65 ms Waiting for query cache lock 0.05 ms Update 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 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:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 3.11 ms После последнего запроса: 1.23 ms Память запроса: 0.040 MB. Память перед запросом: 1.369 MB Возвращено строк: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joo_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_extensions ref extension extension 82 const 43 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.19 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.94 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Такой же, как вызов в строке ниже 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.51 ms После последнего запроса: 2.88 ms Память запроса: 0.021 MB. Память перед запросом: 1.417 MB Возвращено строк: 5
SELECT id, rules
FROM `joo_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_viewlevels ALL NULL INDEX KEY не используется NULL NULL 5 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.04 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.14 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 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.60 ms После последнего запроса: 0.16 ms Память запроса: 0.021 MB. Память перед запросом: 1.429 MB Возвращено строк: 2
SELECT b.id
FROM joo_usergroups AS a
LEFT JOIN joo_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 range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.25 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.26 ms После последнего запроса: 0.27 ms Память запроса: 0.035 MB. Память перед запросом: 1.451 MB Возвращено строк: 136
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joo_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_extensions ALL extension INDEX KEY не используется NULL NULL 332 Using where; Используется сортировка файлов Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.63 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Такой же, как вызов в строке ниже 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.78 ms После последнего запроса: 33.07 ms Память запроса: 0.068 MB. Память перед запросом: 2.293 MB Возвращено строк: 33
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joo_menu AS m
LEFT JOIN joo_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language INDEX KEY не используется NULL NULL 72 Using where; Используется сортировка файлов 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 jackall_dev_db.m.component_id 1 Using where Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.28 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.66 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Такой же, как вызов в строке ниже 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:445 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:561 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1169 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.50 ms После последнего запроса: 10.07 ms Память запроса: 0.027 MB. Память перед запросом: 2.715 MB Возвращено строк: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joo_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','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_getresponse','com_installer','com_jlsitemap','com_joomlaupdate','com_jshopping','com_jshopping2sms','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_quantummanager','com_redirect','com_search','com_sendsay','com_starryscashbox','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_assets range idx_asset_name idx_asset_name 202 NULL 44 Using index condition Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.62 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.08 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 15 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 14 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 13 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 12 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 11 Joomla\CMS\User\User->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:30 10 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/advancedmodules.php:99 9 PlgSystemAdvancedModules->handleOnAfterRoute() JROOT/libraries/regularlabs/src/SystemPlugin.php:191 8 RegularLabs\Library\SystemPlugin->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:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.98 ms После последнего запроса: 1.17 ms Память запроса: 0.022 MB. Память перед запросом: 2.797 MB Возвращено строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joo_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.26 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Такой же, как вызов в строке ниже 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.66 ms После последнего запроса: 0.23 ms Память запроса: 0.005 MB. Память перед запросом: 2.788 MB
UPDATE `joo_extensions`
SET `params` = '{\"mediaversion\":\"d1fc1c50b78fadc55d2e884bf771fd3d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN недоступен для: UPDATE `joo_extensions` SET `params` = '{\"mediaversion\":\"d1fc1c50b78fadc55d2e884bf771fd3d\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms checking permissions 0.00 ms After opening tables 0.00 ms init for update 0.00 ms init 0.01 ms Updating main table 0.01 ms init 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms init for update 0.04 ms Updating 0.28 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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.52 ms После последнего запроса: 1.35 ms Память запроса: 0.019 MB. Память перед запросом: 2.812 MB Возвращено строк: 2
SELECT *
FROM joo_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_languages ALL NULL INDEX KEY не используется NULL NULL 2 Using where; Используется сортировка файлов Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.14 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.77 ms После последнего запроса: 0.74 ms Память запроса: 0.019 MB. Память перед запросом: 2.823 MB Возвращено строк: 3
SELECT id, home, template, s.params
FROM joo_template_styles as s
LEFT JOIN joo_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 3 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 jackall_dev_db.s.template,const 1 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.29 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.14 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.83 ms После последнего запроса: 2.14 ms Память запроса: 0.023 MB. Память перед запросом: 2.862 MB Возвращено строк: 0
SELECT id, image, color
FROM `joo_jshopping_products_extra_field_values`
WHERE image !='' OR color!=''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_extra_field_values ALL NULL INDEX KEY не используется NULL NULL 636 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.49 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.06 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/plugins/jshopping/efext/efext.php:45 14 plgJshoppingEFExt->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 13 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 12 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/lib/factory.php:21 11 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 10 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 9 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 8 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/loadparams.php:15 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 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.85 ms После последнего запроса: 2.66 ms Память запроса: 0.048 MB. Память перед запросом: 2.977 MB Возвращено строк: 140
SHOW FULL COLUMNS
FROM `joo_jshopping_config`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_config`Status Duration Starting 0.05 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.44 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.20 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.07 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.15 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.07 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/config.php:14 16 jshopConfig->__construct() JROOT/components/com_jshopping/lib/factory.php:24 15 JSFactory::getConfig() JROOT/plugins/jshopping/jackall/jackall.php:26 14 plgJshoppingJackall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 13 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 12 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/lib/factory.php:21 11 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 10 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 9 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 8 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/loadparams.php:15 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 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.17 ms После последнего запроса: 4.94 ms Память запроса: 0.076 MB. Память перед запросом: 3.185 MB Возвращено строк: 1Повторяющиеся запросы: #19
SELECT *
FROM joo_jshopping_config
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_config const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.04 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.23 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.10 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 16 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/lib/factory.php:30 15 JSFactory::getConfig() JROOT/plugins/jshopping/jackall/jackall.php:26 14 plgJshoppingJackall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 13 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 12 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/lib/factory.php:21 11 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 10 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 9 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 8 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/loadparams.php:15 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 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.09 ms После последнего запроса: 0.78 ms Память запроса: 0.029 MB. Память перед запросом: 3.185 MB Возвращено строк: 8
SHOW FULL COLUMNS
FROM `joo_jshopping_currencies`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_currencies`Status Duration Starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.51 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.06 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.13 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 23 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 22 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 21 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/currency.php:14 20 jshopCurrency->__construct() JROOT/libraries/src/Table/Table.php:320 19 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 18 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:569 17 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 16 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 15 JSFactory::getConfig() JROOT/plugins/jshopping/jackall/jackall.php:26 14 plgJshoppingJackall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 13 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 12 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/lib/factory.php:21 11 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 10 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 9 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 8 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/loadparams.php:15 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.63 ms После последнего запроса: 0.10 ms Память запроса: 0.025 MB. Память перед запросом: 3.206 MB Возвращено строк: 1
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `joo_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_currencies ref currency_publish currency_publish 1 const 1 Using where; Используется сортировка файлов Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.19 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.14 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/currency.php:22 18 jshopCurrency->getAllCurrencies() JROOT/components/com_jshopping/lib/factory.php:570 17 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 16 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 15 JSFactory::getConfig() JROOT/plugins/jshopping/jackall/jackall.php:26 14 plgJshoppingJackall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 13 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 12 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/lib/factory.php:21 11 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 10 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 9 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 8 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/loadparams.php:15 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.16 ms После последнего запроса: 4.46 ms Память запроса: 0.074 MB. Память перед запросом: 3.452 MB Возвращено строк: 1Повторяющиеся запросы: #16
SELECT *
FROM joo_jshopping_config
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_config const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.10 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 12 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/lib/factory.php:30 11 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 10 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 9 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 8 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/loadparams.php:15 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 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.54 ms После последнего запроса: 2.99 ms Память запроса: 0.021 MB. Память перед запросом: 3.441 MB Возвращено строк: 2
select *
from joo_jshopping_languagesid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_languages ALL NULL INDEX KEY не используется NULL NULL 2 Status Duration Starting 0.09 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/functions.php:297 8 installNewLanguages() JROOT/components/com_jshopping/loadparams.php:33 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.23 ms После последнего запроса: 5.07 ms Память запроса: 0.031 MB. Память перед запросом: 3.601 MB Возвращено строк: 29
SHOW FULL COLUMNS
FROM `joo_jshopping_categories`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_categories`Status Duration Starting 0.09 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.46 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.12 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.13 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 12 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/category.php:15 11 jshopCategory->__construct() JROOT/libraries/src/Table/Table.php:320 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 9 JSFactory::getTable() JROOT/components/com_jshopping/controllers/category.php:59 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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 После последнего запроса: 0.76 ms Память запроса: 0.021 MB. Память перед запросом: 3.638 MB Возвращено строк: 0
SELECT category_id
FROM joo_jshopping_categories
WHERE category_parent_id IN (5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_categories ref category_parent_id category_parent_id 4 const 1 Using index Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.19 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/ff_category_subcat.php:66 10 jshopFF_Category_subcat->getCategoryChildrenAnyNode() JROOT/components/com_jshopping/tables/ff_category_subcat.php:39 9 jshopFF_Category_subcat->load() JROOT/components/com_jshopping/controllers/category.php:60 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 0.11 ms Память запроса: 0.023 MB. Память перед запросом: 3.647 MB Возвращено строк: 1
SELECT *
FROM joo_jshopping_categories
WHERE `category_id` = '5'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.14 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 10 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/ff_category_subcat.php:42 9 jshopFF_Category_subcat->load() JROOT/components/com_jshopping/controllers/category.php:60 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.61 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB. Память перед запросом: 3.652 MB Возвращено строк: 0
SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image, `alias_ru-RU` as alias
FROM `joo_jshopping_categories`
WHERE category_parent_id = '5'
AND category_publish = '1'
AND access IN (1,1,5)
ORDER BY ordering ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_categories ref category_parent_id,category_publish,access,category_publish_2 category_parent_id 4 const 1 Using where; Используется сортировка файлов Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.29 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/ff_category_subcat.php:250 10 jshopFF_Category_subcat->getSubCategories() JROOT/components/com_jshopping/tables/category.php:119 9 jshopCategory->getChildCategories() JROOT/components/com_jshopping/controllers/category.php:69 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.56 ms После последнего запроса: 0.61 ms Память запроса: 0.023 MB. Память перед запросом: 3.662 MB Возвращено строк: 14
select id,link
from joo_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 joo_menu ALL idx_client_id_parent_id_alias_language,idx_language INDEX KEY не используется NULL NULL 72 Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.04 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.15 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.09 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/shop_item_menu.php:141 13 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:47 12 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:40 11 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:403 10 getShopMainPageItemid() JROOT/components/com_jshopping/helpers/metadata.php:52 9 JshopHelpersMetadata::category() JROOT/components/com_jshopping/controllers/category.php:72 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.71 ms После последнего запроса: 2.12 ms Память запроса: 0.033 MB. Память перед запросом: 3.766 MB Возвращено строк: 31
SHOW FULL COLUMNS
FROM `joo_jshopping_vendors`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_vendors`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.44 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.07 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.10 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 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:253 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/vendor.php:15 15 jshopVendor->__construct() JROOT/libraries/src/Table/Table.php:320 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 13 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:435 12 JSFactory::getMainVendor() JROOT/components/com_jshopping/lib/functions.php:1449 11 getBuildFilterListProduct() JROOT/components/com_jshopping/tables/category.php:307 10 jshopCategory->getFilterListProduct() JROOT/components/com_jshopping/models/productlist.php:168 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.42 ms После последнего запроса: 1.21 ms Память запроса: 0.023 MB. Память перед запросом: 3.807 MB Возвращено строк: 1
SELECT id
FROM joo_jshopping_vendors
WHERE `main`=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_vendors ref main main 1 const 1 Using index Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.14 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_jshopping/tables/vendor.php:23 13 jshopVendor->loadMain() JROOT/components/com_jshopping/lib/factory.php:436 12 JSFactory::getMainVendor() JROOT/components/com_jshopping/lib/functions.php:1449 11 getBuildFilterListProduct() JROOT/components/com_jshopping/tables/category.php:307 10 jshopCategory->getFilterListProduct() JROOT/components/com_jshopping/models/productlist.php:168 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.61 ms После последнего запроса: 0.67 ms Память запроса: 0.024 MB. Память перед запросом: 3.817 MB Возвращено строк: 1
SELECT *
FROM joo_jshopping_vendors
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_vendors const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.15 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.11 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 14 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/vendor.php:24 13 jshopVendor->loadMain() JROOT/components/com_jshopping/lib/factory.php:436 12 JSFactory::getMainVendor() JROOT/components/com_jshopping/lib/functions.php:1449 11 getBuildFilterListProduct() JROOT/components/com_jshopping/tables/category.php:307 10 jshopCategory->getFilterListProduct() JROOT/components/com_jshopping/models/productlist.php:168 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.75 ms После последнего запроса: 1.07 ms Память запроса: 0.027 MB. Память перед запросом: 3.826 MB Возвращено строк: 11
SHOW FULL COLUMNS
FROM `joo_jshopping_products_extra_fields`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_products_extra_fields`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.31 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.05 ms closing tables 0.02 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.11 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfield.php:14 16 jshopProductField->__construct() JROOT/libraries/src/Table/Table.php:320 15 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 14 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:496 13 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1136 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/tables/ff_category_subcat.php:305 11 jshopFF_Category_subcat->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/ff_category_subcat.php:140 10 jshopFF_Category_subcat->getCountProducts() JROOT/components/com_jshopping/models/productlist.php:172 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.96 ms После последнего запроса: 0.32 ms Память запроса: 0.025 MB. Память перед запросом: 3.848 MB Возвращено строк: 10
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 `joo_jshopping_products_extra_fields` as F
left join `joo_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 INDEX KEY не используется NULL NULL 10 Using temporary; Используется сортировка файлов 1 SIMPLE G eq_ref PRIMARY PRIMARY 4 jackall_dev_db.F.group 1 Using where Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.53 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.14 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfield.php:48 14 jshopProductField->getList() JROOT/components/com_jshopping/lib/factory.php:497 13 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1136 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/tables/ff_category_subcat.php:305 11 jshopFF_Category_subcat->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/ff_category_subcat.php:140 10 jshopFF_Category_subcat->getCountProducts() JROOT/components/com_jshopping/models/productlist.php:172 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 0.41 ms Память запроса: 0.026 MB. Память перед запросом: 3.867 MB Возвращено строк: 3
SHOW FULL COLUMNS
FROM `joo_jshopping_taxes`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_taxes`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.30 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.04 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.11 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 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:253 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 18 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/tax.php:14 17 jshopTax->__construct() JROOT/libraries/src/Table/Table.php:320 16 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 15 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:369 14 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:991 13 getCorrectedPriceForQueryFilter() JROOT/components/com_jshopping/lib/jtableauto.php:101 12 JTableAvto->getBuildQueryListProductFilterPrice() JROOT/components/com_jshopping/tables/ff_category_subcat.php:397 11 jshopFF_Category_subcat->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/ff_category_subcat.php:140 10 jshopFF_Category_subcat->getCountProducts() JROOT/components/com_jshopping/models/productlist.php:172 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.36 ms Память запроса: 0.024 MB. Память перед запросом: 3.883 MB Возвращено строк: 1
SELECT tax_id, tax_name, tax_value
FROM `joo_jshopping_taxes`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_taxes ALL NULL INDEX KEY не используется NULL NULL 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.15 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.01 ms Freeing items 0.00 ms Updating status 0.22 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/tax.php:21 16 jshopTax->getAllTaxes() JROOT/components/com_jshopping/lib/factory.php:355 15 JSFactory::getAllTaxesOriginal() JROOT/components/com_jshopping/lib/factory.php:370 14 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:991 13 getCorrectedPriceForQueryFilter() JROOT/components/com_jshopping/lib/jtableauto.php:101 12 JTableAvto->getBuildQueryListProductFilterPrice() JROOT/components/com_jshopping/tables/ff_category_subcat.php:397 11 jshopFF_Category_subcat->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/ff_category_subcat.php:140 10 jshopFF_Category_subcat->getCountProducts() JROOT/components/com_jshopping/models/productlist.php:172 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.31 ms После последнего запроса: 0.12 ms Память запроса: 0.023 MB. Память перед запросом: 3.896 MB Возвращено строк: 1
SELECT COUNT(distinct prod.product_id)
FROM `joo_jshopping_products_to_categories` AS pr_cat
INNER JOIN `joo_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
WHERE pr_cat.category_id IN (5)
AND prod.product_publish=1
AND prod.listing_product>0
AND prod.access IN (1,1,5)
AND prod.listing_product >0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 category_id 4 const 8 Using index 1 SIMPLE prod eq_ref PRIMARY,product_publish,access,fregat_family_products PRIMARY 4 jackall_dev_db.pr_cat.product_id 1 Using where Status Duration Starting 0.09 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.34 ms Preparing 0.05 ms Executing 0.00 ms Sending data 0.46 ms End of update loop 0.01 ms Removing tmp table 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.09 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_jshopping/tables/ff_category_subcat.php:151 10 jshopFF_Category_subcat->getCountProducts() JROOT/components/com_jshopping/models/productlist.php:172 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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 После последнего запроса: 1.61 ms Память запроса: 0.025 MB. Память перед запросом: 3.924 MB Возвращено строк: 6
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.manufacturer_code, 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.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template
FROM `joo_jshopping_products` AS prod
LEFT JOIN `joo_jshopping_products_to_categories` AS pr_cat USING (product_id)
WHERE pr_cat.category_id IN (5)
AND prod.product_publish=1
AND prod.access IN (1,1,5)
AND prod.listing_product >0
GROUP BY product_id
ORDER BY prod.product_quantity=0, prod.image='', name ASC
LIMIT 0, 96id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 category_id 4 const 8 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE prod eq_ref PRIMARY,product_publish,access,fregat_family_products PRIMARY 4 jackall_dev_db.pr_cat.product_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Creating tmp table 0.07 ms Sorting for group 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.58 ms Creating sort index 0.05 ms Removing tmp table 0.28 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.17 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/ff_category_subcat.php:119 10 jshopFF_Category_subcat->getProducts() JROOT/components/com_jshopping/models/productlist.php:185 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.91 ms После последнего запроса: 0.98 ms Память запроса: 0.033 MB. Память перед запросом: 3.950 MB Возвращено строк: 53
SHOW FULL COLUMNS
FROM `joo_jshopping_users`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_users`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.34 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.10 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.12 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.17 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 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:253 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/usershopbase.php:14 14 jshopUserShopBase->__construct() JROOT/components/com_jshopping/tables/usershop.php:15 13 jshopUserShop->__construct() JROOT/components/com_jshopping/lib/factory.php:47 12 JSFactory::getUserShop() JROOT/components/com_jshopping/lib/functions.php:663 11 listProductUpdateData() JROOT/components/com_jshopping/tables/ff_category_subcat.php:120 10 jshopFF_Category_subcat->getProducts() JROOT/components/com_jshopping/models/productlist.php:185 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.74 ms После последнего запроса: 1.14 ms Память запроса: 0.027 MB. Память перед запросом: 4.024 MB Возвращено строк: 7
SHOW FULL COLUMNS
FROM `joo_jshopping_products_extra_field_values`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_products_extra_field_values`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.35 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.04 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.09 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.21 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfieldvalue.php:15 16 jshopProductFieldValue->__construct() JROOT/libraries/src/Table/Table.php:320 15 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 14 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:505 13 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/lib/functions.php:821 12 getProductExtraFieldForProduct() JROOT/components/com_jshopping/lib/functions.php:746 11 listProductUpdateData() JROOT/components/com_jshopping/tables/ff_category_subcat.php:120 10 jshopFF_Category_subcat->getProducts() JROOT/components/com_jshopping/models/productlist.php:185 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.55 ms После последнего запроса: 0.24 ms Память запроса: 0.082 MB. Память перед запросом: 4.042 MB Возвращено строк: 636
SELECT id, `name_ru-RU` as name, field_id
FROM `joo_jshopping_products_extra_field_values`
order by orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_extra_field_values ALL NULL INDEX KEY не используется NULL NULL 636 Используется сортировка файлов Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.32 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.12 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfieldvalue.php:26 14 jshopProductFieldValue->getAllList() JROOT/components/com_jshopping/lib/factory.php:506 13 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/lib/functions.php:821 12 getProductExtraFieldForProduct() JROOT/components/com_jshopping/lib/functions.php:746 11 listProductUpdateData() JROOT/components/com_jshopping/tables/ff_category_subcat.php:120 10 jshopFF_Category_subcat->getProducts() JROOT/components/com_jshopping/models/productlist.php:185 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.73 ms После последнего запроса: 7.00 ms Память запроса: 0.036 MB. Память перед запросом: 4.132 MB Возвращено строк: 143
select product_id as id, `alias_ru-RU` as alias
from joo_jshopping_products
where `alias_ru-RU`!=''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products ALL NULL INDEX KEY не используется NULL NULL 171 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.25 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.33 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:303 21 JSFactory::getAliasProduct() JROOT/components/com_jshopping/router.php:81 20 jshoppingBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_jshopping/lib/functions.php:496 12 SEFLink() JROOT/components/com_jshopping/lib/functions.php:446 11 addLinkToProducts() JROOT/components/com_jshopping/tables/ff_category_subcat.php:121 10 jshopFF_Category_subcat->getProducts() JROOT/components/com_jshopping/models/productlist.php:185 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.18 ms Память запроса: 0.026 MB. Память перед запросом: 4.163 MB Возвращено строк: 10
select category_id as id, `alias_ru-RU` as alias
from joo_jshopping_categories
where `alias_ru-RU`!=''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_categories ALL NULL INDEX KEY не используется NULL NULL 10 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.79 ms Reset for next command 0.02 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:255 21 JSFactory::getAliasCategory() JROOT/components/com_jshopping/router.php:82 20 jshoppingBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_jshopping/lib/functions.php:496 12 SEFLink() JROOT/components/com_jshopping/lib/functions.php:446 11 addLinkToProducts() JROOT/components/com_jshopping/tables/ff_category_subcat.php:121 10 jshopFF_Category_subcat->getProducts() JROOT/components/com_jshopping/models/productlist.php:185 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.94 ms После последнего запроса: 0.69 ms Память запроса: 0.041 MB. Память перед запросом: 4.180 MB Возвращено строк: 1
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id
FROM `joo_jshopping_products` AS `p`
WHERE `p`.`family` = 'Воблер JACKALL Re/70'
AND `p`.`product_publish` =1
AND `p`.`product_manufacturer_id`=1
ORDER BY p.product_id=1986 DESC, `name_ru-RU` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ALL product_manufacturer_id,product_publish INDEX KEY не используется NULL NULL 171 Using where; Используется сортировка файлов Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.21 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.20 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:216 13 plgJshoppingproductsFregat_family->loadModelRow() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:165 12 plgJshoppingproductsFregat_family->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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 - Время запроса: 5.79 ms После последнего запроса: 0.44 ms Память запроса: 0.041 MB. Память перед запросом: 4.199 MB Возвращено строк: 1
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id
FROM `joo_jshopping_products` AS `p`
WHERE `p`.`family` = 'Воблер JACKALL Tn Slim'
AND `p`.`product_publish` =1
AND `p`.`product_manufacturer_id`=1
ORDER BY p.product_id=1987 DESC, `name_ru-RU` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ALL product_manufacturer_id,product_publish INDEX KEY не используется NULL NULL 171 Using where; Используется сортировка файлов Status Duration Starting 0.91 ms checking permissions 0.09 ms Opening tables 0.21 ms After opening tables 0.09 ms System lock 0.01 ms table lock 0.09 ms init 0.75 ms Optimizing 0.21 ms Statistics 0.59 ms Preparing 0.11 ms Sorting result 0.11 ms Executing 0.09 ms Sending data 0.20 ms Creating sort index 1.48 ms End of update loop 0.09 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.09 ms Starting cleanup 0.01 ms Freeing items 0.09 ms Updating status 0.15 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:216 13 plgJshoppingproductsFregat_family->loadModelRow() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:165 12 plgJshoppingproductsFregat_family->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.74 ms После последнего запроса: 0.43 ms Память запроса: 0.041 MB. Память перед запросом: 4.218 MB Возвращено строк: 1
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id
FROM `joo_jshopping_products` AS `p`
WHERE `p`.`family` = 'Воблер JACKALL TN/60 Trigon'
AND `p`.`product_publish` =1
AND `p`.`product_manufacturer_id`=1
ORDER BY p.product_id=2020 DESC, `name_ru-RU` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ALL product_manufacturer_id,product_publish INDEX KEY не используется NULL NULL 171 Using where; Используется сортировка файлов Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.17 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:216 13 plgJshoppingproductsFregat_family->loadModelRow() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:165 12 plgJshoppingproductsFregat_family->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.83 ms После последнего запроса: 0.74 ms Память запроса: 0.041 MB. Память перед запросом: 4.238 MB Возвращено строк: 1
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id
FROM `joo_jshopping_products` AS `p`
WHERE `p`.`family` = 'Воблер JACKALL TN/70 Trigon'
AND `p`.`product_publish` =1
AND `p`.`product_manufacturer_id`=1
ORDER BY p.product_id=1989 DESC, `name_ru-RU` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ALL product_manufacturer_id,product_publish INDEX KEY не используется NULL NULL 171 Using where; Используется сортировка файлов Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.22 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:216 13 plgJshoppingproductsFregat_family->loadModelRow() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:165 12 plgJshoppingproductsFregat_family->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.60 ms После последнего запроса: 0.43 ms Память запроса: 0.041 MB. Память перед запросом: 4.257 MB Возвращено строк: 1
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id
FROM `joo_jshopping_products` AS `p`
WHERE `p`.`family` = 'Воблер JACKALL TN80'
AND `p`.`product_publish` =1
AND `p`.`product_manufacturer_id`=1
ORDER BY p.product_id=1991 DESC, `name_ru-RU` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ALL product_manufacturer_id,product_publish INDEX KEY не используется NULL NULL 171 Using where; Используется сортировка файлов Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.15 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:216 13 plgJshoppingproductsFregat_family->loadModelRow() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:165 12 plgJshoppingproductsFregat_family->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.63 ms После последнего запроса: 0.87 ms Память запроса: 0.041 MB. Память перед запросом: 4.277 MB Возвращено строк: 1
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id
FROM `joo_jshopping_products` AS `p`
WHERE `p`.`family` = 'Воблер JACKALL TIMON Dartrun'
AND `p`.`product_publish` =1
AND `p`.`product_manufacturer_id`=2
ORDER BY p.product_id=1985 DESC, `name_ru-RU` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ref|filter product_manufacturer_id,product_publish product_publish|product_manufacturer_id 1|4 const 95 (16%) Using where; Используется сортировка файлов; Using rowid filter Status Duration Starting 0.07 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.04 ms Creating sort index 0.12 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:216 13 plgJshoppingproductsFregat_family->loadModelRow() JROOT/plugins/jshoppingproducts/fregat_family/fregat_family.php:165 12 plgJshoppingproductsFregat_family->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.95 ms После последнего запроса: 0.86 ms Память запроса: 0.038 MB. Память перед запросом: 4.382 MB Возвращено строк: 67
SHOW FULL COLUMNS
FROM `joo_jshopping_products`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_products`Status Duration Starting 0.04 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.44 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.12 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.13 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 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:253 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/product.php:15 15 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:320 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 13 JSFactory::getTable() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:36 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.02 ms После последнего запроса: 1.23 ms Память запроса: 0.041 MB. Память перед запросом: 4.477 MB Возвращено строк: 1Повторяющиеся запросы: #74
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1986'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.03 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 13 Joomla\CMS\Table\Table->load() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:37 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.00 ms После последнего запроса: 0.58 ms Память запроса: 0.028 MB. Память перед запросом: 4.480 MB Возвращено строк: 11
SHOW FULL COLUMNS
FROM `joo_jshopping_attr`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_attr`Status Duration Starting 0.05 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.42 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.07 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.14 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 19 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/attribut.php:14 18 jshopAttribut->__construct() JROOT/libraries/src/Table/Table.php:320 17 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 16 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:317 15 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:128 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.03 ms После последнего запроса: 0.12 ms Память запроса: 0.025 MB. Память перед запросом: 4.503 MB Возвращено строк: 3
SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname
FROM `joo_jshopping_attr` as A
left join `joo_jshopping_attr_groups` as G
on A.`
group`=G.id
ORDER BY G.ordering, A.attr_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE A ALL NULL INDEX KEY не используется NULL NULL 3 Using temporary; Используется сортировка файлов 1 SIMPLE G eq_ref PRIMARY PRIMARY 4 jackall_dev_db.A.group 1 Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.04 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.55 ms Creating sort index 0.03 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/attribut.php:28 16 jshopAttribut->getAllAttributes() JROOT/components/com_jshopping/lib/factory.php:318 15 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:128 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.09 ms После последнего запроса: 0.08 ms Память запроса: 0.027 MB. Память перед запросом: 4.512 MB Возвращено строк: 12Повторяющиеся запросы: #75
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1986
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 12 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.35 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.42 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 15 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:133 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.83 ms После последнего запроса: 0.35 ms Память запроса: 0.025 MB. Память перед запросом: 4.521 MB Возвращено строк: 12
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_1=V.value_id
WHERE PA.product_id=1986
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 12 Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_1 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.36 ms Creating sort index 0.04 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.64 ms После последнего запроса: 0.14 ms Память запроса: 0.025 MB. Память перед запросом: 4.541 MB Возвращено строк: 12
SELECT distinct PA.attr_2 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_2=V.value_id
WHERE PA.product_id=1986
and PA.attr_1=1
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 12 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_2 1 Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.21 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.93 ms После последнего запроса: 0.28 ms Память запроса: 0.041 MB. Память перед запросом: 4.568 MB Возвращено строк: 1Повторяющиеся запросы: #76
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1987'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 13 Joomla\CMS\Table\Table->load() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:37 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.34 ms После последнего запроса: 0.11 ms Память запроса: 0.027 MB. Память перед запросом: 4.567 MB Возвращено строк: 11Повторяющиеся запросы: #77
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1987
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 11 Using where Status Duration Starting 0.03 ms checking permissions 0.03 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 15 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:133 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.37 ms После последнего запроса: 0.24 ms Память запроса: 0.025 MB. Память перед запросом: 4.576 MB Возвращено строк: 11
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_1=V.value_id
WHERE PA.product_id=1987
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 11 Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_1 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.46 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB. Память перед запросом: 4.596 MB Возвращено строк: 11
SELECT distinct PA.attr_2 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_2=V.value_id
WHERE PA.product_id=1987
and PA.attr_1=97
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 11 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_2 1 Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.08 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.52 ms После последнего запроса: 0.21 ms Память запроса: 0.041 MB. Память перед запросом: 4.622 MB Возвращено строк: 1Повторяющиеся запросы: #78
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '2020'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 13 Joomla\CMS\Table\Table->load() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:37 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.50 ms После последнего запроса: 0.10 ms Память запроса: 0.027 MB. Память перед запросом: 4.621 MB Возвращено строк: 12Повторяющиеся запросы: #79
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=2020
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 12 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.18 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.26 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 15 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:133 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.10 ms Память запроса: 0.025 MB. Память перед запросом: 4.630 MB Возвращено строк: 12
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_1=V.value_id
WHERE PA.product_id=2020
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 12 Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_1 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.07 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.46 ms После последнего запроса: 0.48 ms Память запроса: 0.025 MB. Память перед запросом: 4.650 MB Возвращено строк: 12
SELECT distinct PA.attr_2 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_2=V.value_id
WHERE PA.product_id=2020
and PA.attr_1=306
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 12 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_2 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.10 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.64 ms После последнего запроса: 0.21 ms Память запроса: 0.041 MB. Память перед запросом: 4.677 MB Возвращено строк: 1Повторяющиеся запросы: #80
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1989'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 13 Joomla\CMS\Table\Table->load() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:37 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.27 ms После последнего запроса: 0.08 ms Память запроса: 0.027 MB. Память перед запросом: 4.677 MB Возвращено строк: 12Повторяющиеся запросы: #81
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1989
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 12 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 15 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:133 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.41 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB. Память перед запросом: 4.685 MB Возвращено строк: 12
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_1=V.value_id
WHERE PA.product_id=1989
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 12 Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_1 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms Creating sort index 0.05 ms Removing tmp table 0.01 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.41 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB. Память перед запросом: 4.706 MB Возвращено строк: 12
SELECT distinct PA.attr_2 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_2=V.value_id
WHERE PA.product_id=1989
and PA.attr_1=1
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 12 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_2 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.08 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.16 ms После последнего запроса: 0.41 ms Память запроса: 0.046 MB. Память перед запросом: 4.742 MB Возвращено строк: 1Повторяющиеся запросы: #82
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1991'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.10 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 13 Joomla\CMS\Table\Table->load() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:37 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.33 ms После последнего запроса: 0.10 ms Память запроса: 0.028 MB. Память перед запросом: 4.747 MB Возвращено строк: 13Повторяющиеся запросы: #83
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1991
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 13 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 15 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:133 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.09 ms Память запроса: 0.025 MB. Память перед запросом: 4.756 MB Возвращено строк: 13
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_1=V.value_id
WHERE PA.product_id=1991
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 13 Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_1 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.07 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.35 ms После последнего запроса: 0.07 ms Память запроса: 0.025 MB. Память перед запросом: 4.777 MB Возвращено строк: 13
SELECT distinct PA.attr_2 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_2=V.value_id
WHERE PA.product_id=1991
and PA.attr_1=97
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 13 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_2 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.06 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.51 ms Память запроса: 0.041 MB. Память перед запросом: 4.804 MB Возвращено строк: 1Повторяющиеся запросы: #84
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1985'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.10 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 13 Joomla\CMS\Table\Table->load() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:37 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.27 ms После последнего запроса: 0.08 ms Память запроса: 0.026 MB. Память перед запросом: 4.804 MB Возвращено строк: 8Повторяющиеся запросы: #85
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1985
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 8 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.17 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 15 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:133 14 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.37 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB. Память перед запросом: 4.813 MB Возвращено строк: 8
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_1=V.value_id
WHERE PA.product_id=1985
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 8 Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_1 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.04 ms Creating sort index 0.02 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.19 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB. Память перед запросом: 4.829 MB Возвращено строк: 8
SELECT distinct PA.attr_2 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_2=V.value_id
WHERE PA.product_id=1985
and PA.attr_1=319
ORDER BY V.value_orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PA ref product_id product_id 4 const 8 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE V eq_ref PRIMARY PRIMARY 4 jackall_dev_db.PA.attr_2 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms Creating sort index 0.01 ms Removing tmp table 0.00 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.06 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.22 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:201 14 jshopProduct->getAttribValue() JROOT/components/com_jshopping/tables/product.php:210 13 jshopProduct->getAttributesDatas() JROOT/plugins/jshoppingproducts/allattrdata/allattrdata.php:38 12 plgJshoppingProductsAllattrdata->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/components/com_jshopping/models/productlist.php:187 9 jshopProductList->load() JROOT/components/com_jshopping/controllers/category.php:76 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.99 ms После последнего запроса: 0.82 ms Память запроса: 0.026 MB. Память перед запросом: 4.842 MB Возвращено строк: 10
SHOW FULL COLUMNS
FROM `joo_jshopping_products_reviews`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_products_reviews`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.56 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.06 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.12 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.43 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 15 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 14 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 13 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/review.php:14 12 jshopReview->__construct() JROOT/libraries/src/Table/Table.php:320 11 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 10 JSFactory::getTable() JROOT/components/com_jshopping/models/productlist.php:252 9 jshopProductList->getAllowReview() JROOT/components/com_jshopping/controllers/category.php:90 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.72 ms После последнего запроса: 1.18 ms Память запроса: 0.040 MB. Память перед запросом: 4.891 MB Возвращено строк: 1Повторяющиеся запросы: #47
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1986'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 12 Joomla\CMS\Table\Table->load() JROOT/plugins/jshopping/jackall/jackall.php:94 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.50 ms После последнего запроса: 0.31 ms Память запроса: 0.025 MB. Память перед запросом: 4.890 MB Возвращено строк: 12Повторяющиеся запросы: #50
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1986
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 12 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 12 jshopProduct->getAttributes() JROOT/plugins/jshopping/jackall/jackall.php:95 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.59 ms После последнего запроса: 0.18 ms Память запроса: 0.040 MB. Память перед запросом: 4.919 MB Возвращено строк: 1Повторяющиеся запросы: #53
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1987'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 12 Joomla\CMS\Table\Table->load() JROOT/plugins/jshopping/jackall/jackall.php:94 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.33 ms После последнего запроса: 0.35 ms Память запроса: 0.025 MB. Память перед запросом: 4.918 MB Возвращено строк: 11Повторяющиеся запросы: #54
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1987
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 11 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 12 jshopProduct->getAttributes() JROOT/plugins/jshopping/jackall/jackall.php:95 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.56 ms После последнего запроса: 0.47 ms Память запроса: 0.040 MB. Память перед запросом: 4.946 MB Возвращено строк: 1Повторяющиеся запросы: #57
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '2020'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 12 Joomla\CMS\Table\Table->load() JROOT/plugins/jshopping/jackall/jackall.php:94 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB. Память перед запросом: 4.944 MB Возвращено строк: 12Повторяющиеся запросы: #58
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=2020
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 12 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 12 jshopProduct->getAttributes() JROOT/plugins/jshopping/jackall/jackall.php:95 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 0.14 ms Память запроса: 0.040 MB. Память перед запросом: 4.973 MB Возвращено строк: 1Повторяющиеся запросы: #61
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1989'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 12 Joomla\CMS\Table\Table->load() JROOT/plugins/jshopping/jackall/jackall.php:94 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.31 ms После последнего запроса: 0.07 ms Память запроса: 0.025 MB. Память перед запросом: 4.972 MB Возвращено строк: 12Повторяющиеся запросы: #62
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1989
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 12 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 12 jshopProduct->getAttributes() JROOT/plugins/jshopping/jackall/jackall.php:95 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.66 ms После последнего запроса: 0.68 ms Память запроса: 0.040 MB. Память перед запросом: 5.001 MB Возвращено строк: 1Повторяющиеся запросы: #65
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1991'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 12 Joomla\CMS\Table\Table->load() JROOT/plugins/jshopping/jackall/jackall.php:94 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 0.09 ms Память запроса: 0.026 MB. Память перед запросом: 4.999 MB Возвращено строк: 13Повторяющиеся запросы: #66
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1991
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 13 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 12 jshopProduct->getAttributes() JROOT/plugins/jshopping/jackall/jackall.php:95 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.35 ms После последнего запроса: 0.15 ms Память запроса: 0.040 MB. Память перед запросом: 5.029 MB Возвращено строк: 1Повторяющиеся запросы: #69
SELECT *
FROM joo_jshopping_products
WHERE `product_id` = '1985'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products const PRIMARY,fregat_family_products PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 12 Joomla\CMS\Table\Table->load() JROOT/plugins/jshopping/jackall/jackall.php:94 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB. Память перед запросом: 5.028 MB Возвращено строк: 8Повторяющиеся запросы: #70
SELECT *
FROM `joo_jshopping_products_attr`
WHERE product_id=1985
ORDER BY product_attr_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_products_attr ref product_id product_id 4 const 8 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 12 jshopProduct->getAttributes() JROOT/plugins/jshopping/jackall/jackall.php:95 11 plgJshoppingJackall->onBeforeDisplayProductListView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/category.php:131 8 JshoppingControllerCategory->view() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 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.76 ms После последнего запроса: 17.57 ms Память запроса: 0.058 MB. Память перед запросом: 5.351 MB Возвращено строк: 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM joo_modules AS m
LEFT JOIN joo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN joo_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL published,newsfeeds INDEX KEY не используется NULL NULL 75 Using where; Используется сортировка файлов 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 jackall_dev_db.m.module,const 1 Using index condition; Using where 1 SIMPLE am eq_ref PRIMARY PRIMARY 4 jackall_dev_db.m.id 1 Using where Status Duration Starting 0.11 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.03 ms Statistics 0.25 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 1.11 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278 14 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60 13 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 12 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 11 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:366 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/jackall/index.php:27 7 require JROOT/templates/jackall/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.63 ms После последнего запроса: 14.39 ms Память запроса: 0.023 MB. Память перед запросом: 5.643 MB Возвращено строк: 0
SELECT fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type
FROM `joo_jshopping_free_attr` AS fa
ORDER BY fa.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE fa ALL NULL INDEX KEY не используется NULL NULL 1 Используется сортировка файлов 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.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.20 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/models/cartajaxattributes.php:375 13 jshopCartAjaxAttributes->getAllFreeAttributes() JROOT/components/com_jshopping/helpers/cartajax.php:54 12 CartAjaxHelper::_getFreeAttributes() JROOT/components/com_jshopping/helpers/cartajax.php:41 11 CartAjaxHelper::includeCommonCode() JROOT/modules/mod_adv_jshopping_cartajax/mod_adv_jshopping_cartajax.php:44 10 include JROOT/modules/mod_adv_jshopping_cartajax/mod_adv_jshopping_cartajax.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.04 ms После последнего запроса: 7.05 ms Память запроса: 0.027 MB. Память перед запросом: 5.669 MB Возвращено строк: 17
SHOW FULL COLUMNS
FROM `joo_jshopping_shops`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_shops`Status Duration Starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.41 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.07 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.12 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 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:253 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 14 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/shop.php:35 13 jshopShop->__construct() JROOT/libraries/src/Table/Table.php:320 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 11 JSFactory::getTable() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:19 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.86 ms После последнего запроса: 0.45 ms Память запроса: 0.022 MB. Память перед запросом: 5.758 MB Возвращено строк: 1
SELECT s.*
FROM `joo_jshopping_shops` AS s
WHERE s.publish=1
AND s.city_id=1
AND s.dealer=0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL NULL INDEX KEY не используется NULL NULL 201 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.54 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/shop.php:81 11 jshopShop::getShops() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:19 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.64 ms После последнего запроса: 0.25 ms Память запроса: 0.025 MB. Память перед запросом: 5.769 MB Возвращено строк: 6
SHOW FULL COLUMNS
FROM `joo_jshopping_cities`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `joo_jshopping_cities`Status Duration Starting 0.02 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.29 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.03 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.09 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.05 ms # Вызывающий объект Файл и номер строки 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:253 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 14 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/city.php:29 13 jshopCity->__construct() JROOT/libraries/src/Table/Table.php:320 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 11 JSFactory::getTable() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:20 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.33 ms После последнего запроса: 0.11 ms Память запроса: 0.022 MB. Память перед запросом: 5.787 MB Возвращено строк: 1
SELECT *
FROM joo_jshopping_cities
WHERE `city_id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_cities const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.14 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 11 Joomla\CMS\Table\Table->load() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:21 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.43 ms После последнего запроса: 0.32 ms Память запроса: 0.022 MB. Память перед запросом: 5.790 MB Возвращено строк: 1
SELECT s.*
FROM `joo_jshopping_shops` AS s
WHERE s.publish=1
AND s.city_id=1
AND s.dealer=0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL NULL INDEX KEY не используется NULL NULL 201 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.19 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/shop.php:81 11 jshopShop::getShops() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:19 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.19 ms После последнего запроса: 0.11 ms Память запроса: 0.022 MB. Память перед запросом: 5.801 MB Возвращено строк: 1
SELECT *
FROM joo_jshopping_cities
WHERE `city_id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_cities const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 11 Joomla\CMS\Table\Table->load() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:21 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.43 ms После последнего запроса: 4.83 ms Память запроса: 0.022 MB. Память перед запросом: 5.884 MB Возвращено строк: 1
SELECT s.*
FROM `joo_jshopping_shops` AS s
WHERE s.publish=1
AND s.city_id=1
AND s.dealer=0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL NULL INDEX KEY не используется NULL NULL 201 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.15 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/shop.php:81 11 jshopShop::getShops() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:19 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.21 ms После последнего запроса: 0.09 ms Память запроса: 0.022 MB. Память перед запросом: 5.895 MB Возвращено строк: 1
SELECT *
FROM joo_jshopping_cities
WHERE `city_id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_cities const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 11 Joomla\CMS\Table\Table->load() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:21 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 1.57 ms Память запроса: 0.022 MB. Память перед запросом: 5.933 MB Возвращено строк: 1
SELECT s.*
FROM `joo_jshopping_shops` AS s
WHERE s.publish=1
AND s.city_id=2
AND s.dealer=0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL NULL INDEX KEY не используется NULL NULL 201 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.14 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/shop.php:81 11 jshopShop::getShops() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:19 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.21 ms После последнего запроса: 0.08 ms Память запроса: 0.022 MB. Память перед запросом: 5.944 MB Возвращено строк: 1
SELECT *
FROM joo_jshopping_cities
WHERE `city_id` = '2'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE joo_jshopping_cities const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 11 Joomla\CMS\Table\Table->load() JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php:21 10 include JROOT/modules/mod_jshopping_cityshops/mod_jshopping_cityshops.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
52 типов запросов зарегистрировано (отсортировано по вхождениям)
Запросы типа SELECT:
12 × SELECT *
FROM joo_jshopping_products12 × SELECT *
FROM `joo_jshopping_products_attr`6 × SELECT distinct PA.attr_2 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_2=V.value_id6 × SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price
FROM `joo_jshopping_products_attr` as PA
INNER JOIN joo_jshopping_attr_values as V
ON PA.attr_1=V.value_id6 × SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id
FROM `joo_jshopping_products` AS `p`4 × SELECT *
FROM joo_jshopping_cities4 × SELECT s.*
FROM `joo_jshopping_shops` AS s2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joo_extensions`2 × SELECT *
FROM joo_jshopping_config1 × select product_id as id, `alias_ru-RU` as alias
from joo_jshopping_products1 × SELECT COUNT(distinct prod.product_id)
FROM `joo_jshopping_products_to_categories` AS pr_cat
INNER JOIN `joo_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id1 × 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.manufacturer_code, 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.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template
FROM `joo_jshopping_products` AS prod
LEFT JOIN `joo_jshopping_products_to_categories` AS pr_cat USING (product_id)1 × SELECT id, `name_ru-RU` as name, field_id
FROM `joo_jshopping_products_extra_field_values`1 × SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname
FROM `joo_jshopping_attr` as A
left join `joo_jshopping_attr_groups` as G
on A.`
group`=G.id1 × select category_id as id, `alias_ru-RU` as alias
from joo_jshopping_categories1 × 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 `joo_jshopping_products_extra_fields` as F
left join `joo_jshopping_products_extra_field_groups` as G
on G.id=F.
group1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM joo_modules AS m
LEFT JOIN joo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN joo_advancedmodules as am
ON am.moduleid = m.id1 × SELECT fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type
FROM `joo_jshopping_free_attr` AS fa1 × SELECT tax_id, tax_name, tax_value
FROM `joo_jshopping_taxes1 × SELECT `data`
FROM `joo_session`1 × SELECT *
FROM joo_jshopping_vendors1 × SELECT id, home, template, s.params
FROM joo_template_styles as s
LEFT JOIN joo_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT id, rules
FROM `joo_viewlevels1 × SELECT b.id
FROM joo_usergroups AS a
LEFT JOIN joo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joo_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joo_menu AS m
LEFT JOIN joo_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `joo_assets`1 × SELECT *
FROM joo_languages1 × SELECT id, image, color
FROM `joo_jshopping_products_extra_field_values`1 × SELECT `session_id`
FROM `joo_session`1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `joo_jshopping_currencies`1 × select *
from joo_jshopping_language1 × SELECT category_id
FROM joo_jshopping_categories1 × SELECT *
FROM joo_jshopping_categories1 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image, `alias_ru-RU` as alias
FROM `joo_jshopping_categories`1 × select id,link
from joo_menu1 × SELECT id
FROM joo_jshopping_vendors
Запросы типа OTHER:
1 × INSERT INTO `joo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'687469366e6c6463336f317263643636326469686a636a356d39', 1, 1781041471, 0, '', 01 × UPDATE `joo_extensions`
SET `params` = '{\"mediaversion\":\"d1fc1c50b78fadc55d2e884bf771fd3d\"}'1 × SHOW FULL COLUMNS
FROM `joo_jshopping_config1 × SHOW FULL COLUMNS
FROM `joo_jshopping_currencies1 × SHOW FULL COLUMNS
FROM `joo_jshopping_categories1 × SHOW FULL COLUMNS
FROM `joo_jshopping_vendors1 × SHOW FULL COLUMNS
FROM `joo_jshopping_products_extra_fields1 × SHOW FULL COLUMNS
FROM `joo_jshopping_taxes1 × SHOW FULL COLUMNS
FROM `joo_jshopping_users1 × SHOW FULL COLUMNS
FROM `joo_jshopping_products_extra_field_values1 × SHOW FULL COLUMNS
FROM `joo_jshopping_products1 × SHOW FULL COLUMNS
FROM `joo_jshopping_attr1 × SHOW FULL COLUMNS
FROM `joo_jshopping_products_reviews1 × SHOW FULL COLUMNS
FROM `joo_jshopping_shops1 × SHOW FULL COLUMNS
FROM `joo_jshopping_cities