{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713553146,
                "last": 1713553146,
                "now": 1713553146
            },
            "token": "WzMkTZDefba1Eva7Ed8rYlTUpMGIqArI"
        },
        "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,
        "vmlastvisitedcategoryid": 10
    }
}

Time

Memory

59 Queries Logged 49.50 ms

1. Query Time: 0.94 ms Query memory: 0.022 MB Memory before query: 2.519 MB Rows returned: 0

   SELECT `data`
   
     FROM `grafe_session`
   
     WHERE `session_id` = 'e933884355a34b747ca9b68018f16344'

   Explain

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

   Profile

   Status	Duration
   Starting	0.18 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.06 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.14 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.14 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 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.]

   ---

2. Query Time: 0.91 ms After last query: 2.19 ms Query memory: 0.019 MB Memory before query: 2.645 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `grafe_session`
   
     WHERE `session_id` = 'e933884355a34b747ca9b68018f16344' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   Starting	0.13 ms
   Waiting for query cache lock	0.09 ms
   starting	0.01 ms
   Checking query cache for query	0.15 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.15 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.11 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	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.]

   ---

3. Query Time: 0.77 ms After last query: 0.08 ms Query memory: 0.003 MB Memory before query: 2.650 MB

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.16 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.02 ms
   Update	0.22 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.16 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.01 ms
   Reset for next command	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.]

   ---

4. Query Time: 0.79 ms After last query: 2.72 ms Query memory: 0.023 MB Memory before query: 2.825 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	Extra
   1	SIMPLE	grafe_extensions	ref	extension	extension	82	const	39	Using index condition

   Profile

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.16 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.20 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.02 ms
   Storing result in query cache	0.01 ms
   Reset for next command	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.]

   ---

5. Query Time: 0.62 ms After last query: 1.57 ms Query memory: 0.021 MB Memory before query: 3.020 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	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

   Profile

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.13 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 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.]

   ---

6. Query Time: 0.44 ms After last query: 0.57 ms Query memory: 0.021 MB Memory before query: 3.065 MB Rows returned: 5

   SELECT id, rules
   
     FROM `grafe_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	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.]

   ---

7. Query Time: 0.95 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.073 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	Extra
   1	SIMPLE	grafe_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	213	Using where; Using filesort

   Profile

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.45 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 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.]

   ---

8. Query Time: 0.88 ms After last query: 15.07 ms Query memory: 0.020 MB Memory before query: 4.604 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	Extra
   1	SIMPLE	grafe_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.11 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.08 ms
   Preparing	0.07 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.08 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.29 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	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.]

   ---

9. Query Time: 0.52 ms After last query: 6.76 ms Query memory: 0.022 MB Memory before query: 5.174 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	Extra
   1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profile

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.03 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.05 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.01 ms
   Storing result in query cache	0.01 ms
   Reset for next command	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.]

   ---

10. Query Time: 0.47 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 5.182 MB Rows returned: 0

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	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.]

    ---

11. Query Time: 0.57 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 5.188 MB Rows returned: 0

    SELECT id, ipaddress 
      from grafe_bfstop_whitelist 
      WHERE ((LOCATE('/', ipaddress) != 0 
      AND LOCATE('.', ipaddress) != 0 
      AND (INET_ATON('18.116.239.195') & ~((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	Extra
    1	SIMPLE	grafe_bfstop_whitelist	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

    Profile

    Status	Duration
    Starting	0.06 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.08 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	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.]

    ---

12. Query Time: 0.65 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 5.195 MB Rows returned: 0

    SELECT id, ipaddress, crdate, duration 
      FROM grafe_bfstop_bannedip b 
      WHERE (ipaddress='18.116.239.195' 
      AND LOCATE('/', ipaddress) = 0) 
      AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-04-19 18:59: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	Extra
    1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    2	DEPENDENT SUBQUERY	u	unique_subquery	PRIMARY	PRIMARY	4	func	1	Using index

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.05 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.06 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.]

    ---

13. Query Time: 0.62 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 5.201 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('18.116.239.195') & ~((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) >= '2024-04-19 18:59: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	Extra
    1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    2	DEPENDENT SUBQUERY	u	unique_subquery	PRIMARY	PRIMARY	4	func	1	Using index

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	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: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.]

    ---

14. Query Time: 0.42 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 5.207 MB Rows returned: 0

    SELECT `state`,`rule_type`
    
      FROM `grafe_jhackguard_ip_filters`
    
      WHERE `ip` = '18.116.239.195' 
      AND `state` = 1
    
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	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.]

    ---

15. Query Time: 1.01 ms After last query: 4.07 ms Query memory: 0.047 MB Memory before query: 5.561 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	Extra
    1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	251	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.m.component_id	1	Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.37 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.04 ms
    Starting cleanup	0.03 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	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.]

    ---

16. Query Time: 1.62 ms After last query: 18.65 ms Query memory: 0.027 MB Memory before query: 7.345 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.16 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.46 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.07 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    checking permissions	0.09 ms
    closing tables	0.09 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.10 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.20 ms
    Updating status	0.14 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
    14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.87 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 7.381 MB Rows returned: 1

    SELECT *
    
      FROM grafe_assets
    
      WHERE `id` = '1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.35 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.09 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
    14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.95 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 7.389 MB Rows returned: 1
    Duplicate queries: #45

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

    Profile

    Status	Duration
    Starting	0.14 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.17 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.99 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.12 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.15 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
    14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.96 ms After last query: 0.58 ms Query memory: 0.026 MB Memory before query: 7.482 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	Extra
    1	SIMPLE	grafe_extensions	ref	extension	extension	82	const	39	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.23 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.12 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
    14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 1.32 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 7.497 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	Extra
    1	SIMPLE	a	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	168	Using where

    Profile

    Status	Duration
    Starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.24 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.40 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
    14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 2.25 ms After last query: 2.00 ms Query memory: 0.022 MB Memory before query: 7.784 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.13 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	1.52 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.16 ms
    Updating status	0.07 ms
    Reset for next command	0.01 ms

    Call Stack

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

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

    ---

22. Query Time: 0.64 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 7.791 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	Extra
    1	SIMPLE	grafe_virtuemart_configs	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

    Profile

    Status	Duration
    Starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

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

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

    ---

23. Query Time: 1.57 ms After last query: 0.47 ms Query memory: 0.026 MB Memory before query: 7.843 MB Rows returned: 9

    SELECT * 
      FROM `grafe_menu`  
      where `link` like "index.php?option=com_virtuemart%" 
      and client_id=0 
      and published=1 
      and (language="*" or language = "en-GB"  )

    Explain

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

    Profile

    Status	Duration
    Starting	0.16 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.25 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.64 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

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

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

    ---

24. Query Time: 0.73 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 7.875 MB Rows returned: 1

    SELECT p.`virtuemart_product_id`  
      FROM `grafe_virtuemart_products_en_gb` AS `p`  
      WHERE `slug` = "casual03"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	p	const	slug	slug	576	const	1

    Profile

    Status	Duration
    Starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.22 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

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

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

    ---

25. Query Time: 0.66 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 7.882 MB Rows returned: 0

    SELECT `virtuemart_category_id`
    				
      FROM  `grafe_virtuemart_categories_en_gb`
    				
      WHERE `slug` = ''

    Explain

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

    Profile

    Status	Duration
    Starting	0.14 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.14 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

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

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

    ---

26. Query Time: 0.79 ms After last query: 0.56 ms Query memory: 0.022 MB Memory before query: 7.919 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	Extra
    1	SIMPLE	grafe_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.13 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.18 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.06 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 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.]

    ---

27. Query Time: 0.81 ms After last query: 0.15 ms Query memory: 0.005 MB Memory before query: 7.910 MB

    UPDATE `grafe_extensions`
    
      SET `params` = '{\"mediaversion\":\"cc727dcbd5dc1781e152703cc5ea7886\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `grafe_extensions` SET `params` = '{\"mediaversion\":\"cc727dcbd5dc1781e152703cc5ea7886\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.08 ms
    Updating	0.14 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.01 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.21 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.02 ms
    Reset for next command	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.]

    ---

28. Query Time: 0.87 ms After last query: 2.00 ms Query memory: 0.019 MB Memory before query: 8.051 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	Extra
    1	SIMPLE	grafe_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.18 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.07 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.07 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.03 ms
    Reset for next command	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.]

    ---

29. Query Time: 0.89 ms After last query: 0.22 ms Query memory: 0.034 MB Memory before query: 8.060 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	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	belodan2_grafe.s.template,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.12 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	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.]

    ---

30. Query Time: 1.21 ms After last query: 71.19 ms Query memory: 0.024 MB Memory before query: 10.145 MB Rows returned: 1

    SELECT * 
      FROM `grafe_virtuemart_shoppergroups` 
      WHERE `default` = "2" 
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
      AND `published`="1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

    Profile

    Status	Duration
    Starting	0.12 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.30 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.11 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:119
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1137
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

31. Query Time: 0.62 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 10.173 MB Rows returned: 1

    SELECT `grafe_virtuemart_shoppergroups`.*  
      FROM `grafe_virtuemart_shoppergroups`  
      WHERE `grafe_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	2	const	1

    Profile

    Status	Duration
    Starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
    17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:124
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1137
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

32. Query Time: 0.88 ms After last query: 0.43 ms Query memory: 0.023 MB Memory before query: 10.200 MB Rows returned: 1

    SELECT `grafe_virtuemart_products`.* ,`grafe_virtuemart_products_en_gb`.*  
      FROM `grafe_virtuemart_products` 
      INNER JOIN `grafe_virtuemart_products_en_gb` using (`virtuemart_product_id`) 
      WHERE `grafe_virtuemart_products`.`virtuemart_product_id` = "42"

    Explain

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

    Profile

    Status	Duration
    Starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.09 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1162
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

33. Query Time: 1.36 ms After last query: 0.82 ms Query memory: 0.024 MB Memory before query: 10.274 MB Rows returned: 4

    SELECT `virtuemart_media_id` 
      FROM `grafe_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "42" 
      ORDER BY `ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	2	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.13 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.37 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.20 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.35 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

34. Query Time: 0.56 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 10.300 MB Rows returned: 0

    SELECT `virtuemart_shoppergroup_id` 
      FROM `grafe_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "42"

    Explain

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

    Profile

    Status	Duration
    Starting	0.13 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.14 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1170
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

35. Query Time: 0.81 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 10.305 MB Rows returned: 1

    SELECT * 
      FROM `grafe_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "42"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-04-19 18:59:06" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-19 18:59:06" ) ) 
      ORDER BY `product_price` DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_product_prices	ref	virtuemart_product_id,product_price,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.10 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.12 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.17 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1014
    13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1033
    12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1182
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

36. Query Time: 0.39 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 10.326 MB Rows returned: 0

    SELECT `virtuemart_manufacturer_id` 
      FROM `grafe_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "42"

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.07 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1185
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

37. Query Time: 0.74 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 10.333 MB Rows returned: 1

    SELECT * 
      FROM `grafe_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 42

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	1

    Profile

    Status	Duration
    Starting	0.14 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.11 ms
    Optimizing	0.01 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.09 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1391
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

38. Query Time: 0.72 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 10.346 MB Rows returned: 1

    SELECT `grafe_virtuemart_categories`.* ,`grafe_virtuemart_categories_en_gb`.*  
      FROM `grafe_virtuemart_categories` 
      INNER JOIN `grafe_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
      WHERE `grafe_virtuemart_categories`.`virtuemart_category_id` = "10"

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.20 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	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/product.php:1396
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

39. Query Time: 0.58 ms After last query: 2.36 ms Query memory: 0.023 MB Memory before query: 10.590 MB Rows returned: 0

    SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
    		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
    		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
    		
      FROM `grafe_virtuemart_customs` AS c 
      LEFT JOIN `grafe_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE `virtuemart_product_id` IN (42) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering`,`virtuemart_custom_id` ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
    12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2244
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

40. Query Time: 0.56 ms After last query: 1.08 ms Query memory: 0.025 MB Memory before query: 10.700 MB Rows returned: 1

    SELECT *  
      FROM `grafe_virtuemart_currencies` AS c
    			, `grafe_virtuemart_vendors` AS v
    			
      WHERE v.virtuemart_vendor_id = 1
    			
      AND   v.vendor_currency = c.virtuemart_currency_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v	system	PRIMARY,vendor_currency	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	2	const	1

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:256
    16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:49
    15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:98
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

41. Query Time: 0.45 ms After last query: 0.96 ms Query memory: 0.025 MB Memory before query: 10.771 MB Rows returned: 1

    SELECT `grafe_virtuemart_currencies`.*  
      FROM `grafe_virtuemart_currencies`  
      WHERE `grafe_virtuemart_currencies`.`virtuemart_currency_id` = "118"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_currencies	const	PRIMARY	PRIMARY	2	const	1

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
    15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:114
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

42. Query Time: 1.40 ms After last query: 4.87 ms Query memory: 0.035 MB Memory before query: 11.150 MB Rows returned: 31

    SHOW FULL COLUMNS  
      FROM `grafe_virtuemart_userfields`

    Explain

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

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.51 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    checking permissions	0.19 ms
    closing tables	0.06 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.13 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:647
    23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
    22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:204
    21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425
    20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387
    19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593
    18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
    17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545
    16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:248
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

43. Query Time: 1.12 ms After last query: 0.34 ms Query memory: 0.037 MB Memory before query: 11.188 MB Rows returned: 21

    SELECT * 
      FROM `grafe_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `account`=1 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type') = 0  
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.51 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.05 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
    18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:586
    17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:484
    16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

44. Query Time: 0.71 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 11.240 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	Extra
    1	SIMPLE	grafe_assets	ref	idx_parent_id	idx_parent_id	4	const	1	Using index

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.16 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
    20	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
    19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    18	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1261
    17	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:751
    16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

45. Query Time: 0.21 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 11.252 MB Rows returned: 1
    Duplicate queries: #18

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.07 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.07 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    20	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
    19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    18	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1261
    17	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:751
    16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

46. Query Time: 0.79 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 11.270 MB Rows returned: 2

    SELECT fieldtitle, fieldvalue 
      FROM grafe_virtuemart_userfield_values 
      WHERE virtuemart_userfield_id = 23 
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_userfield_values	ref	virtuemart_userfield_id	virtuemart_userfield_id	2	const	2	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.34 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.06 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
    17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:981
    16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

47. Query Time: 1.79 ms After last query: 1.53 ms Query memory: 0.096 MB Memory before query: 11.392 MB Rows returned: 246

    SELECT * 
      FROM `grafe_virtuemart_countries`
     
      WHERE `published` = 1
    
     
      ORDER BY country_name ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.13 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	1.01 ms
    Waiting for query cache lock	0.01 ms
    Creating sort index	0.20 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:843
    19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
    18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:154
    17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:811
    16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

48. Query Time: 0.90 ms After last query: 2.23 ms Query memory: 0.033 MB Memory before query: 11.786 MB Rows returned: 14

    SELECT * 
      FROM `grafe_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `shipment`=1 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.04 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.24 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
    18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:586
    17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:490
    16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

49. Query Time: 0.63 ms After last query: 2.24 ms Query memory: 0.023 MB Memory before query: 11.906 MB Rows returned: 0

    SELECT * 
      FROM grafe_virtuemart_calcs  
      LEFT JOIN grafe_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-04-19 18:59:06" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-19 18:59:06" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.15 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:179
    14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

50. Query Time: 0.61 ms After last query: 1.75 ms Query memory: 0.023 MB Memory before query: 12.026 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.06 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	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/askquestion/view.html.php:108
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

51. Query Time: 0.84 ms After last query: 0.60 ms Query memory: 0.022 MB Memory before query: 12.064 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	Extra
    1	SIMPLE	grafe_virtuemart_category_medias	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.32 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 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/category.php:73
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

52. Query Time: 0.48 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 12.070 MB Rows returned: 0

    SELECT `category_child_id`
    			
      FROM `grafe_virtuemart_category_categories`
    			
      WHERE `category_parent_id` = 10

    Explain

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

    Profile

    Status	Duration
    Starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:663
    11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:84
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

53. Query Time: 0.71 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 12.077 MB Rows returned: 1

    SELECT count(grafe_virtuemart_products.virtuemart_product_id) AS total
    			
      FROM `grafe_virtuemart_products`, `grafe_virtuemart_product_categories`
    			
      WHERE `grafe_virtuemart_products`.`virtuemart_vendor_id` = "1"
    			
      AND `grafe_virtuemart_product_categories`.`virtuemart_category_id` = 10
    			
      AND `grafe_virtuemart_products`.`virtuemart_product_id` = `grafe_virtuemart_product_categories`.`virtuemart_product_id`
    			
      AND `grafe_virtuemart_products`.`published` = "1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_virtuemart_product_categories	index	virtuemart_product_id	virtuemart_product_id	8	NULL	62	Using where; Using index
    1	SIMPLE	grafe_virtuemart_products	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	belodan2_grafe.grafe_virtuemart_product_categories.virtuemart_product_id	1	Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.16 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:389
    11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:91
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

54. Query Time: 0.69 ms After last query: 0.42 ms Query memory: 0.025 MB Memory before query: 12.094 MB Rows returned: 0
    Duplicate queries: #56

    SELECT * 
      FROM `grafe_menu` 
      WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=10&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
      and published = "1" 
      and `language` = "en-GB"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.05 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
    19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
    18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
    17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
    16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    12	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    10	JRoute::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:123
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

55. Query Time: 1.24 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 12.104 MB Rows returned: 1
    Duplicate queries: #57

    SELECT * 
      FROM `grafe_menu` 
      WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=10&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
      and published = "1" 
      and `language` = "*"

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.60 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.10 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.06 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
    19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
    18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
    17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
    16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    12	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    10	JRoute::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:123
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

56. Query Time: 0.17 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 12.114 MB Rows returned: 0
    Duplicate queries: #54

    SELECT * 
      FROM `grafe_menu` 
      WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=10&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
      and published = "1" 
      and `language` = "en-GB"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	grafe_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 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
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
    17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
    16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    12	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    10	JRoute::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:123
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

57. Query Time: 0.21 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 12.124 MB Rows returned: 1
    Duplicate queries: #55

    SELECT * 
      FROM `grafe_menu` 
      WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=10&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
      and published = "1" 
      and `language` = "*"

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.04 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.11 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
    17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
    16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    12	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    10	JRoute::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:123
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
    8	VirtueMartControllerProductdetails->MailForm()	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.]

    ---

58. Query Time: 0.89 ms After last query: 84.05 ms Query memory: 0.027 MB Memory before query: 13.096 MB Rows returned: 127

    SELECT * 
      FROM grafe_acymailing_config

    Explain

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

    Profile

    Status	Duration
    Starting	0.12 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.06 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.07 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.11 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:454
    9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1127
    8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.80 ms After last query: 1.48 ms Query memory: 0.020 MB Memory before query: 13.232 MB Rows returned: 0

    SELECT `name`,`regex`,`replacement`
    
      FROM `grafe_jhackguard_output_filters`
    
      WHERE `state` = 1
    
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.08 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.13 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.23 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jhackguard/jhackguard.php:91
    7	PlgSystemJhackguard->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---