+7 (812) 701-06-28

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

В корзине

0 руб

0 товаров

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

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

Главная

Консультации

Андрогенетическая алопеция

Альтернатива Миноксидилу.

Доброго времени суток. Мой диагноз андрогенетическая алопеция. В моем случае используют Миноксидил, который имеет эффект отмены. Врач мне порекомендовал начать с наногена. Что бы вы порекомендовали? Есть ли альтернатива миноксидилу?

Мария

01.06.2016

Ответ

Здравствуйте, Мария. Наноген это фирма. Что именно рекомендовали? Практически альтернатива Миноксидилу финастерид. Но побочные эффекты такие же.

Ольга Лейтес

Директор Центра дизайна волос

Похожие вопросы

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

Сессия

{
    "__default": {
        "session": {
            "counter": 5,
            "timer": {
                "start": 1791845872,
                "last": 1791845928,
                "now": 1791845938
            },
            "token": "Ho0PF3Ml5wGuANBg7AuqxDUBDsdt79gq"
        },
        "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
        },
        "com_rsfirewall": {
            "geoip": "US"
        },
        "js_id_currency_orig": "2",
        "js_id_currency": "2"
    }
}

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

Time

Memory

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

Time: 32.26 ms / 35.30 ms Memory: 2.399 MB / 2.80 MB Application: afterInitialise

Time: 7.61 ms / 42.91 ms Memory: 0.329 MB / 3.13 MB Application: Before JAccess::preloadComponents (all components)

Time: 1.07 ms / 43.98 ms Memory: 0.071 MB / 3.20 MB Application: After JAccess::preloadComponents (all components)

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

Time: 0.29 ms / 44.31 ms Memory: 0.009 MB / 3.20 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.28 ms / 44.59 ms Memory: 0.000 MB / 3.20 MB Application: afterRoute

Time: 1.52 ms / 46.11 ms Memory: 0.101 MB / 3.30 MB Application: beforeRenderComponent com_consult

Time: 117.34 ms / 163.45 ms Memory: 1.204 MB / 4.51 MB Application: afterRenderComponent com_consult

Time: 7.50 ms / 170.95 ms Memory: 0.248 MB / 4.75 MB Application: afterDispatch

Time: 9.92 ms / 180.87 ms Memory: 0.568 MB / 5.32 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

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

Time: 2.93 ms / 183.85 ms Memory: 0.048 MB / 5.38 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.19 ms / 185.04 ms Memory: 0.014 MB / 5.39 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.66 ms / 185.70 ms Memory: 0.004 MB / 5.39 MB Application: beforeRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini (mobile))

Time: 2.37 ms / 188.07 ms Memory: 0.207 MB / 5.60 MB Application: afterRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini (mobile))

Time: 0.51 ms / 188.58 ms Memory: 0.000 MB / 5.59 MB Application: beforeRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini)

Time: 0.57 ms / 189.16 ms Memory: 0.018 MB / 5.61 MB Application: afterRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini)

Time: 0.23 ms / 189.38 ms Memory: 0.000 MB / 5.60 MB Application: beforeRenderModule mod_jshopping_search (Поиск)

Time: 0.72 ms / 190.10 ms Memory: 0.007 MB / 5.61 MB Application: afterRenderModule mod_jshopping_search (Поиск)

Time: 6.81 ms / 196.91 ms Memory: 0.163 MB / 5.77 MB Application: afterRender

Database queries total: 100.50 ms

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

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

38 SQL-запросов зафиксировано 100.50 ms

4 duplicate found!

4 duplicates: #27 #28 #29 #30

Query Time: 0.17 ms Query memory: 0.023 MB Memory before query: 0.901 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.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.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.16 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 0.914 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.01 ms
init	0.01 ms
System lock	0.00 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.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: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.17 ms After last query: 3.06 ms Query memory: 0.023 MB Memory before query: 1.237 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.00 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.13 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 1.243 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.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: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.19 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 1.248 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.48 ms After last query: 2.53 ms Query memory: 0.028 MB Memory before query: 1.461 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.14 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.03 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
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.30 ms After last query: 6.31 ms Query memory: 0.024 MB Memory before query: 1.892 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.01 ms
init	0.02 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.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
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: 5.49 ms Query memory: 0.036 MB Memory before query: 2.217 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.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 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: 8.85 ms Query memory: 0.024 MB Memory before query: 3.063 MB Rows returned: 0

select `alias`,`newurl` 
  from `triholog_sh404sef_aliases` 
  where `alias` = 'consult/androgeneticheskaya-alopeciya/alternativa-minoksidilu.html' 
  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.00 ms
optimizing	0.01 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.36 ms After last query: 0.44 ms Query memory: 0.027 MB Memory before query: 3.083 MB Rows returned: 2

SELECT `oldurl`, `newurl`, `dateadd` 
  FROM triholog_sh404sef_urls 
  WHERE `oldurl`='consult/androgeneticheskaya-alopeciya/alternativa-minoksidilu.html' 
  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	2	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.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 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: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.20 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 3.096 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.01 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.01 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.14 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 3.103 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.01 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/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.22 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 3.109 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.03 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.01 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
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.08 ms Query memory: 0.023 MB Memory before query: 3.114 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.13 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 3.120 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.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.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
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.83 ms After last query: 0.33 ms Query memory: 0.031 MB Memory before query: 3.130 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.06 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.31 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: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.12 ms Query memory: 0.005 MB Memory before query: 3.207 MB

UPDATE `triholog_extensions`

  SET `params` = '{\"mediaversion\":\"cb67305b626e639a9cce3aa31b2b8985\"}'

  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.05 ms
updating	0.05 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.01 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.57 ms After last query: 2.40 ms Query memory: 0.045 MB Memory before query: 3.372 MB Rows returned: 1

SELECT q.*, q.created q_created, q.id as q_id, s.*, s.title as s_title, u.*, u.name as exp_name, e.description as exp_description, CONCAT(q.id, ":", q.alias) as slug, CONCAT(s.id, ":", s.path) as s_slug

  FROM triholog_cs_questions q

  LEFT JOIN triholog_cs_sections s 
  ON s.id=q.section_id

  LEFT JOIN triholog_users u 
  ON u.id=q.to_exp_id

  LEFT JOIN triholog_cs_experts e 
  ON e.user_id=u.id

  WHERE q.id=7691 
  AND q.published=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	q	NULL	const	id	id	4	const	1	100.00	NULL
1	SIMPLE	s	NULL	const	id	id	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	e	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.07 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 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/components/com_consult/models/consult.php:139
12	ConsultModelConsult->getQuestion()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_consult/views/consult/view.html.php:101
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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: 4.05 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 3.395 MB Rows returned: 5

SELECT q.from_title, CONCAT(q.id, ":", q.alias) as slug, CONCAT(s.id, ":", s.path) as s_slug

  FROM triholog_cs_questions q

  LEFT JOIN triholog_cs_sections s 
  ON s.id=q.section_id

  WHERE q.published=1 
  AND q.exp_answer!='' 
  AND q.section_id = 4 
  AND q.id <> 7691

  ORDER BY RAND() 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	q	NULL	range	id	id	4	NULL	2504	0.90	Using where; Using temporary; Using filesort
1	SIMPLE	s	NULL	const	id	id	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 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.06 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	3.72 ms
Creating sort index	0.06 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_consult/models/consult.php:121
11	ConsultModelConsult->getRandomQuestions()	JROOT/components/com_consult/views/consult/view.html.php:103
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.10 ms After last query: 1.39 ms Query memory: 0.054 MB Memory before query: 3.452 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.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.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.00 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.02 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.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.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.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.21 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
19	JTable->__construct()	JROOT/components/com_jshopping/tables/config.php:14
18	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
17	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
16	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
15	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
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_consult/views/consult/view.html.php:111
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.34 ms After last query: 0.83 ms Query memory: 0.076 MB Memory before query: 3.752 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.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.10 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
18	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
17	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
16	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
15	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
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_consult/views/consult/view.html.php:111
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.41 ms After last query: 0.51 ms Query memory: 0.033 MB Memory before query: 3.757 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.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.01 ms
checking permissions	0.02 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
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.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
24	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
23	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
22	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:311
21	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
20	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:549
19	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
18	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
17	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
16	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
15	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
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_consult/views/consult/view.html.php:111
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.08 ms Query memory: 0.029 MB Memory before query: 3.783 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.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 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/components/com_jshopping/tables/currency.php:22
20	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:550
19	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
18	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
17	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
16	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
15	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
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_consult/views/consult/view.html.php:111
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.39 ms After last query: 0.31 ms Query memory: 0.031 MB Memory before query: 3.853 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.00 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.03 ms
closing tables	0.00 ms
freeing items	0.01 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/review.php:14
16	jshopReview->__construct()	JROOT/libraries/joomla/table/table.php:311
15	JTable::getInstance()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:37
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_consult/views/consult/view.html.php:111
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.98 ms After last query: 0.19 ms Query memory: 0.030 MB Memory before query: 3.882 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.05 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.64 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 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/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_consult/views/consult/view.html.php:111
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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: 81.54 ms After last query: 4.15 ms Query memory: 0.041 MB Memory before query: 4.236 MB Rows returned: 34

SELECT 
        		s.*, 
        		CONCAT(s.id, ":", s.path) as slug, 
        		(
        			SELECT count(q.section_id) 
        			
  FROM triholog_cs_questions q 
        			
  WHERE q.published=1 
  AND q.section_id=s.id 
  AND q.exp_answer!=''
				) AS numQuestions
			

  FROM triholog_cs_sections s

  WHERE s.published=1

  ORDER BY s.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	34	10.00	Using where; Using filesort
2	DEPENDENT SUBQUERY	q	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2652	0.90	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
executing	0.00 ms
Sending data	3.14 ms
executing	0.02 ms
Sending data	2.73 ms
executing	0.00 ms
Sending data	2.31 ms
executing	0.00 ms
Sending data	2.45 ms
executing	0.00 ms
Sending data	2.35 ms
executing	0.00 ms
Sending data	2.42 ms
executing	0.00 ms
Sending data	2.30 ms
executing	0.00 ms
Sending data	2.27 ms
executing	0.00 ms
Sending data	2.35 ms
executing	0.00 ms
Sending data	2.29 ms
executing	0.00 ms
Sending data	2.34 ms
executing	0.00 ms
Sending data	2.26 ms
executing	0.00 ms
Sending data	2.48 ms
executing	0.00 ms
Sending data	2.43 ms
executing	0.00 ms
Sending data	2.29 ms
executing	0.00 ms
Sending data	2.51 ms
executing	0.00 ms
Sending data	2.32 ms
executing	0.00 ms
Sending data	2.26 ms
executing	0.00 ms
Sending data	2.25 ms
executing	0.00 ms
Sending data	2.19 ms
executing	0.01 ms
Sending data	2.27 ms
executing	0.00 ms
Sending data	2.36 ms
executing	0.00 ms
Sending data	2.38 ms
executing	0.00 ms
Sending data	2.38 ms
executing	0.00 ms
Sending data	2.40 ms
executing	0.00 ms
Sending data	2.53 ms
executing	0.00 ms
Sending data	2.32 ms
executing	0.00 ms
Sending data	2.33 ms
executing	0.00 ms
Sending data	2.34 ms
executing	0.00 ms
Sending data	2.41 ms
executing	0.00 ms
Sending data	2.34 ms
executing	0.00 ms
Sending data	2.32 ms
executing	0.00 ms
Sending data	2.37 ms
executing	0.00 ms
Sending data	2.35 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_consult/models/consult.php:78
12	ConsultModelConsult->getListSections()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_consult/views/consult/view.html.php:144
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.56 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 4.359 MB Rows returned: 1

Duplicate queries: #28 #29 #30

SELECT id 
  from triholog_menu 
  WHERE link LIKE "%option=com_consult&view=consult%"

Explain

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

Profile

Status	Duration
starting	0.04 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.01 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.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT/components/com_consult/views/consult/view.html.php:171
11	ConsultViewConsult->_listSections()	JROOT/components/com_consult/views/consult/view.html.php:145
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.43 ms After last query: 0.49 ms Query memory: 0.024 MB Memory before query: 4.366 MB Rows returned: 1

Duplicate queries: #27 #29 #30

SELECT id 
  from triholog_menu 
  WHERE link LIKE "%option=com_consult&view=consult%"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	219	11.11	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.23 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:1720
13	JDatabaseDriver->loadResult()	JROOT/components/com_consult/views/consult/view.html.php:171
12	ConsultViewConsult->_listSections()	JROOT/components/com_consult/views/consult/view.html.php:208
11	ConsultViewConsult->_listSections()	JROOT/components/com_consult/views/consult/view.html.php:145
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.39 ms After last query: 4.47 ms Query memory: 0.024 MB Memory before query: 4.390 MB Rows returned: 1

Duplicate queries: #27 #28 #30

SELECT id 
  from triholog_menu 
  WHERE link LIKE "%option=com_consult&view=consult%"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	219	11.11	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.23 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:1720
13	JDatabaseDriver->loadResult()	JROOT/components/com_consult/views/consult/view.html.php:171
12	ConsultViewConsult->_listSections()	JROOT/components/com_consult/views/consult/view.html.php:208
11	ConsultViewConsult->_listSections()	JROOT/components/com_consult/views/consult/view.html.php:145
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.43 ms After last query: 2.32 ms Query memory: 0.024 MB Memory before query: 4.410 MB Rows returned: 1

Duplicate queries: #27 #28 #29

SELECT id 
  from triholog_menu 
  WHERE link LIKE "%option=com_consult&view=consult%"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	219	11.11	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.24 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:1720
13	JDatabaseDriver->loadResult()	JROOT/components/com_consult/views/consult/view.html.php:171
12	ConsultViewConsult->_listSections()	JROOT/components/com_consult/views/consult/view.html.php:208
11	ConsultViewConsult->_listSections()	JROOT/components/com_consult/views/consult/view.html.php:145
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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: 5.68 ms Query memory: 0.031 MB Memory before query: 4.577 MB Rows returned: 0

SELECT `oldurl`, `dateadd` 
  FROM triholog_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_consult&Itemid=146&id=2&lang=ru&task=expert&view=consult';

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.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.07 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.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
29	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:605
28	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:412
27	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
26	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:995
25	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1022
24	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1644
23	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:508
22	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1436
21	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:248
20	Sh404sefClassRouterInternal->buildRule()	JROOT/libraries/cms/router/router.php:639
19	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:645
18	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:615
17	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:271
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/templates/tpl_triholog/html/com_consult/consult/default_question.php:10
13	include JROOT/templates/tpl_triholog/html/com_consult/consult/default_question.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_consult/views/consult/view.html.php:159
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.23 ms After last query: 1.13 ms Query memory: 0.032 MB Memory before query: 4.615 MB Rows returned: 1

SELECT `oldurl` 
  FROM triholog_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_consult&Itemid=146&lang=ru&task=expert&view=consult';

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.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.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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
31	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:662
30	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:333
29	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
28	ShlDbHelper::selectResult()	JROOT/components/com_sh404sef/sef_ext.php:633
27	sef_404::sefGetLocation()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:767
26	shFinalizePlugin()	JROOT/components/com_consult/sef_ext/com_consult.php:86
25	include JROOT/components/com_consult/sef_ext/com_consult.php	JROOT/components/com_sh404sef/sef_ext.php:302
24	sef_404->create()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1818
23	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:508
22	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1436
21	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:248
20	Sh404sefClassRouterInternal->buildRule()	JROOT/libraries/cms/router/router.php:639
19	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:645
18	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:615
17	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:271
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/templates/tpl_triholog/html/com_consult/consult/default_question.php:10
13	include JROOT/templates/tpl_triholog/html/com_consult/consult/default_question.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_consult/views/consult/view.html.php:159
10	ConsultViewConsult->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_consult/controller.php:17
8	ConsultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_consult/consult.php:16
6	require_once JROOT/components/com_consult/consult.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.23 ms After last query: 2.39 ms Query memory: 0.025 MB Memory before query: 4.522 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.01 ms
statistics	0.05 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.01 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.20 ms After last query: 1.93 ms Query memory: 0.029 MB Memory before query: 4.674 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.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
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: 2.21 ms After last query: 5.36 ms Query memory: 0.138 MB Memory before query: 4.854 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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.05 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.01 ms
Creating sort index	1.81 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
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.80 ms After last query: 12.89 ms Query memory: 0.041 MB Memory before query: 5.502 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.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.16 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.08 ms
checking permissions	0.03 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.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.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
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.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.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.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
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/product.php:15
12	jshopProduct->__construct()	JROOT/libraries/joomla/table/table.php:311
11	JTable::getInstance()	JROOT/modules/mod_jshopping_cart_ajax_mini/mod_jshopping_cart_ajax_mini.php:28
10	include JROOT/modules/mod_jshopping_cart_ajax_mini/mod_jshopping_cart_ajax_mini.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1128
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.51 ms After last query: 7.27 ms Query memory: 0.033 MB Memory before query: 5.741 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.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.00 ms
executing	0.01 ms
Opening tables	0.07 ms
checking permissions	0.02 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.02 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.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.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.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 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.18 ms After last query: 0.13 ms Query memory: 0.037 MB Memory before query: 5.798 MB Rows returned: 0

SELECT * 
  FROM triholog_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_consult&Itemid=146&id=7691&lang=ru&section_id=4&task=question&view=consult';

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.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.03 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
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.]

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

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

```
4 × SELECT id 
  from triholog_menu
```

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

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

1 × SELECT id, rules 
  FROM `triholog_viewlevels

1 × SELECT q.*, q.created q_created, q.id as q_id, s.*, s.title as s_title, u.*, u.name as exp_name, e.description as exp_description, CONCAT(q.id, ":", q.alias) as slug, CONCAT(s.id, ":", s.path) as s_slug 
  FROM triholog_cs_questions q 
  LEFT JOIN triholog_cs_sections s 
  ON s.id=q.section_id 
  LEFT JOIN triholog_users u 
  ON u.id=q.to_exp_id 
  LEFT JOIN triholog_cs_experts e 
  ON e.user_id=u.id

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 params 
  FROM triholog_extensions AS e

1 × SELECT `oldurl` 
  FROM triholog_sh404sef_urls

1 × SELECT            s.*,            CONCAT(s.id, ":", s.path) as slug,            (            SELECT count(q.section_id)             
  FROM triholog_cs_questions q

1 × select id,link 
  from triholog_menu

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

1 × SELECT * 
  FROM triholog_jshopping_config

1 × SELECT q.from_title, CONCAT(q.id, ":", q.alias) as slug, CONCAT(s.id, ":", s.path) as s_slug 
  FROM triholog_cs_questions q 
  LEFT JOIN triholog_cs_sections s 
  ON s.id=q.section_id

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

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 * 
  FROM triholog_rsfirewall_exceptions

1 × SELECT * 
  FROM triholog_rsfirewall_snapshots

1 × SELECT * 
  FROM triholog_rsfirewall_hashes

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

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

1 × SELECT `params` 
  FROM triholog_extensions

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

1 × SELECT * 
  FROM triholog_rsfirewall_configuratio

1 × SELECT `file` 
  FROM triholog_rsfirewall_hashes

1 × SELECT `path` 
  FROM triholog_rsfirewall_ignored

1 × SELECT * 
  FROM triholog_sh404sef_metas

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

1 × SHOW FULL COLUMNS 
  FROM `triholog_rsfirewall_logs

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

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_currencies

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_reviews

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products

1 × SHOW FULL COLUMNS 
  FROM `triholog_sh404sef_metas