Оформить заказ
Контакты
Омск, Россия, 644070
ул. Шебалдина, 60, оф. 3, 4
Каталог
© 2023 ТСК "КапСтрой", Омск
Консоль отладки Joomla
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1696446037,
"last": 1696446037,
"now": 1696446037
},
"token": "LN80SdkJYR5TKzBpph6a2Dj2oMbTPBab"
},
"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": "2",
"js_id_currency": "2",
"js_history_sel_lang": "ru-RU",
"js_prev_user_id": 0,
"jshop_checked_language": [
"en-GB",
"ru-RU"
],
"jshop_end_page_buy_product": "/montazhe",
"jshop_end_page_list_product": "/montazhe"
}
}
Время
Память
Время: 23.71 ms / 23.71 ms Память: 1.415 MB / 1.75 MB Application: afterLoad
Время: 99.28 ms / 122.99 ms Память: 7.330 MB / 9.08 MB Application: afterInitialise
Время: 25.79 ms / 148.78 ms Память: 2.652 MB / 11.74 MB Application: Before Access::preloadComponents (all components)
Время: 0.88 ms / 149.67 ms Память: 0.061 MB / 11.80 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 149.70 ms Память: -0.003 MB / 11.79 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Время: 0.54 ms / 150.24 ms Память: 0.025 MB / 11.82 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Время: 7.86 ms / 158.10 ms Память: 0.486 MB / 12.31 MB Application: afterRoute
Время: 0.63 ms / 158.73 ms Память: 0.011 MB / 12.32 MB Application: beforeRenderComponent com_jshopping
Время: 43.49 ms / 202.22 ms Память: 1.979 MB / 14.30 MB Application: afterRenderComponent com_jshopping
Время: 0.57 ms / 202.79 ms Память: 0.007 MB / 14.30 MB Application: afterDispatch
Время: 7.84 ms / 210.64 ms Память: 0.479 MB / 14.78 MB Application: beforeRenderModule mod_simplecallback (Оформить заказ)
Время: 8.70 ms / 219.33 ms Память: 0.536 MB / 15.32 MB Application: afterRenderModule mod_simplecallback (Оформить заказ)
Время: 0.05 ms / 219.39 ms Память: -0.094 MB / 15.22 MB Application: beforeRenderModule mod_custom (Контакты)
Время: 0.39 ms / 219.78 ms Память: 0.006 MB / 15.23 MB Application: afterRenderModule mod_custom (Контакты)
Время: 0.03 ms / 219.80 ms Память: 0.006 MB / 15.24 MB Application: beforeRenderModule mod_menu (Компания)
Время: 3.06 ms / 222.87 ms Память: 0.162 MB / 15.40 MB Application: afterRenderModule mod_menu (Компания)
Время: 0.03 ms / 222.90 ms Память: -0.004 MB / 15.39 MB Application: beforeRenderModule mod_menu (Каталог)
Время: 1.71 ms / 224.61 ms Память: 0.028 MB / 15.42 MB Application: afterRenderModule mod_menu (Каталог)
Время: 0.03 ms / 224.64 ms Память: 0.001 MB / 15.42 MB Application: beforeRenderModule mod_menu (Полезно)
Время: 0.74 ms / 225.39 ms Память: 0.015 MB / 15.44 MB Application: afterRenderModule mod_menu (Полезно)
Время: 0.11 ms / 225.50 ms Память: -0.001 MB / 15.44 MB Application: beforeRenderModule mod_breadcrumbs (Путь по сайту)
Время: 1.44 ms / 226.94 ms Память: 0.040 MB / 15.48 MB Application: afterRenderModule mod_breadcrumbs (Путь по сайту)
Время: 0.09 ms / 227.03 ms Память: -0.002 MB / 15.48 MB Application: beforeRenderModule mod_menu (Меню Каталог)
Время: 9.64 ms / 236.66 ms Память: 0.250 MB / 15.73 MB Application: afterRenderModule mod_menu (Меню Каталог)
Время: 0.08 ms / 236.75 ms Память: -0.016 MB / 15.71 MB Application: beforeRenderModule mod_custom (Адрес вверху)
Время: 0.20 ms / 236.95 ms Память: 0.003 MB / 15.71 MB Application: afterRenderModule mod_custom (Адрес вверху)
Время: 0.03 ms / 236.97 ms Память: -0.000 MB / 15.71 MB Application: beforeRenderModule mod_search (Поиск по сайту)
Время: 1.08 ms / 238.05 ms Память: 0.019 MB / 15.73 MB Application: afterRenderModule mod_search (Поиск по сайту)
Время: 0.07 ms / 238.12 ms Память: -0.003 MB / 15.73 MB Application: beforeRenderModule mod_menu (Верхнее меню)
Время: 1.07 ms / 239.19 ms Память: 0.035 MB / 15.76 MB Application: afterRenderModule mod_menu (Верхнее меню)
Время: 75.64 ms / 314.83 ms Память: 1.685 MB / 17.45 MB Application: afterRender
Всего запросов к базе данных: 29.12 ms
17.97 MB (18 839 912 Байт)
37 запросов зарегистрировано 29.12 ms
- Время запроса: 0.28 ms Память запроса: 0.023 MB. Память перед запросом: 3.279 MB Возвращено строк: 0
SELECT `data`
FROM `kpstr_session`
WHERE `session_id` = X'6362396632383731396665346661363666653832386530386331316165393131'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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.21 ms После последнего запроса: 1.50 ms Память запроса: 0.020 MB. Память перед запросом: 3.368 MB Возвращено строк: 0
SELECT `session_id`
FROM `kpstr_session`
WHERE `session_id` = X'6362396632383731396665346661363666653832386530386331316165393131'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 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.34 ms После последнего запроса: 0.08 ms Память запроса: 0.004 MB. Память перед запросом: 3.373 MB
INSERT INTO `kpstr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6362396632383731396665346661363666653832386530386331316165393131', 1, 1696446037, 0, '', 0)EXPLAIN недоступен для: INSERT INTO `kpstr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6362396632383731396665346661363666653832386530386331316165393131', 1, 1696446037, 0, '', 0)Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms update 0.13 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.08 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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 - Время запроса: 0.70 ms После последнего запроса: 3.38 ms Память запроса: 0.025 MB. Память перед запросом: 3.618 MB Возвращено строк: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kpstr_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_extensions NULL ref extension extension 82 const 42 1.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.33 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.08 ms freeing items 0.02 ms cleaning up 0.01 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.32 ms После последнего запроса: 2.71 ms Память запроса: 0.021 MB. Память перед запросом: 3.798 MB Возвращено строк: 5
SELECT id, rules
FROM `kpstr_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_viewlevels NULL ALL NULL INDEX KEY не используется NULL NULL 5 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.06 ms freeing items 0.02 ms cleaning up 0.01 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.34 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB. Память перед запросом: 3.810 MB Возвращено строк: 2
SELECT b.id
FROM kpstr_usergroups AS a
LEFT JOIN kpstr_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 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.05 ms После последнего запроса: 0.80 ms Память запроса: 0.030 MB. Память перед запросом: 3.875 MB Возвращено строк: 97
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kpstr_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_extensions NULL ref extension extension 82 const 115 0.60 Using where; Используется сортировка файлов Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.04 ms executing 0.72 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 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 - Время запроса: 0.41 ms После последнего запроса: 58.79 ms Память запроса: 0.022 MB. Память перед запросом: 8.795 MB Возвращено строк: 1
SELECT `params`
FROM `kpstr_extensions`
WHERE `type` = 'component'
AND `element` = 'com_jchoptimize'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/fof40/Params/Params.php:55 12 FOF40\Params\Params->reload() JROOT/libraries/fof40/Params/Params.php:40 11 FOF40\Params\Params->__construct() JROOT/libraries/fof40/Container/Container.php:281 10 FOF40\Container\Container->FOF40\Container\{closure}() JROOT/libraries/fof40/Pimple/Container.php:115 9 FOF40\Pimple\Container->offsetGet() JROOT/libraries/fof40/Container/ContainerBase.php:27 8 FOF40\Container\ContainerBase->__get() JROOT/plugins/system/jchoptimize/jchoptimize.php:123 7 plgSystemJchoptimize->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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.22 ms После последнего запроса: 6.31 ms Память запроса: 0.415 MB. Память перед запросом: 9.262 MB Возвращено строк: 247
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 kpstr_menu AS m
LEFT JOIN kpstr_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language INDEX KEY не используется NULL NULL 315 7.94 Using where; Используется сортировка файлов 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 cz94742_kapstroy.m.component_id 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms executing 1.72 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.06 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 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 - Время запроса: 0.61 ms После последнего запроса: 21.18 ms Память запроса: 0.027 MB. Память перед запросом: 11.740 MB Возвращено строк: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kpstr_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jchoptimize','com_joomlaupdate','com_jshopping','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sige','com_simplecallback','com_smartslider3','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_assets NULL ALL idx_asset_name INDEX KEY не используется NULL NULL 98 43.88 Using where Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.16 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 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:95 9 PlgSystemAdvancedModules->handleOnAfterRoute() JROOT/libraries/regularlabs/src/SystemPlugin.php:533 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.30 ms После последнего запроса: 1.35 ms Память запроса: 0.024 MB. Память перед запросом: 11.854 MB Возвращено строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kpstr_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Такой же, как вызов в строке ниже 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84 8 plgSystemSL_ScrollToTop->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.33 ms После последнего запроса: 0.13 ms Память запроса: 0.006 MB. Память перед запросом: 11.847 MB
UPDATE `kpstr_extensions`
SET `params` = '{\"mediaversion\":\"42a9edb434f89d464203fe5cf53fdf54\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN недоступен для: UPDATE `kpstr_extensions` SET `params` = '{\"mediaversion\":\"42a9edb434f89d464203fe5cf53fdf54\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.05 ms updating 0.09 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.09 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84 8 plgSystemSL_ScrollToTop->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.51 ms После последнего запроса: 3.80 ms Память запроса: 0.025 MB. Память перед запросом: 12.119 MB Возвращено строк: 3
SELECT id, home, template, s.params
FROM kpstr_template_styles as s
LEFT JOIN kpstr_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 cz94742_kapstroy.e.element 1 60.00 Using index condition; Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms executing 0.08 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.00 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 0.05 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 18 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 17 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 16 Joomla\CMS\HTML\HTMLHelper::script() Такой же, как вызов в строке ниже 15 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 14 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 13 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 12 JHtmlJquery::framework() Такой же, как вызов в строке ниже 11 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 10 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 9 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:146 8 plgSystemSL_ScrollToTop->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.28 ms После последнего запроса: 2.31 ms Память запроса: 0.019 MB. Память перед запросом: 12.308 MB Возвращено строк: 1
SELECT *
FROM kpstr_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_languages NULL ALL NULL INDEX KEY не используется NULL NULL 2 50.00 Using where; Используется сортировка файлов Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.01 ms cleaning up 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 - Время запроса: 3.47 ms После последнего запроса: 1.99 ms Память запроса: 0.046 MB. Память перед запросом: 12.393 MB Возвращено строк: 140
SHOW FULL COLUMNS
FROM `kpstr_jshopping_config`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_config`Status Duration checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.15 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.00 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:261 14 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 13 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/config.php:14 12 jshopConfig->__construct() JROOT/components/com_jshopping/lib/factory.php:24 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:1593 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.57 ms После последнего запроса: 1.74 ms Память запроса: 0.102 MB. Память перед запросом: 12.656 MB Возвращено строк: 1
SELECT *
FROM kpstr_jshopping_config
WHERE `id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_config NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 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:1593 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.41 ms После последнего запроса: 0.42 ms Память запроса: 0.028 MB. Память перед запросом: 12.657 MB Возвращено строк: 8
SHOW FULL COLUMNS
FROM `kpstr_jshopping_currencies`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_currencies`Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.66 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.09 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.05 ms freeing items 0.04 ms cleaning up 0.03 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:261 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/currency.php:14 16 jshopCurrency->__construct() JROOT/libraries/src/Table/Table.php:328 15 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 14 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:569 13 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 12 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 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:1593 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.22 ms После последнего запроса: 0.08 ms Память запроса: 0.023 MB. Память перед запросом: 12.676 MB Возвращено строк: 1
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `kpstr_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_currencies NULL ref currency_publish currency_publish 1 const 1 100.00 Используется сортировка файлов Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/currency.php:22 14 jshopCurrency->getAllCurrencies() JROOT/components/com_jshopping/lib/factory.php:570 13 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 12 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 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:1593 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.16 ms После последнего запроса: 1.79 ms Память запроса: 0.021 MB. Память перед запросом: 12.662 MB Возвращено строк: 2
select *
from kpstr_jshopping_languagesid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_languages NULL ALL NULL INDEX KEY не используется NULL NULL 2 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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.82 ms После последнего запроса: 5.63 ms Память запроса: 0.027 MB. Память перед запросом: 13.007 MB Возвращено строк: 24
SHOW FULL COLUMNS
FROM `kpstr_jshopping_categories`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_categories`Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.69 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.09 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.09 ms freeing items 0.05 ms cleaning up 0.04 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:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/category.php:15 11 jshopCategory->__construct() JROOT/libraries/src/Table/Table.php:328 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.24 ms После последнего запроса: 0.16 ms Память запроса: 0.022 MB. Память перед запросом: 13.043 MB Возвращено строк: 1
SELECT *
FROM kpstr_jshopping_categories
WHERE `category_id` = '5'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.03 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/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.87 ms После последнего запроса: 0.11 ms Память запроса: 0.115 MB. Память перед запросом: 13.054 MB Возвращено строк: 1
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
FROM `kpstr_jshopping_categories`
WHERE category_parent_id = '5'
AND category_publish = '1'
AND access IN (1,1,5)
ORDER BY ordering ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_categories NULL ref category_parent_id,category_publish,access,category_publish_2 category_parent_id 4 const 1 100.00 Using where; Используется сортировка файлов Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.64 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:34 10 jshopCategory->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 - Время запроса: 1.61 ms После последнего запроса: 0.10 ms Память запроса: 0.052 MB. Память перед запросом: 13.109 MB Возвращено строк: 220
select id,link
from kpstr_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 251 0.32 Using index condition; Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 1.37 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/shop_item_menu.php:141 16 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:47 15 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:40 14 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:403 13 getShopMainPageItemid() JROOT/components/com_jshopping/lib/functions.php:422 12 getDefaultItemid() JROOT/components/com_jshopping/lib/functions.php:481 11 SEFLink() JROOT/components/com_jshopping/tables/category.php:36 10 jshopCategory->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 - Время запроса: 1.87 ms После последнего запроса: 3.32 ms Память запроса: 0.033 MB. Память перед запросом: 13.577 MB Возвращено строк: 31
SHOW FULL COLUMNS
FROM `kpstr_jshopping_vendors`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_vendors`Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.69 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.10 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.06 ms freeing items 0.04 ms cleaning up 0.04 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:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/vendor.php:15 15 jshopVendor->__construct() JROOT/libraries/src/Table/Table.php:328 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:1447 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.17 ms После последнего запроса: 0.11 ms Память запроса: 0.023 MB. Память перед запросом: 13.618 MB Возвращено строк: 1
SELECT id
FROM kpstr_jshopping_vendors
WHERE `main`=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_vendors NULL ref main main 1 const 1 100.00 Using index Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:1447 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.19 ms После последнего запроса: 0.09 ms Память запроса: 0.024 MB. Память перед запросом: 13.628 MB Возвращено строк: 1
SELECT *
FROM kpstr_jshopping_vendors
WHERE `id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_vendors NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 14 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/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:1447 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 - Время запроса: 1.29 ms После последнего запроса: 0.35 ms Память запроса: 0.027 MB. Память перед запросом: 13.643 MB Возвращено строк: 11
SHOW FULL COLUMNS
FROM `kpstr_jshopping_products_extra_fields`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_products_extra_fields`Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.57 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.08 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.02 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:261 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfield.php:14 16 jshopProductField->__construct() JROOT/libraries/src/Table/Table.php:328 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:1134 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:37 11 JTableAvto->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/category.php:179 10 jshopCategory->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.24 ms После последнего запроса: 0.08 ms Память запроса: 0.023 MB. Память перед запросом: 13.665 MB Возвращено строк: 0
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 `kpstr_jshopping_products_extra_fields` as F
left join `kpstr_jshopping_products_extra_field_groups` as G
on G.id=F.
group
order by G.ordering, F.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE F NULL ALL NULL INDEX KEY не используется NULL NULL 1 100.00 Using temporary; Используется сортировка файлов 1 SIMPLE G NULL eq_ref PRIMARY PRIMARY 4 cz94742_kapstroy.F.group 1 100.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Creating tmp table 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:1134 12 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:37 11 JTableAvto->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/category.php:179 10 jshopCategory->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.01 ms После последнего запроса: 0.27 ms Память запроса: 0.026 MB. Память перед запросом: 13.677 MB Возвращено строк: 3
SHOW FULL COLUMNS
FROM `kpstr_jshopping_taxes`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_taxes`Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.49 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.07 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.02 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:261 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 18 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/tax.php:14 17 jshopTax->__construct() JROOT/libraries/src/Table/Table.php:328 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:989 13 getCorrectedPriceForQueryFilter() JROOT/components/com_jshopping/lib/jtableauto.php:101 12 JTableAvto->getBuildQueryListProductFilterPrice() JROOT/components/com_jshopping/lib/jtableauto.php:88 11 JTableAvto->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/category.php:179 10 jshopCategory->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.13 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB. Память перед запросом: 13.692 MB Возвращено строк: 1
SELECT tax_id, tax_name, tax_value
FROM `kpstr_jshopping_taxes`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kpstr_jshopping_taxes NULL ALL NULL INDEX KEY не используется NULL NULL 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:989 13 getCorrectedPriceForQueryFilter() JROOT/components/com_jshopping/lib/jtableauto.php:101 12 JTableAvto->getBuildQueryListProductFilterPrice() JROOT/components/com_jshopping/lib/jtableauto.php:88 11 JTableAvto->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/category.php:179 10 jshopCategory->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.32 ms После последнего запроса: 0.04 ms Память запроса: 0.022 MB. Память перед запросом: 13.699 MB Возвращено строк: 1
SELECT count(*)
FROM `kpstr_jshopping_products_to_categories` AS pr_cat
INNER JOIN `kpstr_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
WHERE pr_cat.category_id=5
AND prod.product_publish=1
AND prod.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pr_cat NULL ref PRIMARY,category_id,product_id,product_id_2 category_id 4 const 1 100.00 Using index 1 SIMPLE prod NULL eq_ref PRIMARY,product_publish,access PRIMARY 4 cz94742_kapstroy.pr_cat.product_id 1 100.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.03 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_jshopping/tables/category.php:190 10 jshopCategory->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.44 ms После последнего запроса: 1.64 ms Память запроса: 0.022 MB. Память перед запросом: 13.805 MB Возвращено строк: 0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.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
FROM `kpstr_jshopping_products` AS prod
LEFT JOIN `kpstr_jshopping_products_to_categories` AS pr_cat USING (product_id)
WHERE pr_cat.category_id=5
AND prod.product_publish=1
AND prod.access IN (1,1,5)
ORDER BY pr_cat.product_ordering ASC
LIMIT 0, 32id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pr_cat NULL ref PRIMARY,category_id,product_id,product_id_2 category_id 4 const 1 100.00 Using index condition; Используется сортировка файлов 1 SIMPLE prod NULL eq_ref PRIMARY,product_publish,access PRIMARY 4 cz94742_kapstroy.pr_cat.product_id 1 100.00 Using where Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:171 10 jshopCategory->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.98 ms После последнего запроса: 1.19 ms Память запроса: 0.035 MB. Память перед запросом: 13.904 MB Возвращено строк: 53
SHOW FULL COLUMNS
FROM `kpstr_jshopping_users`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_users`Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.57 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.08 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.02 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:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/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/category.php:172 10 jshopCategory->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.89 ms После последнего запроса: 2.71 ms Память запроса: 0.026 MB. Память перед запросом: 14.231 MB Возвращено строк: 10
SHOW FULL COLUMNS
FROM `kpstr_jshopping_products_reviews`EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `kpstr_jshopping_products_reviews`Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.84 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.06 ms executing 0.13 ms checking permissions 0.10 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.05 ms freeing items 0.04 ms cleaning up 0.04 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:261 14 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 13 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/review.php:14 12 jshopReview->__construct() JROOT/libraries/src/Table/Table.php:328 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.99 ms После последнего запроса: 4.58 ms Память запроса: 0.088 MB. Память перед запросом: 14.417 MB Возвращено строк: 14
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 kpstr_modules AS m
LEFT JOIN kpstr_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN kpstr_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL published,newsfeeds INDEX KEY не используется NULL NULL 21 7.62 Using where; Используется сортировка файлов 1 SIMPLE am NULL eq_ref PRIMARY PRIMARY 4 cz94742_kapstroy.m.id 1 100.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 cz94742_kapstroy.m.module,const 1 10.00 Using index condition; Using where Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.53 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.07 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:168 13 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60 12 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:366 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 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.20 ms После последнего запроса: 3.79 ms Память запроса: 0.023 MB. Память перед запросом: 14.732 MB Возвращено строк: 1
SELECT a.mirror_id
FROM kpstr_advancedmodules AS a
WHERE a.moduleid = 101id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:402 14 PlgSystemAdvancedModuleHelper->getMirrorModuleIdById() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:248 13 PlgSystemAdvancedModuleHelper->setMirrorParams() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:103 12 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:366 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 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.15 ms После последнего запроса: 0.04 ms Память запроса: 0.023 MB. Память перед запросом: 14.739 MB Возвращено строк: 1
SELECT a.params
FROM kpstr_advancedmodules AS a
WHERE a.moduleid = 101id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:421 14 PlgSystemAdvancedModuleHelper->getAdvancedParamsById() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:284 13 PlgSystemAdvancedModuleHelper->setMirrorParams() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:103 12 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:366 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:499 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:791 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:565 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
36 типов запросов зарегистрировано (отсортировано по вхождениям)
Запросы типа SELECT:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kpstr_extensions`1 × SELECT `data`
FROM `kpstr_session`1 × SELECT *
FROM kpstr_jshopping_categories1 × SELECT a.mirror_id
FROM kpstr_advancedmodules AS a1 × 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 kpstr_modules AS m
LEFT JOIN kpstr_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN kpstr_advancedmodules as am
ON am.moduleid = m.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
FROM `kpstr_jshopping_products` AS prod
LEFT JOIN `kpstr_jshopping_products_to_categories` AS pr_cat USING (product_id)1 × SELECT count(*)
FROM `kpstr_jshopping_products_to_categories` AS pr_cat
INNER JOIN `kpstr_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id1 × SELECT tax_id, tax_name, tax_value
FROM `kpstr_jshopping_taxes1 × 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 `kpstr_jshopping_products_extra_fields` as F
left join `kpstr_jshopping_products_extra_field_groups` as G
on G.id=F.
group1 × SELECT *
FROM kpstr_jshopping_vendors1 × SELECT id
FROM kpstr_jshopping_vendors1 × select id,link
from kpstr_menu1 × 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
FROM `kpstr_jshopping_categories`1 × select *
from kpstr_jshopping_language1 × SELECT `session_id`
FROM `kpstr_session`1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `kpstr_jshopping_currencies`1 × SELECT *
FROM kpstr_jshopping_config1 × SELECT *
FROM kpstr_languages1 × SELECT id, home, template, s.params
FROM kpstr_template_styles as s
LEFT JOIN kpstr_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `kpstr_assets`1 × 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 kpstr_menu AS m
LEFT JOIN kpstr_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `params`
FROM `kpstr_extensions`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kpstr_extensions1 × SELECT b.id
FROM kpstr_usergroups AS a
LEFT JOIN kpstr_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `kpstr_viewlevels1 × SELECT a.params
FROM kpstr_advancedmodules AS a
Запросы типа OTHER:
1 × INSERT INTO `kpstr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6362396632383731396665346661363666653832386530386331316165393131', 1, 1696446037, 0, '', 01 × UPDATE `kpstr_extensions`
SET `params` = '{\"mediaversion\":\"42a9edb434f89d464203fe5cf53fdf54\"}'1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_config1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_currencies1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_categories1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_vendors1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_products_extra_fields1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_taxes1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_users1 × SHOW FULL COLUMNS
FROM `kpstr_jshopping_products_reviews