{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713303671,
                "last": 1713303671,
                "now": 1713303671
            }
        },
        "registry": {
            "com_virtuemart": {
                "productdetails": {
                    "limit": "int",
                    "limitstart": 0
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 705,
        "vmlastvisitedcategoryid": 10,
        "vmlastvisitedproductids": [
            51
        ]
    }
}

Time

Memory

86 Queries Logged 57.44 ms

1. Query Time: 1.12 ms Query memory: 0.022 MB Memory before query: 2.518 MB Rows returned: 0

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

   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.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.03 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Executing	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.08 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.30 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/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: 1.15 ms After last query: 2.00 ms Query memory: 0.003 MB Memory before query: 2.644 MB

   DELETE 
   
     FROM `grafe_session`
   
     WHERE `time` < '1713302771'

   Explain

   EXPLAIN not possible on query: DELETE FROM `grafe_session` WHERE `time` < '1713302771'

   Profile

   Status	Duration
   Starting	0.35 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.17 ms
   Updating	0.34 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.02 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

3. Query Time: 0.79 ms After last query: 0.06 ms Query memory: 0.019 MB Memory before query: 2.649 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `grafe_session`
   
     WHERE `session_id` = 'a0f0f6c2b955d4b912b4ee03fe7ef1c6' 
     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.16 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.02 ms
   Optimizing	0.02 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.08 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
   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.]

   ---

4. Query Time: 1.03 ms After last query: 0.07 ms Query memory: 0.003 MB Memory before query: 2.653 MB

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.32 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.02 ms
   Update	0.23 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.18 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.02 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.]

   ---

5. Query Time: 0.25 ms After last query: 2.43 ms Query memory: 0.023 MB Memory before query: 2.827 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.12 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.02 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.12 ms
   Updating status	0.01 ms
   Reset for next command	0.09 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.]

   ---

6. Query Time: 0.21 ms After last query: 1.56 ms Query memory: 0.021 MB Memory before query: 3.021 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.11 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.11 ms
   Updating status	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.]

   ---

7. Query Time: 0.20 ms After last query: 0.58 ms Query memory: 0.021 MB Memory before query: 3.066 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.11 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.10 ms
   Updating status	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.]

   ---

8. Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.074 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.10 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.12 ms
   Updating status	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.]

   ---

9. Query Time: 0.23 ms After last query: 14.98 ms Query memory: 0.021 MB Memory before query: 4.606 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.12 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.10 ms
   Updating status	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.]

   ---

10. Query Time: 0.22 ms After last query: 6.69 ms Query memory: 0.022 MB Memory before query: 5.176 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.12 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.11 ms
    Updating status	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.]

    ---

11. Query Time: 0.20 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 5.183 MB Rows returned: 0

    SELECT id, ipaddress 
      from grafe_bfstop_whitelist 
      WHERE (ipaddress='3.19.31.73' 
      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.10 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.11 ms
    Updating status	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.]

    ---

12. Query Time: 0.24 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 5.189 MB Rows returned: 0

    SELECT id, ipaddress 
      from grafe_bfstop_whitelist 
      WHERE ((LOCATE('/', ipaddress) != 0 
      AND LOCATE('.', ipaddress) != 0 
      AND (INET_ATON('3.19.31.73') & ~((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.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.10 ms
    Updating status	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.]

    ---

13. Query Time: 1.57 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 5.196 MB Rows returned: 0

    SELECT id, ipaddress, crdate, duration 
      FROM grafe_bfstop_bannedip b 
      WHERE (ipaddress='3.19.31.73' 
      AND LOCATE('/', ipaddress) = 0) 
      AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-04-16 21:41:12') 
      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.10 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.16 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.03 ms
    init	0.09 ms
    Optimizing	0.28 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.04 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.12 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.29 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.16 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.]

    ---

14. Query Time: 1.19 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 5.202 MB Rows returned: 0

    SELECT id, ipaddress, crdate, duration 
      FROM grafe_bfstop_bannedip b 
      WHERE ((LOCATE('/', ipaddress) != 0 
      AND LOCATE('.', ipaddress) != 0 
      AND (INET_ATON('3.19.31.73') & ~((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-16 21:41:12') 
      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.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.17 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.08 ms
    Optimizing	0.08 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 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.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
    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.]

    ---

15. Query Time: 0.91 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 5.208 MB

    DELETE 
    
      FROM `grafe_jhackguard_ip_filters`
    
      WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) 
      AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

    Explain

    EXPLAIN not possible on query: DELETE FROM `grafe_jhackguard_ip_filters` WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

    Profile

    Status	Duration
    Starting	0.30 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
    init for update	0.04 ms
    Updating	0.04 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
    Waiting for query cache lock	0.01 ms
    Unlocking tables	0.21 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 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/joomla/database/database.php:33
    9	JDatabase->query()	JROOT/plugins/system/jhackguard/jhackguard.php:156
    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.]

    ---

16. Query Time: 0.65 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 5.215 MB Rows returned: 0

    SELECT `state`,`rule_type`
    
      FROM `grafe_jhackguard_ip_filters`
    
      WHERE `ip` = '3.19.31.73' 
      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.17 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.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.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.06 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.]

    ---

17. Query Time: 0.25 ms After last query: 3.61 ms Query memory: 0.047 MB Memory before query: 5.569 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.12 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.12 ms
    Updating status	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: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.]

    ---

18. Query Time: 2.18 ms After last query: 18.62 ms Query memory: 0.027 MB Memory before query: 7.353 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.23 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.80 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    checking permissions	0.12 ms
    closing tables	0.11 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.15 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.19 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.02 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.]

    ---

19. Query Time: 0.19 ms After last query: 0.62 ms Query memory: 0.025 MB Memory before query: 7.387 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.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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: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.]

    ---

20. Query Time: 0.27 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 7.394 MB Rows returned: 1
    Duplicate queries: #47

    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.19 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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.]

    ---

21. Query Time: 1.08 ms After last query: 0.60 ms Query memory: 0.026 MB Memory before query: 7.487 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.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 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.23 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.21 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.10 ms
    Waiting for query cache lock	0.10 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.]

    ---

22. Query Time: 0.29 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 7.502 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.09 ms
    Waiting for query cache lock	0.02 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.11 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	0.07 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.]

    ---

23. Query Time: 1.34 ms After last query: 2.00 ms Query memory: 0.022 MB Memory before query: 7.790 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.12 ms
    checking permissions	0.01 ms
    Opening tables	0.14 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	0.77 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.09 ms
    Updating status	0.02 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.]

    ---

24. Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 7.796 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.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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.]

    ---

25. Query Time: 0.25 ms After last query: 0.48 ms Query memory: 0.026 MB Memory before query: 7.848 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.13 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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.]

    ---

26. Query Time: 1.04 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 7.881 MB Rows returned: 1

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

    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.01 ms
    Checking query cache for query	0.17 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.28 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.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.11 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.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
    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.]

    ---

27. Query Time: 0.23 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 7.887 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.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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.]

    ---

28. Query Time: 1.03 ms After last query: 0.58 ms Query memory: 0.022 MB Memory before query: 7.924 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.09 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.02 ms
    Optimizing	0.02 ms
    Statistics	0.46 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 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.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
    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.]

    ---

29. Query Time: 1.08 ms After last query: 0.16 ms Query memory: 0.005 MB Memory before query: 7.915 MB

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.12 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.09 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.34 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.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.]

    ---

30. Query Time: 0.21 ms After last query: 2.15 ms Query memory: 0.019 MB Memory before query: 8.056 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.10 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	0.01 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.]

    ---

31. Query Time: 1.14 ms After last query: 0.27 ms Query memory: 0.034 MB Memory before query: 8.065 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.13 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 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.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.16 ms
    Statistics	0.21 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.04 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.18 ms
    Reset for next command	0.01 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.]

    ---

32. Query Time: 0.36 ms After last query: 23.37 ms Query memory: 0.024 MB Memory before query: 9.823 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.21 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	0.01 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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.30 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 9.858 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.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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: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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 1.19 ms After last query: 0.94 ms Query memory: 0.023 MB Memory before query: 9.924 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` = "51"

    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.09 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.08 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.12 ms
    Optimizing	0.05 ms
    Statistics	0.12 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.20 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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.93 ms After last query: 0.78 ms Query memory: 0.022 MB Memory before query: 9.991 MB Rows returned: 2

    SELECT `virtuemart_media_id` 
      FROM `grafe_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "51" 
      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	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.15 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.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.28 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.20 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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.58 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 10.015 MB Rows returned: 0

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

    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.09 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.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.14 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.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
    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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.90 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 10.020 MB Rows returned: 1

    SELECT * 
      FROM `grafe_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "51"  
      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-16 21:41:12" )
    		        
      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-16 21:41:12" ) ) 
      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.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 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.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.13 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.04 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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.52 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 10.041 MB Rows returned: 0

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

    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.10 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.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.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.06 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:1185
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.82 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 10.048 MB Rows returned: 1

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

    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.18 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.08 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.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.19 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: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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.88 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 10.098 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.08 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.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.04 ms
    Optimizing	0.02 ms
    Statistics	0.28 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 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.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.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
    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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.60 ms After last query: 2.48 ms Query memory: 0.023 MB Memory before query: 10.280 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 (51) 
      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.10 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.04 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.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.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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.21 ms After last query: 4.15 ms Query memory: 0.025 MB Memory before query: 10.699 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.10 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.07 ms
    Updating status	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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.38 ms After last query: 0.93 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.12 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.11 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
    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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 1.87 ms After last query: 4.80 ms Query memory: 0.035 MB Memory before query: 11.149 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.17 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.84 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.03 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    checking permissions	0.27 ms
    closing tables	0.02 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.00 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.07 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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.17 ms After last query: 0.42 ms Query memory: 0.037 MB Memory before query: 11.187 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.01 ms
    checking privileges on cached	0.01 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
    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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.14 ms After last query: 0.19 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.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.06 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/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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.13 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 11.251 MB Rows returned: 1
    Duplicate queries: #20

    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.06 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.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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.17 ms After last query: 0.16 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.09 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.07 ms
    Updating status	0.01 ms
    Reset for next command	0.00 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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.22 ms After last query: 1.59 ms Query memory: 0.096 MB Memory before query: 11.454 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.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.09 ms
    Updating status	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/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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.22 ms After last query: 2.37 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.12 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.07 ms
    Updating status	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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.93 ms After last query: 2.38 ms Query memory: 0.023 MB Memory before query: 11.905 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-16 21:41:12" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-16 21:41:12" )
     
      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.08 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.05 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.10 ms
    Optimizing	0.05 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Executing	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.17 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.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
    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/productdetails/view.html.php:83
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.88 ms After last query: 1.43 ms Query memory: 0.023 MB Memory before query: 12.025 MB Rows returned: 1

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

    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.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.17 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.14 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.07 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.00 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.08 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.00 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
    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/productdetails/view.html.php:144
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.46 ms After last query: 0.40 ms Query memory: 0.023 MB Memory before query: 12.044 MB Rows returned: 1

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

    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.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.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 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.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.01 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
    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/productdetails/view.html.php:144
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 1.88 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 12.057 MB Rows returned: 1

    SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
      FROM `grafe_virtuemart_products` as p 
      INNER JOIN `grafe_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) 
      LEFT JOIN `grafe_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
      LEFT JOIN `grafe_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
      WHERE ( `pc`.`virtuemart_category_id` = 10 
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
      AND p.`virtuemart_product_id`!="51"  
      AND `pc`.ordering <= "0"  
      ORDER BY `pc`.`ordering` DESC, `product_name` DESC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ps	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
    1	SIMPLE	pc	range	virtuemart_product_id,ordering	ordering	4	NULL	49	Using index condition; Using where
    1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	belodan2_grafe.pc.virtuemart_product_id	1	Using index condition; Using where
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.pc.virtuemart_product_id	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.08 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.07 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Creating tmp table	0.07 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.73 ms
    Creating sort index	0.17 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.01 ms
    End of update loop	0.12 ms
    Query end	0.01 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.03 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.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1648
    10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:161
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 1.10 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 12.064 MB Rows returned: 1

    SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
      FROM `grafe_virtuemart_products` as p 
      INNER JOIN `grafe_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) 
      LEFT JOIN `grafe_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
      LEFT JOIN `grafe_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
      WHERE ( `pc`.`virtuemart_category_id` = 10 
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
      AND p.`virtuemart_product_id`!="51" 
      AND p.`virtuemart_product_id`!="49" 
      AND `pc`.ordering >= "0"  
      ORDER BY `pc`.`ordering` ASC, `product_name` ASC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ps	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
    1	SIMPLE	pc	range	virtuemart_product_id,ordering	ordering	4	NULL	62	Using index condition; Using where
    1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	belodan2_grafe.pc.virtuemart_product_id	1	Using index condition; Using where
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.pc.virtuemart_product_id	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.07 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.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.40 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.01 ms
    Creating sort index	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.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:1494
    11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1648
    10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:161
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.71 ms After last query: 1.58 ms Query memory: 0.022 MB Memory before query: 12.191 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.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.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.03 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.13 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.03 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.04 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
    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/productdetails/view.html.php:184
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.48 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 12.197 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.01 ms
    Optimizing	0.01 ms
    Statistics	0.06 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.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
    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/productdetails/view.html.php:184
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.65 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 12.204 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.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.05 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.15 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.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/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/productdetails/view.html.php:184
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.46 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 12.210 MB Rows returned: 1

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

    Explain

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

    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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 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
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 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.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
    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/productdetails/view.html.php:186
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.76 ms After last query: 1.99 ms Query memory: 0.023 MB Memory before query: 12.318 MB Rows returned: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cx	ref	category_parent_id,category_child_id	category_parent_id	4	const	1	Using index; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	belodan2_grafe.cx.category_child_id	1
    1	SIMPLE	c	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	belodan2_grafe.cx.category_child_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.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.04 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Creating tmp table	0.07 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.10 ms
    Removing tmp table	0.01 ms
    Creating sort index	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.01 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:234
    13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:158
    10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:200
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 0.66 ms After last query: 0.52 ms Query memory: 0.022 MB Memory before query: 12.328 MB Rows returned: 0
    Duplicate queries: #63

    SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published` 
      FROM `grafe_virtuemart_rating_reviews` AS `pr`
    		
      LEFT JOIN `grafe_users` AS `u`	
      ON `pr`.`created_by` = `u`.`id`
    		
      LEFT JOIN `grafe_virtuemart_products_en_gb` AS `l` 
      ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id` 
    		
      LEFT JOIN `grafe_virtuemart_rating_votes` AS `rv` 
      on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` 
      and `rv`.`created_by`=`u`.`id`
     
      WHERE  `l`.`virtuemart_product_id` = "51" 
    
     
      ORDER BY created_on DESC 
      LIMIT 0, 24

    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.08 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.02 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Executing	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 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.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:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:843
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/ratings.php:168
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:244
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.35 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 12.334 MB Rows returned: 1

    SELECT FOUND_ROWS()

    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	No tables used

    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.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    Optimizing	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
    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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:853
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/ratings.php:168
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:244
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 12.341 MB Rows returned: 0
    Duplicate queries: #61

    SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published` 
      FROM `grafe_virtuemart_rating_reviews` AS `pr`
    		
      LEFT JOIN `grafe_users` AS `u`	
      ON `pr`.`created_by` = `u`.`id`
    		
      LEFT JOIN `grafe_virtuemart_products_en_gb` AS `l` 
      ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id` 
    		
      LEFT JOIN `grafe_virtuemart_rating_votes` AS `rv` 
      on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` 
      and `rv`.`created_by`=`u`.`id`
     
      WHERE  `l`.`virtuemart_product_id` = "51" 
    
     
      ORDER BY created_on DESC 
      LIMIT 0, 24

    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.06 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.10 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:870
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/ratings.php:168
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:244
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 1.14 ms After last query: 31.68 ms Query memory: 0.023 MB Memory before query: 14.521 MB Rows returned: 1

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
      FROM   `grafe_virtuemart_shipmentmethods` as i  
      LEFT JOIN `grafe_virtuemart_shipmentmethods_en_gb` as l using (`virtuemart_shipmentmethod_id`) 
     
      LEFT JOIN `grafe_extensions` as j 
      ON j.`extension_id` =  i.`shipment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `grafe_virtuemart_shipmentmethod_shoppergroups` AS s 
      ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
      WHERE i.`published` = "1" 
      AND j.`element` = "weight_countries"
    	    						
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
    	    						
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
      GROUP BY i.`virtuemart_shipmentmethod_id` 
      ORDER BY i.`ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	system	shipment_jplugin_id	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	s	system	virtuemart_shipmentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	l	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	j	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1

    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.13 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.15 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.07 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.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.20 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:530
    13	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:417
    12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:305
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 0.89 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 14.543 MB Rows returned: 0

    SELECT * 
      FROM grafe_virtuemart_calcs  
      LEFT JOIN grafe_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="DBTaxBill"
                    
      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-16 21:41:12" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-16 21:41:12" )
     
      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.10 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.04 ms
    After opening tables	0.11 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.04 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.18 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1310
    16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:705
    15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1514
    14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1611
    13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:434
    12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:305
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.71 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 14.558 MB Rows returned: 0

    SELECT * 
      FROM grafe_virtuemart_calcs  
      LEFT JOIN grafe_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="TaxBill"
                    
      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-16 21:41:12" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-16 21:41:12" )
     
      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.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 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.05 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.10 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.17 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1310
    16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:706
    15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1514
    14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1611
    13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:434
    12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:305
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.67 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 14.567 MB Rows returned: 0

    SELECT * 
      FROM grafe_virtuemart_calcs  
      LEFT JOIN grafe_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="DATaxBill"
                    
      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-16 21:41:12" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-16 21:41:12" )
     
      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.09 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.05 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.10 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.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1310
    16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:707
    15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1514
    14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1611
    13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:434
    12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:305
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.91 ms After last query: 6.60 ms Query memory: 0.027 MB Memory before query: 14.891 MB Rows returned: 0
    Duplicate queries: #82

    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.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.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.22 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 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.12 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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
    22	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
    21	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
    20	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:175
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:160
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

69. Query Time: 1.05 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 14.902 MB Rows returned: 1
    Duplicate queries: #83

    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.09 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.55 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.00 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.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.03 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/components/com_virtuemart/router.php:1151
    22	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
    21	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
    20	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:175
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:160
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

70. Query Time: 1.29 ms After last query: 0.26 ms Query memory: 0.028 MB Memory before query: 14.925 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` = "49"

    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.09 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.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.05 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 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.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.63 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1162
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:184
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

71. Query Time: 0.69 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 14.944 MB Rows returned: 2

    SELECT `virtuemart_media_id` 
      FROM `grafe_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "49" 
      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	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.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.00 ms
    Sending data	0.01 ms
    Creating sort index	0.19 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.09 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.01 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:184
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

72. Query Time: 0.45 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 14.960 MB Rows returned: 0

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

    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.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.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.01 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.09 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.07 ms
    Updating status	0.01 ms
    Storing result in query cache	0.07 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1170
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:184
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

73. Query Time: 0.75 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 14.968 MB Rows returned: 1

    SELECT * 
      FROM `grafe_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "49"  
      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-16 21:41:12" )
    		        
      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-16 21:41:12" ) ) 
      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.09 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.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.08 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.07 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.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.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1014
    24	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1033
    23	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1182
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:184
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

74. Query Time: 0.72 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 14.982 MB Rows returned: 0

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

    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.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.03 ms
    Starting cleanup	0.05 ms
    Freeing items	0.09 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.21 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1185
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:184
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

75. Query Time: 0.67 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 14.993 MB Rows returned: 1

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

    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.21 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.04 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.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.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.11 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.04 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/models/product.php:1391
    23	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:184
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

76. Query Time: 0.80 ms After last query: 0.29 ms Query memory: 0.028 MB Memory before query: 15.028 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` = "43"

    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.09 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.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.07 ms
    Optimizing	0.03 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.04 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.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.00 ms
    Updating status	0.18 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1162
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:189
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

77. Query Time: 0.72 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 15.047 MB Rows returned: 2

    SELECT `virtuemart_media_id` 
      FROM `grafe_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "43" 
      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	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.15 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.17 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.09 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.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:189
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

78. Query Time: 0.39 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 15.063 MB Rows returned: 0

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

    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.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.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.01 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.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.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.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1170
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:189
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

79. Query Time: 0.60 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 15.072 MB Rows returned: 1

    SELECT * 
      FROM `grafe_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "43"  
      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-16 21:41:12" )
    		        
      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-16 21:41:12" ) ) 
      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.09 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.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.04 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.09 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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1014
    24	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1033
    23	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1182
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:189
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

80. Query Time: 0.49 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 15.085 MB Rows returned: 0

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

    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.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.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.01 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.09 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.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1185
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:189
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

81. Query Time: 0.48 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 15.096 MB Rows returned: 1

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

    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.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.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.00 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.09 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.05 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/models/product.php:1391
    23	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
    22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
    21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:883
    20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:188
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:189
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

82. Query Time: 0.17 ms After last query: 0.23 ms Query memory: 0.026 MB Memory before query: 15.111 MB Rows returned: 0
    Duplicate queries: #68

    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.09 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.09 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:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
    20	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:200
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

83. Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 15.122 MB Rows returned: 1
    Duplicate queries: #69

    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.09 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.09 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:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
    20	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php:200
    12	include JROOT/templates/shaper_tixon/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
    11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:339
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

84. Query Time: 1.90 ms After last query: 34.77 ms Query memory: 0.026 MB Memory before query: 17.012 MB Rows returned: 14

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM grafe_modules AS m
    
      LEFT JOIN grafe_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN grafe_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-16 21:41:12') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-16 21:41:12') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 705 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	51	Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	belodan2_grafe.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	belodan2_grafe.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.15 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.14 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.03 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.12 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.76 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.11 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.13 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:593
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:540
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:258
    8	Helix3::generatelayout()	JROOT/templates/shaper_tixon/index.php:162
    7	require JROOT/templates/shaper_tixon/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    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.]

    ---

85. Query Time: 0.42 ms After last query: 13.21 ms Query memory: 0.027 MB Memory before query: 17.853 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.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.10 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.20 ms
    Updating status	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/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.]

    ---

86. Query Time: 0.17 ms After last query: 1.22 ms Query memory: 0.020 MB Memory before query: 17.985 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.09 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.09 ms
    Updating status	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.]

    ---