Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685746926,
                "last": 1685746926,
                "now": 1685746926
            }
        },
        "registry": {},
        "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": 702
    }
}

Profile Information

Time

Memory

Time: 10.14 ms / 10.14 ms Memory: 0.551 MB / 0.93 MB Application: afterLoad

Time: 62.96 ms / 73.10 ms Memory: 4.397 MB / 5.32 MB Application: afterInitialise

Time: 10.53 ms / 83.64 ms Memory: 0.729 MB / 6.05 MB Application: afterRoute

Time: 6.42 ms / 90.06 ms Memory: 0.272 MB / 6.33 MB Application: beforeRenderComponent com_virtuemart

Time: 15.16 ms / 105.22 ms Memory: 1.426 MB / 7.75 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.67 ms / 105.90 ms Memory: 0.029 MB / 7.78 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.08 ms / 105.98 ms Memory: 0.000 MB / 7.78 MB Application: Start JAccess::preload(components)

Time: 1.97 ms / 107.95 ms Memory: 0.212 MB / 7.99 MB Application: Finish JAccess::preload(components)

Time: 40.22 ms / 148.17 ms Memory: 1.123 MB / 9.11 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.37 ms / 148.54 ms Memory: 0.014 MB / 9.13 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 95.16 ms / 243.71 ms Memory: 2.230 MB / 11.36 MB Application: afterRenderComponent com_virtuemart

Time: 6.89 ms / 250.60 ms Memory: 0.182 MB / 11.54 MB Application: afterDispatch

Time: 33.87 ms / 284.47 ms Memory: 1.186 MB / 12.72 MB Application: beforeRenderModule mod_search (Search)

Time: 1.44 ms / 285.92 ms Memory: 0.065 MB / 12.79 MB Application: afterRenderModule mod_search (Search)

Time: 0.04 ms / 285.96 ms Memory: 0.000 MB / 12.78 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 2.99 ms / 288.94 ms Memory: 0.060 MB / 12.84 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.06 ms / 289.00 ms Memory: 0.000 MB / 12.84 MB Application: beforeRenderModule mod_custom (EMAILSITEL)

Time: 0.38 ms / 289.38 ms Memory: 0.007 MB / 12.85 MB Application: afterRenderModule mod_custom (EMAILSITEL)

Time: 0.06 ms / 289.43 ms Memory: 0.000 MB / 12.85 MB Application: beforeRenderModule mod_virtuemart_product (Cele mai noi produse)

Time: 0.87 ms / 290.30 ms Memory: 0.041 MB / 12.89 MB Application: afterRenderModule mod_virtuemart_product (Cele mai noi produse)

Time: 9.32 ms / 299.62 ms Memory: 0.861 MB / 13.75 MB Application: afterRender

Database queries total: 67.76 ms

Memory Usage

Database Queries

93 Queries Logged 67.76 ms

38 duplicate found!

2 duplicates: #22 #30

2 duplicates: #53 #57

2 duplicates: #54 #58

2 duplicates: #55 #59

2 duplicates: #56 #60

2 duplicates: #61 #63

2 duplicates: #62 #64

2 duplicates: #65 #67

2 duplicates: #66 #68

2 duplicates: #69 #71

2 duplicates: #70 #72

2 duplicates: #73 #75

2 duplicates: #74 #76

2 duplicates: #77 #79

2 duplicates: #78 #80

2 duplicates: #81 #83

2 duplicates: #82 #84

2 duplicates: #85 #87

2 duplicates: #86 #88

Query Time: 1.07 ms Query memory: 0.007 MB Memory before query: 2.476 MB Rows returned: 0

SELECT `data`

  FROM `grafe_session`

  WHERE `session_id` = 'f7b3ccf66169c8e65a5c975b059e9918'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

Profile

Status	Duration
starting	0.18 ms
Waiting for query cache lock	0.11 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.16 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

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: 0.55 ms After last query: 2.20 ms Query memory: 0.004 MB Memory before query: 2.602 MB Rows returned: 0

SELECT `session_id`

  FROM `grafe_session`

  WHERE `session_id` = 'f7b3ccf66169c8e65a5c975b059e9918' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.15 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.09 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

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: 0.61 ms After last query: 0.07 ms Query memory: 0.003 MB Memory before query: 2.606 MB

INSERT INTO `grafe_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('f7b3ccf66169c8e65a5c975b059e9918', 0, 1, '1685746926', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `grafe_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('f7b3ccf66169c8e65a5c975b059e9918', 0, 1, '1685746926', 0, '')

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.19 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.01 ms

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: 1.18 ms After last query: 3.25 ms Query memory: 0.004 MB Memory before query: 2.782 MB Rows returned: 39

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

  FROM `grafe_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_extensions	ref	extension	extension	82	const	39	100.00	Using index condition

Profile

Status	Duration
starting	0.13 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.23 ms
preparing	0.08 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

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.17 ms After last query: 1.63 ms Query memory: 0.005 MB Memory before query: 2.983 MB Rows returned: 1

SELECT b.id

  FROM grafe_usergroups AS a

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

  WHERE a.id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	22.22	Using where; Using index

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.09 ms
cleaning up	0.03 ms

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.17 ms After last query: 0.62 ms Query memory: 0.005 MB Memory before query: 3.028 MB Rows returned: 5

SELECT id, rules

  FROM `grafe_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.08 ms
cleaning up	0.01 ms

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.25 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 3.036 MB Rows returned: 74

SELECT folder AS type, element AS name, params

  FROM grafe_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_extensions	ref	extension	extension	82	const	102	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.65 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.03 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.04 ms

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: 1.12 ms After last query: 15.76 ms Query memory: 0.005 MB Memory before query: 4.575 MB Rows returned: 1

SELECT `enabled`

  FROM `grafe_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.22 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.33 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
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.25 ms After last query: 7.13 ms Query memory: 0.007 MB Memory before query: 5.145 MB Rows returned: 0

select email 
  from grafe_users 
  where id=0 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.14 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.14 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:246
12	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:253
11	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:23
10	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:197
9	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:367
8	plgSystembfstop->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.29 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 5.153 MB Rows returned: 0

SELECT id, ipaddress 
  from grafe_bfstop_whitelist 
  WHERE (ipaddress='3.227.251.94' 
  AND LOCATE('/', ipaddress) = 0)

Explain

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

Profile

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.06 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.13 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:189
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->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.33 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 5.159 MB Rows returned: 0

SELECT id, ipaddress 
  from grafe_bfstop_whitelist 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('3.227.251.94') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))

Explain

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

Profile

Status	Duration
starting	0.14 ms
Waiting for query cache lock	0.04 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:190
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->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.81 ms After last query: 0.06 ms Query memory: 0.006 MB Memory before query: 5.166 MB Rows returned: 0

SELECT id, ipaddress, crdate, duration 
  FROM grafe_bfstop_bannedip b 
  WHERE (ipaddress='3.227.251.94' 
  AND LOCATE('/', ipaddress) = 0) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2023-06-02 23:02:06') 
  AND NOT EXISTS (SELECT 1 
  FROM grafe_bfstop_unblock u 
  WHERE b.id = u.block_id)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
2	DEPENDENT SUBQUERY	u	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.b.id	1	100.00	Using index

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.16 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:179
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->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.65 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 5.172 MB Rows returned: 0

SELECT id, ipaddress, crdate, duration 
  FROM grafe_bfstop_bannedip b 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('3.227.251.94') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2023-06-02 23:02:06') 
  AND NOT EXISTS (SELECT 1 
  FROM grafe_bfstop_unblock u 
  WHERE b.id = u.block_id)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
2	DEPENDENT SUBQUERY	u	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.b.id	1	100.00	Using index

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.08 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:180
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->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.16 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 5.178 MB Rows returned: 0

SELECT `state`,`rule_type`

  FROM `grafe_jhackguard_ip_filters`

  WHERE `ip` = '3.227.251.94' 
  AND `state` = 1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
9	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
8	PlgSystemJhackguard->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.41 ms After last query: 3.73 ms Query memory: 0.007 MB Memory before query: 5.532 MB Rows returned: 24

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

  LEFT JOIN grafe_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	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	239	83.26	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.13 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.16 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.04 ms
Sending data	0.02 ms
Creating sort index	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

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: 0.98 ms After last query: 7.52 ms Query memory: 0.006 MB Memory before query: 6.088 MB Rows returned: 1

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

  FROM `grafe_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.13 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.24 ms
preparing	0.12 ms
executing	0.05 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
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: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.14 ms Query memory: 0.005 MB Memory before query: 6.081 MB

UPDATE `grafe_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.13 ms
updating	0.16 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.20 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
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: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: 1.86 ms Query memory: 0.003 MB Memory before query: 6.225 MB Rows returned: 1

SELECT *

  FROM grafe_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
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.87 ms After last query: 0.19 ms Query memory: 0.003 MB Memory before query: 6.297 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM grafe_template_styles as s

  LEFT JOIN grafe_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	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	belodan2_grafe.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.08 ms
Waiting for query cache lock	0.03 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.11 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
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.48 ms After last query: 13.75 ms Query memory: 0.009 MB Memory before query: 7.708 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `grafe_assets`

Explain

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

Profile

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

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/libraries/joomla/table/asset.php:60
14	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
9	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
8	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.24 ms After last query: 0.57 ms Query memory: 0.007 MB Memory before query: 7.748 MB Rows returned: 1

SELECT *

  FROM grafe_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/libraries/joomla/access/access.php:697
12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
9	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
8	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.16 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 7.753 MB Rows returned: 1

Duplicate queries: #30

SELECT a.rules

  FROM grafe_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	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.08 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
9	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
8	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.78 ms After last query: 0.60 ms Query memory: 0.007 MB Memory before query: 7.777 MB Rows returned: 39

SELECT element

  FROM grafe_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.12 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.07 ms
cleaning up	0.01 ms

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:413
13	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
12	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
9	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
8	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.09 ms Query memory: 0.007 MB Memory before query: 7.790 MB Rows returned: 39

SELECT a.name, a.rules

  FROM grafe_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_akeeba','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jhackguard','com_joomlaupdate','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_sppagebuilder','com_spsimpleportfolio','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper') OR a.name = 'root.1')

Explain

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

Profile

Status	Duration
starting	0.19 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.15 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
13	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
12	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
9	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
8	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.34 ms After last query: 1.80 ms Query memory: 0.005 MB Memory before query: 8.075 MB Rows returned: 1

SHOW TABLES LIKE "grafe_virtuemart_configs"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:499
8	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:796
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.21 ms After last query: 0.04 ms Query memory: 0.005 MB Memory before query: 8.080 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:848
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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: 4.69 ms After last query: 23.96 ms Query memory: 0.006 MB Memory before query: 9.026 MB Rows returned: 1

SELECT `grafe_virtuemart_vendors`.* ,`grafe_virtuemart_vendors_en_gb`.*  
  FROM `grafe_virtuemart_vendors` 
  INNER JOIN `grafe_virtuemart_vendors_en_gb` using (`virtuemart_vendor_id`) 
  WHERE `grafe_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

Explain

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

Profile

Status	Duration
starting	0.19 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.50 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.11 ms
optimizing	0.03 ms
statistics	0.26 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.10 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:86
10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:39
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.72 ms After last query: 5.80 ms Query memory: 0.006 MB Memory before query: 9.098 MB Rows returned: 0

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_vendor_medias` 
  WHERE `virtuemart_vendor_id` = "1" 
  ORDER BY `ordering`

Explain

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

Profile

Status	Duration
starting	0.27 ms
Waiting for query cache lock	0.06 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	1.82 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.09 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.07 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:97
10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:39
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.16 ms Query memory: 0.007 MB Memory before query: 9.104 MB Rows returned: 1

SELECT id

  FROM grafe_assets

  WHERE parent_id = 0

Explain

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

Profile

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.15 ms
cleaning up	0.01 ms

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:1261
11	vmAccess::manager()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:95
10	shopFunctionsF::isFEmanager()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:61
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.22 ms After last query: 0.12 ms Query memory: 0.007 MB Memory before query: 9.113 MB Rows returned: 1

Duplicate queries: #22

SELECT a.rules

  FROM grafe_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	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.03 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.14 ms
cleaning up	0.01 ms

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:1261
11	vmAccess::manager()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:95
10	shopFunctionsF::isFEmanager()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:61
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.41 ms After last query: 9.56 ms Query memory: 0.007 MB Memory before query: 9.870 MB Rows returned: 8

SELECT l.*
					
  FROM `grafe_virtuemart_categories_en_gb` as l
					
  INNER JOIN `grafe_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `grafe_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 0  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY c.ordering,category_name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cx	ref	category_parent_id,category_child_id	category_parent_id	4	const	7	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.cx.category_child_id	1	100.00	NULL
1	SIMPLE	c	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	belodan2_grafe.cx.category_child_id	1	100.00	Using where

Profile

Status	Duration
starting	0.17 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.34 ms
preparing	0.12 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.04 ms
Sending data	0.32 ms
Creating sort index	0.49 ms
end	0.01 ms
removing tmp table	0.15 ms
end	0.14 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.11 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.07 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:234
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.99 ms After last query: 0.33 ms Query memory: 0.007 MB Memory before query: 9.905 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "8" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.03 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.15 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.05 ms After last query: 0.10 ms Query memory: 0.009 MB Memory before query: 9.919 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "15" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.15 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.07 ms
freeing items	0.15 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.89 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 9.928 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "9" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.15 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.76 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 9.936 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "10" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.15 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.25 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 9.943 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "11" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.16 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.14 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.07 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 9.951 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "12" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.14 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.15 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.76 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 9.959 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "13" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.04 ms
Waiting for query cache lock	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.14 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
Waiting for query cache lock	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.95 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 9.966 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `grafe_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "14" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.26 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:240
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:77
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.96 ms After last query: 1.74 ms Query memory: 0.007 MB Memory before query: 10.052 MB Rows returned: 1

SELECT `grafe_virtuemart_medias`.*  
  FROM `grafe_virtuemart_medias`  
  WHERE `grafe_virtuemart_medias`.`virtuemart_media_id` = "421"

Explain

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

Profile

Status	Duration
starting	0.29 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.18 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:79
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.59 ms After last query: 0.42 ms Query memory: 0.007 MB Memory before query: 10.072 MB Rows returned: 1

SELECT `grafe_virtuemart_medias`.*  
  FROM `grafe_virtuemart_medias`  
  WHERE `grafe_virtuemart_medias`.`virtuemart_media_id` = "574"

Explain

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

Profile

Status	Duration
starting	0.17 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:79
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.64 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 10.085 MB Rows returned: 1

SELECT `grafe_virtuemart_medias`.*  
  FROM `grafe_virtuemart_medias`  
  WHERE `grafe_virtuemart_medias`.`virtuemart_media_id` = "424"

Explain

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

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.12 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:79
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.21 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 10.098 MB Rows returned: 1

SELECT `grafe_virtuemart_medias`.*  
  FROM `grafe_virtuemart_medias`  
  WHERE `grafe_virtuemart_medias`.`virtuemart_media_id` = "423"

Explain

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

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.03 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:79
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.31 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 10.112 MB Rows returned: 1

SELECT `grafe_virtuemart_medias`.*  
  FROM `grafe_virtuemart_medias`  
  WHERE `grafe_virtuemart_medias`.`virtuemart_media_id` = "419"

Explain

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

Profile

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.11 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:79
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.68 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 10.125 MB Rows returned: 1

SELECT `grafe_virtuemart_medias`.*  
  FROM `grafe_virtuemart_medias`  
  WHERE `grafe_virtuemart_medias`.`virtuemart_media_id` = "420"

Explain

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

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.16 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:79
9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:59
8	VirtueMartControllerVirtuemart->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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: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.74 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 10.138 MB Rows returned: 1