+7 (812) 701-06-28

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

В корзине

0 руб

0 товаров

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

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

Главная

Новости

Лосьон на основе плаценты

Лосьон на основе плаценты (линия "Оптима") является классическим биогенным стимулятором роста волос, стимулирует процессы деления, созревания и дифференцирования клеток матрицы, благодаря специфическим пептидам снижает андрогенную нагрузку на рецепторы волосяного фолликула.

Эвкапил

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

Косметическая линия по лечению волос и кожи головы фирмы "Оптима"

В продаже появилась новая косметическая линия по лечению волос и кожи головы фирмы "Оптима" (Италия).

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

Сессия

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1791831329,
                "last": 1791831329,
                "now": 1791831339
            },
            "token": "1AsDFrFWnoZKtQZvOqLTaVeenY5QcOUK"
        },
        "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.00 ms / 3.00 ms Memory: 0.061 MB / 0.40 MB Application: afterLoad

Time: 32.66 ms / 35.66 ms Memory: 2.406 MB / 2.80 MB Application: afterInitialise

Time: 7.16 ms / 42.82 ms Memory: 0.330 MB / 3.13 MB Application: Before JAccess::preloadComponents (all components)

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

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

Time: 0.25 ms / 44.04 ms Memory: 0.009 MB / 3.21 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.30 ms / 44.33 ms Memory: 0.000 MB / 3.21 MB Application: afterRoute

Time: 1.32 ms / 45.66 ms Memory: 0.034 MB / 3.24 MB Application: beforeRenderComponent com_zoo

Time: 4.00 ms / 49.66 ms Memory: 0.238 MB / 3.48 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Time: 0.04 ms / 49.70 ms Memory: 0.007 MB / 3.49 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Time: 24.20 ms / 73.90 ms Memory: 1.284 MB / 4.77 MB Application: afterRenderComponent com_zoo

Time: 6.91 ms / 80.81 ms Memory: 0.312 MB / 5.09 MB Application: afterDispatch

Time: 13.90 ms / 94.71 ms Memory: 0.565 MB / 5.65 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.96 ms / 95.66 ms Memory: 0.011 MB / 5.66 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

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

Time: 2.00 ms / 98.32 ms Memory: 0.206 MB / 5.87 MB Application: afterRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini (mobile))

Time: 0.52 ms / 98.84 ms Memory: 0.000 MB / 5.87 MB Application: beforeRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini)

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

Time: 0.22 ms / 99.58 ms Memory: 0.000 MB / 5.88 MB Application: beforeRenderModule mod_jshopping_search (Поиск)

Time: 0.58 ms / 100.16 ms Memory: 0.007 MB / 5.88 MB Application: afterRenderModule mod_jshopping_search (Поиск)

Time: 6.42 ms / 106.58 ms Memory: 0.210 MB / 6.09 MB Application: afterRender

Database queries total: 14.61 ms

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

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

40 SQL-запросов зафиксировано 14.61 ms

4 duplicate found!

2 duplicates: #1 #35

2 duplicates: #2 #36

Query Time: 0.31 ms Query memory: 0.003 MB Memory before query: 0.722 MB

Duplicate queries: #35

DELETE 

  FROM `triholog_session`

  WHERE `time` < '1791813339'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.20 ms After last query: 0.67 ms Query memory: 0.021 MB Memory before query: 0.746 MB Rows returned: 1

Duplicate queries: #36

SELECT `session_id`

  FROM `triholog_session`

  WHERE `session_id` = '16a2e026a3238a52829229dec2d6d7be' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.18 ms After last query: 1.58 ms Query memory: 0.023 MB Memory before query: 0.908 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.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.13 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 0.920 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.02 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.19 ms After last query: 3.08 ms Query memory: 0.023 MB Memory before query: 1.244 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.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 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
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.250 MB Rows returned: 0

SELECT `file`

  FROM triholog_rsfirewall_hashes

  WHERE `type`='protect'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 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
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.255 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.45 ms After last query: 2.46 ms Query memory: 0.028 MB Memory before query: 1.467 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.16 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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.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.25 ms After last query: 6.28 ms Query memory: 0.025 MB Memory before query: 1.899 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.01 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.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
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.42 ms Query memory: 0.036 MB Memory before query: 2.224 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.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

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

select `alias`,`newurl` 
  from `triholog_sh404sef_aliases` 
  where `alias` = 'novosti/page5' 
  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.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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.25 ms After last query: 0.43 ms Query memory: 0.027 MB Memory before query: 3.089 MB Rows returned: 1

SELECT `oldurl`, `newurl`, `dateadd` 
  FROM triholog_sh404sef_urls 
  WHERE `oldurl`='novosti/page5' 
  ORDER BY `rank`;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.25 ms Query memory: 0.023 MB Memory before query: 3.102 MB Rows returned: 0

SELECT *

  FROM triholog_rsfirewall_hashes

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.12 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 3.108 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.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.16 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 3.115 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM triholog_rsfirewall_lists

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.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.19 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 3.120 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.03 ms
statistics	0.02 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
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.20 ms Query memory: 0.026 MB Memory before query: 3.128 MB Rows returned: 0

SELECT *

  FROM triholog_rsfirewall_exceptions

  WHERE `published`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/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.69 ms After last query: 0.34 ms Query memory: 0.031 MB Memory before query: 3.139 MB Rows returned: 46

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

  FROM `triholog_assets`

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.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.32 ms After last query: 1.06 ms Query memory: 0.005 MB Memory before query: 3.214 MB

UPDATE `triholog_extensions`

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

  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.18 ms After last query: 2.29 ms Query memory: 0.025 MB Memory before query: 3.347 MB Rows returned: 1

SELECT * 
  FROM triholog_zoo_application 
  WHERE id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_zoo_application	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.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
11	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
10	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
9	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.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.09 ms After last query: 2.51 ms Query memory: 0.008 MB Memory before query: 3.476 MB


  SET SESSION group_concat_max_len = 1048576

Explain

EXPLAIN not possible on query: SET SESSION group_concat_max_len = 1048576

Profile

Status	Duration
starting	0.02 ms
Opening tables	0.03 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
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:183
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:293
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:317
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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.20 ms Query memory: 0.031 MB Memory before query: 3.488 MB Rows returned: 11

SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM triholog_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN triholog_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN triholog_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-10-12 18:55:39') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-10-12 18:55:39') 
  WHERE c.application_id = 1 
  AND c.published = 1 
  GROUP BY c.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	PRIMARY,ALIAS_INDEX,PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	NO INDEX KEY COULD BE USED	NULL	NULL	12	91.67	Using where; Using filesort
1	SIMPLE	ci	NULL	ref	PRIMARY,CATEGORYID_INDEX	CATEGORYID_INDEX	4	cy85373_triholog.c.id	16	100.00	Using index
1	SIMPLE	i	NULL	ref	MULTI_INDEX2	MULTI_INDEX2	9	cy85373_triholog.ci.item_id,const,const	1	100.00	Using where; Using index

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.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.60 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
18	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
17	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
16	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:209
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:293
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:317
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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.81 ms After last query: 0.80 ms Query memory: 0.030 MB Memory before query: 3.560 MB Rows returned: 3

SELECT a.* 
  FROM triholog_zoo_item AS a 
  LEFT JOIN triholog_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 1 
  AND a.access IN (1) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-12 18:55:39') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-12 18:55:39') 
  AND b.category_id  = 28 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.created DESC 
  LIMIT 16,4

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	19	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT	PRIMARY	4	cy85373_triholog.b.item_id	1	40.00	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.01 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.32 ms
Creating sort index	0.12 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.03 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/administrator/components/com_zoo/framework/helpers/database.php:64
15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
14	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:470
13	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:234
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.45 ms After last query: 8.38 ms Query memory: 0.033 MB Memory before query: 4.266 MB Rows returned: 1

SELECT b.id 
  FROM triholog_zoo_category_item AS a JOIN triholog_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=141 
  AND b.published = 1 UNION SELECT 0 
  FROM triholog_zoo_category_item AS a 
  WHERE a.item_id=141 
  AND a.category_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	cy85373_triholog.a.category_id	1	91.67	Using where
2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

Profile

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

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:7
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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.09 ms After last query: 2.65 ms Query memory: 0.063 MB Memory before query: 4.351 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.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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.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.20 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
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
39	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
38	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
37	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
36	JTable->__construct()	JROOT/components/com_jshopping/tables/config.php:14
35	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
34	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
33	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
32	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
31	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
30	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
28	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
27	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
26	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
25	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:13
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.35 ms After last query: 0.81 ms Query memory: 0.085 MB Memory before query: 4.660 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.01 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.01 ms
executing	0.00 ms
Sending data	0.08 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
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
36	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
35	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
34	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
33	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
32	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
31	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
30	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
28	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
27	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
26	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
25	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:13
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.36 ms After last query: 0.45 ms Query memory: 0.042 MB Memory before query: 4.675 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_currencies`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.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.01 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
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
43	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
42	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
41	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
40	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
39	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:311
38	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
37	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:549
36	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
35	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
34	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
33	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
32	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
31	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
30	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
28	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
27	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
26	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
25	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:13
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.20 ms After last query: 0.09 ms Query memory: 0.038 MB Memory before query: 4.710 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
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
38	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
37	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:550
36	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
35	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
34	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
33	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
32	JSFactory::loadLanguageFile()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:30
31	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
30	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
28	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
27	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
26	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
25	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:13
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.28 ms After last query: 0.28 ms Query memory: 0.040 MB Memory before query: 4.726 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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 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.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
37	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
36	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
35	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
34	JTable->__construct()	JROOT/components/com_jshopping/tables/review.php:14
33	jshopReview->__construct()	JROOT/libraries/joomla/table/table.php:311
32	JTable::getInstance()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:37
31	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
30	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
28	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
27	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
26	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
25	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:13
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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.63 ms After last query: 0.17 ms Query memory: 0.039 MB Memory before query: 4.765 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.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.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.41 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
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
38	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:136
37	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:46
36	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:39
35	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:396
34	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:415
33	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:488
32	SEFLink()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:44
31	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
30	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
28	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
27	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
26	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
25	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:13
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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.30 ms After last query: 1.10 ms Query memory: 0.033 MB Memory before query: 4.825 MB Rows returned: 1

SELECT b.id 
  FROM triholog_zoo_category_item AS a JOIN triholog_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=140 
  AND b.published = 1 UNION SELECT 0 
  FROM triholog_zoo_category_item AS a 
  WHERE a.item_id=140 
  AND a.category_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	cy85373_triholog.a.category_id	1	91.67	Using where
2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 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.01 ms
statistics	0.04 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:7
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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.30 ms After last query: 1.21 ms Query memory: 0.033 MB Memory before query: 4.843 MB Rows returned: 1

SELECT b.id 
  FROM triholog_zoo_category_item AS a JOIN triholog_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=139 
  AND b.published = 1 UNION SELECT 0 
  FROM triholog_zoo_category_item AS a 
  WHERE a.item_id=139 
  AND a.category_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	cy85373_triholog.a.category_id	1	91.67	Using where
2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 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.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php:7
22	include JROOT/media/zoo/applications/blog/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/default/_item.php:4
19	include JROOT/media/zoo/applications/blog/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/_items.php:4
17	include JROOT/media/zoo/applications/blog/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/default/category.php:9
15	include JROOT/media/zoo/applications/blog/templates/default/category.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:321
12	DefaultController->category()	JROOT/libraries/legacy/controller/legacy.php:709
11	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	JROOT/libraries/legacy/controller/legacy.php:709
9	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.22 ms After last query: 2.34 ms Query memory: 0.025 MB Memory before query: 4.790 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.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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.21 ms After last query: 1.92 ms Query memory: 0.029 MB Memory before query: 4.951 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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.20 ms After last query: 4.65 ms Query memory: 0.006 MB Memory before query: 5.128 MB

Duplicate queries: #1

DELETE 

  FROM `triholog_session`

  WHERE `time` < '1791813339'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.02 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:834
11	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
10	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
9	JApplicationSite->__construct()	JROOT/templates/tpl_triholog/includes/head.php:7
8	include JROOT/templates/tpl_triholog/includes/head.php	JROOT/templates/tpl_triholog/index.php:5
7	require JROOT/templates/tpl_triholog/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1114
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:51

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

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

Duplicate queries: #2

SELECT `session_id`

  FROM `triholog_session`

  WHERE `session_id` = '16a2e026a3238a52829229dec2d6d7be' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.95 ms After last query: 0.24 ms Query memory: 0.138 MB Memory before query: 5.145 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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.63 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
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.63 ms After last query: 13.26 ms Query memory: 0.041 MB Memory before query: 5.775 MB Rows returned: 59

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.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.02 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.47 ms After last query: 6.78 ms Query memory: 0.033 MB Memory before query: 6.049 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.01 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 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.19 ms After last query: 0.15 ms Query memory: 0.037 MB Memory before query: 6.105 MB Rows returned: 0

SELECT * 
  FROM triholog_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_zoo&Itemid=326&lang=ru&layout=category&page=5&view=category';

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

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

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

3 × SELECT b.id 
  FROM triholog_zoo_category_item AS a JOIN triholog_zoo_category AS b 
  ON a.category_id = b.id

2 × SELECT `session_id` 
  FROM `triholog_session`

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

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

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 `oldurl`, `dateadd` 
  FROM triholog_sh404sef_urls

1 × SELECT params 
  FROM triholog_extensions AS e

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 a.* 
  FROM triholog_zoo_item AS a 
  LEFT JOIN triholog_zoo_category_item AS b 
  ON a.id = b.item_id

1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM triholog_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN triholog_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN triholog_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-10-12 18:55:39') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-10-12 18:55:39')

1 × SELECT * 
  FROM triholog_zoo_application

1 × SELECT * 
  FROM triholog_rsfirewall_exceptions

1 × SELECT id, rules 
  FROM `triholog_viewlevels

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 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_sh404sef_metas

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

2 × DELETE  
  FROM `triholog_session`

1 × SHOW FULL COLUMNS 
  FROM `triholog_rsfirewall_logs

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

1 × 
  SET SESSION group_concat_max_len = 104857

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