BK Shillington

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728073579,
                "last": 1728073579,
                "now": 1728073579
            }
        },
        "registry": {
            "com_virtuemart": {
                "categoryc16": {
                    "limit": "int"
                },
                "categoryc16m0": {
                    "limitstart": 0
                }
            }
        },
        "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
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 101,
        "vmlastvisitedcategoryid": 16,
        "vmlastvisitedmanuid": -1
    }
}

Profile Information

Time

Memory

Time: 2.38 ms / 2.38 ms Memory: 0.036 MB / 0.38 MB Application: afterLoad

Time: 63.40 ms / 65.78 ms Memory: 1.159 MB / 1.54 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.73 ms / 66.50 ms Memory: 0.013 MB / 1.55 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 1.17 ms / 67.68 ms Memory: 0.003 MB / 1.55 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.57 ms / 68.25 ms Memory: 0.016 MB / 1.57 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.03 ms / 68.28 ms Memory: 0.000 MB / 1.57 MB Application: Start JAccess::preload(components)

Time: 2.45 ms / 70.73 ms Memory: 0.230 MB / 1.80 MB Application: Finish JAccess::preload(components)

Time: 0.55 ms / 71.28 ms Memory: 0.001 MB / 1.80 MB Application: afterInitialise

Time: 17.00 ms / 88.28 ms Memory: 0.559 MB / 2.36 MB Application: afterRoute

Time: 4.18 ms / 92.46 ms Memory: 0.042 MB / 2.40 MB Application: beforeRenderComponent com_virtuemart

Time: 105.14 ms / 197.60 ms Memory: 2.255 MB / 4.66 MB Application: afterRenderComponent com_virtuemart

Time: 1.15 ms / 198.74 ms Memory: 0.007 MB / 4.66 MB Application: afterDispatch

Time: 3.92 ms / 202.66 ms Memory: 0.092 MB / 4.76 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)

Time: 0.66 ms / 203.32 ms Memory: 0.005 MB / 4.76 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)

Time: 0.04 ms / 203.36 ms Memory: 0.001 MB / 4.76 MB Application: beforeRenderModule mod_menu (Navigation)

Time: 0.62 ms / 203.98 ms Memory: 0.084 MB / 4.85 MB Application: afterRenderModule mod_menu (Navigation)

Time: 0.02 ms / 204.00 ms Memory: 0.000 MB / 4.84 MB Application: beforeRenderModule mod_menu (Information)

Time: 0.43 ms / 204.43 ms Memory: 0.009 MB / 4.85 MB Application: afterRenderModule mod_menu (Information)

Time: 0.02 ms / 204.45 ms Memory: 0.000 MB / 4.85 MB Application: beforeRenderModule mod_menu (Social List)

Time: 0.17 ms / 204.63 ms Memory: 0.007 MB / 4.86 MB Application: afterRenderModule mod_menu (Social List)

Time: 0.02 ms / 204.64 ms Memory: 0.000 MB / 4.85 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.29 ms / 204.93 ms Memory: 0.006 MB / 4.86 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.03 ms / 204.96 ms Memory: 0.000 MB / 4.86 MB Application: beforeRenderModule mod_virtuemart_category (Furniture )

Time: 103.85 ms / 308.82 ms Memory: 1.249 MB / 6.11 MB Application: afterRenderModule mod_virtuemart_category (Furniture )

Time: 0.09 ms / 308.91 ms Memory: 0.000 MB / 6.10 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.78 ms / 309.69 ms Memory: 0.011 MB / 6.11 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.04 ms / 309.73 ms Memory: 0.000 MB / 6.11 MB Application: beforeRenderModule mod_icemegamenu (Navigation menu)

Time: 5.32 ms / 315.05 ms Memory: 0.090 MB / 6.20 MB Application: afterRenderModule mod_icemegamenu (Navigation menu)

Time: 0.10 ms / 315.15 ms Memory: 0.000 MB / 6.20 MB Application: beforeRenderModule mod_virtuemart_search (Search product)

Time: 0.94 ms / 316.09 ms Memory: 0.012 MB / 6.21 MB Application: afterRenderModule mod_virtuemart_search (Search product)

Time: 0.04 ms / 316.13 ms Memory: 0.009 MB / 6.22 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Time: 0.59 ms / 316.72 ms Memory: 0.105 MB / 6.32 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Time: 2.49 ms / 319.21 ms Memory: 0.052 MB / 6.37 MB Application: afterRender

Database queries total: 199.18 ms

Memory Usage

Database Queries

187 Queries Logged 199.18 ms

42 duplicate found!

2 duplicates: #15 #17

2 duplicates: #31 #34

2 duplicates: #32 #35

2 duplicates: #127 #128

2 duplicates: #130 #131

2 duplicates: #132 #133

2 duplicates: #136 #137

2 duplicates: #140 #141

2 duplicates: #144 #145

2 duplicates: #148 #149

2 duplicates: #152 #153

2 duplicates: #155 #156

2 duplicates: #158 #159

2 duplicates: #161 #162

2 duplicates: #164 #165

2 duplicates: #167 #168

2 duplicates: #171 #172

2 duplicates: #173 #174

2 duplicates: #176 #177

2 duplicates: #179 #180

2 duplicates: #182 #183

Query Time: 0.72 ms Query memory: 0.022 MB Memory before query: 0.658 MB Rows returned: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'eb04fb019583f258e8251228151625fe'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	766	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
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: 2.03 ms After last query: 0.68 ms Query memory: 0.003 MB Memory before query: 0.674 MB

DELETE 

  FROM `jos_session`

  WHERE `time` < '1728072679'

Explain

EXPLAIN not possible on query: DELETE FROM `jos_session` WHERE `time` < '1728072679'

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
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: 1.77 ms After last query: 0.08 ms Query memory: 0.019 MB Memory before query: 0.679 MB Rows returned: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'eb04fb019583f258e8251228151625fe' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
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: 3.25 ms After last query: 0.07 ms Query memory: 0.003 MB Memory before query: 0.683 MB

INSERT INTO `jos_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('eb04fb019583f258e8251228151625fe', 0, 1, '1728073579', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('eb04fb019583f258e8251228151625fe', 0, 1, '1728073579', 0, '')

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
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.98 ms After last query: 0.77 ms Query memory: 0.023 MB Memory before query: 0.705 MB Rows returned: 38

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jos_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	38	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.52 ms Query memory: 0.021 MB Memory before query: 0.725 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 0.730 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 0.738 MB Rows returned: 74

SELECT folder AS type, element AS name, params

  FROM jos_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	238	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.43 ms After last query: 5.23 ms Query memory: 0.022 MB Memory before query: 1.273 MB Rows returned: 12

SELECT * 
  FROM jos_loginradius_settings

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_loginradius_settings	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	12

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
9	plgSystemSocialLoginTools::sociallogin_getsettings()	JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
8	plgSystemSocialLoginAndSocialShare->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 7.12 ms After last query: 1.71 ms Query memory: 0.021 MB Memory before query: 1.352 MB Rows returned: 1

SHOW TABLES LIKE "jos_virtuemart_configs"

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE "jos_virtuemart_configs"

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:533
10	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:883
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 12.91 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 1.357 MB Rows returned: 1

SELECT `config` 
  FROM `jos_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_configs	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:931
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.35 ms After last query: 0.80 ms Query memory: 0.022 MB Memory before query: 1.417 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
12	JLanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:92
11	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:69
10	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:952
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.67 ms After last query: 0.49 ms Query memory: 0.026 MB Memory before query: 1.511 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `jos_assets`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1265
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:640
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:953
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.07 ms After last query: 0.36 ms Query memory: 0.024 MB Memory before query: 1.533 MB Rows returned: 1

SELECT *

  FROM jos_assets

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	const	PRIMARY	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1265
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:640
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:953
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 1.539 MB Rows returned: 1

Duplicate queries: #17

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1265
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:640
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:953
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.01 ms After last query: 0.39 ms Query memory: 0.023 MB Memory before query: 1.547 MB Rows returned: 1

SELECT id

  FROM jos_assets

  WHERE parent_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	ref	idx_parent_id	idx_parent_id	4	const	1	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
14	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1265
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:640
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:953
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[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.06 ms Query memory: 0.023 MB Memory before query: 1.557 MB Rows returned: 1

Duplicate queries: #15

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1265
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:640
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:953
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.27 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 1.571 MB Rows returned: 38

SELECT element

  FROM jos_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	38	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1265
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:640
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:953
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 1.585 MB Rows returned: 38

SELECT a.name, a.rules

  FROM jos_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_socialloginandsocialshare','com_tags','com_tcpdf','com_templates','com_tmbox','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	170	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1265
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:640
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:953
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.36 ms After last query: 1.72 ms Query memory: 0.070 MB Memory before query: 1.809 MB Rows returned: 51

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	64	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bktradingvm.m.component_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.97 ms After last query: 2.64 ms Query memory: 0.025 MB Memory before query: 2.140 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `jos_komento_configs`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/cms/router/site.php:738
6	JRouterSite->getComponentRouter()	JROOT/libraries/cms/router/site.php:123
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.24 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 2.154 MB Rows returned: 1

SELECT *

  FROM jos_komento_configs

  WHERE `component` = 'com_komento'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/cms/router/site.php:738
6	JRouterSite->getComponentRouter()	JROOT/libraries/cms/router/site.php:123
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.59 ms After last query: 2.82 ms Query memory: 0.022 MB Memory before query: 2.317 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
13	JApplicationSite->getTemplate()	JROOT/components/com_virtuemart/router.php:776
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:822
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:345
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.33 ms Query memory: 0.022 MB Memory before query: 2.328 MB Rows returned: 1

SELECT `id` 
  FROM `jos_menu` 
  WHERE `home`="1" 
  and (language="*" or language = "en-GB" ) 
  ORDER BY `language` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_menu	ALL	idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	123	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:787
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:822
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:345
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[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.07 ms Query memory: 0.046 MB Memory before query: 2.335 MB Rows returned: 13

SELECT * 
  FROM `jos_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "en-GB" ) 
  AND ( access="1" OR access="5" )  
  ORDER BY `language` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	123	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1198
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:794
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:822
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:345
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.69 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 2.348 MB Rows returned: 0

SELECT virtuemart_product_id 
  FROM jos_virtuemart_products_en_gb 
  WHERE slug = "individual-dressers-nightstands"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1132
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1065
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:669
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 2.355 MB Rows returned: 1

BK Shillington

Individual Dressers & Nightstands

Brand New Ashley Furniture "Bruebar" High Chest

SOLD New Ashley Furniture

SOLD. Ethan Allen Maple Dresser with mirror

SOLD Ethan Allen Nightstands SOLD

HoursMonday: ClosedTuesday-Wednesday: 10am-4pmThursday-Saturday: 10am-8pmSunday: 10am-6pm

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

187 Queries Logged 199.18 ms

42 duplicate found!

Hours
Monday: Closed
Tuesday-Wednesday: 10am-4pm
Thursday-Saturday: 10am-8pm
Sunday: 10am-6pm