+7 (812) 701-06-28

пн-пт: c 10:00 до 21:00
сб-вс: с 10:00 до 19:00

В корзине

0 руб

0 товаров

руб Товар добавлен в корзину Товаров в корзине на сумму

Оформить заказ

Главная

Optimaker

Наборы

Набор себорегулирущий (для жирной кожи головы) №1

Optimaker Набор себорегулирущий (для жирной кожи головы) №1

Для кого:

Для мужчин, Для женщин

Назначение:

От перхоти и себореи , Для жирных волос

Бренд:

Optima

Вид:

Наборы

Страна изготовитель:

Италия

Доступность:

Есть в наличии

Количество товара:

Описание

Optima Себорегулирующий шампунь для жирных волос, 250 мл

Это поистине уникальное средство комплексного воздействия. Благодаря нему вы очистите кожу головы от чрезмерного количества кожного сала, восстановите рост волос, а также избавитесь от надоевшей перхоти.

Optima Себорегулирующий лосьон для жирных волос, 75 мл

Данное средство быстро и бережно очистит вашу кожу от чрезмерного количества кожного сала и других сопутствующих неприятностей. Покупайте этот препарат, если вы также хотите восстановить свои волосы, вернуть им былую силу и красоту

Optima Себорегулирующая маска для жирных волос, 150 мл

Маска эффективно справится с излишней жирностью волос, полноценно очистив кожу от избытка кожного сала. Купив ее, вы навсегда позабудете о таком неприятном эффекте «немытых» волос.

Доставка

Оплата

Консоль отладки Joomla!

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1791826839,
                "last": 1791826839,
                "now": 1791826839
            },
            "token": "WSSdTbgzC8kjFfleEo86INXJ8DNYC9Sx"
        },
        "registry": {
            "jshoping": {
                "list": {
                    "front": {
                        "product": {
                            "cat": {
                                "1manufacturers": [],
                                "1extra_fields": []
                            }
                        }
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "js_id_currency_orig": "2",
        "js_id_currency": "2",
        "com_rsfirewall": {
            "geoip": "US"
        },
        "js_history_sel_lang": "ru-RU",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB",
            "ru-RU"
        ],
        "jshop_end_page_buy_product": "\/optima\/nabory\/nabor-seboregulirushchij-dlya-zhirnoj-kozhi-golovy-1",
        "product_back_value": []
    }
}

Результаты профилирования

Time

Memory

Time: 2.98 ms / 2.98 ms Memory: 0.061 MB / 0.40 MB Application: afterLoad

Time: 38.41 ms / 41.39 ms Memory: 2.403 MB / 2.80 MB Application: afterInitialise

Time: 13.80 ms / 55.19 ms Memory: 0.734 MB / 3.53 MB Application: Before JAccess::preloadComponents (all components)

Time: 0.95 ms / 56.13 ms Memory: 0.071 MB / 3.60 MB Application: After JAccess::preloadComponents (all components)

Time: 0.04 ms / 56.17 ms Memory: 0.000 MB / 3.60 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.28 ms / 56.45 ms Memory: 0.009 MB / 3.61 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.30 ms / 56.76 ms Memory: 0.000 MB / 3.61 MB Application: afterRoute

Time: 1.36 ms / 58.12 ms Memory: 0.096 MB / 3.71 MB Application: beforeRenderComponent com_jshopping

Time: 58.70 ms / 116.82 ms Memory: 0.797 MB / 4.50 MB Application: afterRenderComponent com_jshopping

Time: 10.35 ms / 127.16 ms Memory: 0.615 MB / 5.12 MB Application: afterDispatch

Time: 38.18 ms / 165.34 ms Memory: 0.573 MB / 5.69 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Time: 0.05 ms / 165.39 ms Memory: 0.007 MB / 5.70 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Time: 3.33 ms / 168.72 ms Memory: 0.064 MB / 5.76 MB Application: beforeRenderModule mod_menu (Информация)

Time: 2.91 ms / 171.63 ms Memory: 0.028 MB / 5.79 MB Application: afterRenderModule mod_menu (Информация)

Time: 0.51 ms / 172.14 ms Memory: 0.000 MB / 5.79 MB Application: beforeRenderModule mod_menu (Контактная информация)

Time: 2.16 ms / 174.29 ms Memory: 0.016 MB / 5.80 MB Application: afterRenderModule mod_menu (Контактная информация)

Time: 0.44 ms / 174.73 ms Memory: 0.000 MB / 5.80 MB Application: beforeRenderModule mod_menu (Как заказать)

Time: 1.31 ms / 176.04 ms Memory: 0.012 MB / 5.82 MB Application: afterRenderModule mod_menu (Как заказать)

Time: 0.25 ms / 176.29 ms Memory: 0.000 MB / 5.80 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.98 ms / 177.27 ms Memory: 0.014 MB / 5.81 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.64 ms / 177.91 ms Memory: 0.018 MB / 5.83 MB Application: beforeRenderModule mod_menu (Основные направления (mobile))

Time: 5.25 ms / 183.16 ms Memory: 0.053 MB / 5.88 MB Application: afterRenderModule mod_menu (Основные направления (mobile))

Time: 0.44 ms / 183.60 ms Memory: 0.000 MB / 5.88 MB Application: beforeRenderModule mod_menu (Меню пользователя (mobile))

Time: 0.82 ms / 184.42 ms Memory: 0.007 MB / 5.89 MB Application: afterRenderModule mod_menu (Меню пользователя (mobile))

Time: 0.18 ms / 184.60 ms Memory: 0.000 MB / 5.87 MB Application: beforeRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini (mobile))

Time: 1.03 ms / 185.63 ms Memory: 0.090 MB / 5.96 MB Application: afterRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini (mobile))

Time: 0.79 ms / 186.42 ms Memory: 0.010 MB / 5.97 MB Application: beforeRenderModule mod_menu (Вход - Регистрация)

Time: 1.08 ms / 187.50 ms Memory: 0.010 MB / 5.98 MB Application: afterRenderModule mod_menu (Вход - Регистрация)

Time: 0.42 ms / 187.92 ms Memory: 0.000 MB / 5.97 MB Application: beforeRenderModule mod_menu (Основные направления)

Time: 2.32 ms / 190.24 ms Memory: 0.008 MB / 5.98 MB Application: afterRenderModule mod_menu (Основные направления)

Time: 0.18 ms / 190.42 ms Memory: 0.000 MB / 5.96 MB Application: beforeRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini)

Time: 0.52 ms / 190.94 ms Memory: 0.018 MB / 5.98 MB Application: afterRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini)

Time: 0.21 ms / 191.15 ms Memory: 0.000 MB / 5.97 MB Application: beforeRenderModule mod_jshopping_search (Поиск)

Time: 0.56 ms / 191.72 ms Memory: 0.009 MB / 5.98 MB Application: afterRenderModule mod_jshopping_search (Поиск)

Time: 7.51 ms / 199.23 ms Memory: 0.148 MB / 6.13 MB Application: afterRender

Database queries total: 22.97 ms

Использование памяти

Запросы к базе данных

58 SQL-запросов зафиксировано 22.97 ms

6 duplicate found!

2 duplicates: #1 #54

2 duplicates: #2 #55

2 duplicates: #12 #15

Query Time: 0.29 ms Query memory: 0.003 MB Memory before query: 0.721 MB

Duplicate queries: #54

DELETE 

  FROM `triholog_session`

  WHERE `time` < '1791808839'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	triholog_session	NULL	range	time	time	45	const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.04 ms
updating	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:834
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:420
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.73 ms Query memory: 0.021 MB Memory before query: 0.738 MB Rows returned: 0

Duplicate queries: #55

SELECT `session_id`

  FROM `triholog_session`

  WHERE `session_id` = '4350974e337076d4fd14e995e3caa891' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_session	NULL	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:843
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:420
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 0.11 ms Query memory: 0.003 MB Memory before query: 0.743 MB

INSERT INTO `triholog_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('4350974e337076d4fd14e995e3caa891', 1, '1791826839', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `triholog_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('4350974e337076d4fd14e995e3caa891', 1, '1791826839', 0, '')

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.07 ms
end	0.00 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:217
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:843
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:420
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 1.84 ms Query memory: 0.023 MB Memory before query: 0.903 MB Rows returned: 5

SELECT id, rules

  FROM `triholog_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 0.916 MB Rows returned: 0

SELECT b.id

  FROM triholog_usergroups AS a

  LEFT JOIN triholog_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 13

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 4.47 ms Query memory: 0.023 MB Memory before query: 1.239 MB Rows returned: 1

SELECT `path`

  FROM triholog_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_ignored	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:695
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 1.245 MB Rows returned: 0

SELECT `file`

  FROM triholog_rsfirewall_hashes

  WHERE `type`='protect'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_hashes	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:695
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 1.250 MB Rows returned: 52

SELECT *

  FROM triholog_rsfirewall_configuration

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_configuration	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	52	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:695
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.47 ms After last query: 2.87 ms Query memory: 0.028 MB Memory before query: 1.464 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `triholog_rsfirewall_logs`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_rsfirewall_logs`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RSFirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:695
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 7.26 ms Query memory: 0.024 MB Memory before query: 1.895 MB Rows returned: 1

SELECT COUNT(`extension_id`)

  FROM `triholog_extensions`

  WHERE `element` = 'com_advancedmodules' 
  AND `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:95
14	JComponentHelper::isInstalled()	JROOT/libraries/regularlabs/src/Parameters.php:136
13	RegularLabs\Library\Parameters->getComponentParams()	JROOT/plugins/system/advancedmodules/src/Params.php:29
12	RegularLabs\Plugin\System\AdvancedModules\Params::get()	JROOT/plugins/system/advancedmodules/src/Helper.php:22
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterInitialise()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:59
8	PlgSystemAdvancedModules->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:696
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 6.21 ms Query memory: 0.036 MB Memory before query: 2.220 MB Rows returned: 1

SELECT `params` 
  FROM triholog_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:662
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:333
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:111
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:542
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:52
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:696
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 9.43 ms Query memory: 0.024 MB Memory before query: 3.065 MB Rows returned: 0

Duplicate queries: #15

select `alias`,`newurl` 
  from `triholog_sh404sef_aliases` 
  where `alias` = 'optima/nabory/nabor-seboregulirushchij-dlya-zhirnoj-kozhi-golovy-1' 
  order by `alias` desc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_sh404sef_aliases	NULL	ref	alias	alias	767	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605
12	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:1104
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:104
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 0.48 ms Query memory: 0.027 MB Memory before query: 3.084 MB Rows returned: 0

SELECT `oldurl`, `newurl`, `dateadd` 
  FROM triholog_sh404sef_urls 
  WHERE `oldurl`='optima/nabory/nabor-seboregulirushchij-dlya-zhirnoj-kozhi-golovy-1' 
  ORDER BY `rank`;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_sh404sef_urls	NULL	ref	oldurl	oldurl	767	const	1	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605
17	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412
16	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
15	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:76
14	Sh404sefModelSefurls->getNonSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:583
13	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:326
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.16 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 3.094 MB Rows returned: 0

SELECT `oldurl`, `newurl`, `dateadd` 
  FROM triholog_sh404sef_urls 
  WHERE `oldurl`='optima/nabory/nabor-seboregulirushchij-dlya-zhirnoj-kozhi-golovy-1/' 
  ORDER BY `rank`;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_sh404sef_urls	NULL	ref	oldurl	oldurl	767	const	1	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605
18	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412
17	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
16	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:76
15	Sh404sefModelSefurls->getNonSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:583
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1049
13	Sh404sefClassRouterInternal->_checkTrailingSlash()	JROOT/administrator/components/com_sh404sef/classes/router.php:348
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 3.103 MB Rows returned: 0

Duplicate queries: #12

select `alias`,`newurl` 
  from `triholog_sh404sef_aliases` 
  where `alias` = 'optima/nabory/nabor-seboregulirushchij-dlya-zhirnoj-kozhi-golovy-1' 
  order by `alias` desc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_sh404sef_aliases	NULL	ref	alias	alias	767	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605
14	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:1104
13	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:351
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.10 ms After last query: 0.63 ms Query memory: 0.054 MB Memory before query: 3.126 MB Rows returned: 140

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_config`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_config`

Profile

Status	Duration
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.18 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
22	JTable->__construct()	JROOT/components/com_jshopping/tables/config.php:14
21	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
20	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
19	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
18	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1590
17	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:255
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.40 ms After last query: 0.81 ms Query memory: 0.077 MB Memory before query: 3.428 MB Rows returned: 1

SELECT *

  FROM triholog_jshopping_config

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_config	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
21	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
20	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
19	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
18	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1590
17	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:255
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.42 ms After last query: 0.43 ms Query memory: 0.033 MB Memory before query: 3.435 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_currencies`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_currencies`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
27	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
26	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
25	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:311
24	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
23	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:549
22	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
21	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
20	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
19	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
18	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1590
17	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:255
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 0.08 ms Query memory: 0.029 MB Memory before query: 3.462 MB Rows returned: 1

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `triholog_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_currencies	NULL	ref	currency_publish	currency_publish	1	const	1	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.07 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
23	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:550
22	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
21	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
20	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
19	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
18	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1590
17	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:255
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.42 ms After last query: 0.42 ms Query memory: 0.034 MB Memory before query: 3.476 MB Rows returned: 113

select product_id as id, `alias_ru-RU` as alias 
  from triholog_jshopping_products 
  where `alias_ru-RU`!=''

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_products	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	73	90.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:283
17	JSFactory::getAliasProduct()	JROOT/components/com_jshopping/router.php:351
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 0.45 ms Query memory: 0.023 MB Memory before query: 3.501 MB Rows returned: 0

SELECT *

  FROM triholog_rsfirewall_hashes

  WHERE (`type`='3.7.4' OR `type`='protect') 
  AND `flag`!='C'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_hashes	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	28.80	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:949
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1167
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 3.508 MB Rows returned: 0

SELECT *

  FROM triholog_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_snapshots	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:972
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1167
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 3.515 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM triholog_rsfirewall_lists

  WHERE (`ip`='216.73.217.94' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_lists	NULL	ref	published,type	type	1	const	1	36.79	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:168
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:147
9	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1000
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1167
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 3.520 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM triholog_rsfirewall_lists

  WHERE (`ip`='216.73.217.94' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_lists	NULL	ALL	published,type	NO INDEX KEY COULD BE USED	NULL	NULL	14	36.79	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:168
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:137
9	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1004
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1167
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.37 ms Query memory: 0.025 MB Memory before query: 3.528 MB Rows returned: 0

SELECT *

  FROM triholog_rsfirewall_exceptions

  WHERE `published`='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_rsfirewall_exceptions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:642
9	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1052
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1167
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.71 ms After last query: 0.36 ms Query memory: 0.031 MB Memory before query: 3.538 MB Rows returned: 46

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `triholog_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_consult','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_jshopping','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_rsform','com_search','com_sh404sef','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper','com_xmap','com_zhyandexmap','com_zoo')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	188	25.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
15	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
14	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
13	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
8	PlgSystemAdvancedModules->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1167
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.35 ms After last query: 1.10 ms Query memory: 0.005 MB Memory before query: 3.613 MB

UPDATE `triholog_extensions`

  SET `params` = '{\"mediaversion\":\"44ca8a72d2eda9dafd13143400b6e8d3\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	triholog_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.06 ms
updating	0.06 ms
end	0.00 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 3.37 ms Query memory: 0.024 MB Memory before query: 3.727 MB Rows returned: 2

select * 
  from triholog_jshopping_languages

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/functions.php:290
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/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.72 ms After last query: 0.82 ms Query memory: 0.040 MB Memory before query: 3.759 MB Rows returned: 59

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/components/com_jshopping/tables/product.php:15
11	jshopProduct->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/product.php:43
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.36 ms After last query: 38.35 ms Query memory: 0.045 MB Memory before query: 3.875 MB Rows returned: 1

SELECT *

  FROM triholog_jshopping_products

  WHERE `product_id` = '520'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
9	JTable->load()	JROOT/components/com_jshopping/controllers/product.php:44
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.54 ms After last query: 0.30 ms Query memory: 0.031 MB Memory before query: 3.889 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_categories`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_categories`

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/components/com_jshopping/tables/category.php:15
11	jshopCategory->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/product.php:46
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.18 ms Query memory: 0.031 MB Memory before query: 3.943 MB Rows returned: 1

SELECT *

  FROM triholog_jshopping_categories

  WHERE `category_id` = '38'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
9	JTable->load()	JROOT/components/com_jshopping/controllers/product.php:47
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 3.953 MB Rows returned: 2

SELECT * 
  FROM `triholog_jshopping_products_to_categories` 
  WHERE product_id=520

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_products_to_categories	NULL	ref	PRIMARY,product_id,product_id_2	product_id_2	4	const	2	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:261
10	jshopProduct->getCategories()	JROOT/components/com_jshopping/models/productshop.php:79
9	jshopProductShop->getCategories()	JROOT/components/com_jshopping/controllers/product.php:60
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.38 ms After last query: 0.30 ms Query memory: 0.031 MB Memory before query: 3.966 MB Rows returned: 11

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_attr`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_attr`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
17	JTable->__construct()	JROOT/components/com_jshopping/tables/attribut.php:14
16	jshopAttribut->__construct()	JROOT/libraries/joomla/table/table.php:311
15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:297
13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:107
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:186
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:214
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.38 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 3.996 MB Rows returned: 2

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 `triholog_jshopping_attr` as A 
  left join `triholog_jshopping_attr_groups` as G 
  on A.`
  group`=G.id
                  
  ORDER BY G.ordering, A.attr_ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	A	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using temporary; Using filesort
1	SIMPLE	G	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	0.10 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/attribut.php:28
14	jshopAttribut->getAllAttributes()	JROOT/components/com_jshopping/lib/factory.php:298
13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:107
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:186
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:214
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 0.07 ms Query memory: 0.028 MB Memory before query: 4.006 MB Rows returned: 0

SELECT * 
  FROM `triholog_jshopping_products_attr` 
  WHERE product_id=520 
  ORDER BY product_attr_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_products_attr	NULL	ref	product_id	product_id	4	const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:138
13	jshopProduct->getAttributes()	JROOT/components/com_jshopping/tables/product.php:112
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:186
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:214
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 4.013 MB Rows returned: 0

SELECT * 
  FROM `triholog_jshopping_products_attr2` 
  WHERE product_id=520 
  ORDER BY id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_products_attr2	NULL	ref	product_id	product_id	4	const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:147
13	jshopProduct->getAttributes2()	JROOT/components/com_jshopping/tables/product.php:123
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:186
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:214
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.80 ms After last query: 0.22 ms Query memory: 0.038 MB Memory before query: 4.027 MB Rows returned: 53

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_users`

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__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:1118
11	jshopProduct->getBuildSelectAttributes()	JROOT/components/com_jshopping/tables/product.php:218
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:92
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.45 ms After last query: 0.35 ms Query memory: 0.031 MB Memory before query: 4.137 MB Rows returned: 11

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_fields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products_extra_fields`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
18	JTable->__construct()	JROOT/components/com_jshopping/tables/productfield.php:14
17	jshopProductField->__construct()	JROOT/libraries/joomla/table/table.php:311
16	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:476
14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1132
13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:214
12	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:837
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:526
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 0.08 ms Query memory: 0.030 MB Memory before query: 4.167 MB Rows returned: 11

SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_ru-RU` as groupname, multilist 
  FROM `triholog_jshopping_products_extra_fields` as F 
  left join `triholog_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group 
  order by G.ordering, F.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	F	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10	100.00	Using temporary; Using filesort
1	SIMPLE	G	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.08 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
15	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:477
14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1132
13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:214
12	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:837
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:526
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.55 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 4.193 MB Rows returned: 0

SELECT prod.product_id, prod.product_primary_category, 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_4` , prod.`extra_field_9` , prod.`extra_field_10` , prod.`extra_field_11`  
  FROM `triholog_jshopping_products_relations` AS relation
                
  INNER JOIN `triholog_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                
  LEFT JOIN `triholog_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                
  LEFT JOIN `triholog_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
                
  WHERE relation.product_id=520 
  AND cat.category_publish=1 
  AND prod.product_publish=1  
  AND prod.access IN (1,1) 
  AND cat.access IN (1,1) 
				
  group by prod.product_id 
  order by relation.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	relation	NULL	ref	product_id,product_id_2,product_related_id	product_id	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	prod	NULL	eq_ref	PRIMARY,product_manufacturer_id,parent_id,product_ean,unlimited,product_publish,product_tax_id,currency_id,product_price,min_price,add_price_unit_id,average_rating,reviews_count,delivery_times_id,hits,basic_price_unit_id,label_id,vendor_id,access	PRIMARY	4	cy85373_triholog.relation.product_related_id	1	17.81	Using where
1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	product_id	4	cy85373_triholog.relation.product_related_id	1	100.00	Using index
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	cy85373_triholog.pr_cat.category_id	1	58.06	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.08 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:850
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:526
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.26 ms After last query: 0.18 ms Query memory: 0.030 MB Memory before query: 4.267 MB Rows returned: 3

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_taxes`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_taxes`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
17	JTable->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
16	jshopTax->__construct()	JROOT/libraries/joomla/table/table.php:311
15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:349
13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:675
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:854
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:526
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.284 MB Rows returned: 1

SELECT tax_id, tax_name, tax_value 
  FROM `triholog_jshopping_taxes`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_taxes	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
15	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:335
14	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:350
13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:675
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:854
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:526
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.28 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.291 MB Rows returned: 7

select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url 
  from triholog_jshopping_manufacturers 
  where manufacturer_publish='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_manufacturers	NULL	ALL	manufacturer_publish	NO INDEX KEY COULD BE USED	NULL	NULL	8	87.50	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:402
13	JSFactory::getAllManufacturer()	JROOT/components/com_jshopping/lib/functions.php:677
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:854
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:526
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:101
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.38 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 4.304 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_reviews`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products_reviews`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
13	JTable->__construct()	JROOT/components/com_jshopping/tables/review.php:14
12	jshopReview->__construct()	JROOT/libraries/joomla/table/table.php:311
11	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
10	JSFactory::getTable()	JROOT/components/com_jshopping/models/productshop.php:114
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.40 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 4.336 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_field_values`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_jshopping_products_extra_field_values`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/components/com_jshopping/tables/productfieldvalue.php:15
14	jshopProductFieldValue->__construct()	JROOT/libraries/joomla/table/table.php:311
13	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
12	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:485
11	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/tables/product.php:759
10	jshopProduct->getExtraFields()	JROOT/components/com_jshopping/models/productshop.php:152
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.28 ms After last query: 0.07 ms Query memory: 0.031 MB Memory before query: 4.356 MB Rows returned: 56

SELECT id, `name_ru-RU` as name, field_id, alias 
  FROM `triholog_jshopping_products_extra_field_values` 
  order by ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_products_extra_field_values	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	56	100.00	Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:27
12	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:486
11	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/tables/product.php:759
10	jshopProduct->getExtraFields()	JROOT/components/com_jshopping/models/productshop.php:152
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.37 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 4.371 MB Rows returned: 0

SELECT FA.id, FA.required, FA.`name_ru-RU` as name, FA.`description_ru-RU` as description, FA.type 
				  
  FROM `triholog_jshopping_products_free_attr` as PFA 
				  
  left join `triholog_jshopping_free_attr` as FA 
  on FA.id=PFA.attr_id
                  
  WHERE PFA.product_id=520 
  order by FA.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PFA	NULL	ref	product_id	product_id	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	FA	NULL	eq_ref	PRIMARY	PRIMARY	4	cy85373_triholog.PFA.attr_id	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.07 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:237
10	jshopProduct->getListFreeAttributes()	JROOT/components/com_jshopping/models/productshop.php:158
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.01 ms After last query: 1.33 ms Query memory: 0.030 MB Memory before query: 4.427 MB Rows returned: 33

select id,link 
  from triholog_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='ru-RU') 
  and access IN (1,1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	116	0.46	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.63 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:136
20	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:46
19	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:39
18	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:396
17	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:415
16	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:488
15	SEFLink()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:44
14	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
13	plgContentJshopProductInsert->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:947
10	changeDataUsePluginContent()	JROOT/components/com_jshopping/models/productshop.php:199
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:62
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.35 ms After last query: 1.19 ms Query memory: 0.005 MB Memory before query: 4.485 MB

UPDATE triholog_jshopping_products

  SET `hits` = (`hits` + 1)

  WHERE `product_id` = '520'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	triholog_jshopping_products	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.11 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
9	JTable->hit()	JROOT/components/com_jshopping/controllers/product.php:75
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.40 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 4.489 MB Rows returned: 1

SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `triholog_jshopping_products_images` as I 
				 
  left join `triholog_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=520 
  ORDER BY sort, I.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	I	NULL	ref	product_id	product_id	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	P	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.05 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:350
9	jshopProduct->getImages()	JROOT/components/com_jshopping/controllers/product.php:85
8	JshoppingControllerProduct->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 2.06 ms Query memory: 0.024 MB Memory before query: 4.575 MB Rows returned: 1

SELECT params 
  FROM triholog_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:254
13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 4.80 ms Query memory: 0.029 MB Memory before query: 5.028 MB Rows returned: 0

SELECT `oldurl`, `dateadd` 
  FROM triholog_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_widgetkit&format=raw&id=&lang=ru';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_sh404sef_urls	NULL	ref	newurl	newurl	767	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
25	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605
24	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412
23	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
22	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:995
21	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1022
20	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1610
19	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:508
18	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1436
17	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:248
16	Sh404sefClassRouterInternal->buildRule()	JROOT/libraries/cms/router/router.php:639
15	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:645
14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:615
13	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:271
12	JRouter->build()	JROOT/libraries/cms/router/site.php:149
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/administrator/components/com_widgetkit/helpers/system.php:162
9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 5.14 ms Query memory: 0.006 MB Memory before query: 5.152 MB

Duplicate queries: #1

DELETE 

  FROM `triholog_session`

  WHERE `time` < '1791808839'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	triholog_session	NULL	range	time	time	45	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.05 ms
updating	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:834
11	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
10	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
9	JApplicationSite->__construct()	JROOT/templates/tpl_triholog/includes/head.php:7
8	include JROOT/templates/tpl_triholog/includes/head.php	JROOT/templates/tpl_triholog/index.php:5
7	require JROOT/templates/tpl_triholog/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1114
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 5.160 MB Rows returned: 1

Duplicate queries: #2

SELECT `session_id`

  FROM `triholog_session`

  WHERE `session_id` = '4350974e337076d4fd14e995e3caa891' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_session	NULL	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
12	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:843
11	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
10	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
9	JApplicationSite->__construct()	JROOT/templates/tpl_triholog/includes/head.php:7
8	include JROOT/templates/tpl_triholog/includes/head.php	JROOT/templates/tpl_triholog/index.php:5
7	require JROOT/templates/tpl_triholog/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1114
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.43 ms After last query: 0.23 ms Query memory: 0.138 MB Memory before query: 5.231 MB Rows returned: 71

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 triholog_modules AS m

  LEFT JOIN triholog_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN triholog_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	124	5.97	Using where; Using filesort
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	cy85373_triholog.m.id	1	100.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	cy85373_triholog.m.module,const	1	10.00	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	3.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:404
15	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
14	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
13	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
12	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:364
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
9	JDocumentHtml->countModules()	JROOT/templates/tpl_triholog/includes/head.php:35
8	include JROOT/templates/tpl_triholog/includes/head.php	JROOT/templates/tpl_triholog/index.php:5
7	require JROOT/templates/tpl_triholog/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1114
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.88 ms After last query: 64.92 ms Query memory: 0.033 MB Memory before query: 6.089 MB Rows returned: 28

SHOW FULL COLUMNS 
  FROM `triholog_sh404sef_metas`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `triholog_sh404sef_metas`

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
Opening tables	0.06 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:116
13	Sh404sefTableMetas->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/components/com_sh404sef/shPageRewrite.full.php:252
11	shGetCustomMetaData()	JROOT/components/com_sh404sef/shPageRewrite.full.php:329
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:917
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:292
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1134
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.28 ms After last query: 0.15 ms Query memory: 0.037 MB Memory before query: 6.146 MB Rows returned: 0

SELECT * 
  FROM triholog_sh404sef_metas 
  WHERE `newurl`='index.php&lang=ru';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_sh404sef_metas	NULL	ref	newurl	newurl	767	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/components/com_sh404sef/shPageRewrite.full.php:256
11	shGetCustomMetaData()	JROOT/components/com_sh404sef/shPageRewrite.full.php:329
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:917
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:292
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1134
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:51

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

53 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

2 × SELECT `session_id` 
  FROM `triholog_session`

2 × select `alias`,`newurl` 
  from `triholog_sh404sef_aliases`

2 × SELECT `ip`,`reason` 
  FROM triholog_rsfirewall_lists

2 × SELECT `oldurl`, `newurl`, `dateadd` 
  FROM triholog_sh404sef_urls

1 × SELECT params 
  FROM triholog_extensions AS e

1 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `triholog_jshopping_products_images` as I 
      
  left join `triholog_jshopping_products` as P 
  on P.product_id=I.product_id

1 × select id,link 
  from triholog_menu

1 × SELECT FA.id, FA.required, FA.`name_ru-RU` as name, FA.`description_ru-RU` as description, FA.type 
       
  FROM `triholog_jshopping_products_free_attr` as PFA 
       
  left join `triholog_jshopping_free_attr` as FA 
  on FA.id=PFA.attr_id

1 × SELECT `oldurl`, `dateadd` 
  FROM triholog_sh404sef_urls

1 × SELECT * 
  FROM `triholog_jshopping_products_to_categories`

1 × SELECT id, `name_ru-RU` as name, field_id, alias 
  FROM `triholog_jshopping_products_extra_field_values`

1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url 
  from triholog_jshopping_manufacturers

1 × SELECT tax_id, tax_name, tax_value 
  FROM `triholog_jshopping_taxes

1 × SELECT prod.product_id, prod.product_primary_category, 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_4` , prod.`extra_field_9` , prod.`extra_field_10` , prod.`extra_field_11`  
  FROM `triholog_jshopping_products_relations` AS relation
                 
  INNER JOIN `triholog_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                 
  LEFT JOIN `triholog_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                 
  LEFT JOIN `triholog_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

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.`
  group`, G.`name_ru-RU` as groupname, multilist 
  FROM `triholog_jshopping_products_extra_fields` as F 
  left join `triholog_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group

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 triholog_modules AS m 
  LEFT JOIN triholog_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN triholog_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT * 
  FROM `triholog_jshopping_products_attr2`

1 × SELECT * 
  FROM `triholog_jshopping_products_attr`

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 `triholog_jshopping_attr` as A 
  left join `triholog_jshopping_attr_groups` as G 
  on A.`
  group`=G.id

1 × select * 
  from triholog_jshopping_language

1 × SELECT * 
  FROM triholog_jshopping_categories

1 × SELECT * 
  FROM triholog_jshopping_config

1 × SELECT b.id 
  FROM triholog_usergroups AS a 
  LEFT JOIN triholog_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `path` 
  FROM triholog_rsfirewall_ignored

1 × SELECT `file` 
  FROM triholog_rsfirewall_hashes

1 × SELECT * 
  FROM triholog_rsfirewall_configuratio

1 × SELECT COUNT(`extension_id`) 
  FROM `triholog_extensions`

1 × SELECT `params` 
  FROM triholog_extensions

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `triholog_jshopping_currencies`

1 × SELECT * 
  FROM triholog_jshopping_products

1 × select product_id as id, `alias_ru-RU` as alias 
  from triholog_jshopping_products

1 × SELECT * 
  FROM triholog_rsfirewall_hashes

1 × SELECT * 
  FROM triholog_rsfirewall_snapshots

1 × SELECT * 
  FROM triholog_rsfirewall_exceptions

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `triholog_assets`

1 × SELECT id, rules 
  FROM `triholog_viewlevels

1 × SELECT * 
  FROM triholog_sh404sef_metas

Прочие SQL-запросы:

2 × DELETE  
  FROM `triholog_session`

1 × INSERT INTO `triholog_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('4350974e337076d4fd14e995e3caa891', 1, '1791826839', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `triholog_rsfirewall_logs

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_currencies

1 × UPDATE `triholog_extensions` 
  SET `params` = '{\"mediaversion\":\"44ca8a72d2eda9dafd13143400b6e8d3\"}'

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_categories

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_attr

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_users

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_fields

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_reviews

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_field_values

1 × UPDATE triholog_jshopping_products 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `triholog_sh404sef_metas