Пермь, п. Красный Восход, д. Качка, ул. Тюляковская, 20
Контакты
Посетителям
О ферме
Все экскурсии проводятся по предварительной записи или бронированию
Наш веб-сайт использует cookie-файлы для сохранения информации на вашем компьютере.
Это позволяет обеспечивать удобный просмотр нашего веб-сайта, а также даёт возможность улучшать его.
Это позволяет обеспечивать удобный просмотр нашего веб-сайта, а также даёт возможность улучшать его.
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1790896510,
"last": 1790896510,
"now": 1790896511
},
"token": "wKpDO79cTMgpSiBRIYnoOWNYlw92HxDj"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"js_id_currency_orig": "1",
"js_id_currency": "1",
"js_history_sel_lang": "ru-RU",
"js_prev_user_id": 0,
"jshop_checked_language": [
"en-GB",
"ru-RU"
],
"jshop_end_page_buy_product": "/component/jshopping/mylo-ruchnoj-raboty/molodei-ka?Itemid=308",
"product_back_value": []
}
}
Время
Память
Время: 19.79 ms / 19.79 ms Память: 0.410 MB / 0.76 MB Application: afterLoad
Время: 103.60 ms / 123.39 ms Память: 1.974 MB / 2.73 MB Application: afterInitialise
Время: 32.83 ms / 156.22 ms Память: 0.603 MB / 3.33 MB Application: Before Access::preloadComponents (all components)
Время: 0.82 ms / 157.04 ms Память: 0.067 MB / 3.40 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 157.06 ms Память: -0.004 MB / 3.40 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Время: 0.72 ms / 157.78 ms Память: 0.008 MB / 3.40 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Время: 3.95 ms / 161.73 ms Память: 0.104 MB / 3.51 MB Application: afterRoute
Время: 4.63 ms / 166.36 ms Память: 0.304 MB / 3.81 MB Application: beforeRenderComponent com_jshopping
Время: 66.64 ms / 233.00 ms Память: 0.769 MB / 4.58 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.04 ms / 233.04 ms Память: 0.007 MB / 4.59 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 20.79 ms / 253.83 ms Память: 0.153 MB / 4.74 MB Application: afterRenderComponent com_jshopping
Время: 108.09 ms / 361.92 ms Память: 0.521 MB / 5.26 MB Application: afterDispatch
Время: 36.63 ms / 398.56 ms Память: 0.642 MB / 5.91 MB Application: beforeRenderModule mod_menu (Меню)
Время: 31.02 ms / 429.58 ms Память: 0.037 MB / 5.94 MB Application: afterRenderModule mod_menu (Меню)
Время: 0.12 ms / 429.70 ms Память: -0.008 MB / 5.93 MB Application: beforeRenderModule mod_custom (Подвал)
Время: 1.50 ms / 431.20 ms Память: 0.009 MB / 5.94 MB Application: afterRenderModule mod_custom (Подвал)
Время: 0.09 ms / 431.29 ms Память: 0.000 MB / 5.94 MB Application: beforeRenderModule mod_jshopping_cart_wl_ajax (Jshopping Cart and Wishlist Ajax)
Время: 5.48 ms / 436.77 ms Память: 0.061 MB / 6.00 MB Application: afterRenderModule mod_jshopping_cart_wl_ajax (Jshopping Cart and Wishlist Ajax)
Время: 0.08 ms / 436.85 ms Память: -0.015 MB / 5.99 MB Application: beforeRenderModule mod_custom (Шапка сайта)
Время: 0.53 ms / 437.38 ms Память: 0.004 MB / 5.99 MB Application: afterRenderModule mod_custom (Шапка сайта)
Время: 18.45 ms / 455.83 ms Память: 0.119 MB / 6.11 MB Application: afterRender
Всего SQL-запросов: 30.55 ms
6.81 MB (7 136 584 Байт)
51 SQL-запросов зафиксировано 30.55 ms
- Время запроса: 0.46 ms Память запроса: 0.023 MB Память до запроса: 1.037 MB Выбрано строк: 1
SELECT `data`
FROM `m5fdi_session`
WHERE `session_id` = X'3231363766636166393732313135656465343639633534343963643065326336'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1741 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.71 ms После последнего запроса: 3.30 ms Память запроса: 0.040 MB Память до запроса: 1.084 MB Выбрано строк: 46
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m5fdi_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_extensions NULL ref extension extension 82 const 47 1.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.21 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Так же, как вызов в строке ниже. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 2.75 ms Память запроса: 0.021 MB Память до запроса: 1.123 MB Выбрано строк: 5
SELECT id, rules
FROM `m5fdi_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_viewlevels NULL ALL NULL Индекс не используется NULL NULL 5 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1507 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.30 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB Память до запроса: 1.135 MB Выбрано строк: 2
SELECT b.id
FROM m5fdi_usergroups AS a
LEFT JOIN m5fdi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1551 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.79 ms После последнего запроса: 0.34 ms Память запроса: 0.051 MB Память до запроса: 1.157 MB Выбрано строк: 155
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM m5fdi_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_extensions NULL ref extension extension 82 const 191 0.60 Using where; Используется filesort Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.43 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.54 ms После последнего запроса: 19.65 ms Память запроса: 0.022 MB Память до запроса: 1.652 MB Выбрано строк: 1
SELECT `value`
FROM `m5fdi_admintools_storage`
WHERE `key` = 'cparams'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_admintools_storage NULL const PRIMARY PRIMARY 402 const 1 100.00 NULL Status Duration starting 0.14 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1741 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:122 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:49 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:409 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:892 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.37 ms После последнего запроса: 0.41 ms Память запроса: 0.021 MB Память до запроса: 1.660 MB Выбрано строк: 0
SELECT *
FROM `m5fdi_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_admintools_wafexceptions NULL ALL NULL Индекс не используется NULL NULL 1 100.00 Using where Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1507 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:729 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:640 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:901 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 43.42 ms Память запроса: 0.021 MB Память до запроса: 2.586 MB Выбрано строк: 0
SELECT `source`,`keepurlparams`
FROM `m5fdi_admintools_redirects`
WHERE ((`dest` = 'component/jshopping/mylo-ruchnoj-raboty/molodei-ka') OR (`dest` = 'component/jshopping/mylo-ruchnoj-raboty/molodei-ka?Itemid=308') OR ('component/jshopping/mylo-ruchnoj-raboty/molodei-ka?Itemid=308' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_admintools_redirects NULL ALL NULL Индекс не используется NULL NULL 1 100.00 Using where; Используется filesort Status Duration starting 0.21 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.05 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1774 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:91 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.56 ms После последнего запроса: 5.59 ms Память запроса: 0.023 MB Память до запроса: 2.694 MB Выбрано строк: 1
SELECT `params`
FROM `m5fdi_extensions`
WHERE `type` = 'component'
AND `element` = 'com_engage'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.02 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1741 14 JDatabaseDriver->loadResult() JROOT/libraries/fof30/Params/Params.php:57 13 FOF30\Params\Params->reload() JROOT/libraries/fof30/Params/Params.php:42 12 FOF30\Params\Params->__construct() JROOT/libraries/fof30/Container/Container.php:292 11 FOF30\Container\Container->FOF30\Container\{closure}() JROOT/libraries/fof30/Pimple/Container.php:124 10 FOF30\Pimple\Container->offsetGet() JROOT/libraries/fof30/Container/ContainerBase.php:27 9 FOF30\Container\ContainerBase->__get() JROOT/plugins/system/engagecache/engagecache.php:57 8 plgSystemEngagecache->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.87 ms После последнего запроса: 5.98 ms Память запроса: 0.060 MB Память до запроса: 2.776 MB Выбрано строк: 13
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 m5fdi_menu AS m
LEFT JOIN m5fdi_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 29 10.00 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 straus-park2021.m.component_id 1 100.00 Using where Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.05 ms executing 0.29 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 3.19 ms После последнего запроса: 17.22 ms Память запроса: 0.047 MB Память до запроса: 3.086 MB Выбрано строк: 140
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_config`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_config`Status Duration checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.17 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/config.php:14 15 jshopConfig->__construct() JROOT/components/com_jshopping/lib/factory.php:24 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:225 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.59 ms После последнего запроса: 1.75 ms Память запроса: 0.097 MB Память до запроса: 3.286 MB Выбрано строк: 1
SELECT *
FROM m5fdi_jshopping_config
WHERE `id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_config NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.04 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1466 16 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 15 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/lib/factory.php:30 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:225 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.94 ms После последнего запроса: 0.59 ms Память запроса: 0.027 MB Память до запроса: 3.283 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_currencies`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_currencies`Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.36 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.08 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/currency.php:14 19 jshopCurrency->__construct() JROOT/libraries/src/Table/Table.php:328 18 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 17 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:569 16 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 15 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:225 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.23 ms После последнего запроса: 0.05 ms Память запроса: 0.024 MB Память до запроса: 3.303 MB Выбрано строк: 1
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `m5fdi_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_currencies NULL ref currency_publish currency_publish 1 const 1 100.00 Используется filesort Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 18 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/currency.php:22 17 jshopCurrency->getAllCurrencies() JROOT/components/com_jshopping/lib/factory.php:570 16 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 15 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1595 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:225 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.26 ms После последнего запроса: 2.16 ms Память запроса: 0.022 MB Память до запроса: 3.309 MB Выбрано строк: 11
select category_id as id, `alias_ru-RU` as alias
from m5fdi_jshopping_categories
where `alias_ru-RU`!=''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_categories NULL ALL NULL Индекс не используется NULL NULL 11 90.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:255 11 JSFactory::getAliasCategory() JROOT/components/com_jshopping/router.php:306 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 0.05 ms Память запроса: 0.025 MB Память до запроса: 3.317 MB Выбрано строк: 78
select product_id as id, `alias_ru-RU` as alias
from m5fdi_jshopping_products
where `alias_ru-RU`!=''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_products NULL ALL NULL Индекс не используется NULL NULL 78 90.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:303 11 JSFactory::getAliasProduct() JROOT/components/com_jshopping/router.php:317 10 jshoppingParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.62 ms После последнего запроса: 1.70 ms Память запроса: 0.028 MB Память до запроса: 3.342 MB Выбрано строк: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `m5fdi_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jmap','com_joomlaupdate','com_jshopping','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_rstbox','com_search','com_speasyimagegallery','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_assets NULL range idx_asset_name idx_asset_name 202 NULL 47 100.00 Using index condition Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.27 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 15 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 14 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 13 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 12 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 11 Joomla\CMS\User\User->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:30 10 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/advancedmodules.php:95 9 PlgSystemAdvancedModules->handleOnAfterRoute() JROOT/libraries/regularlabs/src/SystemPlugin.php:192 8 RegularLabs\Library\SystemPlugin->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.35 ms После последнего запроса: 1.41 ms Память запроса: 0.068 MB Память до запроса: 3.406 MB Выбрано строк: 1
SELECT id, home, template, s.params
FROM m5fdi_template_styles as s
LEFT JOIN m5fdi_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 2 2.50 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 straus-park2021.e.element 1 50.00 Using index condition; Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 11 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/helixultimate/src/Platform/Helper.php:273 10 HelixUltimate\Framework\Platform\Helper::loadTemplateData() JROOT/plugins/system/helixultimate/helixultimate.php:278 9 PlgSystemHelixultimate->attachWebAsset() JROOT/plugins/system/helixultimate/helixultimate.php:307 8 PlgSystemHelixultimate->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.24 ms После последнего запроса: 1.95 ms Память запроса: 0.069 MB Память до запроса: 3.462 MB Выбрано строк: 1
SELECT *
FROM `m5fdi_template_styles`
WHERE `id` = 11id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_template_styles NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1663 12 JDatabaseDriver->loadObject() JROOT/plugins/system/helixultimate/src/Platform/Helper.php:59 11 HelixUltimate\Framework\Platform\Helper::getTemplateStyle() JROOT/plugins/system/helixultimate/src/Platform/Helper.php:343 10 HelixUltimate\Framework\Platform\Helper::loadTemplateData() JROOT/plugins/system/helixultimate/helixultimate.php:278 9 PlgSystemHelixultimate->attachWebAsset() JROOT/plugins/system/helixultimate/helixultimate.php:307 8 PlgSystemHelixultimate->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.31 ms После последнего запроса: 1.27 ms Память запроса: 0.022 MB Память до запроса: 3.528 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m5fdi_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1663 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:323 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:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.37 ms После последнего запроса: 0.15 ms Память запроса: 0.005 MB Память до запроса: 3.519 MB
UPDATE `m5fdi_extensions`
SET `params` = '{\"mediaversion\":\"628e2f92ba907737408cf6d69b2b73f8\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `m5fdi_extensions` SET `params` = '{\"mediaversion\":\"628e2f92ba907737408cf6d69b2b73f8\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.06 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.11 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:374 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:333 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:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.31 ms После последнего запроса: 1.54 ms Память запроса: 0.019 MB Память до запроса: 3.613 MB Выбрано строк: 1
SELECT *
FROM m5fdi_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_languages NULL ALL NULL Индекс не используется NULL NULL 1 100.00 Using where; Используется filesort Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.13 ms После последнего запроса: 44.88 ms Память запроса: 0.032 MB Память до запроса: 3.878 MB Выбрано строк: 48
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_products`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_products`Status Duration starting 0.17 ms Executing hook on transaction 0.00 ms starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.47 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.03 ms Creating tmp table 0.06 ms executing 0.14 ms checking permissions 0.07 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.04 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/product.php:15 11 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 9 JSFactory::getTable() JROOT/components/com_jshopping/controllers/product.php:44 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 0.25 ms Память запроса: 0.023 MB Память до запроса: 3.938 MB Выбрано строк: 1
SELECT *
FROM m5fdi_jshopping_products
WHERE `product_id` = '30'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_products NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1466 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:45 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.02 ms После последнего запроса: 0.45 ms Память запроса: 0.027 MB Память до запроса: 3.955 MB Выбрано строк: 24
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_categories`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_categories`Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.34 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.05 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/category.php:15 11 jshopCategory->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 9 JSFactory::getTable() JROOT/components/com_jshopping/controllers/product.php:51 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.26 ms После последнего запроса: 0.14 ms Память запроса: 0.022 MB Память до запроса: 3.991 MB Выбрано строк: 1
SELECT *
FROM m5fdi_jshopping_categories
WHERE `category_id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1466 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:52 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.23 ms После последнего запроса: 0.09 ms Память запроса: 0.022 MB Память до запроса: 3.997 MB Выбрано строк: 1
SELECT *
FROM `m5fdi_jshopping_products_to_categories`
WHERE product_id=30id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_products_to_categories NULL ref PRIMARY,product_id,product_id_2,product_ordering PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:282 10 jshopProduct->getCategories() JROOT/components/com_jshopping/models/productshop.php:81 9 jshopProductShop->getCategories() JROOT/components/com_jshopping/controllers/product.php:57 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.83 ms После последнего запроса: 0.49 ms Память запроса: 0.027 MB Память до запроса: 4.009 MB Выбрано строк: 11
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_attr`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_attr`Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.03 ms checking permissions 0.00 ms Opening tables 0.28 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.05 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/attribut.php:14 16 jshopAttribut->__construct() JROOT/libraries/src/Table/Table.php:328 15 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 14 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:317 13 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:128 12 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 11 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/tables/product.php:235 10 jshopProduct->getInitLoadAttribute() JROOT/components/com_jshopping/models/productshop.php:95 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.30 ms После последнего запроса: 0.08 ms Память запроса: 0.023 MB Память до запроса: 4.031 MB Выбрано строк: 1
SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname
FROM `m5fdi_jshopping_attr` as A
left join `m5fdi_jshopping_attr_groups` as G
on A.`
group`=G.id
ORDER BY G.ordering, A.attr_orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE A NULL ALL NULL Индекс не используется NULL NULL 1 100.00 Using temporary; Используется filesort 1 SIMPLE G NULL eq_ref PRIMARY PRIMARY 4 straus-park2021.A.group 1 100.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms Creating tmp table 0.02 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/attribut.php:28 14 jshopAttribut->getAllAttributes() JROOT/components/com_jshopping/lib/factory.php:318 13 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:128 12 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 11 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/tables/product.php:235 10 jshopProduct->getInitLoadAttribute() JROOT/components/com_jshopping/models/productshop.php:95 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.21 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB Память до запроса: 4.037 MB Выбрано строк: 0
SELECT *
FROM `m5fdi_jshopping_products_attr`
WHERE product_id=30
ORDER BY product_attr_idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_products_attr NULL ref product_id product_id 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 14 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:159 13 jshopProduct->getAttributes() JROOT/components/com_jshopping/tables/product.php:133 12 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:207 11 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/tables/product.php:235 10 jshopProduct->getInitLoadAttribute() JROOT/components/com_jshopping/models/productshop.php:95 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.35 ms После последнего запроса: 0.28 ms Память запроса: 0.033 MB Память до запроса: 4.052 MB Выбрано строк: 53
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_users`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_users`Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.28 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.05 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/usershopbase.php:14 14 jshopUserShopBase->__construct() JROOT/components/com_jshopping/tables/usershop.php:15 13 jshopUserShop->__construct() JROOT/components/com_jshopping/lib/factory.php:47 12 JSFactory::getUserShop() JROOT/components/com_jshopping/tables/product.php:1145 11 jshopProduct->getBuildSelectAttributes() JROOT/components/com_jshopping/tables/product.php:239 10 jshopProduct->getInitLoadAttribute() JROOT/components/com_jshopping/models/productshop.php:95 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.69 ms После последнего запроса: 0.51 ms Память запроса: 0.026 MB Память до запроса: 4.186 MB Выбрано строк: 3
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_taxes`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_taxes`Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.04 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/tax.php:14 15 jshopTax->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 13 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:369 12 JSFactory::getAllTaxes() JROOT/components/com_jshopping/tables/product.php:734 11 jshopProduct->getTax() JROOT/components/com_jshopping/tables/product.php:537 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:104 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.19 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB Память до запроса: 4.207 MB Выбрано строк: 1
SELECT tax_id, tax_name, tax_value
FROM `m5fdi_jshopping_taxes`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_taxes NULL ALL NULL Индекс не используется NULL NULL 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/tax.php:21 14 jshopTax->getAllTaxes() JROOT/components/com_jshopping/lib/factory.php:355 13 JSFactory::getAllTaxesOriginal() JROOT/components/com_jshopping/lib/factory.php:370 12 JSFactory::getAllTaxes() JROOT/components/com_jshopping/tables/product.php:734 11 jshopProduct->getTax() JROOT/components/com_jshopping/tables/product.php:537 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:104 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.74 ms После последнего запроса: 0.44 ms Память запроса: 0.026 MB Память до запроса: 4.217 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `m5fdi_jshopping_products_reviews`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `m5fdi_jshopping_products_reviews`Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.26 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 16 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 15 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 14 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 13 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/review.php:14 12 jshopReview->__construct() JROOT/libraries/src/Table/Table.php:328 11 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 10 JSFactory::getTable() JROOT/components/com_jshopping/models/productshop.php:117 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.34 ms После последнего запроса: 6.03 ms Память запроса: 0.023 MB Память до запроса: 4.412 MB Выбрано строк: 1
SELECT `enabled`
FROM `m5fdi_extensions`
WHERE (`element`='com_sppagebuilder')
AND (`type`='component')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1741 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:218 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:46 13 PlgContentSppagebuilder->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 12 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 11 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/lib/functions.php:934 10 changeDataUsePluginContent() JROOT/components/com_jshopping/models/productshop.php:202 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.80 ms После последнего запроса: 9.46 ms Память запроса: 0.025 MB Память до запроса: 4.608 MB Выбрано строк: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m5fdi_fields AS a
LEFT JOIN `m5fdi_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m5fdi_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m5fdi_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m5fdi_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m5fdi_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.article'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 straus-park2021.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 straus-park2021.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 straus-park2021.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 straus-park2021.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 straus-park2021.a.group_id 1 100.00 Using where Status Duration starting 0.15 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.08 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/lib/functions.php:950 10 changeDataUsePluginContent() JROOT/components/com_jshopping/models/productshop.php:202 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:59 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 0.48 ms Память запроса: 0.023 MB Память до запроса: 4.609 MB Выбрано строк: 1
select id,link
from m5fdi_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='ru-RU')
and access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 30 1.16 Using index condition; Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.13 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 14 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/shop_item_menu.php:141 13 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:47 12 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:40 11 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:403 10 getShopMainPageItemid() JROOT/components/com_jshopping/helpers/metadata.php:200 9 JshopHelpersMetadata::product() JROOT/components/com_jshopping/controllers/product.php:70 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.53 ms После последнего запроса: 0.11 ms Память запроса: 0.005 MB Память до запроса: 4.620 MB
UPDATE m5fdi_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '30'EXPLAIN не доступен для запроса: UPDATE m5fdi_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '30'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.05 ms updating 0.23 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.10 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 9 Joomla\CMS\Table\Table->hit() JROOT/components/com_jshopping/controllers/product.php:72 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.22 ms Память запроса: 0.021 MB Память до запроса: 4.623 MB Выбрано строк: 1
SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `m5fdi_jshopping_products_images` as I
left join `m5fdi_jshopping_products` as P
on P.product_id=I.product_id
WHERE I.product_id=30
ORDER BY sort, I.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE I NULL ref product_id product_id 4 const 1 100.00 Using temporary; Используется filesort 1 SIMPLE P NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Creating tmp table 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.15 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:371 9 jshopProduct->getImages() JROOT/components/com_jshopping/controllers/product.php:82 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.06 ms Память запроса: 0.021 MB Память до запроса: 4.630 MB Выбрано строк: 0
SELECT *
FROM `m5fdi_jshopping_products_files`
WHERE product_id=30
and demo!=''
order by `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_products_files NULL ref product_id product_id 4 const 1 100.00 Using where; Используется filesort Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.04 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:419 9 jshopProduct->getDemoFiles() JROOT/components/com_jshopping/controllers/product.php:84 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.35 ms После последнего запроса: 2.91 ms Память запроса: 0.022 MB Память до запроса: 4.716 MB Выбрано строк: 1
SELECT count(review_id)
FROM `m5fdi_jshopping_products_reviews`
WHERE product_id=30
and publish=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_products_reviews NULL index_merge product_id,publish product_id,publish 4,1 NULL 1 100.00 Using intersect(product_id,publish); Using where; Using index Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1741 11 JDatabaseDriver->loadResult() JROOT/components/com_jshopping/tables/product.php:1110 10 jshopProduct->getReviewsCount() JROOT/components/com_jshopping/models/productreviewlist.php:86 9 jshopProductReviewList->load() JROOT/components/com_jshopping/controllers/product.php:136 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.30 ms После последнего запроса: 0.86 ms Память запроса: 0.021 MB Память до запроса: 4.722 MB Выбрано строк: 0
SELECT *
FROM `m5fdi_jshopping_products_reviews`
WHERE product_id=30
and publish=1
order by review_id desc
LIMIT 0, 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jshopping_products_reviews NULL index_merge product_id,publish product_id,publish 4,1 NULL 1 100.00 Using intersect(product_id,publish); Using where; Используется filesort Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:1101 10 jshopProduct->getReviews() JROOT/components/com_jshopping/models/productreviewlist.php:88 9 jshopProductReviewList->load() JROOT/components/com_jshopping/controllers/product.php:136 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.29 ms После последнего запроса: 10.46 ms Память запроса: 0.021 MB Память до запроса: 4.748 MB Выбрано строк: 3
SELECT `id`
FROM `m5fdi_rstbox`
WHERE `published` = 1
AND `testmode` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_rstbox NULL ALL NULL Индекс не используется NULL NULL 4 25.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1551 9 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 1.04 ms Память запроса: 0.021 MB Память до запроса: 4.756 MB Выбрано строк: 1
SELECT *
FROM `m5fdi_rstbox`
WHERE `id` = 2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_rstbox NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1663 10 JDatabaseDriver->loadObject() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:226 9 EngageBox\Box::get() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:51 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.55 ms После последнего запроса: 25.38 ms Память запроса: 0.024 MB Память до запроса: 4.849 MB Выбрано строк: 1
SELECT *
FROM `m5fdi_convertforms`
WHERE `id` = 2
AND `state` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_convertforms NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1466 17 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_convertforms/ConvertForms/Form.php:61 16 ConvertForms\Form::load() JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:582 15 ConvertForms\Helper::renderFormById() JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:957 14 ConvertForms\Helper::doShortcodeReplacements() JROOT/plugins/system/convertforms/convertforms.php:214 13 PlgSystemConvertForms->onEngageBoxAfterRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:40 9 EngageBox\Box::render() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:54 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.56 ms После последнего запроса: 52.06 ms Память запроса: 0.021 MB Память до запроса: 5.188 MB Выбрано строк: 1
SELECT *
FROM `m5fdi_rstbox`
WHERE `id` = 3id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_rstbox NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1663 10 JDatabaseDriver->loadObject() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:226 9 EngageBox\Box::get() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:51 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 10.75 ms Память запроса: 0.021 MB Память до запроса: 5.219 MB Выбрано строк: 1
SELECT *
FROM `m5fdi_rstbox`
WHERE `id` = 4id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_rstbox NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1663 10 JDatabaseDriver->loadObject() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:226 9 EngageBox\Box::get() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:51 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 0.54 ms Память запроса: 0.022 MB Память до запроса: 5.251 MB Выбрано строк: 1
SELECT COUNT(id)
FROM `m5fdi_rstbox_logs`
WHERE `event` = 1
AND `box` = 4
AND `visitorid` = 'd582b7c63a6b3df8'
AND DATE(date) = '2026-10-01'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_rstbox_logs NULL ref visitorid,box visitorid 258 const 1 5.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1741 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_rstbox/EngageBox/Assignments.php:197 13 EngageBox\Assignments->passImpressions() JROOT/administrator/components/com_rstbox/EngageBox/Assignments.php:91 12 EngageBox\Assignments->passAll() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:320 11 EngageBox\Box::passLocalAssignments() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:264 10 EngageBox\Box::pass() JROOT/administrator/components/com_rstbox/EngageBox/Box.php:28 9 EngageBox\Box::render() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:54 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:68 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.88 ms После последнего запроса: 31.21 ms Память запроса: 0.198 MB Память до запроса: 5.639 MB Выбрано строк: 41
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM m5fdi_modules AS m
LEFT JOIN m5fdi_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN m5fdi_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL published,newsfeeds Индекс не используется NULL NULL 85 5.41 Using where; Используется filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 straus-park2021.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE am NULL eq_ref PRIMARY PRIMARY 4 straus-park2021.m.id 1 100.00 Using where Status Duration starting 0.22 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.06 ms executing 1.02 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1702 19 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:168 18 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60 17 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:381 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:88 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:994 11 HelixUltimate\Framework\Core\HelixUltimate->count_modules() JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:728 10 HelixUltimate\Framework\Core\HelixUltimate->get_current_row() JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:630 9 HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout() JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:596 8 HelixUltimate\Framework\Core\HelixUltimate->render_layout() JROOT/templates/shaper_helixultimate/index.php:168 7 require JROOT/templates/shaper_helixultimate/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.81 ms После последнего запроса: 61.18 ms Память запроса: 0.022 MB Память до запроса: 5.990 MB Выбрано строк: 0
SELECT *
FROM m5fdi_jmap_metainfo
WHERE `linkurl` = 'https://straus-park59.ru/component/jshopping/mylo-ruchnoj-raboty/molodei-ka'
AND `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jmap_metainfo NULL ALL published Индекс не используется NULL NULL 43 10.00 Using where Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.03 ms executing 0.14 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1663 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:407 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 4.48 ms Память запроса: 0.020 MB Память до запроса: 6.103 MB Выбрано строк: 0
SELECT *
FROM m5fdi_jmap_headings
WHERE `linkurl` = 'https://straus-park59.ru/component/jshopping/mylo-ruchnoj-raboty/molodei-ka'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m5fdi_jmap_headings NULL ALL NULL Индекс не используется NULL NULL 1 100.00 Using where Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Вызывающий объект Файл и номер строки 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1663 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:720 7 plgSystemJMap->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
48 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
3 × SELECT *
FROM `m5fdi_rstbox`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `m5fdi_extensions`1 × SELECT `data`
FROM `m5fdi_session`1 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `m5fdi_jshopping_products_images` as I
left join `m5fdi_jshopping_products` as P
on P.product_id=I.product_id1 × SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname
FROM `m5fdi_jshopping_attr` as A
left join `m5fdi_jshopping_attr_groups` as G
on A.`
group`=G.id1 × SELECT *
FROM `m5fdi_jshopping_products_attr`1 × SELECT tax_id, tax_name, tax_value
FROM `m5fdi_jshopping_taxes1 × SELECT `enabled`
FROM `m5fdi_extensions`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m5fdi_fields AS a
LEFT JOIN `m5fdi_languages` AS l
ON l.lang_code = a.language
LEFT JOIN m5fdi_users AS uc
ON uc.id=a.checked_out
LEFT JOIN m5fdi_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN m5fdi_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN m5fdi_fields_groups AS g
ON g.id = a.group_id1 × select id,link
from m5fdi_menu1 × SELECT count(review_id)
FROM `m5fdi_jshopping_products_reviews`1 × SELECT *
FROM `m5fdi_jshopping_products_files`1 × SELECT *
FROM `m5fdi_jshopping_products_reviews`1 × SELECT `id`
FROM `m5fdi_rstbox`1 × SELECT *
FROM `m5fdi_convertforms`1 × SELECT COUNT(id)
FROM `m5fdi_rstbox_logs`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM m5fdi_modules AS m
LEFT JOIN m5fdi_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN m5fdi_advancedmodules as am
ON am.moduleid = m.id1 × SELECT *
FROM m5fdi_jmap_metainfo1 × SELECT *
FROM `m5fdi_jshopping_products_to_categories`1 × SELECT *
FROM m5fdi_jshopping_categories1 × SELECT *
FROM m5fdi_jshopping_products1 × SELECT `params`
FROM `m5fdi_extensions`1 × SELECT id, rules
FROM `m5fdi_viewlevels1 × SELECT b.id
FROM m5fdi_usergroups AS a
LEFT JOIN m5fdi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM m5fdi_extensions1 × SELECT `value`
FROM `m5fdi_admintools_storage`1 × SELECT *
FROM `m5fdi_admintools_wafexceptions`1 × SELECT `source`,`keepurlparams`
FROM `m5fdi_admintools_redirects`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 m5fdi_menu AS m
LEFT JOIN m5fdi_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM m5fdi_languages1 × SELECT *
FROM m5fdi_jshopping_config1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `m5fdi_jshopping_currencies`1 × select category_id as id, `alias_ru-RU` as alias
from m5fdi_jshopping_categories1 × select product_id as id, `alias_ru-RU` as alias
from m5fdi_jshopping_products1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `m5fdi_assets`1 × SELECT id, home, template, s.params
FROM m5fdi_template_styles as s
LEFT JOIN m5fdi_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM `m5fdi_template_styles`1 × SELECT *
FROM m5fdi_jmap_headings
Прочие SQL-запросы:
1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_config1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_currencies1 × UPDATE `m5fdi_extensions`
SET `params` = '{\"mediaversion\":\"628e2f92ba907737408cf6d69b2b73f8\"}'1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_products1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_categories1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_attr1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_users1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_taxes1 × SHOW FULL COLUMNS
FROM `m5fdi_jshopping_products_reviews1 × UPDATE m5fdi_jshopping_products
SET `hits` = (`hits` + 1)