Найдем все.
Связаться с автором
Главная / Связаться с автором
Вы можете написать мне по любым вопросам, связанным с книгами, авторскими встречами или сотрудничеством.
Оставьте сообщение и свои контакты, я обязательно его прочту и отвечу.
Оставить заявку
Заполните заявку
Заполните заявку
Мы используем cookie для улучшения работы сайта.
Подробнее о cookies.
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1770380535,
"last": 1770380535,
"now": 1770380535
}
},
"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
}
},
"__vm": {
"vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"ru-RU\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}"
}
}
Время
Память
Время: 2.41 ms / 2.41 ms Память: 0.482 MB / 0.85 MB Application: afterLoad
Время: 13.26 ms / 15.67 ms Память: 0.924 MB / 1.77 MB Application: afterInitialise
Время: 3.29 ms / 18.96 ms Память: 0.509 MB / 2.28 MB Application: afterRoute
Время: 2.62 ms / 21.58 ms Память: 0.069 MB / 2.35 MB Application: beforeRenderComponent com_content
Время: 0.80 ms / 22.38 ms Память: 0.117 MB / 2.46 MB Application: Before Access::preloadComponents (all components)
Время: 0.66 ms / 23.04 ms Память: 0.045 MB / 2.51 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 23.07 ms Память: 0.000 MB / 2.51 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Время: 0.13 ms / 23.19 ms Память: 0.009 MB / 2.52 MB Application: After Access::getAssetRules (id:8 name:com_content)
Время: 6.85 ms / 30.04 ms Память: 0.335 MB / 2.85 MB Application: afterRenderComponent com_content
Время: 1.14 ms / 31.18 ms Память: 0.019 MB / 2.87 MB Application: afterDispatch
Время: 2.01 ms / 33.19 ms Память: 0.225 MB / 3.10 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.04 ms / 33.23 ms Память: 0.007 MB / 3.10 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 0.02 ms / 33.25 ms Память: 0.000 MB / 3.10 MB Application: Before Access::getAssetRules (id:88 name:com_virtuemart)
Время: 0.01 ms / 33.25 ms Память: 0.002 MB / 3.10 MB Application: After Access::getAssetRules (id:88 name:com_virtuemart)
Время: 2.62 ms / 35.87 ms Память: 0.316 MB / 3.42 MB Application: beforeRenderModule mod_menu (Мобильное (Верхнее меню))
Время: 1.86 ms / 37.73 ms Память: 0.070 MB / 3.49 MB Application: afterRenderModule mod_menu (Мобильное (Верхнее меню))
Время: 0.05 ms / 37.78 ms Память: 0.000 MB / 3.49 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.46 ms / 38.23 ms Память: 0.012 MB / 3.50 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.04 ms / 38.28 ms Память: 0.000 MB / 3.50 MB Application: beforeRenderModule mod_vm_cart (Корзина Virtuemart)
Время: 13.79 ms / 52.07 ms Память: 1.121 MB / 4.62 MB Application: afterRenderModule mod_vm_cart (Корзина Virtuemart)
Время: 0.05 ms / 52.12 ms Память: 0.000 MB / 4.61 MB Application: beforeRenderModule mod_menu (Верхнее меню)
Время: 0.33 ms / 52.46 ms Память: 0.005 MB / 4.62 MB Application: afterRenderModule mod_menu (Верхнее меню)
Время: 0.86 ms / 53.32 ms Память: 0.075 MB / 4.69 MB Application: afterRender
Всего SQL-запросов: 14.61 ms
5.22 MB (5 469 656 Байт)
37 SQL-запросов зафиксировано 14.61 ms
- Время запроса: 0.34 ms Память запроса: 0.003 MB Память до запроса: 1.139 MB
DELETE
FROM `j_session`
WHERE `time` < '1770379635'EXPLAIN не доступен для запроса: DELETE FROM `j_session` WHERE `time` < '1770379635'Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.05 ms Updating 0.07 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.02 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 6 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:824 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.24 ms После последнего запроса: 0.22 ms Память запроса: 0.023 MB Память до запроса: 1.147 MB Выбрано строк: 0
SELECT `data`
FROM `j_session`
WHERE `session_id` = 'b00115ab89c9e0fe47f67604dcc2123d'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_session const PRIMARY PRIMARY 575 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 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:831 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.20 ms После последнего запроса: 0.24 ms Память запроса: 0.019 MB Память до запроса: 1.162 MB Выбрано строк: 0
SELECT `session_id`
FROM `j_session`
WHERE `session_id` = 'b00115ab89c9e0fe47f67604dcc2123d'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_session const PRIMARY PRIMARY 575 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 7 JDatabaseDriver->loadResult() JROOT/libraries/src/Application/CMSApplication.php:178 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.25 ms После последнего запроса: 0.07 ms Память запроса: 0.003 MB Память до запроса: 1.166 MB
INSERT INTO `j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('b00115ab89c9e0fe47f67604dcc2123d', 1, '1770380535', 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b00115ab89c9e0fe47f67604dcc2123d', 1, '1770380535', 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.01 ms Update 0.07 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:218 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.44 ms После последнего запроса: 0.40 ms Память запроса: 0.024 MB Память до запроса: 1.262 MB Выбрано строк: 38
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_extensions ref extension extension 62 const 28 Using index condition Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.12 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:422 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:430 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:496 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:596 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 0.45 ms Память запроса: 0.021 MB Память до запроса: 1.293 MB Выбрано строк: 5
SELECT id, rules
FROM `j_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_viewlevels ALL NULL Индекс не используется NULL NULL 5 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 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:310 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.31 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB Память до запроса: 1.305 MB Выбрано строк: 2
SELECT b.id
FROM j_usergroups AS a
LEFT JOIN j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 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:310 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.60 ms После последнего запроса: 0.15 ms Память запроса: 0.030 MB Память до запроса: 1.327 MB Выбрано строк: 71
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_extensions ALL extension Индекс не используется NULL NULL 200 Using where; Используется filesort Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.25 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 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:348 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.17 ms После последнего запроса: 4.82 ms Память запроса: 0.116 MB Память до запроса: 1.799 MB Выбрано строк: 92
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 j_menu AS m
LEFT JOIN j_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 84 Using index condition; Using where; Используется filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 joomla.m.component_id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.82 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:76 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:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 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:64 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:551 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1146 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 1.99 ms Память запроса: 0.022 MB Память до запроса: 2.297 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using index condition Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.12 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Так же, как вызов в строке ниже. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 0.12 ms Память запроса: 0.005 MB Память до запроса: 2.287 MB
UPDATE `j_extensions`
SET `params` = '{\"mediaversion\":\"901a4b9fb2272fee7b6794540eef96c5\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `j_extensions` SET `params` = '{\"mediaversion\":\"901a4b9fb2272fee7b6794540eef96c5\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.12 ms Updating 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.32 ms Память запроса: 0.019 MB Память до запроса: 2.320 MB Выбрано строк: 1
SELECT *
FROM j_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_languages ALL NULL Индекс не используется NULL NULL 2 Using where; Используется filesort Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.35 ms После последнего запроса: 0.18 ms Память запроса: 0.019 MB Память до запроса: 2.332 MB Выбрано строк: 1
SELECT id, home, template, s.params
FROM j_template_styles as s
LEFT JOIN j_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template Индекс не используется NULL NULL 2 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 joomla.s.template,const 1 Using index condition; Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.49 ms После последнего запроса: 1.35 ms Память запроса: 0.027 MB Память до запроса: 2.468 MB Выбрано строк: 32
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_istmedia_forms','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_assets range idx_asset_name idx_asset_name 152 NULL 35 Using index condition Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 0.39 ms Память запроса: 0.031 MB Память до запроса: 2.519 MB Выбрано строк: 30
SHOW FULL COLUMNS
FROM `j_content`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `j_content`Status Duration Starting 0.02 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.26 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.07 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.07 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.56 ms Память запроса: 0.022 MB Память до запроса: 2.570 MB Выбрано строк: 1
SELECT *
FROM j_content
WHERE `id` = '103'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.23 ms После последнего запроса: 0.10 ms Память запроса: 0.006 MB Память до запроса: 2.578 MB
UPDATE j_content
SET `hits` = (`hits` + 1)
WHERE `id` = '103'EXPLAIN не доступен для запроса: UPDATE j_content SET `hits` = (`hits` + 1) WHERE `id` = '103'Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.03 ms Updating 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1241 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.47 ms После последнего запроса: 0.35 ms Память запроса: 0.023 MB Память до запроса: 2.603 MB Выбрано строк: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM j_content AS a
INNER JOIN j_categories AS c
on c.id = a.catid
LEFT JOIN j_users AS u
on u.id = a.created_by
LEFT JOIN j_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 103
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-06 12:22:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-06 12:22:15')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v system PRIMARY Индекс не используется NULL NULL 0 Const row not found 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.10 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.31 ms После последнего запроса: 0.66 ms Память запроса: 0.022 MB Память до запроса: 2.704 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `j_contentitem_tag_map` AS m
INNER JOIN `j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 103
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:180 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.49 ms После последнего запроса: 0.73 ms Память запроса: 0.026 MB Память до запроса: 2.750 MB Выбрано строк: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM j_categories as c
LEFT JOIN j_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right Индекс не используется NULL NULL 23 Using where; Используется filesort Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:197 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.51 ms После последнего запроса: 0.20 ms Память запроса: 0.025 MB Память до запроса: 2.771 MB Выбрано строк: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM j_fields AS a
LEFT JOIN `j_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `j_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE g system PRIMARY,idx_state,idx_access Индекс не используется NULL NULL 0 Const row not found 1 SIMPLE fc system PRIMARY Индекс не используется NULL NULL 0 Const row not found 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 joomla.a.language 1 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 joomla.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 joomla.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 joomla.a.created_user_id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.03 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.27 ms После последнего запроса: 0.79 ms Память запроса: 0.023 MB Память до запроса: 2.888 MB Выбрано строк: 1
SELECT introtext
FROM j_content
WHERE alias = 'email'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_content ref idx_alias idx_alias 575 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 14 JDatabaseDriver->loadAssoc() JROOT/templates/jblank/html/com_content/article/default.php:150 13 include JROOT/templates/jblank/html/com_content/article/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_content/views/article/view.html.php:207 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.54 ms После последнего запроса: 2.19 ms Память запроса: 0.021 MB Память до запроса: 3.042 MB Выбрано строк: 1
SHOW TABLES LIKE "j_virtuemart_configs"
EXPLAIN не доступен для запроса: SHOW TABLES LIKE "j_virtuemart_configs"Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms checking permissions 0.28 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701 10 VmTable::checkTableExists() JROOT/administrator/components/com_virtuemart/models/config.php:571 9 VirtueMartModelConfig::checkConfigTableExists() JROOT/administrator/components/com_virtuemart/helpers/config.php:932 8 VmConfig::loadConfig() JROOT/plugins/system/plg_sj_vm_quickview/plg_sj_vm_quickview.php:45 7 plgSystemPlg_Sj_Vm_QuickView->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1107 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 0.05 ms Память запроса: 0.020 MB Память до запроса: 3.048 MB Выбрано строк: 1
SELECT `config`
FROM `j_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_configs system PRIMARY Индекс не используется NULL NULL 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 9 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/config.php:980 8 VmConfig::loadConfig() JROOT/plugins/system/plg_sj_vm_quickview/plg_sj_vm_quickview.php:45 7 plgSystemPlg_Sj_Vm_QuickView->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1107 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.74 ms После последнего запроса: 2.01 ms Память запроса: 0.025 MB Память до запроса: 3.399 MB Выбрано строк: 23
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j_modules AS m
LEFT JOIN j_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-02-06 12:22:15')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-06 12:22:15')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 258 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 25 Using index condition; Using where; Используется filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 joomla.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 joomla.m.module,const 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.33 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() Так же, как вызов в строке ниже. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.46 ms После последнего запроса: 1.04 ms Память запроса: 0.027 MB Память до запроса: 3.467 MB Выбрано строк: 2
SELECT *
FROM `j_menu`
WHERE `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "ru-RU" )
AND ( access="1" OR access="5" )
ORDER BY `language` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_menu ALL idx_client_id_parent_id_alias_language,idx_language Индекс не используется NULL NULL 151 Using where; Используется filesort Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.11 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 22 JDatabaseDriver->loadObjectList() JROOT/components/com_virtuemart/router.php:1264 21 vmrouterHelper->setMenuItemId() JROOT/components/com_virtuemart/router.php:850 20 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:879 19 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:27 18 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 17 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 16 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 15 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_menu/helper.php:127 11 ModMenuHelper::getList() JROOT/modules/mod_menu/mod_menu.php:15 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.31 ms После последнего запроса: 1.74 ms Память запроса: 0.024 MB Память до запроса: 3.658 MB Выбрано строк: 1
SELECT *
FROM `j_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_shoppergroups ALL virtuemart_vendor_id,shared,published Индекс не используется NULL NULL 4 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 16 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102 15 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 14 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:163 13 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 12 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:132 11 VirtueMartCart::getCart() JROOT/modules/mod_vm_cart/mod_vm_cart.php:146 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.14 ms Память запроса: 0.025 MB Память до запроса: 3.686 MB Выбрано строк: 1
SELECT `j_virtuemart_shoppergroups`.*
FROM `j_virtuemart_shoppergroups`
WHERE `j_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_shoppergroups const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 19 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020 18 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031 17 VmModel->getData() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52 16 VirtueMartModelShopperGroup->getShopperGroup() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107 15 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 14 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:163 13 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 12 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:132 11 VirtueMartCart::getCart() JROOT/modules/mod_vm_cart/mod_vm_cart.php:146 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.31 ms После последнего запроса: 1.07 ms Память запроса: 0.026 MB Память до запроса: 3.877 MB Выбрано строк: 1
SELECT *
FROM `j_virtuemart_currencies` AS c
LEFT JOIN `j_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v system PRIMARY,vendor_currency Индекс не используется NULL NULL 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 19 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/vendor.php:264 18 VirtueMartModelVendor::getVendorCurrency() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 17 CurrencyDisplay->__construct() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103 16 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.26 ms После последнего запроса: 0.23 ms Память запроса: 0.025 MB Память до запроса: 3.916 MB Выбрано строк: 1
SELECT `j_virtuemart_currencies`.*
FROM `j_virtuemart_currencies`
WHERE `j_virtuemart_currencies`.`virtuemart_currency_id` = "131"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_currencies const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 19 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020 18 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031 17 VmModel->getData() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119 16 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 0.27 ms Память запроса: 0.036 MB Память до запроса: 3.958 MB Выбрано строк: 31
SHOW FULL COLUMNS
FROM `j_virtuemart_userfields`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `j_virtuemart_userfields`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.25 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.07 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.08 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 26 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:662 25 VmTable->showFullColumns() JROOT/administrator/components/com_virtuemart/tables/userfields.php:43 24 TableUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:219 23 VmTable::getInstance() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434 22 VmModel->_createTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396 21 VmModel->getTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602 20 VmModel->setMainTable() JROOT/administrator/components/com_virtuemart/models/userfields.php:52 19 VirtueMartModelUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554 18 VmModel::getModel() JROOT/components/com_virtuemart/helpers/cart.php:254 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 0.13 ms Память запроса: 0.028 MB Память до запроса: 3.997 MB Выбрано строк: 5
SELECT *
FROM `j_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_userfields ALL published,account Индекс не используется NULL NULL 28 Using where; Используется filesort Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 20 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:619 19 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:501 18 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:265 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.34 ms После последнего запроса: 0.14 ms Память запроса: 0.029 MB Память до запроса: 4.029 MB Выбрано строк: 4
SELECT *
FROM `j_virtuemart_userfields`
WHERE 1 = 1
AND `shipment`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_userfields ALL published,shipment Индекс не используется NULL NULL 28 Using where; Используется filesort Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 20 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:619 19 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:507 18 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:265 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.33 ms После последнего запроса: 0.26 ms Память запроса: 0.024 MB Память до запроса: 4.075 MB Выбрано строк: 0
SELECT c.*
FROM j_virtuemart_calcs as c
LEFT JOIN j_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id
WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-02-06 12:22:15" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:22:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 17 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172 16 calculationHelper->setVendorId() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.31 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB Память до запроса: 4.086 MB Выбрано строк: 0
SELECT *
FROM j_virtuemart_calcs
LEFT JOIN j_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-02-06 12:22:15" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:22:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 15 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:740 14 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1533 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.27 ms После последнего запроса: 0.06 ms Память запроса: 0.024 MB Память до запроса: 4.095 MB Выбрано строк: 0
SELECT *
FROM j_virtuemart_calcs
LEFT JOIN j_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-02-06 12:22:15" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:22:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 15 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:741 14 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1533 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.26 ms После последнего запроса: 0.04 ms Память запроса: 0.024 MB Память до запроса: 4.104 MB Выбрано строк: 0
SELECT *
FROM j_virtuemart_calcs
LEFT JOIN j_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-02-06 12:22:15" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:22:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 15 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:742 14 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1533 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1756 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_vm_cart/mod_vm_cart.php:156 10 include JROOT/modules/mod_vm_cart/mod_vm_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
33 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
3 × SELECT *
FROM j_virtuemart_calcs
LEFT JOIN j_virtuemart_calc_shoppergroups using(virtuemart_calc_id)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j_extensions`2 × SELECT *
FROM `j_virtuemart_userfields`1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM j_fields AS a
LEFT JOIN `j_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `j_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT c.*
FROM j_virtuemart_calcs as c
LEFT JOIN j_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id1 × SELECT `j_virtuemart_currencies`.*
FROM `j_virtuemart_currencies`1 × SELECT *
FROM `j_virtuemart_currencies` AS c
LEFT JOIN `j_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency1 × SELECT `j_virtuemart_shoppergroups`.*
FROM `j_virtuemart_shoppergroups`1 × SELECT *
FROM `j_virtuemart_shoppergroups`1 × SELECT *
FROM `j_menu`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j_modules AS m
LEFT JOIN j_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `config`
FROM `j_virtuemart_configs`1 × SELECT introtext
FROM j_content1 × SELECT `data`
FROM `j_session`1 × SELECT `session_id`
FROM `j_session`1 × SELECT `m`.`tag_id`,`t`.*
FROM `j_contentitem_tag_map` AS m
INNER JOIN `j_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM j_content AS a
INNER JOIN j_categories AS c
on c.id = a.catid
LEFT JOIN j_users AS u
on u.id = a.created_by
LEFT JOIN j_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM j_content1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `j_assets`1 × SELECT id, home, template, s.params
FROM j_template_styles as s
LEFT JOIN j_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM j_languages1 × 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 j_menu AS m
LEFT JOIN j_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j_extensions1 × SELECT b.id
FROM j_usergroups AS a
LEFT JOIN j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `j_viewlevels1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM j_categories as c
LEFT JOIN j_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
Прочие SQL-запросы:
1 × DELETE
FROM `j_session`1 × INSERT INTO `j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('b00115ab89c9e0fe47f67604dcc2123d', 1, '1770380535', 0, '', 01 × UPDATE `j_extensions`
SET `params` = '{\"mediaversion\":\"901a4b9fb2272fee7b6794540eef96c5\"}'1 × SHOW FULL COLUMNS
FROM `j_content1 × UPDATE j_content
SET `hits` = (`hits` + 1)1 × SHOW TABLES LIKE "j_virtuemart_configs
1 × SHOW FULL COLUMNS
FROM `j_virtuemart_userfields