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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1792026850,
                "last": 1792026850,
                "now": 1792026850
            },
            "token": "ZYkI24pK1iLm7s7bjg5ePBbWAkzIqhXr"
        },
        "registry": {
            "jshoping": {
                "list": {
                    "front": {
                        "product": {
                            "cat": {
                                "1manufacturers": [],
                                "1extra_fields": []
                            }
                        }
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "js_id_currency_orig": "2",
        "js_id_currency": "2",
        "com_rsfirewall": {
            "geoip": false
        },
        "js_history_sel_lang": "ru-RU",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB",
            "ru-RU"
        ],
        "jshop_end_page_buy_product": "\/filter\/optimaker",
        "jshop_end_page_list_product": "\/filter\/optimaker"
    }
}

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

Time

Memory

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

Time: 30.29 ms / 33.28 ms Memory: 2.399 MB / 2.80 MB Application: afterInitialise

Time: 12.46 ms / 45.74 ms Memory: 0.758 MB / 3.56 MB Application: Before JAccess::preloadComponents (all components)

Time: 0.86 ms / 46.60 ms Memory: 0.071 MB / 3.63 MB Application: After JAccess::preloadComponents (all components)

Time: 0.03 ms / 46.62 ms Memory: 0.000 MB / 3.62 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.21 ms / 46.83 ms Memory: 0.009 MB / 3.63 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.25 ms / 47.09 ms Memory: 0.000 MB / 3.63 MB Application: afterRoute

Time: 1.10 ms / 48.19 ms Memory: 0.097 MB / 3.73 MB Application: beforeRenderComponent com_jshopping

Time: 20.81 ms / 68.99 ms Memory: 0.924 MB / 4.65 MB Application: afterRenderComponent com_jshopping

Time: 9.32 ms / 78.31 ms Memory: 0.605 MB / 5.26 MB Application: afterDispatch

Time: 10.79 ms / 89.11 ms Memory: 0.514 MB / 5.77 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

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

Time: 2.80 ms / 91.95 ms Memory: 0.050 MB / 5.83 MB Application: beforeRenderModule mod_custom (Значения фильтров для JoomShopping (Bottom))

Time: 0.70 ms / 92.65 ms Memory: 0.015 MB / 5.84 MB Application: afterRenderModule mod_custom (Значения фильтров для JoomShopping (Bottom))

Time: 0.06 ms / 92.71 ms Memory: 0.006 MB / 5.85 MB Application: beforeRenderModule mod_custom (Значения фильтров для JoomShopping (Top))

Time: 0.27 ms / 92.97 ms Memory: 0.003 MB / 5.85 MB Application: afterRenderModule mod_custom (Значения фильтров для JoomShopping (Top))

Time: 0.05 ms / 93.02 ms Memory: 0.000 MB / 5.85 MB Application: beforeRenderModule mod_jshopping_filters (Фильтр товаров)

Time: 2.23 ms / 95.24 ms Memory: 0.064 MB / 5.92 MB Application: afterRenderModule mod_jshopping_filters (Фильтр товаров)

Time: 0.07 ms / 95.32 ms Memory: 0.016 MB / 5.93 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs (для фильтров))

Time: 0.95 ms / 96.27 ms Memory: 0.015 MB / 5.95 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs (для фильтров))

Time: 0.63 ms / 96.89 ms Memory: 0.004 MB / 5.95 MB Application: beforeRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini (mobile))

Time: 1.72 ms / 98.61 ms Memory: 0.207 MB / 6.16 MB Application: afterRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini (mobile))

Time: 0.48 ms / 99.10 ms Memory: 0.000 MB / 6.15 MB Application: beforeRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini)

Time: 0.48 ms / 99.58 ms Memory: 0.018 MB / 6.17 MB Application: afterRenderModule mod_jshopping_cart_ajax_mini (Jshopping Cart Ajax mini)

Time: 0.20 ms / 99.78 ms Memory: 0.000 MB / 6.16 MB Application: beforeRenderModule mod_jshopping_search (Поиск)

Time: 0.52 ms / 100.31 ms Memory: 0.007 MB / 6.17 MB Application: afterRenderModule mod_jshopping_search (Поиск)

Time: 11.06 ms / 111.36 ms Memory: 0.317 MB / 6.49 MB Application: afterRender

Database queries total: 19.21 ms

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

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

59 SQL-запросов зафиксировано 19.21 ms

10 duplicate found!

2 duplicates: #1 #52

2 duplicates: #11 #14

4 duplicates: #21 #22 #47 #56

2 duplicates: #32 #54

Query Time: 0.20 ms Query memory: 0.021 MB Memory before query: 0.734 MB Rows returned: 0

Duplicate queries: #52

SELECT `session_id`

  FROM `triholog_session`

  WHERE `session_id` = '6ccdffa3f3fc60c5ae9e620f0c67cf06' 
  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.01 ms
Opening tables	0.04 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.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.21 ms After last query: 0.08 ms Query memory: 0.003 MB Memory before query: 0.739 MB

INSERT INTO `triholog_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('6ccdffa3f3fc60c5ae9e620f0c67cf06', 1, '1792026850', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `triholog_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('6ccdffa3f3fc60c5ae9e620f0c67cf06', 1, '1792026850', 0, '')

Profile

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

Call Stack

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

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

Query Time: 0.18 ms After last query: 1.51 ms Query memory: 0.023 MB Memory before query: 0.902 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.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.15 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 0.914 MB Rows returned: 0

SELECT b.id

  FROM triholog_usergroups AS a

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

  WHERE a.id = 13

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.19 ms After last query: 3.04 ms Query memory: 0.023 MB Memory before query: 1.238 MB Rows returned: 1

SELECT `path`

  FROM triholog_rsfirewall_ignored

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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: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.12 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 1.244 MB Rows returned: 0

SELECT `file`

  FROM triholog_rsfirewall_hashes

  WHERE `type`='protect'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 1.249 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.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.44 ms After last query: 2.28 ms Query memory: 0.028 MB Memory before query: 1.460 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.12 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.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.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
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.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.26 ms After last query: 6.52 ms Query memory: 0.025 MB Memory before query: 1.892 MB Rows returned: 1

SELECT COUNT(`extension_id`)

  FROM `triholog_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.24 ms After last query: 4.84 ms Query memory: 0.036 MB Memory before query: 2.218 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 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.21 ms After last query: 7.62 ms Query memory: 0.024 MB Memory before query: 3.063 MB Rows returned: 0

Duplicate queries: #14

select `alias`,`newurl` 
  from `triholog_sh404sef_aliases` 
  where `alias` = 'filter/optimaker' 
  order by `alias` desc

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.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.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.19 ms After last query: 0.39 ms Query memory: 0.027 MB Memory before query: 3.082 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	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
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.14 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 3.091 MB Rows returned: 0

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.12 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 3.100 MB Rows returned: 0

Duplicate queries: #11

select `alias`,`newurl` 
  from `triholog_sh404sef_aliases` 
  where `alias` = 'filter/optimaker' 
  order by `alias` desc

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.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/administrator/components/com_sh404sef/classes/router.php:1104
13	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:351
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.97 ms After last query: 0.44 ms Query memory: 0.054 MB Memory before query: 3.123 MB Rows returned: 140

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_config`

Explain

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

Profile

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

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

Query Time: 0.33 ms After last query: 0.58 ms Query memory: 0.076 MB Memory before query: 3.424 MB Rows returned: 1

SELECT *

  FROM triholog_jshopping_config

  WHERE `id` = '1'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.33 ms After last query: 0.35 ms Query memory: 0.034 MB Memory before query: 3.431 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_currencies`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.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.00 ms
checking permissions	0.01 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.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.21 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 3.459 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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
23	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:550
22	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
21	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
20	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:146
19	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:169
18	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1590
17	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:255
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.24 ms After last query: 0.35 ms Query memory: 0.027 MB Memory before query: 3.474 MB Rows returned: 7

select manufacturer_id as id, `alias_ru-RU` as alias 
  from triholog_jshopping_manufacturers 
  where `alias_ru-RU`!=''

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 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.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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:266
17	JSFactory::getAliasManufacturer()	JROOT/components/com_jshopping/router.php:273
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.29 ms After last query: 0.18 ms Query memory: 0.031 MB Memory before query: 3.488 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_field_values`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.25 ms After last query: 0.06 ms Query memory: 0.033 MB Memory before query: 3.509 MB Rows returned: 56

Duplicate queries: #22 #47 #56

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.13 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:25
17	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/router.php:281
16	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
15	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
14	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
13	JRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:362
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1432
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:110
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.28 ms After last query: 0.26 ms Query memory: 0.030 MB Memory before query: 3.519 MB Rows returned: 56

Duplicate queries: #21 #47 #56

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:25
11	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/router.php:281
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
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.15 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 3.523 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.02 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.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.14 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.530 MB Rows returned: 0

SELECT *

  FROM triholog_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

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

Profile

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

SELECT `ip`,`reason`

  FROM triholog_rsfirewall_lists

  WHERE (`ip`='2600:1f28:365:80b0:fe6c:4ae8:e422:8cd7' 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.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

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

SELECT `ip`,`reason`

  FROM triholog_rsfirewall_lists

  WHERE (`ip`='2600:1f28:365:80b0:fe6c:4ae8:e422:8cd7' 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.17 ms After last query: 0.37 ms Query memory: 0.025 MB Memory before query: 3.550 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.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.66 ms After last query: 0.29 ms Query memory: 0.031 MB Memory before query: 3.561 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.06 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.28 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.26 ms After last query: 0.87 ms Query memory: 0.005 MB Memory before query: 3.636 MB

UPDATE `triholog_extensions`

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

  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.00 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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: 3.24 ms Query memory: 0.024 MB Memory before query: 3.750 MB Rows returned: 2

select * 
  from triholog_jshopping_languages

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.44 ms After last query: 0.60 ms Query memory: 0.031 MB Memory before query: 3.777 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_categories`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.22 ms After last query: 0.85 ms Query memory: 0.031 MB Memory before query: 3.831 MB Rows returned: 1

Duplicate queries: #54

SELECT *

  FROM triholog_jshopping_categories

  WHERE `category_id` = '1'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.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.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.37 ms After last query: 1.18 ms Query memory: 0.032 MB Memory before query: 3.894 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_reviews`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
18	JTable->__construct()	JROOT/components/com_jshopping/tables/review.php:14
17	jshopReview->__construct()	JROOT/libraries/joomla/table/table.php:311
16	JTable::getInstance()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:37
15	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
14	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:947
11	changeDataUsePluginContent()	JROOT/components/com_jshopping/tables/category.php:257
10	jshopCategory->preparePluginContent()	JROOT/components/com_jshopping/tables/category.php:66
9	jshopCategory->getDescription()	JROOT/components/com_jshopping/controllers/category.php:58
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.89 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 3.925 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.02 ms
init	0.02 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.63 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:136
21	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:46
20	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:39
19	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:396
18	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:415
17	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:488
16	SEFLink()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:44
15	plgContentJshopProductInsert->_initJSConfig()	JROOT/plugins/content/jshopproductinsert/jshopproductinsert.php:120
14	plgContentJshopProductInsert->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:947
11	changeDataUsePluginContent()	JROOT/components/com_jshopping/tables/category.php:257
10	jshopCategory->preparePluginContent()	JROOT/components/com_jshopping/tables/category.php:66
9	jshopCategory->getDescription()	JROOT/components/com_jshopping/controllers/category.php:58
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.25 ms After last query: 0.52 ms Query memory: 0.025 MB Memory before query: 4.039 MB Rows returned: 0

SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `triholog_jshopping_categories`
                   
  WHERE category_parent_id = '1'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY ordering asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	58.06	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:66
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.47 ms After last query: 0.47 ms Query memory: 0.037 MB Memory before query: 4.061 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_vendors`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.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.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/components/com_jshopping/tables/vendor.php:15
15	jshopVendor->__construct()	JROOT/libraries/joomla/table/table.php:311
14	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:415
12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1444
11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:310
10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

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

SELECT id 
  FROM triholog_jshopping_vendors 
  WHERE `main`=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	triholog_jshopping_vendors	NULL	ref	main	main	1	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.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/components/com_jshopping/tables/vendor.php:23
13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:416
12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1444
11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:310
10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.17 ms After last query: 0.08 ms Query memory: 0.037 MB Memory before query: 4.134 MB Rows returned: 1

SELECT *

  FROM triholog_jshopping_vendors

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.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:1445
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
14	JTable->load()	JROOT/components/com_jshopping/tables/vendor.php:24
13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:416
12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1444
11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:310
10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.34 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.144 MB Rows returned: 11

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_fields`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
17	JTable->__construct()	JROOT/components/com_jshopping/tables/productfield.php:14
16	jshopProductField->__construct()	JROOT/libraries/joomla/table/table.php:311
15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:476
13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1132
12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:177
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.38 ms After last query: 0.08 ms Query memory: 0.029 MB Memory before query: 4.174 MB Rows returned: 11

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
14	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:477
13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1132
12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:177
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.24 ms After last query: 0.20 ms Query memory: 0.030 MB Memory before query: 4.202 MB Rows returned: 3

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_taxes`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.02 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
18	JTable->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
17	jshopTax->__construct()	JROOT/libraries/joomla/table/table.php:311
16	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:601
15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:349
14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:988
13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:177
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.12 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 4.219 MB Rows returned: 1

SELECT tax_id, tax_name, tax_value 
  FROM `triholog_jshopping_taxes`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
16	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:335
15	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:350
14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:988
13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:177
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.44 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 4.226 MB Rows returned: 1

SELECT count(*) 
  FROM `triholog_jshopping_products_to_categories` AS pr_cat
                  
  INNER JOIN `triholog_jshopping_products` AS prod 
  ON pr_cat.product_id = prod.product_id
                   
                  
  WHERE pr_cat.category_id=1 
  AND prod.product_publish=1  
  AND prod.access IN (1,1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prod	NULL	index_merge	PRIMARY,product_publish,access	product_publish,access	1,4	NULL	20	100.00	Using intersect(product_publish,access); Using where; Using index
1	SIMPLE	pr_cat	NULL	eq_ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	8	cy85373_triholog.prod.product_id,const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 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:1720
11	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/category.php:187
10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.72 ms After last query: 0.47 ms Query memory: 0.039 MB Memory before query: 4.238 MB Rows returned: 13

SELECT prod.product_id, prod.product_primary_category, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_4` , prod.`extra_field_9` , prod.`extra_field_10` , prod.`extra_field_11`  
  FROM `triholog_jshopping_products` AS prod
                  
  LEFT JOIN `triholog_jshopping_products_to_categories` AS pr_cat USING (product_id)
                  
                  
  WHERE pr_cat.category_id=1 
  AND prod.product_publish=1  
  AND prod.access IN (1,1)  
  ORDER BY pr_cat.product_ordering ASC 
  LIMIT 0, 15

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prod	NULL	ref	PRIMARY,product_publish,access	product_publish	1	const	13	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	pr_cat	NULL	eq_ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	8	cy85373_triholog.prod.product_id,const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:169
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:186
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.53 ms After last query: 0.23 ms Query memory: 0.038 MB Memory before query: 4.305 MB Rows returned: 53

SHOW FULL COLUMNS 
  FROM `triholog_jshopping_users`

Explain

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

Profile

Status	Duration
starting	0.02 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.01 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.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.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
14	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
13	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
12	JSFactory::getUserShop()	JROOT/components/com_jshopping/lib/functions.php:674
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:170
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:186
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.16 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 4.409 MB Rows returned: 7

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:402
12	JSFactory::getAllManufacturer()	JROOT/components/com_jshopping/lib/functions.php:677
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:170
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:186
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.22 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 4.423 MB Rows returned: 56

Duplicate queries: #21 #22 #56

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

Explain

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

Profile

Status	Duration
starting	0.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
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.11 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:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:27
14	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:486
13	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:820
12	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:745
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:170
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:186
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.33 ms After last query: 0.48 ms Query memory: 0.035 MB Memory before query: 4.469 MB Rows returned: 113

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.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.13 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:283
20	JSFactory::getAliasProduct()	JROOT/components/com_jshopping/router.php:73
19	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_jshopping/lib/functions.php:505
12	SEFLink()	JROOT/components/com_jshopping/lib/functions.php:451
11	addLinkToProducts()	JROOT/components/com_jshopping/tables/category.php:171
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:186
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.16 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 4.494 MB Rows returned: 31

select category_id as id, `alias_ru-RU` as alias 
  from triholog_jshopping_categories 
  where `alias_ru-RU`!=''

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:249
20	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:74
19	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_jshopping/lib/functions.php:505
12	SEFLink()	JROOT/components/com_jshopping/lib/functions.php:451
11	addLinkToProducts()	JROOT/components/com_jshopping/tables/category.php:171
10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:186
9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:74
8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:51

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

Query Time: 0.21 ms After last query: 5.55 ms Query memory: 0.024 MB Memory before query: 4.662 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.01 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.20 ms After last query: 3.62 ms Query memory: 0.029 MB Memory before query: 5.115 MB Rows returned: 0

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.18 ms After last query: 5.36 ms Query memory: 0.024 MB Memory before query: 5.291 MB Rows returned: 1

Duplicate queries: #1

SELECT `session_id`

  FROM `triholog_session`

  WHERE `session_id` = '6ccdffa3f3fc60c5ae9e620f0c67cf06' 
  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.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.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: 2.14 ms After last query: 0.20 ms Query memory: 0.138 MB Memory before query: 5.302 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.03 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.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.87 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.23 ms After last query: 12.23 ms Query memory: 0.032 MB Memory before query: 5.879 MB Rows returned: 1

Duplicate queries: #32

SELECT *

  FROM triholog_jshopping_categories

  WHERE `category_id` = '1'

Explain

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

Profile

Status	Duration
starting	0.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.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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
11	JTable->load()	JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:50
10	include JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.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.49 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 5.886 MB Rows returned: 1

SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name 
  FROM `triholog_jshopping_products` AS prod
                  
  LEFT JOIN `triholog_jshopping_products_to_categories` AS categ USING (product_id)
                  
  LEFT JOIN `triholog_jshopping_manufacturers` as man 
  on prod.product_manufacturer_id=man.manufacturer_id 
                  
  WHERE 
                     categ.category_id=1 
  AND 
                     prod.product_publish=1 
  AND 
                     prod.product_manufacturer_id!=0  
  AND prod.access IN (1,1) 
  AND
                     man.manufacturer_publish=1   
                  
  ORDER BY man.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prod	NULL	ref	PRIMARY,product_manufacturer_id,product_publish,access	product_publish	1	const	13	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	man	NULL	eq_ref	PRIMARY,manufacturer_publish	PRIMARY	4	cy85373_triholog.prod.product_manufacturer_id	1	50.00	Using where
1	SIMPLE	categ	NULL	eq_ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	8	cy85373_triholog.prod.product_id,const	1	100.00	Using index; Distinct

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.05 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.12 ms
Creating sort index	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.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:233
11	jshopCategory->getManufacturers()	JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:55
10	include JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.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.24 ms After last query: 0.06 ms Query memory: 0.031 MB Memory before query: 5.895 MB Rows returned: 56

Duplicate queries: #21 #22 #47

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

Explain

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

Profile

Status	Duration
starting	0.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
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:35
12	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:495
11	JSFactory::getAllProductExtraFieldValueDetail()	JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:77
10	include JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.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.61 ms After last query: 2.91 ms Query memory: 0.041 MB Memory before query: 6.059 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.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.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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Sending data	0.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.46 ms After last query: 10.58 ms Query memory: 0.033 MB Memory before query: 6.481 MB Rows returned: 28

SHOW FULL COLUMNS 
  FROM `triholog_sh404sef_metas`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.18 ms After last query: 0.11 ms Query memory: 0.037 MB Memory before query: 6.537 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.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.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

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

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

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

2 × SELECT `session_id` 
  FROM `triholog_session`

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

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

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

2 × SELECT * 
  FROM triholog_jshopping_categories

1 × SELECT count(*) 
  FROM `triholog_jshopping_products_to_categories` AS pr_cat                   
  INNER JOIN `triholog_jshopping_products` AS prod 
  ON pr_cat.product_id = prod.product_id

1 × SELECT id 
  FROM triholog_jshopping_vendors

1 × SELECT * 
  FROM triholog_jshopping_vendors

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

1 × SELECT tax_id, tax_name, tax_value 
  FROM `triholog_jshopping_taxes

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

1 × SELECT prod.product_id, prod.product_primary_category, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_4` , prod.`extra_field_9` , prod.`extra_field_10` , prod.`extra_field_11`  
  FROM `triholog_jshopping_products` AS prod                   
  LEFT JOIN `triholog_jshopping_products_to_categories` AS pr_cat USING (product_id)

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

1 × select category_id as id, `alias_ru-RU` as alias 
  from triholog_jshopping_categories

1 × SELECT params 
  FROM triholog_extensions AS e

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

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 distinct man.manufacturer_id as id, man.`name_ru-RU` as name 
  FROM `triholog_jshopping_products` AS prod                   
  LEFT JOIN `triholog_jshopping_products_to_categories` AS categ USING (product_id)                   
  LEFT JOIN `triholog_jshopping_manufacturers` as man 
  on prod.product_manufacturer_id=man.manufacturer_id

1 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image 
  FROM `triholog_jshopping_categories`

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

1 × select id,link 
  from triholog_menu

1 × select * 
  from triholog_jshopping_language

1 × SELECT id, rules 
  FROM `triholog_viewlevels

1 × SELECT * 
  FROM triholog_rsfirewall_exceptions

1 × SELECT * 
  FROM triholog_rsfirewall_snapshots

1 × SELECT * 
  FROM triholog_rsfirewall_hashes

1 × select manufacturer_id as id, `alias_ru-RU` as alias 
  from triholog_jshopping_manufacturers

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 `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-запросы:

1 × INSERT INTO `triholog_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('6ccdffa3f3fc60c5ae9e620f0c67cf06', 1, '1792026850', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `triholog_rsfirewall_logs

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_currencies

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_field_values

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

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_categories

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_reviews

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_vendors

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products_extra_fields

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_users

1 × SHOW FULL COLUMNS 
  FROM `triholog_jshopping_products

1 × SHOW FULL COLUMNS 
  FROM `triholog_sh404sef_metas