Найдем все.
Оставить заявку
Заполните заявку
Заполните заявку
Мы используем cookie для улучшения работы сайта.
Подробнее о cookies.
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1770380607,
"last": 1770380607,
"now": 1770380607
},
"token": "2TCZztX7V7PN94fdxM7PQpHqMCEr4ECI"
},
"registry": {
"com_virtuemart": {
"cart": {
"limitstart": 0
}
}
},
"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": {
"manage": 0,
"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\":\"131\",\"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}"
}
}
Время
Память
Время: 1.43 ms / 1.43 ms Память: 0.482 MB / 0.85 MB Application: afterLoad
Время: 14.27 ms / 15.71 ms Память: 0.931 MB / 1.78 MB Application: afterInitialise
Время: 6.14 ms / 21.85 ms Память: 0.678 MB / 2.45 MB Application: Before Access::preloadComponents (all components)
Время: 0.76 ms / 22.61 ms Память: 0.046 MB / 2.50 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 22.64 ms Память: 0.000 MB / 2.50 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.13 ms / 22.77 ms Память: 0.009 MB / 2.51 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 0.02 ms / 22.79 ms Память: 0.001 MB / 2.51 MB Application: Before Access::getAssetRules (id:88 name:com_virtuemart)
Время: 0.01 ms / 22.81 ms Память: 0.002 MB / 2.51 MB Application: After Access::getAssetRules (id:88 name:com_virtuemart)
Время: 2.45 ms / 25.25 ms Память: 0.133 MB / 2.64 MB Application: afterRoute
Время: 1.67 ms / 26.93 ms Память: 0.052 MB / 2.69 MB Application: beforeRenderComponent com_virtuemart
Время: 32.84 ms / 59.77 ms Память: 1.883 MB / 4.58 MB Application: afterRenderComponent com_virtuemart
Время: 0.45 ms / 60.22 ms Память: 0.009 MB / 4.59 MB Application: afterDispatch
Время: 2.05 ms / 62.26 ms Память: 0.108 MB / 4.69 MB Application: beforeRenderModule mod_menu (Мобильное (Верхнее меню))
Время: 1.35 ms / 63.61 ms Память: 0.055 MB / 4.75 MB Application: afterRenderModule mod_menu (Мобильное (Верхнее меню))
Время: 0.06 ms / 63.67 ms Память: 0.000 MB / 4.75 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.99 ms / 64.66 ms Память: 0.021 MB / 4.77 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.06 ms / 64.72 ms Память: 0.000 MB / 4.76 MB Application: beforeRenderModule mod_vm_cart (Корзина Virtuemart)
Время: 0.53 ms / 65.25 ms Память: 0.017 MB / 4.78 MB Application: afterRenderModule mod_vm_cart (Корзина Virtuemart)
Время: 0.05 ms / 65.31 ms Память: 0.000 MB / 4.78 MB Application: beforeRenderModule mod_menu (Верхнее меню)
Время: 0.42 ms / 65.72 ms Память: 0.005 MB / 4.78 MB Application: afterRenderModule mod_menu (Верхнее меню)
Время: 0.95 ms / 66.67 ms Память: 0.102 MB / 4.89 MB Application: afterRender
Всего SQL-запросов: 21.54 ms
5.58 MB (5 845 896 Байт)
50 SQL-запросов зафиксировано 21.54 ms
- Время запроса: 0.32 ms Память запроса: 0.003 MB Память до запроса: 1.139 MBПовторяющиеся запросы: #3
DELETE
FROM `j_session`
WHERE `time` < '1770379707'EXPLAIN не доступен для запроса: DELETE FROM `j_session` WHERE `time` < '1770379707'Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init for update 0.06 ms Updating 0.04 ms End of update loop 0.01 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 # Вызывающий объект Файл и номер строки 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.21 ms После последнего запроса: 0.16 ms Память запроса: 0.023 MB Память до запроса: 1.147 MB Выбрано строк: 0Повторяющиеся запросы: #32
SELECT `data`
FROM `j_session`
WHERE `session_id` = '89dd86dc06ad1603b79211ff4a980d16'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.02 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.15 ms После последнего запроса: 0.06 ms Память запроса: 0.006 MB Память до запроса: 1.154 MBПовторяющиеся запросы: #1
DELETE
FROM `j_session`
WHERE `time` < '1770379707'EXPLAIN не доступен для запроса: DELETE FROM `j_session` WHERE `time` < '1770379707'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 for update 0.02 ms Updating 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.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/session/storage/database.php:156 14 JSessionStorageDatabase->gc() Так же, как вызов в строке ниже. 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.18 ms После последнего запроса: 0.25 ms Память запроса: 0.019 MB Память до запроса: 1.168 MB Выбрано строк: 0
SELECT `session_id`
FROM `j_session`
WHERE `session_id` = '89dd86dc06ad1603b79211ff4a980d16'
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.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.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.20 ms После последнего запроса: 0.07 ms Память запроса: 0.003 MB Память до запроса: 1.173 MB
INSERT INTO `j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('89dd86dc06ad1603b79211ff4a980d16', 1, '1770380607', 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('89dd86dc06ad1603b79211ff4a980d16', 1, '1770380607', 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.05 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.02 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.50 ms После последнего запроса: 0.29 ms Память запроса: 0.024 MB Память до запроса: 1.268 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.06 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.18 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: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.35 ms Память запроса: 0.021 MB Память до запроса: 1.300 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.01 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.04 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.30 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB Память до запроса: 1.312 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.05 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.01 ms Updating status 0.02 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.74 ms После последнего запроса: 0.13 ms Память запроса: 0.030 MB Память до запроса: 1.334 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.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.06 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.40 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.82 ms Reset for next command 0.01 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.62 ms После последнего запроса: 7.14 ms Память запроса: 0.116 MB Память до запроса: 1.806 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.09 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 1.06 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.01 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.71 ms После последнего запроса: 2.55 ms Память запроса: 0.023 MB Память до запроса: 2.384 MB Выбрано строк: 1
SHOW TABLES LIKE "j_virtuemart_configs"
EXPLAIN не доступен для запроса: SHOW TABLES LIKE "j_virtuemart_configs"Status Duration Starting 0.03 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms checking permissions 0.45 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.13 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701 14 VmTable::checkTableExists() JROOT/administrator/components/com_virtuemart/models/config.php:571 13 VirtueMartModelConfig::checkConfigTableExists() JROOT/administrator/components/com_virtuemart/helpers/config.php:932 12 VmConfig::loadConfig() JROOT/components/com_virtuemart/router.php:874 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:362 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 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.22 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 2.391 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.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.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.40 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/config.php:980 12 VmConfig::loadConfig() JROOT/components/com_virtuemart/router.php:874 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:362 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 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.26 ms После последнего запроса: 0.34 ms Память запроса: 0.024 MB Память до запроса: 2.443 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.01 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.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms 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 # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 15 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:87 14 vmLanguage::setLanguageByTag() JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:53 13 vmLanguage::initialise() JROOT/administrator/components/com_virtuemart/helpers/config.php:1001 12 VmConfig::loadConfig() JROOT/components/com_virtuemart/router.php:874 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:362 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 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.57 ms После последнего запроса: 0.18 ms Память запроса: 0.027 MB Память до запроса: 2.459 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.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.05 ms Optimizing 0.01 ms Statistics 0.09 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.23 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.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_virtuemart/helpers/config.php:1341 14 vmAccess::manager() JROOT/administrator/components/com_virtuemart/helpers/config.php:645 13 VmConfig::echoAdmin() JROOT/administrator/components/com_virtuemart/helpers/config.php:1002 12 VmConfig::loadConfig() JROOT/components/com_virtuemart/router.php:874 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:362 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 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.41 ms После последнего запроса: 1.15 ms Память запроса: 0.022 MB Память до запроса: 2.622 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.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.07 ms Preparing 0.02 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 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:1691 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 13 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/components/com_virtuemart/router.php:832 12 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:879 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:362 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 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.35 ms После последнего запроса: 0.11 ms Память запроса: 0.022 MB Память до запроса: 2.627 MB Выбрано строк: 1
SELECT `id`
FROM `j_menu`
WHERE `home`="1"
and (language="*" or language = "ru-RU" )
ORDER BY `language` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_menu ALL idx_language Индекс не используется NULL NULL 151 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.04 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 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.15 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 13 JDatabaseDriver->loadResult() JROOT/components/com_virtuemart/router.php:843 12 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:879 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:362 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 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.49 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB Память до запроса: 2.636 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.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.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.16 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.40 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/components/com_virtuemart/router.php:1264 13 vmrouterHelper->setMenuItemId() JROOT/components/com_virtuemart/router.php:850 12 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:879 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:362 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 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.38 ms После последнего запроса: 0.29 ms Память запроса: 0.022 MB Память до запроса: 2.666 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.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.15 ms Preparing 0.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.32 ms После последнего запроса: 0.13 ms Память запроса: 0.005 MB Память до запроса: 2.656 MB
UPDATE `j_extensions`
SET `params` = '{\"mediaversion\":\"d9c4802f5632d587433afeff2d4c340f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `j_extensions` SET `params` = '{\"mediaversion\":\"d9c4802f5632d587433afeff2d4c340f\"}' 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.06 ms End of update loop 0.01 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.02 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.35 ms После последнего запроса: 4.43 ms Память запроса: 0.023 MB Память до запроса: 3.141 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.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.04 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/administrator/components/com_virtuemart/models/shoppergroup.php:102 13 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 12 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:163 11 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 10 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:132 9 VirtueMartCart::getCart() JROOT/components/com_virtuemart/controllers/cart.php:83 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.21 ms После последнего запроса: 0.12 ms Память запроса: 0.025 MB Память до запроса: 3.168 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.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 17 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020 16 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031 15 VmModel->getData() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52 14 VirtueMartModelShopperGroup->getShopperGroup() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107 13 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 12 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:163 11 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 10 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:132 9 VirtueMartCart::getCart() JROOT/components/com_virtuemart/controllers/cart.php:83 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.37 ms После последнего запроса: 1.16 ms Память запроса: 0.025 MB Память до запроса: 3.282 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.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.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms 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.36 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 16 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/vendor.php:264 15 VirtueMartModelVendor::getVendorCurrency() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 14 CurrencyDisplay->__construct() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103 13 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 12 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 11 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.25 ms После последнего запроса: 0.25 ms Память запроса: 0.024 MB Память до запроса: 3.382 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.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.02 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.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020 15 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031 14 VmModel->getData() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119 13 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 12 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 11 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.84 ms После последнего запроса: 0.33 ms Память запроса: 0.035 MB Память до запроса: 3.424 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.34 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.11 ms closing tables 0.00 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.10 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 23 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:662 22 VmTable->showFullColumns() JROOT/administrator/components/com_virtuemart/tables/userfields.php:43 21 TableUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:219 20 VmTable::getInstance() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434 19 VmModel->_createTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396 18 VmModel->getTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602 17 VmModel->setMainTable() JROOT/administrator/components/com_virtuemart/models/userfields.php:52 16 VirtueMartModelUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554 15 VmModel::getModel() JROOT/components/com_virtuemart/helpers/cart.php:254 14 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 13 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 12 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 11 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.39 ms После последнего запроса: 0.17 ms Память запроса: 0.027 MB Память до запроса: 3.461 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.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.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.07 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.25 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 17 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:619 16 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:501 15 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:265 14 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 13 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 12 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 11 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.35 ms После последнего запроса: 0.15 ms Память запроса: 0.027 MB Память до запроса: 3.486 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.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.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 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 # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 17 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:619 16 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:507 15 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:265 14 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 13 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 12 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 11 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.38 ms После последнего запроса: 0.27 ms Память запроса: 0.023 MB Память до запроса: 3.529 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:23:27" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:23:27" )
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.08 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.04 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.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 14 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172 13 calculationHelper->setVendorId() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91 12 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 11 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1529 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.30 ms После последнего запроса: 0.07 ms Память запроса: 0.022 MB Память до запроса: 3.539 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:23:27" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:23:27" )
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.04 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.14 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 13 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 12 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:740 11 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1533 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.05 ms Память запроса: 0.022 MB Память до запроса: 3.546 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:23:27" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:23:27" )
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.04 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 # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 13 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 12 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:741 11 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1533 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.25 ms После последнего запроса: 0.04 ms Память запроса: 0.022 MB Память до запроса: 3.553 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:23:27" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-02-06 12:23:27" )
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.04 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.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 13 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 12 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:742 11 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1533 10 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1632 9 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/controllers/cart.php:87 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.33 ms После последнего запроса: 8.27 ms Память запроса: 0.006 MB Память до запроса: 4.077 MB
UPDATE `j_session`
SET `data` = '' , `time` = '1770380607'
WHERE `session_id` = '89dd86dc06ad1603b79211ff4a980d16'EXPLAIN не доступен для запроса: UPDATE `j_session` SET `data` = '' , `time` = '1770380607' WHERE `session_id` = '89dd86dc06ad1603b79211ff4a980d16'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.04 ms Updating 0.06 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.15 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/session/storage/database.php:84 12 JSessionStorageDatabase->write() Так же, как вызов в строке ниже. 11 session_write_close() JROOT/components/com_virtuemart/helpers/cart.php:379 10 VirtueMartCart->setCartIntoSession() JROOT/components/com_virtuemart/helpers/cart.php:958 9 VirtueMartCart->checkoutData() JROOT/components/com_virtuemart/controllers/cart.php:130 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.20 ms После последнего запроса: 0.08 ms Память запроса: 0.022 MB Память до запроса: 4.083 MB Выбрано строк: 1Повторяющиеся запросы: #2
SELECT `data`
FROM `j_session`
WHERE `session_id` = '89dd86dc06ad1603b79211ff4a980d16'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.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.02 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 12 JSessionStorageDatabase->read() Так же, как вызов в строке ниже. 11 session_start() JROOT/components/com_virtuemart/helpers/cart.php:380 10 VirtueMartCart->setCartIntoSession() JROOT/components/com_virtuemart/helpers/cart.php:958 9 VirtueMartCart->checkoutData() JROOT/components/com_virtuemart/controllers/cart.php:130 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.35 ms После последнего запроса: 0.13 ms Память запроса: 0.024 MB Память до запроса: 4.113 MB Выбрано строк: 1
SELECT `j_virtuemart_vendors`.* ,`j_virtuemart_vendors_ru_ru`.*
FROM `j_virtuemart_vendors`
INNER JOIN `j_virtuemart_vendors_ru_ru` using (`virtuemart_vendor_id`)
WHERE `j_virtuemart_vendors`.`virtuemart_vendor_id` = "1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_vendors system PRIMARY Индекс не используется NULL NULL 1 1 SIMPLE j_virtuemart_vendors_ru_ru system PRIMARY Индекс не используется NULL NULL 1 Status Duration Starting 0.03 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.01 ms init 0.04 ms Optimizing 0.02 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.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/vendor.php:86 12 VirtueMartModelVendor->getVendor() JROOT/components/com_virtuemart/helpers/cart.php:1552 11 VirtueMartCart->prepareVendor() JROOT/components/com_virtuemart/helpers/cart.php:1135 10 VirtueMartCart->checkPurchaseValue() JROOT/components/com_virtuemart/helpers/cart.php:961 9 VirtueMartCart->checkoutData() JROOT/components/com_virtuemart/controllers/cart.php:130 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.32 ms Память запроса: 0.023 MB Память до запроса: 4.154 MB Выбрано строк: 1
SELECT `virtuemart_media_id`
FROM `j_virtuemart_vendor_medias`
WHERE `virtuemart_vendor_id` = "1"
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_vendor_medias system virtuemart_vendor_id Индекс не используется NULL NULL 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.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.03 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.28 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 14 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 13 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/vendor.php:97 12 VirtueMartModelVendor->getVendor() JROOT/components/com_virtuemart/helpers/cart.php:1552 11 VirtueMartCart->prepareVendor() JROOT/components/com_virtuemart/helpers/cart.php:1135 10 VirtueMartCart->checkPurchaseValue() JROOT/components/com_virtuemart/helpers/cart.php:961 9 VirtueMartCart->checkoutData() JROOT/components/com_virtuemart/controllers/cart.php:130 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.21 ms Память запроса: 0.024 MB Память до запроса: 4.183 MB Выбрано строк: 1
SELECT `j_virtuemart_medias`.*
FROM `j_virtuemart_medias`
WHERE `j_virtuemart_medias`.`virtuemart_media_id` = "1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_medias const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.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.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.02 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020 15 VmTable->load() JROOT/administrator/components/com_virtuemart/models/media.php:98 14 VirtueMartModelMedia->createMediaByIds() JROOT/administrator/components/com_virtuemart/models/media.php:421 13 VirtueMartModelMedia->attachImages() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1196 12 VmModel->addImages() JROOT/components/com_virtuemart/helpers/cart.php:1553 11 VirtueMartCart->prepareVendor() JROOT/components/com_virtuemart/helpers/cart.php:1135 10 VirtueMartCart->checkPurchaseValue() JROOT/components/com_virtuemart/helpers/cart.php:961 9 VirtueMartCart->checkoutData() JROOT/components/com_virtuemart/controllers/cart.php:130 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.58 ms После последнего запроса: 0.76 ms Память запроса: 0.025 MB Память до запроса: 4.289 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
WHERE a.context = 'com_virtuemart.vendor'
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 a ref|filter idx_state,idx_access,idx_context idx_state|idx_context 1|575 const 1 (50%) Using where; Используется filesort; Using rowid filter 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.10 ms checking permissions 0.00 ms Opening tables 0.05 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.04 ms Sorting result 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.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:887 12 shopFunctionsF::triggerContentPlugin() JROOT/components/com_virtuemart/helpers/cart.php:1555 11 VirtueMartCart->prepareVendor() JROOT/components/com_virtuemart/helpers/cart.php:1135 10 VirtueMartCart->checkPurchaseValue() JROOT/components/com_virtuemart/helpers/cart.php:961 9 VirtueMartCart->checkoutData() JROOT/components/com_virtuemart/controllers/cart.php:130 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.40 ms После последнего запроса: 0.33 ms Память запроса: 0.023 MB Память до запроса: 4.303 MB Выбрано строк: 1
SELECT *
FROM `j_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND required = 1
AND type != 'delimiter'
AND type != 'captcha'
AND FIND_IN_SET(name, 'delimiter_userinfo,name,username,password,password2,address_type_name,address_type,user_is_vendor,agreed') = 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.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.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.06 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.66 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 13 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:619 12 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/user.php:789 11 VirtueMartModelUser->validateUserData() JROOT/components/com_virtuemart/helpers/cart.php:1160 10 VirtueMartCart->validateUserData() JROOT/components/com_virtuemart/helpers/cart.php:966 9 VirtueMartCart->checkoutData() JROOT/components/com_virtuemart/controllers/cart.php:130 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.41 ms После последнего запроса: 0.55 ms Память запроса: 0.022 MB Память до запроса: 4.325 MB Выбрано строк: 1
SELECT *
FROM `j_virtuemart_userfields`
WHERE 1 = 1
AND `cart`="1"
AND published = 1
AND type != 'delimiter'
AND type != 'captcha'
AND FIND_IN_SET(name, 'delimiter_userinfo,user_is_vendor,username,password,password2,agreed,address_type') = 0
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j_virtuemart_userfields ref published,cart cart 1 const 4 Using where; Используется filesort 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.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.06 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 # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 11 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:619 10 VirtueMartModelUserfields->getUserFields() JROOT/components/com_virtuemart/views/cart/view.html.php:104 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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 - Время запроса: 1.13 ms После последнего запроса: 0.25 ms Память запроса: 0.023 MB Память до запроса: 4.347 MB Выбрано строк: 0
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc
FROM j_virtuemart_paymentmethods as i
LEFT JOIN `j_virtuemart_paymentmethods_ru_ru` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
LEFT JOIN `j_extensions` as j
ON j.`extension_id` = i.`payment_jplugin_id`
LEFT
OUTER JOIN `j_virtuemart_paymentmethod_shoppergroups` AS s
ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE i.`published` = "1"
AND j.`element` = "paypal"
AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY i.`virtuemart_paymentmethod_id`
ORDER BY i.`ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s system virtuemart_paymentmethod_id Индекс не используется NULL NULL 0 Const row not found; Using temporary; Используется filesort 1 SIMPLE j ref PRIMARY,element_clientid,element_folder_clientid element_clientid 302 const 1 Using index condition 1 SIMPLE i ALL payment_jplugin_id,virtuemart_vendor_id Индекс не используется NULL NULL 3 Using where; Using join buffer (flat, BNL join) 1 SIMPLE l eq_ref PRIMARY PRIMARY 4 joomla.i.virtuemart_paymentmethod_id 1 Status Duration Starting 0.09 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.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.42 ms Creating sort index 0.03 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526 14 vmPSPlugin->getPluginMethods() JROOT/plugins/vmpayment/paypal/paypal.php:312 13 plgVmPaymentPaypal->plgVmOnCheckoutAdvertise() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_virtuemart/helpers/cart.php:1657 10 VirtueMartCart->getCheckoutAdvertise() JROOT/components/com_virtuemart/views/cart/view.html.php:124 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.36 ms После последнего запроса: 0.34 ms Память запроса: 0.023 MB Память до запроса: 4.376 MB Выбрано строк: 2
SELECT SQL_CALC_FOUND_ROWS i.*, l.shipment_name, l.shipment_desc
FROM `j_virtuemart_shipmentmethods` as i
LEFT JOIN `j_virtuemart_shipmentmethods_ru_ru` as l
ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
ORDER BY i.ordering DESC
LIMIT 0, 21id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i ALL NULL Индекс не используется NULL NULL 2 Используется filesort 1 SIMPLE l eq_ref PRIMARY PRIMARY 4 joomla.i.virtuemart_shipmentmethod_id 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.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 # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859 13 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:142 12 VirtueMartModelShipmentmethod->getShipments() JROOT/components/com_virtuemart/views/cart/view.html.php:406 11 VirtueMartViewCart->checkShipmentMethodsConfigured() JROOT/components/com_virtuemart/views/cart/view.html.php:256 10 VirtueMartViewCart->lSelectShipment() JROOT/components/com_virtuemart/views/cart/view.html.php:156 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.11 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 4.387 MB Выбрано строк: 1Повторяющиеся запросы: #46
SELECT FOUND_ROWS()
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL No tables used Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms init 0.01 ms Optimizing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 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 # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:868 13 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:142 12 VirtueMartModelShipmentmethod->getShipments() JROOT/components/com_virtuemart/views/cart/view.html.php:406 11 VirtueMartViewCart->checkShipmentMethodsConfigured() JROOT/components/com_virtuemart/views/cart/view.html.php:256 10 VirtueMartViewCart->lSelectShipment() JROOT/components/com_virtuemart/views/cart/view.html.php:156 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.14 ms После последнего запроса: 0.03 ms Память запроса: 0.022 MB Память до запроса: 4.394 MB Выбрано строк: 0
SELECT `virtuemart_shoppergroup_id`
FROM j_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "2"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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.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 # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 13 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:151 12 VirtueMartModelShipmentmethod->getShipments() JROOT/components/com_virtuemart/views/cart/view.html.php:406 11 VirtueMartViewCart->checkShipmentMethodsConfigured() JROOT/components/com_virtuemart/views/cart/view.html.php:256 10 VirtueMartViewCart->lSelectShipment() JROOT/components/com_virtuemart/views/cart/view.html.php:156 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.12 ms После последнего запроса: 0.03 ms Память запроса: 0.022 MB Память до запроса: 4.400 MB Выбрано строк: 0
SELECT `virtuemart_shoppergroup_id`
FROM j_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "3"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.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.00 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.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 13 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:151 12 VirtueMartModelShipmentmethod->getShipments() JROOT/components/com_virtuemart/views/cart/view.html.php:406 11 VirtueMartViewCart->checkShipmentMethodsConfigured() JROOT/components/com_virtuemart/views/cart/view.html.php:256 10 VirtueMartViewCart->lSelectShipment() JROOT/components/com_virtuemart/views/cart/view.html.php:156 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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 - Время запроса: 1.16 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 4.411 MB Выбрано строк: 2
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc
FROM j_virtuemart_shipmentmethods as i
LEFT JOIN `j_virtuemart_shipmentmethods_ru_ru` as l
ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `j_extensions` as j
ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT
OUTER JOIN `j_virtuemart_shipmentmethod_shoppergroups` AS s
ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
WHERE i.`published` = "1"
AND j.`element` = "weight_countries"
AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY i.`virtuemart_shipmentmethod_id`
ORDER BY i.`ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s system virtuemart_shipmentmethod_id Индекс не используется NULL NULL 0 Const row not found; Using temporary; Используется filesort 1 SIMPLE j ref PRIMARY,element_clientid,element_folder_clientid element_clientid 302 const 1 Using index condition 1 SIMPLE i ALL shipment_jplugin_id Индекс не используется NULL NULL 2 Using where; Using join buffer (flat, BNL join) 1 SIMPLE l eq_ref PRIMARY PRIMARY 4 joomla.i.virtuemart_shipmentmethod_id 1 Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.41 ms Creating sort index 0.07 ms Removing tmp table 0.11 ms Creating sort index 0.01 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.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526 15 vmPSPlugin->getPluginMethods() JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:119 14 vmPSPlugin->displayListFE() JROOT/plugins/vmshipment/weight_countries/weight_countries.php:512 13 plgVmShipmentWeight_countries->plgVmDisplayListFEShipment() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_virtuemart/views/cart/view.html.php:272 10 VirtueMartViewCart->lSelectShipment() JROOT/components/com_virtuemart/views/cart/view.html.php:156 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.35 ms После последнего запроса: 0.53 ms Память запроса: 0.023 MB Память до запроса: 4.440 MB Выбрано строк: 1
SELECT SQL_CALC_FOUND_ROWS i.*, l.payment_name, l.payment_desc
FROM `j_virtuemart_paymentmethods` as i
LEFT JOIN `j_virtuemart_paymentmethods_ru_ru` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
WHERE `published` = 1
ORDER BY i.ordering DESC
LIMIT 0, 21id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i ALL NULL Индекс не используется NULL NULL 3 Using where; Используется filesort 1 SIMPLE l eq_ref PRIMARY PRIMARY 4 joomla.i.virtuemart_paymentmethod_id 1 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.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.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 # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859 13 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:134 12 VirtueMartModelPaymentmethod->getPayments() JROOT/components/com_virtuemart/views/cart/view.html.php:386 11 VirtueMartViewCart->checkPaymentMethodsConfigured() JROOT/components/com_virtuemart/views/cart/view.html.php:317 10 VirtueMartViewCart->lSelectPayment() JROOT/components/com_virtuemart/views/cart/view.html.php:157 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.10 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB Память до запроса: 4.449 MB Выбрано строк: 1Повторяющиеся запросы: #41
SELECT FOUND_ROWS()
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL No tables used Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms init 0.01 ms Optimizing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.10 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:868 13 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:134 12 VirtueMartModelPaymentmethod->getPayments() JROOT/components/com_virtuemart/views/cart/view.html.php:386 11 VirtueMartViewCart->checkPaymentMethodsConfigured() JROOT/components/com_virtuemart/views/cart/view.html.php:317 10 VirtueMartViewCart->lSelectPayment() JROOT/components/com_virtuemart/views/cart/view.html.php:157 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.15 ms После последнего запроса: 0.05 ms Память запроса: 0.022 MB Память до запроса: 4.456 MB Выбрано строк: 0
SELECT `virtuemart_shoppergroup_id`
FROM j_virtuemart_paymentmethod_shoppergroups
WHERE `virtuemart_paymentmethod_id` = "4"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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.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 # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 13 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:144 12 VirtueMartModelPaymentmethod->getPayments() JROOT/components/com_virtuemart/views/cart/view.html.php:386 11 VirtueMartViewCart->checkPaymentMethodsConfigured() JROOT/components/com_virtuemart/views/cart/view.html.php:317 10 VirtueMartViewCart->lSelectPayment() JROOT/components/com_virtuemart/views/cart/view.html.php:157 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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 - Время запроса: 1.10 ms После последнего запроса: 0.09 ms Память запроса: 0.025 MB Память до запроса: 4.466 MB Выбрано строк: 1
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc
FROM j_virtuemart_paymentmethods as i
LEFT JOIN `j_virtuemart_paymentmethods_ru_ru` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
LEFT JOIN `j_extensions` as j
ON j.`extension_id` = i.`payment_jplugin_id`
LEFT
OUTER JOIN `j_virtuemart_paymentmethod_shoppergroups` AS s
ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE i.`published` = "1"
AND j.`element` = "tinkoff"
AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY i.`virtuemart_paymentmethod_id`
ORDER BY i.`ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s system virtuemart_paymentmethod_id Индекс не используется NULL NULL 0 Const row not found; Using temporary; Используется filesort 1 SIMPLE j ref PRIMARY,element_clientid,element_folder_clientid element_clientid 302 const 1 Using index condition 1 SIMPLE i ALL payment_jplugin_id,virtuemart_vendor_id Индекс не используется NULL NULL 3 Using where; Using join buffer (flat, BNL join) 1 SIMPLE l eq_ref PRIMARY PRIMARY 4 joomla.i.virtuemart_paymentmethod_id 1 Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.40 ms Creating sort index 0.06 ms Removing tmp table 0.10 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.30 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526 15 vmPSPlugin->getPluginMethods() JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:119 14 vmPSPlugin->displayListFE() JROOT/plugins/vmpayment/tinkoff/tinkoff.php:521 13 plgVmPaymentTinkoff->plgVmDisplayListFEPayment() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_virtuemart/views/cart/view.html.php:328 10 VirtueMartViewCart->lSelectPayment() JROOT/components/com_virtuemart/views/cart/view.html.php:157 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.94 ms После последнего запроса: 0.19 ms Память запроса: 0.024 MB Память до запроса: 4.483 MB Выбрано строк: 0
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc
FROM j_virtuemart_paymentmethods as i
LEFT JOIN `j_virtuemart_paymentmethods_ru_ru` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
LEFT JOIN `j_extensions` as j
ON j.`extension_id` = i.`payment_jplugin_id`
LEFT
OUTER JOIN `j_virtuemart_paymentmethod_shoppergroups` AS s
ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE i.`published` = "1"
AND j.`element` = "standard"
AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY i.`virtuemart_paymentmethod_id`
ORDER BY i.`ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s system virtuemart_paymentmethod_id Индекс не используется NULL NULL 0 Const row not found; Using temporary; Используется filesort 1 SIMPLE j ref PRIMARY,element_clientid,element_folder_clientid element_clientid 302 const 1 Using index condition 1 SIMPLE i ALL payment_jplugin_id,virtuemart_vendor_id Индекс не используется NULL NULL 3 Using where; Using join buffer (flat, BNL join) 1 SIMPLE l eq_ref PRIMARY PRIMARY 4 joomla.i.virtuemart_paymentmethod_id 1 Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.33 ms Creating sort index 0.02 ms Removing tmp table 0.07 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.62 ms Reset for next command 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526 15 vmPSPlugin->getPluginMethods() JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:119 14 vmPSPlugin->displayListFE() JROOT/plugins/vmpayment/standard/standard.php:330 13 plgVmPaymentStandard->plgVmDisplayListFEPayment() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_virtuemart/views/cart/view.html.php:328 10 VirtueMartViewCart->lSelectPayment() JROOT/components/com_virtuemart/views/cart/view.html.php:157 9 VirtueMartViewCart->display() JROOT/components/com_virtuemart/controllers/cart.php:135 8 VirtueMartControllerCart->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:126 6 require_once JROOT/components/com_virtuemart/virtuemart.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.99 ms После последнего запроса: 3.06 ms Память запроса: 0.025 MB Память до запроса: 4.673 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:23:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-06 12:23:27')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 126 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.08 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.50 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
38 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
4 × SELECT *
FROM `j_virtuemart_userfields`3 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc
FROM j_virtuemart_paymentmethods as i
LEFT JOIN `j_virtuemart_paymentmethods_ru_ru` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
LEFT JOIN `j_extensions` as j
ON j.`extension_id` = i.`payment_jplugin_id`
LEFT
OUTER JOIN `j_virtuemart_paymentmethod_shoppergroups` AS s
ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`3 × SELECT *
FROM j_virtuemart_calcs
LEFT JOIN j_virtuemart_calc_shoppergroups using(virtuemart_calc_id)2 × SELECT `data`
FROM `j_session`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j_extensions`2 × SELECT `virtuemart_shoppergroup_id`
FROM j_virtuemart_shipmentmethod_shoppergroups2 × SELECT FOUND_ROWS(
1 × SELECT `virtuemart_shoppergroup_id`
FROM j_virtuemart_paymentmethod_shoppergroups1 × SELECT SQL_CALC_FOUND_ROWS i.*, l.payment_name, l.payment_desc
FROM `j_virtuemart_paymentmethods` as i
LEFT JOIN `j_virtuemart_paymentmethods_ru_ru` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc
FROM j_virtuemart_shipmentmethods as i
LEFT JOIN `j_virtuemart_shipmentmethods_ru_ru` as l
ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `j_extensions` as j
ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT
OUTER JOIN `j_virtuemart_shipmentmethod_shoppergroups` AS s
ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`1 × SELECT SQL_CALC_FOUND_ROWS i.*, l.shipment_name, l.shipment_desc
FROM `j_virtuemart_shipmentmethods` as i
LEFT JOIN `j_virtuemart_shipmentmethods_ru_ru` as l
ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`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_id1 × SELECT `j_virtuemart_medias`.*
FROM `j_virtuemart_medias`1 × SELECT `virtuemart_media_id`
FROM `j_virtuemart_vendor_medias`1 × SELECT `j_virtuemart_vendors`.* ,`j_virtuemart_vendors_ru_ru`.*
FROM `j_virtuemart_vendors`
INNER JOIN `j_virtuemart_vendors_ru_ru` using (`virtuemart_vendor_id`)1 × 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 `session_id`
FROM `j_session`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 `id`
FROM `j_menu`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 `id`,`name`,`rules`,`parent_id`
FROM `j_assets`1 × SELECT *
FROM j_languages1 × SELECT `config`
FROM `j_virtuemart_configs`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM 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 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
Прочие SQL-запросы:
2 × DELETE
FROM `j_session`1 × INSERT INTO `j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('89dd86dc06ad1603b79211ff4a980d16', 1, '1770380607', 0, '', 01 × SHOW TABLES LIKE "j_virtuemart_configs
1 × UPDATE `j_extensions`
SET `params` = '{\"mediaversion\":\"d9c4802f5632d587433afeff2d4c340f\"}'1 × SHOW FULL COLUMNS
FROM `j_virtuemart_userfields1 × UPDATE `j_session`
SET `data` = '' , `time` = '1770380607'