Руководство по эксплуатации
Скачать
Доставка в карточке товара
Copyright MAXXmarketing GmbHJoomShopping Download & Support
© 2015- 2025 Компания Dahua Technology. Все права защищены.
Консоль отладки Joomla! {
" __default " : {
" session " : {
" counter " : 1,
" timer " : {
" start " : 1748713078,
" last " : 1748713078,
" now " : 1748713078
},
" token " : "ipu7SAyyu7O0ICqC11FLZr5MPztqNNE2"
},
" registry " : {
" contactus " : {
" add " : {
" form " : {
" data " : []
}
}
}
},
" 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 " : "4" ,
" js_id_currency " : "4" ,
" js_history_sel_lang " : "ru-RU" ,
" js_prev_user_id " : 0,
" jshop_checked_language " : [
"ar-AA" ,
"en-GB" ,
"ru-RU" ,
"uk-UA"
],
" jshop_end_page_buy_product " : "\/arochnye-metallodetektory\/arochnyj-metallodetektor-dahua-dhi-isc-d718-t-s-teplovizorom-1000mm" ,
" product_back_value " : [],
" last_visited_products " : {
" 13828 " : {
" name " : "\u0410\u0440\u043e\u0447\u043d\u044b\u0439 \u043c\u0435\u0442\u0430\u043b\u043b\u043e\u0434\u0435\u0442\u0435\u043a\u0442\u043e\u0440 Dahua DHI-ISC-D718-T \u0441 \u0422\u0435\u043f\u043b\u043e\u0432\u0438\u0437\u043e\u0440\u043e\u043c 1000\u043c\u043c" ,
" orig_image " : "full_205992.jpg" ,
" image " : "full_205992.jpg" ,
" product_thumb_image " : null ,
" product_id " : "13828" ,
" currency_id " : "4" ,
" tax_id " : "0" ,
" orig_product_price " : "657832.000000" ,
" product_price " : "657832.000000" ,
" product_old_price " : 0,
" min_price " : "657832.000000" ,
" different_prices " : "0" ,
" product_manufacturer_id " : "1" ,
" vendor_id " : "0" ,
" delivery_times_id " : "0" ,
" label_id " : "4" ,
" category_id " : 178
}
},
" text_link_add_to_compare " : "\u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u043a \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e" ,
" text_link_go_to_compare " : "\u041f\u0435\u0440\u0435\u0439\u0442\u0438 \u043a \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e"
}
}
Время Память Время: 6.60 ms / 6.60 ms Память: 0.403 MB / 0.75 MB Application: afterLoad
Время: 46.93 ms / 53.53 ms Память: 1.344 MB / 2.09 MB Application: afterInitialise
Время: 23.23 ms / 76.75 ms Память: 1.283 MB / 3.37 MB Application: Before Access::preloadComponents (all components)
Время: 0.70 ms / 77.45 ms Память: 0.065 MB / 3.44 MB Application: After Access::preloadComponents (all components)
Время: 0.02 ms / 77.47 ms Память: 0.060 MB / 3.50 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Время: 0.51 ms / 77.97 ms Память: 0.008 MB / 3.51 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Время: 0.04 ms / 78.01 ms Память: -0.001 MB / 3.51 MB Application: afterRoute
Время: 1.30 ms / 79.31 ms Память: 0.205 MB / 3.71 MB Application: beforeRenderComponent com_jshopping
Время: 76.72 ms / 156.03 ms Память: 2.394 MB / 6.10 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.02 ms / 156.05 ms Память: 0.007 MB / 6.11 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 18.69 ms / 174.74 ms Память: 0.559 MB / 6.67 MB Application: beforeRenderModule mod_custom (В карточке под ценой)
Время: 1.27 ms / 176.01 ms Память: 0.058 MB / 6.73 MB Application: beforeRenderModule mod_custom (Самовывоз в карточке товара)
Время: 1.92 ms / 177.93 ms Память: 0.009 MB / 6.74 MB Application: afterRenderModule mod_custom (Самовывоз в карточке товара)
Время: 0.03 ms / 177.96 ms Память: -0.000 MB / 6.74 MB Application: beforeRenderModule mod_custom (Доставка в карточке товара)
Время: 0.73 ms / 178.69 ms Память: 0.004 MB / 6.74 MB Application: afterRenderModule mod_custom (Доставка в карточке товара)
Время: 0.67 ms / 179.36 ms Память: -0.042 MB / 6.70 MB Application: afterRenderModule mod_custom (В карточке под ценой)
Время: 0.11 ms / 179.47 ms Память: 0.051 MB / 6.75 MB Application: beforeRenderModule mod_custom (Доставка в карточке товара)
Время: 0.73 ms / 180.20 ms Память: 0.005 MB / 6.76 MB Application: afterRenderModule mod_custom (Доставка в карточке товара)
Время: 0.04 ms / 180.25 ms Память: 0.012 MB / 6.77 MB Application: beforeRenderModule mod_jshopping_dop_products (Вместе покупают:)
Время: 3.91 ms / 184.15 ms Память: 0.109 MB / 6.88 MB Application: afterRenderComponent com_jshopping
Время: 1.66 ms / 185.82 ms Память: 0.005 MB / 6.88 MB Application: afterDispatch
Время: 27.11 ms / 212.92 ms Память: 0.189 MB / 7.07 MB Application: beforeRenderModule mod_custom (мобила низ)
Время: 0.22 ms / 213.14 ms Память: 0.046 MB / 7.12 MB Application: beforeRenderModule mod_jshopping_cart_wl_ajax (ИЗбранное (2))
Время: 6.12 ms / 219.27 ms Память: 0.063 MB / 7.18 MB Application: afterRenderModule mod_jshopping_cart_wl_ajax (ИЗбранное (2))
Время: 0.03 ms / 219.30 ms Память: -0.010 MB / 7.17 MB Application: beforeRenderModule mod_jshopping_compare (Jshopping compare ++ (2))
Время: 2.66 ms / 221.96 ms Память: 0.042 MB / 7.21 MB Application: afterRenderModule mod_jshopping_compare (Jshopping compare ++ (2))
Время: 0.03 ms / 221.99 ms Память: -0.006 MB / 7.21 MB Application: beforeRenderModule mod_jshopping_cart_wl_ajax (Jshopping Cart and Wishlist Ajax (2))
Время: 5.03 ms / 227.02 ms Память: 0.027 MB / 7.24 MB Application: afterRenderModule mod_jshopping_cart_wl_ajax (Jshopping Cart and Wishlist Ajax (2))
Время: 0.69 ms / 227.71 ms Память: -0.054 MB / 7.18 MB Application: afterRenderModule mod_custom (мобила низ)
Время: 0.03 ms / 227.74 ms Память: -0.003 MB / 7.18 MB Application: beforeRenderModule mod_custom (copirat)
Время: 0.73 ms / 228.47 ms Память: 0.004 MB / 7.18 MB Application: afterRenderModule mod_custom (copirat)
Время: 0.03 ms / 228.50 ms Память: -0.002 MB / 7.18 MB Application: beforeRenderModule mod_custom (Контактная информация)
Время: 3.03 ms / 231.53 ms Память: 0.008 MB / 7.19 MB Application: afterRenderModule mod_custom (Контактная информация)
Время: 0.03 ms / 231.56 ms Память: 0.001 MB / 7.19 MB Application: beforeRenderModule mod_menu (Служба поддержки)
Время: 3.44 ms / 235.00 ms Память: 0.095 MB / 7.28 MB Application: afterRenderModule mod_menu (Служба поддержки)
Время: 0.03 ms / 235.04 ms Память: -0.004 MB / 7.28 MB Application: beforeRenderModule mod_menu (Каталог продукции)
Время: 4.75 ms / 239.78 ms Память: 0.030 MB / 7.31 MB Application: afterRenderModule mod_menu (Каталог продукции)
Время: 0.04 ms / 239.82 ms Память: 0.003 MB / 7.31 MB Application: beforeRenderModule mod_contactus (Обратная связь ru)
Время: 2.29 ms / 242.11 ms Память: 0.063 MB / 7.38 MB Application: afterRenderModule mod_contactus (Обратная связь ru)
Время: 0.05 ms / 242.16 ms Память: -0.011 MB / 7.37 MB Application: beforeRenderModule mod_jshopping_dop_products (Вы смотрели:)
Время: 3.30 ms / 245.46 ms Память: 0.175 MB / 7.54 MB Application: afterRenderModule mod_jshopping_dop_products (Вы смотрели:)
Время: 0.06 ms / 245.52 ms Память: -0.145 MB / 7.40 MB Application: beforeRenderModule mod_jshopping_unijax_filter (Фильтр товаров)
Время: 1.39 ms / 246.91 ms Память: 0.062 MB / 7.46 MB Application: afterRenderModule mod_jshopping_unijax_filter (Фильтр товаров)
Время: 0.03 ms / 246.94 ms Память: -0.029 MB / 7.43 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 1.26 ms / 248.20 ms Память: 0.013 MB / 7.44 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.04 ms / 248.24 ms Память: -0.004 MB / 7.44 MB Application: beforeRenderModule mod_custom (Вход в кабинет)
Время: 0.20 ms / 248.44 ms Память: 0.042 MB / 7.48 MB Application: beforeRenderModule mod_login (My account)
Время: 5.40 ms / 253.84 ms Память: 0.023 MB / 7.50 MB Application: afterRenderModule mod_login (My account)
Время: 0.66 ms / 254.51 ms Память: -0.036 MB / 7.47 MB Application: afterRenderModule mod_custom (Вход в кабинет)
Время: 0.02 ms / 254.53 ms Память: -0.003 MB / 7.46 MB Application: beforeRenderModule mod_jshopping_compare (Jshopping compare ++)
Время: 2.22 ms / 256.75 ms Память: 0.015 MB / 7.48 MB Application: afterRenderModule mod_jshopping_compare (Jshopping compare ++)
Время: 0.02 ms / 256.77 ms Память: -0.006 MB / 7.47 MB Application: beforeRenderModule mod_jshopping_cart_wl_ajax (ИЗбранное)
Время: 5.09 ms / 261.85 ms Память: 0.025 MB / 7.50 MB Application: afterRenderModule mod_jshopping_cart_wl_ajax (ИЗбранное)
Время: 0.02 ms / 261.87 ms Память: -0.011 MB / 7.49 MB Application: beforeRenderModule mod_jshopping_cart_wl_ajax (Jshopping Cart and Wishlist Ajax)
Время: 5.49 ms / 267.36 ms Память: 0.025 MB / 7.51 MB Application: afterRenderModule mod_jshopping_cart_wl_ajax (Jshopping Cart and Wishlist Ajax)
Время: 0.05 ms / 267.41 ms Память: -0.011 MB / 7.50 MB Application: beforeRenderModule mod_sj_megamenu_res (Категории рус)
Время: 16.56 ms / 283.97 ms Память: 0.029 MB / 7.53 MB Application: afterRenderModule mod_sj_megamenu_res (Категории рус)
Время: 0.03 ms / 284.00 ms Память: -0.008 MB / 7.52 MB Application: beforeRenderModule mod_custom (Контакты верх)
Время: 0.72 ms / 284.72 ms Память: 0.005 MB / 7.53 MB Application: afterRenderModule mod_custom (Контакты верх)
Время: 0.03 ms / 284.74 ms Память: -0.002 MB / 7.52 MB Application: beforeRenderModule mod_menu (Меню мобайл)
Время: 7.37 ms / 292.11 ms Память: 0.046 MB / 7.57 MB Application: afterRenderModule mod_menu (Меню мобайл)
Время: 2.79 ms / 294.90 ms Память: 0.027 MB / 7.60 MB Application: beforeRenderModule mod_menu (mainmenu)
Время: 6.17 ms / 301.07 ms Память: 0.100 MB / 7.70 MB Application: afterRenderModule mod_menu (mainmenu)
Время: 16.76 ms / 317.84 ms Память: 0.281 MB / 7.98 MB Application: afterRender
Всего SQL-запросов: 40.23 ms
9.11 MB (9 550 616 Байт )
Зафиксировано 73 SQL-запросов 40.23 ms Время запроса: 0.40 ms
SHOW VARIABLES LIKE 'query_cache_type'
EXPLAIN недоступен для запроса: SHOW VARIABLES LIKE 'query_cache_type'
Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/database/driver/pdomysql.php:604 10 JDatabaseDriverPdomysql->hasQueryCacheEnabled() JROOT/libraries/joomla/database/driver/pdomysql.php:160 9 JDatabaseDriverPdomysql->connect() JROOT/libraries/src/Filter/InputFilter.php:72 8 Joomla\CMS\Filter\InputFilter->__construct() JROOT/libraries/src/Filter/InputFilter.php:105 7 Joomla\CMS\Filter\InputFilter::getInstance() JROOT/libraries/src/Input/Input.php:64 6 Joomla\CMS\Input\Input->__construct() JROOT/libraries/src/Application/WebApplication.php:214 5 Joomla\CMS\Application\WebApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:110 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:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Время запроса: 0.33 ms После последнего запроса: 0.13 ms
SHOW VARIABLES LIKE 'have_profiling'
EXPLAIN недоступен для запроса: SHOW VARIABLES LIKE 'have_profiling'
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/database/driver/pdomysql.php:590 10 JDatabaseDriverPdomysql->hasProfiling() JROOT/libraries/joomla/database/driver/pdomysql.php:165 9 JDatabaseDriverPdomysql->connect() JROOT/libraries/src/Filter/InputFilter.php:72 8 Joomla\CMS\Filter\InputFilter->__construct() JROOT/libraries/src/Filter/InputFilter.php:105 7 Joomla\CMS\Filter\InputFilter::getInstance() JROOT/libraries/src/Input/Input.php:64 6 Joomla\CMS\Input\Input->__construct() JROOT/libraries/src/Application/WebApplication.php:214 5 Joomla\CMS\Application\WebApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:110 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:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Время запроса: 0.32 ms После последнего запроса: 3.17 ms
SELECT `data`
FROM `nucfh_session `
WHERE `session_id` = X'6431376531383862653830323836643833626436633933306630393536316432'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_session const PRIMARY PRIMARY 194 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.01 ms Update 0.04 ms Waiting for query cache lock 0.01 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 3.22 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 16 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Так же, как вызов в строке ниже. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 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:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Время запроса: 0.24 ms После последнего запроса: 0.75 ms
SELECT `session_id`
FROM `nucfh_session `
WHERE `session_id` = X'6431376531383862653830323836643833626436633933306630393536316432' LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_session const PRIMARY PRIMARY 194 const 1 Using index
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 9 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:806 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:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Время запроса: 3.47 ms После последнего запроса: 0.06 ms
INSERT INTO `nucfh_session `
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'6431376531383862653830323836643833626436633933306630393536316432', 1, 1748713078, 0, '')
EXPLAIN недоступен для запроса: INSERT INTO `nucfh_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'6431376531383862653830323836643833626436633933306630393536316432', 1, 1748713078, 0, '')
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 8 JDatabaseDriverPdo->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:806 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:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Время запроса: 0.45 ms После последнего запроса: 1.25 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nucfh_extensions `
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_extensions ref extension extension 82 const 44 Using index condition; Using where
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Так же, как вызов в строке ниже. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.26 ms После последнего запроса: 0.95 ms
SELECT id, rules
FROM `nucfh_viewlevels `
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_viewlevels ALL NULL Индекс не используется NULL NULL 5
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.42 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 10 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.30 ms После последнего запроса: 0.05 ms
SELECT b.id
FROM nucfh_usergroups AS a
LEFT JOIN nucfh_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index
Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 11 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.75 ms После последнего запроса: 0.11 ms
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM nucfh_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDER BY ordering
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_extensions ref extension extension 82 const 186 Using index condition; Using where; Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.04 ms Updating 0.05 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 3.37 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 11 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 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:359 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.42 ms После последнего запроса: 24.20 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nucfh_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition
Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/modalmessages/modalmessages.php:21 8 plgSystemModalmessages->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:646 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 3.67 ms После последнего запроса: 0.09 ms
UPDATE `nucfh_extensions `
SET `params` = '{\"mediaversion\":\"591f0728dc431da72cf9cdb7d0fc3fcd\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
EXPLAIN недоступен для запроса: UPDATE `nucfh_extensions`
SET `params` = '{\"mediaversion\":\"591f0728dc431da72cf9cdb7d0fc3fcd\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.21 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.04 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 14 JDatabaseDriverPdo->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/modalmessages/modalmessages.php:21 8 plgSystemModalmessages->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:646 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.61 ms После последнего запроса: 3.19 ms
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 nucfh_menu AS m
LEFT JOIN nucfh_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.lft
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 78 Using index condition; Using where; Используется filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 mystery27_dah.m.component_id 1 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:395 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:511 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:1119 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.83 ms После последнего запроса: 6.87 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_config `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_config`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.03 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 20 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 18 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 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:1579 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.37 ms После последнего запроса: 0.82 ms
SELECT *
FROM nucfh_jshopping_config
WHERE `id` = '1'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_config const PRIMARY PRIMARY 4 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 17 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 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:1579 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.43 ms После последнего запроса: 0.28 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_currencies `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_currencies`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 24 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 22 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 20 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/currency.php:14 19 jshopCurrency->__construct() JROOT/libraries/src/Table/Table.php:312 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:1579 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.32 ms После последнего запроса: 0.04 ms
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `nucfh_jshopping_currencies ` WHERE currency_publish = '1' ORDER BY currency_ordering
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_currencies ref currency_publish currency_publish 1 const 2 Using where; Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 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:1579 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.27 ms После последнего запроса: 1.69 ms
select category_id as id, `alias_ru-RU ` as alias nucfh_jshopping_categories RU `!= ''
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_categories ALL NULL Индекс не используется NULL NULL 7 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.15 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 16 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:255 14 JSFactory::getAliasCategory() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:73 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.34 ms После последнего запроса: 0.05 ms
select product_id as id, `alias_ru-RU ` as alias nucfh_jshopping_products RU `!= ''
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products ALL NULL Индекс не используется NULL NULL 61 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.03 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 16 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:303 14 JSFactory::getAliasProduct() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:74 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.63 ms После последнего запроса: 0.24 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_products `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_products`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 20 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 18 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/product.php:15 15 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:80 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.43 ms После последнего запроса: 0.39 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_addons `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_addons`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 25 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 23 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 22 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 21 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/addon.php:20 20 jshopAddon->__construct() JROOT/libraries/src/Table/Table.php:312 19 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/jshoppingproducts/ba_custom_fields/ba_custom_fields.php:16 18 plgJshoppingProductsBa_custom_fields->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 17 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 16 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/tables/product.php:16 15 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:80 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.30 ms После последнего запроса: 0.05 ms
SELECT *
FROM nucfh_jshopping_addons
WHERE `alias` = 'ba_custom_fields'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_addons ref alias alias 767 const 1 Using index condition
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 22 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 21 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 20 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/addon.php:36 19 jshopAddon->loadAlias() JROOT/plugins/jshoppingproducts/ba_custom_fields/ba_custom_fields.php:17 18 plgJshoppingProductsBa_custom_fields->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 17 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 16 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/tables/product.php:16 15 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:80 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.28 ms После последнего запроса: 0.45 ms
SELECT *
FROM nucfh_jshopping_addons
WHERE `alias` = 'second_short_description_for_category'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_addons ref alias alias 767 const 1 Using index condition
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 22 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 21 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 20 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/addon.php:36 19 jshopAddon->loadAlias() JROOT/plugins/jshoppingproducts/second_short_description_for_category/second_short_description_for_category.php:20 18 plgJshoppingProductsSecond_short_description_for_category->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 17 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 16 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/tables/product.php:16 15 jshopProduct->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:80 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.57 ms После последнего запроса: 0.45 ms
Повторяющиеся запросы:
#36 SELECT *
FROM nucfh_jshopping_products
WHERE `product_id` = '13828'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products const PRIMARY PRIMARY 4 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.08 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 16 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 14 Joomla\CMS\Table\Table->load() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:81 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.27 ms После последнего запроса: 0.07 ms
Повторяющиеся запросы:
#38 SELECT * FROM `nucfh_jshopping_products_to_categories ` WHERE product_id= 13828
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products_to_categories ref PRIMARY,product_id,product_id_2 product_id_2 4 const 1 Using index
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 16 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:280 14 jshopProduct->getCategories() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:82 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.51 ms После последнего запроса: 0.20 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_categories `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_categories`
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 22 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 20 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 18 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/category.php:15 17 jshopCategory->__construct() JROOT/libraries/src/Table/Table.php:312 16 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:23 15 plgJshoppingRouterFull_Category_Path::getCategoryList() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:38 14 plgJshoppingRouterFull_Category_Path::buildSegment() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:89 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.31 ms После последнего запроса: 0.08 ms
SELECT category_id, category_parent_id FROM `nucfh_jshopping_categories ` = '1' IN (1,1,5) ORDER BY ordering
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_categories ALL category_publish,access,category_publish_2 Индекс не используется NULL NULL 7 Using where; Используется filesort
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.07 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.24 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 18 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:115 16 jshopCategory->getAllCategories() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:23 15 plgJshoppingRouterFull_Category_Path::getCategoryList() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:38 14 plgJshoppingRouterFull_Category_Path::buildSegment() JROOT/plugins/jshoppingrouter/full_category_path/full_category_path.php:89 13 plgJshoppingRouterFull_Category_Path->onBeforeParseRoute() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:231 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:1120 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.35 ms После последнего запроса: 2.40 ms
SELECT id, home, template, s.params
FROM nucfh_template_styles as s
LEFT JOIN nucfh_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 = 1
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 4 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 mystery27_dah.s.template,const 1 Using index condition; Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t4/src/t4/T4.php:39 9 T4\T4->init() JROOT/plugins/system/t4/t4.php:61 8 PlgSystemT4->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:1168 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.60 ms После последнего запроса: 1.01 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `nucfh_assets `
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactus','com_content','com_contenthistory','com_cpanel','com_excel2js','com_fields','com_finder','com_installer','com_jlsitemap','com_joomlaupdate','com_jshopping','com_jspeed','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slogin','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper')
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_assets ALL idx_asset_name Индекс не используется NULL NULL 273 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 17 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 15 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 14 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 13 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 12 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 11 Joomla\CMS\User\User->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:28 10 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/advancedmodules.php:97 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:1168 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.31 ms После последнего запроса: 0.76 ms
SELECT *
FROM nucfh_languages
WHERE published= 1
ORDER BY ordering ASC
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_languages ALL NULL Индекс не используется NULL NULL 2 Using where; Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 7 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.25 ms После последнего запроса: 29.79 ms
select * nucfh_jshopping_languages
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_languages ALL NULL Индекс не используется NULL NULL 4
Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.56 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms
# Вызывающий объект Файл и номер строки 10 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/functions.php:296 8 installNewLanguages() JROOT/components/com_jshopping/loadparams.php:33 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.29 ms После последнего запроса: 14.06 ms
Повторяющиеся запросы:
#60 SELECT *
FROM nucfh_jshopping_addons
WHERE `alias` = 'addon_quickorder'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_addons ref alias alias 767 const 1 Using index condition
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.11 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.11 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.04 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 18 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 16 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/addon.php:36 15 jshopAddon->loadAlias() JROOT/plugins/jshoppingcheckout/quickorder/quickorder.php:10 14 plgJshoppingCheckoutQuickOrder->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 13 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 12 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_jshopping/models/productshop.php:21 11 jshopProductShop->__construct() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202 10 Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() JROOT/components/com_jshopping/lib/factory.php:628 9 JSFactory::getModel() JROOT/components/com_jshopping/controllers/product.php:24 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.92 ms После последнего запроса: 1.09 ms
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 nucfh_modules AS m
LEFT JOIN nucfh_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
LEFT JOIN nucfh_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.ordering
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref published,newsfeeds published 1 const 61 Using index condition; Using where; Используется filesort 1 SIMPLE am eq_ref PRIMARY PRIMARY 4 mystery27_dah.m.id 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 mystery27_dah.m.module,const 1 Using index condition; Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms Checking permissions 0.04 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:611 17 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:171 16 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 15 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 14 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:357 13 Joomla\CMS\Helper\_JModuleHelper::load() JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:37 12 Joomla\CMS\Helper\_JModuleHelper::getModule() JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:493 11 plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:41 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.58 ms После последнего запроса: 15.74 ms
Повторяющиеся запросы:
#41 SHOW FULL COLUMNS FROM `nucfh_jshopping_users `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_users`
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 21 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 19 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/usershopbase.php:14 16 jshopUserShopBase->__construct() JROOT/components/com_jshopping/models/userguest.php:16 15 jshopUserGust->__construct() JROOT/components/com_jshopping/lib/factory.php:66 14 JSFactory::getUserShopGuest() JROOT/modules/mod_jshopping_unijax_filter/helper.php:643 13 modJshopping_Unijax_FilterHelper->__construct() JROOT/modules/mod_jshopping_unijax_filter/helper.php:23 12 modJshopping_Unijax_FilterHelper::getInstance() JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:496 11 plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:41 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.43 ms После последнего запроса: 0.24 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_usergroups `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_usergroups`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.24 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 23 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 21 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 19 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/usergroup.php:14 18 jshopUserGroup->__construct() JROOT/libraries/src/Table/Table.php:312 17 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 16 JSFactory::getTable() JROOT/components/com_jshopping/models/userguest.php:30 15 jshopUserGust->load() JROOT/components/com_jshopping/lib/factory.php:67 14 JSFactory::getUserShopGuest() JROOT/modules/mod_jshopping_unijax_filter/helper.php:643 13 modJshopping_Unijax_FilterHelper->__construct() JROOT/modules/mod_jshopping_unijax_filter/helper.php:23 12 modJshopping_Unijax_FilterHelper::getInstance() JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:496 11 plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:41 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.41 ms После последнего запроса: 0.30 ms
select id,link nucfh_menu
= 'component' = 1 = com_jshopping%' = 0
= '* ' or language= 'ru-RU ') IN (1,1,5)
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_menu ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 79 Using index condition; Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 21 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/shop_item_menu.php:141 19 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:47 18 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:40 17 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:402 16 getShopMainPageItemid() JROOT/components/com_jshopping/lib/functions.php:421 15 getDefaultItemid() JROOT/components/com_jshopping/lib/functions.php:480 14 SEFLink() JROOT/modules/mod_jshopping_unijax_filter/helper.php:731 13 modJshopping_Unijax_FilterHelper->__construct() JROOT/modules/mod_jshopping_unijax_filter/helper.php:23 12 modJshopping_Unijax_FilterHelper::getInstance() JROOT/plugins/jshoppingproducts/unijax_filter/unijax_filter.php:496 11 plgJshoppingproductsUnijax_Filter->onBeforeLoadProductList() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:41 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.56 ms После последнего запроса: 0.78 ms
Повторяющиеся запросы:
#23 SELECT *
FROM nucfh_jshopping_products
WHERE `product_id` = '13828'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products const PRIMARY PRIMARY 4 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 11 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:44 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.32 ms После последнего запроса: 0.11 ms
SELECT *
FROM nucfh_jshopping_categories
WHERE `category_id` = '178'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_categories const PRIMARY PRIMARY 4 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.04 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 11 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/controllers/product.php:47 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.26 ms После последнего запроса: 0.04 ms
Повторяющиеся запросы:
#24 SELECT * FROM `nucfh_jshopping_products_to_categories ` WHERE product_id= 13828
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products_to_categories ref PRIMARY,product_id,product_id_2 product_id_2 4 const 1 Using index
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.07 ms Creating sort index 0.02 ms Removing tmp table 0.02 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:280 10 jshopProduct->getCategories() JROOT/components/com_jshopping/models/productshop.php:79 9 jshopProductShop->getCategories() JROOT/components/com_jshopping/controllers/product.php:52 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.46 ms После последнего запроса: 0.22 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_attr `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_attr`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.10 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 21 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 19 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/attribut.php:14 16 jshopAttribut->__construct() JROOT/libraries/src/Table/Table.php:312 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:126 12 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:205 11 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/tables/product.php:233 10 jshopProduct->getInitLoadAttribute() JROOT/components/com_jshopping/models/productshop.php:92 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.45 ms После последнего запроса: 0.05 ms
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 `nucfh_jshopping_attr ` as A nucfh_jshopping_attr_groups ` as G = G.id
ORDER BY G.ordering, A.attr_ordering
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE A ALL NULL Индекс не используется NULL NULL 1 Using temporary; Используется filesort 1 SIMPLE G eq_ref PRIMARY PRIMARY 4 mystery27_dah.A.group 1 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.04 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 16 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 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:126 12 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/tables/product.php:205 11 jshopProduct->getAttributesDatas() JROOT/components/com_jshopping/tables/product.php:233 10 jshopProduct->getInitLoadAttribute() JROOT/components/com_jshopping/models/productshop.php:92 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.55 ms После последнего запроса: 0.06 ms
Повторяющиеся запросы:
#33 SHOW FULL COLUMNS FROM `nucfh_jshopping_users `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_users`
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.14 ms Creating sort index 0.05 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 17 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 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:1128 11 jshopProduct->getBuildSelectAttributes() JROOT/components/com_jshopping/tables/product.php:237 10 jshopProduct->getInitLoadAttribute() JROOT/components/com_jshopping/models/productshop.php:92 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.45 ms После последнего запроса: 0.25 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_products_extra_fields `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_products_extra_fields`
Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting for group 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.10 ms Creating sort index 0.02 ms Removing tmp table 0.02 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 22 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 20 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 18 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfield.php:14 17 jshopProductField->__construct() JROOT/libraries/src/Table/Table.php:312 16 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 15 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:496 14 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1121 13 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:214 12 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:842 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:531 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.52 ms После последнего запроса: 0.05 ms
SELECT F.id, F.`name_ru-RU ` as name, F.`description_ru-RU ` as description, F.allcats, F.type, F.cats, F.ordering, F.`RU ` as groupname, multilist FROM `nucfh_jshopping_products_extra_fields ` as F nucfh_jshopping_products_extra_field_groups ` as G = F.
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE F ALL NULL Индекс не используется NULL NULL 26 Using temporary; Используется filesort 1 SIMPLE G eq_ref PRIMARY PRIMARY 4 mystery27_dah.F.group 1 Using where
Status Duration Starting 0.01 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.02 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 17 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfield.php:48 15 jshopProductField->getList() JROOT/components/com_jshopping/lib/factory.php:497 14 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1121 13 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:214 12 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:842 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:531 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.59 ms После последнего запроса: 0.08 ms
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` , IF (prod.product_quantity>0,1,0) as qflag FROM `nucfh_jshopping_products_relations ` AS relation
INNER JOIN `nucfh_jshopping_products ` AS prod ON relation.product_related_id = prod.product_id
LEFT JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id
WHERE relation.product_id= 13828 AND cat.category_publish= 1 AND prod.product_publish= 1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5)
ORDER BY qflag DESC , name ASC
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE relation ref product_id,product_id_2,product_related_id product_id 4 const 1 Using where; Using index; Using temporary; Используется filesort 1 SIMPLE prod eq_ref PRIMARY,product_publish,access PRIMARY 4 mystery27_dah.relation.product_related_id 1 Using where 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 PRIMARY 4 mystery27_dah.relation.product_related_id 1 Using index 1 SIMPLE cat eq_ref PRIMARY,category_publish,access,category_publish_2 PRIMARY 4 mystery27_dah.pr_cat.category_id 1 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:855 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:531 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.38 ms После последнего запроса: 0.19 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_taxes `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_taxes`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 21 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 19 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 17 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/tax.php:14 16 jshopTax->__construct() JROOT/libraries/src/Table/Table.php:312 15 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 14 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:369 13 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:663 12 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:859 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:531 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.26 ms После последнего запроса: 0.04 ms
SELECT tax_id, tax_name, tax_value FROM `nucfh_jshopping_taxes `
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_taxes ALL NULL Индекс не используется NULL NULL 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.03 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 17 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/tax.php:21 15 jshopTax->getAllTaxes() JROOT/components/com_jshopping/lib/factory.php:355 14 JSFactory::getAllTaxesOriginal() JROOT/components/com_jshopping/lib/factory.php:370 13 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:663 12 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:859 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:531 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.28 ms После последнего запроса: 0.05 ms
select manufacturer_id as id, `name_ru-RU ` as name, manufacturer_logo, manufacturer_url nucfh_jshopping_manufacturers = '1'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_manufacturers ref manufacturer_publish manufacturer_publish 1 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.03 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 15 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:422 13 JSFactory::getAllManufacturer() JROOT/components/com_jshopping/lib/functions.php:665 12 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:859 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:531 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.44 ms После последнего запроса: 0.24 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_products_reviews `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_products_reviews`
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 17 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 15 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 14 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 13 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/review.php:14 12 jshopReview->__construct() JROOT/libraries/src/Table/Table.php:312 11 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 10 JSFactory::getTable() JROOT/components/com_jshopping/models/productshop.php:114 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.43 ms После последнего запроса: 0.48 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_products_extra_field_values `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_products_extra_field_values`
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Creating tmp table 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.07 ms Creating sort index 0.01 ms Removing tmp table 0.02 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 17 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productfieldvalue.php:15 14 jshopProductFieldValue->__construct() JROOT/libraries/src/Table/Table.php:312 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 12 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:505 11 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/tables/product.php:764 10 jshopProduct->getExtraFields() JROOT/components/com_jshopping/models/productshop.php:152 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.35 ms После последнего запроса: 0.04 ms
SELECT id, `name_ru-RU ` as name, field_id FROM `nucfh_jshopping_products_extra_field_values `
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products_extra_field_values ALL NULL Индекс не используется NULL NULL 67 Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.03 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.03 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 14 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfieldvalue.php:26 12 jshopProductFieldValue->getAllList() JROOT/components/com_jshopping/lib/factory.php:506 11 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/tables/product.php:764 10 jshopProduct->getExtraFields() JROOT/components/com_jshopping/models/productshop.php:152 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.42 ms После последнего запроса: 0.07 ms
SELECT FA .id, FA .required, FA .`name_ru-RU ` as name, FA .`description_ru-RU ` as description, FA .type
FROM `nucfh_jshopping_products_free_attr ` as PFA
nucfh_jshopping_free_attr ` as FA FA .id= PFA.attr_id
WHERE PFA .product_id= 13828 FA .ordering
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE PFA ref product_id product_id 4 const 1 Using temporary; Используется filesort 1 SIMPLE FA eq_ref PRIMARY PRIMARY 4 mystery27_dah.PFA.attr_id 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:256 10 jshopProduct->getListFreeAttributes() JROOT/components/com_jshopping/models/productshop.php:158 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.44 ms После последнего запроса: 0.19 ms
SHOW FULL COLUMNS FROM `nucfh_jshopping_product_labels `
EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `nucfh_jshopping_product_labels`
Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.12 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 18 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/pdomysql.php:334 16 JDatabaseDriverPdomysql->getTableColumns() JROOT/libraries/src/Table/Table.php:245 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 14 Joomla\CMS\Table\Table->__construct() JROOT/components/com_jshopping/tables/productlabel.php:14 13 jshopProductLabel->__construct() JROOT/libraries/src/Table/Table.php:312 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jshopping/lib/factory.php:621 11 JSFactory::getTable() JROOT/components/com_jshopping/lib/functions.php:632 10 getNameImageLabel() JROOT/components/com_jshopping/models/productshop.php:177 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.27 ms После последнего запроса: 0.04 ms
SELECT id, image, `name_ru-RU ` as name FROM `nucfh_jshopping_product_labels ` ORDER BY name
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_product_labels ALL NULL Индекс не используется NULL NULL 4 Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.03 ms Updating 0.06 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 2.83 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productlabel.php:22 11 jshopProductLabel->getListLabels() JROOT/components/com_jshopping/lib/functions.php:633 10 getNameImageLabel() JROOT/components/com_jshopping/models/productshop.php:177 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.62 ms После последнего запроса: 2.24 ms
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 nucfh_fields AS a
LEFT JOIN `nucfh_languages ` AS l ON l.lang_code = a.language
LEFT JOIN nucfh_users AS uc ON uc.id= a.checked_out
LEFT JOIN nucfh_viewlevels AS ag ON ag.id = a.access
LEFT JOIN nucfh_users AS ua ON ua.id = a.created_user_id
LEFT JOIN nucfh_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 ASC
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 mystery27_dah.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.group_id 1 Using where
Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Creating tmp table 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.01 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php: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:935 10 changeDataUsePluginContent() JROOT/components/com_jshopping/models/productshop.php:199 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:54 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 3.13 ms После последнего запроса: 2.40 ms
UPDATE nucfh_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '13828'
EXPLAIN недоступен для запроса: UPDATE nucfh_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '13828'
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 10 JDatabaseDriverPdo->execute() JROOT/libraries/src/Table/Table.php:1245 9 Joomla\CMS\Table\Table->hit() JROOT/components/com_jshopping/controllers/product.php:67 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.36 ms После последнего запроса: 0.03 ms
SELECT I.* , IF (P.image= I.image_name,0,1) as sort FROM `nucfh_jshopping_products_images ` as I
nucfh_jshopping_products ` as P = I.product_id
WHERE I.product_id= 13828 ORDER BY sort, I.ordering
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE I ref product_id product_id 4 const 3 Using temporary; Используется filesort 1 SIMPLE P const PRIMARY PRIMARY 4 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms
# Вызывающий объект Файл и номер строки 11 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:369 9 jshopProduct->getImages() JROOT/components/com_jshopping/controllers/product.php:77 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.28 ms После последнего запроса: 0.05 ms
SELECT video_name, video_id, video_preview, video_code FROM `nucfh_jshopping_products_videos ` WHERE product_id= 13828
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products_videos ref product_id product_id 4 const 1
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 11 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:389 9 jshopProduct->getVideos() JROOT/components/com_jshopping/controllers/product.php:78 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.31 ms После последнего запроса: 0.03 ms
SELECT * FROM `nucfh_jshopping_products_files ` WHERE product_id= 13828 = ''
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products_files ref product_id product_id 4 const 1 Using where; Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 11 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:417 9 jshopProduct->getDemoFiles() JROOT/components/com_jshopping/controllers/product.php:79 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.32 ms После последнего запроса: 0.06 ms
SELECT *
FROM `nucfh_jshopping_custom_fields `
WHERE `position_category` != "0"
ORDER BY `ordering` ASC
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_custom_fields ALL NULL Индекс не используется NULL NULL 1 Using where; Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/ba_custom_fields/ba_custom_fields.php:42 11 plgJshoppingProductsBa_custom_fields->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:81 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.27 ms После последнего запроса: 0.06 ms
Повторяющиеся запросы:
#31 SELECT *
FROM nucfh_jshopping_addons
WHERE `alias` = 'addon_quickorder'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_addons ref alias alias 767 const 1 Using index condition
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 16 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 14 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/addon.php:36 13 jshopAddon->loadAlias() JROOT/plugins/jshoppingproducts/quickorder/quickorder.php:14 12 plgJshoppingProductsQuickOrder->_init() JROOT/plugins/jshoppingproducts/quickorder/quickorder.php:66 11 plgJshoppingProductsQuickOrder->onBeforeDisplayProductList() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:81 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.28 ms После последнего запроса: 2.62 ms
SELECT count(review_id) FROM `nucfh_jshopping_products_reviews ` WHERE product_id= 13828 = 1
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products_reviews ref product_id,publish product_id 4 const 1 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_jshopping/tables/product.php:1095 10 jshopProduct->getReviewsCount() JROOT/components/com_jshopping/models/productreviewlist.php:86 9 jshopProductReviewList->load() JROOT/components/com_jshopping/controllers/product.php:109 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.23 ms После последнего запроса: 1.07 ms
SELECT * FROM `nucfh_jshopping_products_reviews ` WHERE product_id= 13828 = 1
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_products_reviews ref product_id,publish product_id 4 const 1 Using where
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 12 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:1087 10 jshopProduct->getReviews() JROOT/components/com_jshopping/models/productreviewlist.php:88 9 jshopProductReviewList->load() JROOT/components/com_jshopping/controllers/product.php:109 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.27 ms После последнего запроса: 2.64 ms
SELECT *
FROM `nucfh_jshopping_custom_fields `
WHERE `position_product` != "0"
ORDER BY `ordering` ASC
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_custom_fields ALL NULL Индекс не используется NULL NULL 1 Using where; Используется filesort
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/ba_custom_fields/ba_custom_fields.php:86 11 plgJshoppingProductsBa_custom_fields->onBeforeDisplayProductView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:131 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.28 ms После последнего запроса: 0.04 ms
SELECT *
FROM `nucfh_jshopping_custom_fields_values `
WHERE `id_product` = 13828 AND `lang` = "ru-RU "
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_custom_fields_values ALL NULL Индекс не используется NULL NULL 79 Using where
Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.10 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/plugins/jshoppingproducts/ba_custom_fields/ba_custom_fields.php:95 11 plgJshoppingProductsBa_custom_fields->onBeforeDisplayProductView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:131 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.26 ms После последнего запроса: 0.07 ms
SELECT *
FROM nucfh_jshopping_addons
WHERE `alias` = 'addon_similar_products'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_addons ref alias alias 767 const 1 Using index condition
Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 15 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 13 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/addon.php:36 12 jshopAddon->loadAlias() JROOT/plugins/jshoppingproducts/similar_products/similar_products.php:37 11 plgJshoppingProductsSimilar_Products->onBeforeDisplayProductView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:131 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.59 ms После последнего запроса: 0.59 ms
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` , IF (prod.product_quantity>0,1,0) as qflag FROM `nucfh_jshopping_products_similar ` AS similar
INNER JOIN `nucfh_jshopping_products ` AS prod ON similar.product_similar_id = prod.product_id
LEFT JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = similar.product_similar_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id
WHERE similar.product_id = '13828' AND cat.category_publish= '1' AND prod.product_publish = '1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) ORDER BY qflag DESC , name ASC
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE similar ref product_id product_id 4 const 1 Using where; Using temporary; Используется filesort 1 SIMPLE prod eq_ref PRIMARY,product_publish,access PRIMARY 4 mystery27_dah.similar.product_similar_id 1 Using where 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 PRIMARY 4 mystery27_dah.similar.product_similar_id 1 Using index 1 SIMPLE cat eq_ref PRIMARY,category_publish,access,category_publish_2 PRIMARY 4 mystery27_dah.pr_cat.category_id 1 Using where
Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.12 ms Creating sort index 0.02 ms Removing tmp table 0.02 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/jshoppingproducts/similar_products/similar_products.php:69 11 plgJshoppingProductsSimilar_Products->onBeforeDisplayProductView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:131 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.24 ms После последнего запроса: 0.44 ms
SELECT *
FROM nucfh_jshopping_addons
WHERE `alias` = 'lin_free_attr_type'
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_jshopping_addons ref alias alias 767 const 1 Using index condition
Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.50 ms Creating sort index 0.15 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 15 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 13 Joomla\CMS\Table\Table->load() JROOT/components/com_jshopping/tables/addon.php:36 12 jshopAddon->loadAlias() JROOT/plugins/jshoppingproducts/lin_free_attr_type/lin_free_attr_type.php:21 11 plgJShoppingProductsLin_Free_Attr_Type->onBeforeDisplayProductView() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/components/com_jshopping/controllers/product.php:131 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.59 ms После последнего запроса: 2.55 ms
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 nucfh_fields AS a
LEFT JOIN `nucfh_languages ` AS l ON l.lang_code = a.language
LEFT JOIN nucfh_users AS uc ON uc.id= a.checked_out
LEFT JOIN nucfh_viewlevels AS ag ON ag.id = a.access
LEFT JOIN nucfh_users AS ua ON ua.id = a.created_user_id
LEFT JOIN nucfh_fields_groups AS g ON g.id = a.group_id
WHERE a.context = 'mod_custom.content' 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 ASC
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 mystery27_dah.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 mystery27_dah.a.group_id 1 Using where
Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting for group 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.10 ms Creating sort index 0.01 ms Removing tmp table 0.02 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 29 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 27 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 26 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 25 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 24 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 23 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 18 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 17 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:200 15 Joomla\CMS\Helper\_JModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 13 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/templates/ja_alpha/html/com_jshopping/product/product_default.php:582 12 include JROOT/templates/ja_alpha/html/com_jshopping/product/product_default.php JROOT/plugins/system/t4/src/joomla/src/MVC/View/HtmlView.php:115 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:230 10 Joomla\CMS\MVC\View\_JHtmlView->display() JROOT/components/com_jshopping/views/product/view.html.php:13 9 JshoppingViewProduct->display() JROOT/components/com_jshopping/controllers/product.php:132 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 1.11 ms После последнего запроса: 5.24 ms
Повторяющиеся запросы:
#72 SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` FROM `nucfh_jshopping_products ` AS prod
INNER JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = prod.product_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id
WHERE prod.product_publish = '1' AND cat.category_publish= '1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5)
GROUP BY prod.product_id LIMIT 20
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cat ref PRIMARY,category_publish,access,category_publish_2 category_publish_2 1 const 7 Using where; Using index; Using temporary; Используется filesort 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 category_id 4 mystery27_dah.cat.category_id 5 Using index 1 SIMPLE prod eq_ref PRIMARY,product_publish,access PRIMARY 4 mystery27_dah.pr_cat.product_id 1 Using where
Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jshopping_dop_products/helper.php:17 17 modJshopping_dop_productsHelper::getDopProducts() JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php:163 16 include JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:200 15 Joomla\CMS\Helper\_JModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 13 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/templates/ja_alpha/html/com_jshopping/product/product_default.php:696 12 include JROOT/templates/ja_alpha/html/com_jshopping/product/product_default.php JROOT/plugins/system/t4/src/joomla/src/MVC/View/HtmlView.php:115 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:230 10 Joomla\CMS\MVC\View\_JHtmlView->display() JROOT/components/com_jshopping/views/product/view.html.php:13 9 JshoppingViewProduct->display() JROOT/components/com_jshopping/controllers/product.php:132 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.57 ms После последнего запроса: 0.35 ms
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` FROM `nucfh_jshopping_products_relations ` AS relation
INNER JOIN `nucfh_jshopping_products ` AS prod ON relation.product_related_id = prod.product_id
LEFT JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id
WHERE relation.product_id= 13828 AND cat.category_publish= 1 AND prod.product_publish= 1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5)
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE relation ref product_id,product_id_2,product_related_id product_id 4 const 1 Using where; Using index; Using temporary; Используется filesort 1 SIMPLE prod eq_ref PRIMARY,product_publish,access PRIMARY 4 mystery27_dah.relation.product_related_id 1 Using where 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 PRIMARY 4 mystery27_dah.relation.product_related_id 1 Using index 1 SIMPLE cat eq_ref PRIMARY,category_publish,access,category_publish_2 PRIMARY 4 mystery27_dah.pr_cat.category_id 1 Using where
Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.50 ms Creating sort index 0.15 ms Removing tmp table 0.04 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 19 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jshopping_dop_products/helper.php:55 17 modJshopping_dop_productsHelper::getDopRelatedProducts() JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php:266 16 include JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:200 15 Joomla\CMS\Helper\_JModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 13 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/templates/ja_alpha/html/com_jshopping/product/product_default.php:696 12 include JROOT/templates/ja_alpha/html/com_jshopping/product/product_default.php JROOT/plugins/system/t4/src/joomla/src/MVC/View/HtmlView.php:115 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:230 10 Joomla\CMS\MVC\View\_JHtmlView->display() JROOT/components/com_jshopping/views/product/view.html.php:13 9 JshoppingViewProduct->display() JROOT/components/com_jshopping/controllers/product.php:132 8 JshoppingControllerProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.32 ms После последнего запроса: 57.21 ms
SELECT params
FROM nucfh_modules
WHERE id= 221
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE nucfh_modules const PRIMARY PRIMARY 4 const 1
Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/modules/mod_contactus/helper.php:31 11 ModContactusHelper::getFields() JROOT/modules/mod_contactus/mod_contactus.php:18 10 include JROOT/modules/mod_contactus/mod_contactus.php JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:200 9 Joomla\CMS\Helper\_JModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 1.15 ms После последнего запроса: 1.83 ms
Повторяющиеся запросы:
#69 SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` FROM `nucfh_jshopping_products ` AS prod
INNER JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = prod.product_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id
WHERE prod.product_publish = '1' AND cat.category_publish= '1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5)
GROUP BY prod.product_id LIMIT 20
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cat ref PRIMARY,category_publish,access,category_publish_2 category_publish_2 1 const 7 Using where; Using index; Using temporary; Используется filesort 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 category_id 4 mystery27_dah.cat.category_id 5 Using index 1 SIMPLE prod eq_ref PRIMARY,product_publish,access PRIMARY 4 mystery27_dah.pr_cat.product_id 1 Using where
Status Duration Starting 0.04 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.27 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jshopping_dop_products/helper.php:17 11 modJshopping_dop_productsHelper::getDopProducts() JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php:163 10 include JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:200 9 Joomla\CMS\Helper\_JModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Время запроса: 0.43 ms После последнего запроса: 0.32 ms
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` FROM `nucfh_jshopping_products ` AS prod
INNER JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = prod.product_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id
WHERE prod.product_publish = '1' AND cat.category_publish= '1' AND prod.product_id in (13828) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5)
GROUP BY prod.product_id ORDER BY prod.product_id ASC LIMIT 20
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE prod const PRIMARY,product_publish,access PRIMARY 4 const 1 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 PRIMARY 4 const 1 Using index 1 SIMPLE cat eq_ref PRIMARY,category_publish,access,category_publish_2 PRIMARY 4 mystery27_dah.pr_cat.category_id 1 Using where
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
# Вызывающий объект Файл и номер строки 13 JDatabaseDriverPdo->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jshopping_dop_products/helper.php:17 11 modJshopping_dop_productsHelper::getDopProducts() JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php:252 10 include JROOT/modules/mod_jshopping_dop_products/mod_jshopping_dop_products.php JROOT/plugins/system/t4/src/t4/Helper/Joomla.php(12) : eval()'d code:200 9 Joomla\CMS\Helper\_JModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Зафиксировано 60 типов SQL-запросов, отсортировано по вхождениям Запросы типа SELECT: 6 × SELECT * FROM nucfh_jshopping_addons 3 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` FROM `nucfh_jshopping_products ` AS prod
INNER JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = prod.product_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id 2 × SELECT * FROM `nucfh_jshopping_products_to_categories ` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `nucfh_extensions ` 2 × 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 nucfh_fields AS a LEFT JOIN `nucfh_languages ` AS l ON l.lang_code = a.language LEFT JOIN nucfh_users AS uc ON uc.id= a.checked_out LEFT JOIN nucfh_viewlevels AS ag ON ag.id = a.access LEFT JOIN nucfh_users AS ua ON ua.id = a.created_user_id LEFT JOIN nucfh_fields_groups AS g ON g.id = a.group_id 2 × SELECT * FROM `nucfh_jshopping_custom_fields ` 2 × SELECT * FROM nucfh_jshopping_products 1 × select manufacturer_id as id, `name_ru-RU ` as name, manufacturer_logo, manufacturer_url nucfh_jshopping_manufacturers 1 × SELECT id, `name_ru-RU ` as name, field_id FROM `nucfh_jshopping_products_extra_field_values ` 1 × SELECT FA .id, FA .required, FA .`name_ru-RU ` as name, FA .`description_ru-RU ` as description, FA .type
FROM `nucfh_jshopping_products_free_attr ` as PFA
nucfh_jshopping_free_attr ` as FA FA .id= PFA.attr_id 1 × SELECT id, image, `name_ru-RU ` as name FROM `nucfh_jshopping_product_labels ` 1 × SELECT I.* , IF (P.image= I.image_name,0,1) as sort FROM `nucfh_jshopping_products_images ` as I
nucfh_jshopping_products ` as P = I.product_id 1 × SELECT video_name, video_id, video_preview, video_code FROM `nucfh_jshopping_products_videos ` 1 × SELECT `data` FROM `nucfh_session ` 1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` , IF (prod.product_quantity>0,1,0) as qflag FROM `nucfh_jshopping_products_relations ` AS relation
INNER JOIN `nucfh_jshopping_products ` AS prod ON relation.product_related_id = prod.product_id
LEFT JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id 1 × SELECT * FROM `nucfh_jshopping_products_files ` 1 × SELECT count(review_id) FROM `nucfh_jshopping_products_reviews ` 1 × SELECT * FROM `nucfh_jshopping_products_reviews ` 1 × SELECT * FROM `nucfh_jshopping_custom_fields_values ` 1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` , IF (prod.product_quantity>0,1,0) as qflag FROM `nucfh_jshopping_products_similar ` AS similar INNER JOIN `nucfh_jshopping_products ` AS prod ON similar.product_similar_id = prod.product_id LEFT JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = similar.product_similar_id LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id 1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU ` as name, prod.`short_description_ru-RU ` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_36` , prod.`extra_field_37` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_41` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_46` , prod.`extra_field_47` , prod.`extra_field_48` , prod.`extra_field_49` , prod.`extra_field_50` , prod.`extra_field_51` FROM `nucfh_jshopping_products_relations ` AS relation
INNER JOIN `nucfh_jshopping_products ` AS prod ON relation.product_related_id = prod.product_id
LEFT JOIN `nucfh_jshopping_products_to_categories ` AS pr_cat ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `nucfh_jshopping_categories ` AS cat ON pr_cat.category_id = cat.category_id 1 × SELECT tax_id, tax_name, tax_value FROM `nucfh_jshopping_taxes 1 × SELECT * FROM nucfh_jshopping_categories 1 × SELECT F.id, F.`name_ru-RU ` as name, F.`description_ru-RU ` as description, F.allcats, F.type, F.cats, F.ordering, F.`RU ` as groupname, multilist FROM `nucfh_jshopping_products_extra_fields ` as F nucfh_jshopping_products_extra_field_groups ` as G = F. 1 × select product_id as id, `alias_ru-RU ` as alias nucfh_jshopping_products 1 × SELECT id, rules FROM `nucfh_viewlevels 1 × SELECT b.id FROM nucfh_usergroups AS a LEFT JOIN nucfh_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM nucfh_extensions 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 nucfh_menu AS m LEFT JOIN nucfh_extensions AS e ON m.component_id = e.extension_id 1 × SELECT * FROM nucfh_jshopping_config 1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `nucfh_jshopping_currencies ` 1 × select category_id as id, `alias_ru-RU ` as alias nucfh_jshopping_categories 1 × SELECT category_id, category_parent_id FROM `nucfh_jshopping_categories ` 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 `nucfh_jshopping_attr ` as A nucfh_jshopping_attr_groups ` as G = G.id 1 × SELECT id, home, template, s.params FROM nucfh_template_styles as s LEFT JOIN nucfh_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `nucfh_assets ` 1 × SELECT * FROM nucfh_languages 1 × select * nucfh_jshopping_language 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 nucfh_modules AS m LEFT JOIN nucfh_extensions AS e ON e.element = m.module AND e.client_id = m.client_id LEFT JOIN nucfh_advancedmodules as am ON am.moduleid = m.id 1 × select id,link nucfh_menu 1 × SELECT `session_id` FROM `nucfh_session ` 1 × SELECT params FROM nucfh_modules Прочие SQL-запросы: 2 × SHOW FULL COLUMNS FROM `nucfh_jshopping_users 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_usergroups 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_product_labels 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_products_extra_field_values 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_products_reviews 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_taxes 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_products_extra_fields 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_attr 1 × SHOW VARIABLES LIKE 'query_cache_type 1 × SHOW VARIABLES LIKE 'have_profiling 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_categories 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_addons 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_products 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_currencies 1 × SHOW FULL COLUMNS FROM `nucfh_jshopping_config 1 × UPDATE `nucfh_extensions ` SET `params` = '{\"mediaversion\":\"591f0728dc431da72cf9cdb7d0fc3fcd\"}' 1 × INSERT INTO `nucfh_session ` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'6431376531383862653830323836643833626436633933306630393536316432', 1, 1748713078, 0, '' 1 × UPDATE nucfh_jshopping_products SET `hits` = (`hits` + 1) 
