{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1544859741,
                "last": 1544859741,
                "now": 1544859741
            },
            "client": {
                "forwarded": "52.91.185.49"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Time

Memory

94 Queries Logged 60.74 ms

1. Query Time: 0.73 ms Query memory: 0.024 MB Memory before query: 1.205 MB Rows returned: 0

   SELECT `data`
   
     FROM `hvg4j_session`
   
     WHERE `session_id` = 'jt7nhrd33627n0qogovbg902me'

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.06 ms
   checking permissions	0.01 ms
   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.05 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.15 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.01 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.55 ms After last query: 1.35 ms Query memory: 0.022 MB Memory before query: 1.284 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `hvg4j_session`
   
     WHERE `session_id` = 'jt7nhrd33627n0qogovbg902me' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Waiting for query cache lock	0.05 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.05 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.01 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 3.01 ms After last query: 0.25 ms Query memory: 0.004 MB Memory before query: 1.289 MB

   INSERT INTO `hvg4j_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('jt7nhrd33627n0qogovbg902me', 1, '1544859741', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `hvg4j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('jt7nhrd33627n0qogovbg902me', 1, '1544859741', 0, '', 0)

   Profile

   Status	Duration
   starting	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
   init	0.02 ms
   update	0.14 ms
   Waiting for query cache lock	0.01 ms
   update	0.03 ms
   end	0.01 ms
   query end	2.43 ms
   closing tables	0.03 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.08 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 2.26 ms After last query: 2.09 ms Query memory: 0.042 MB Memory before query: 1.324 MB Rows returned: 50

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `hvg4j_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.09 ms
   checking permissions	0.02 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.05 ms
   init	0.05 ms
   optimizing	0.05 ms
   statistics	0.15 ms
   preparing	0.07 ms
   executing	0.01 ms
   Sending data	1.00 ms
   Waiting for query cache lock	0.02 ms
   Sending data	0.26 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   freeing items	0.03 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
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:425
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:433
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:499
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.39 ms After last query: 2.49 ms Query memory: 0.023 MB Memory before query: 1.386 MB Rows returned: 19
   Duplicate queries: #12

   SELECT id, rules
   
     FROM `hvg4j_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->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.28 ms After last query: 0.44 ms Query memory: 0.023 MB Memory before query: 1.403 MB Rows returned: 3

   SELECT b.id
   
     FROM hvg4j_usergroups AS a
   
     LEFT JOIN hvg4j_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 3.92 ms After last query: 0.82 ms Query memory: 0.034 MB Memory before query: 1.425 MB Rows returned: 89

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM hvg4j_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,2,5,8)
   
     ORDER BY ordering

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Waiting for query cache lock	0.13 ms
   init	0.01 ms
   checking query cache for query	0.14 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Waiting for query cache lock	0.10 ms
   init	0.07 ms
   optimizing	0.06 ms
   statistics	0.14 ms
   preparing	0.09 ms
   executing	0.01 ms
   Sorting result	1.78 ms
   Sending data	0.70 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.01 ms
   Unlocking tables	0.03 ms
   freeing items	0.03 ms
   updating status	0.02 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.03 ms
   Waiting for query cache lock	0.01 ms
   updating status	0.01 ms
   storing result in query cache	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->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.34 ms After last query: 19.35 ms Query memory: 0.026 MB Memory before query: 1.926 MB Rows returned: 2

   SELECT *
   
     FROM hvg4j_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->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.87 ms After last query: 0.33 ms Query memory: 0.024 MB Memory before query: 1.937 MB Rows returned: 4

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `hvg4j_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.12 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.05 ms
   init	0.05 ms
   optimizing	0.04 ms
   statistics	0.11 ms
   preparing	0.05 ms
   executing	0.01 ms
   Sending data	0.14 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 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
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->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.32 ms After last query: 17.85 ms Query memory: 0.026 MB Memory before query: 2.045 MB Rows returned: 1

    SELECT * 
      FROM hvg4j_virtualdomain
    				
      WHERE `domain` = 'bc-acoustique.com' 
      AND published > 0

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/virtualdomains/virtualdomains.php:373
    9	plgSystemVirtualdomains->getCurrentDomain()	JROOT/plugins/system/virtualdomains/virtualdomains.php:106
    8	plgSystemVirtualdomains->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 5.32 ms After last query: 0.74 ms Query memory: 0.298 MB Memory before query: 2.088 MB Rows returned: 272

    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 hvg4j_menu AS m
    
      LEFT JOIN hvg4j_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	439	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bcdiff.m.component_id	1	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.13 ms
    checking permissions	0.01 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.06 ms
    init	0.10 ms
    optimizing	0.04 ms
    statistics	0.11 ms
    preparing	0.07 ms
    executing	0.01 ms
    Sorting result	0.64 ms
    Sending data	0.36 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.29 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.28 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.31 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.28 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.26 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.27 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.37 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.37 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.23 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.24 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.23 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.09 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    19	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    16	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    15	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    14	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    13	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
    12	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    11	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/plugins/system/virtualdomains/virtualdomains.php:221
    10	plgSystemVirtualdomains->checkHome()	JROOT/plugins/system/virtualdomains/virtualdomains.php:396
    9	plgSystemVirtualdomains->getCurrentDomain()	JROOT/plugins/system/virtualdomains/virtualdomains.php:106
    8	plgSystemVirtualdomains->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.34 ms After last query: 15.65 ms Query memory: 0.024 MB Memory before query: 3.250 MB Rows returned: 19
    Duplicate queries: #5

    SELECT id, rules
    
      FROM `hvg4j_viewlevels`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/virtualdomains/virtualdomains.php:791
    9	vdJAccess::addAuthorisedViewLevels()	JROOT/plugins/system/virtualdomains/virtualdomains.php:120
    8	plgSystemVirtualdomains->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.18 ms After last query: 0.43 ms Query memory: 0.023 MB Memory before query: 3.254 MB Rows returned: 0

    Select * 
      From hvg4j_virtualdomain_params 
      Where 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/virtualdomains/virtualdomains.php:549
    9	plgSystemVirtualdomains->setActions()	JROOT/plugins/system/virtualdomains/virtualdomains.php:137
    8	plgSystemVirtualdomains->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.10 ms After last query: 9.44 ms Query memory: 0.025 MB Memory before query: 2.813 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `hvg4j_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Waiting for query cache lock	0.06 ms
    init	0.05 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.05 ms
    executing	0.02 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 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.10 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 3.07 ms After last query: 0.38 ms Query memory: 0.005 MB Memory before query: 2.803 MB

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

    Explain

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

    Profile

    Status	Duration
    starting	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
    init	0.10 ms
    updating	0.12 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.40 ms
    query end	2.14 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 1.06 ms After last query: 1.57 ms Query memory: 0.021 MB Memory before query: 2.831 MB Rows returned: 5

    SELECT id, home, template, s.params
    
      FROM hvg4j_template_styles as s
    
      LEFT JOIN hvg4j_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	7	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	bcdiff.s.template,const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.05 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.14 ms
    preparing	0.07 ms
    executing	0.01 ms
    Sending data	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.04 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.21 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 9.42 ms After last query: 4.48 ms Query memory: 0.314 MB Memory before query: 2.982 MB Rows returned: 56

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM hvg4j_modules AS m
    
      LEFT JOIN hvg4j_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN hvg4j_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 <= '2018-12-15 07:42:21') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-12-15 07:42:21') 
      AND m.access IN (1,1,2,5,8,34) 
      AND m.client_id = 0 
      AND (mm.menuid = 261 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	141	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	bcdiff.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bcdiff.m.id	2	Using where; Using index

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.22 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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.06 ms
    init	0.11 ms
    optimizing	0.08 ms
    statistics	0.27 ms
    preparing	0.13 ms
    executing	0.01 ms
    Sorting result	2.04 ms
    Sending data	0.23 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.14 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.07 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.09 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.08 ms
    Waiting for query cache lock	0.02 ms
    Sending data	0.14 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.15 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.50 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.84 ms
    Waiting for query cache lock	0.02 ms
    Sending data	0.53 ms
    Waiting for query cache lock	0.01 ms
    Sending data	2.75 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.25 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.04 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.03 ms
    storing result in query cache	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:16
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.63 ms After last query: 2.98 ms Query memory: 0.027 MB Memory before query: 3.446 MB Rows returned: 1

    SHOW TABLES LIKE "hvg4j_virtuemart_configs"

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.06 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.03 ms
    preparing	0.03 ms
    executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	1.04 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701
    18	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:569
    17	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:930
    16	VmConfig::loadConfig()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:24
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.22 ms After last query: 0.17 ms Query memory: 0.027 MB Memory before query: 3.456 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:978
    16	VmConfig::loadConfig()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:24
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.26 ms After last query: 1.32 ms Query memory: 0.035 MB Memory before query: 3.525 MB Rows returned: 50

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `hvg4j_assets`
    
      WHERE `name` IN ('root.1','com_acesearch','com_acesql','com_admin','com_aimysitemap','com_ajax','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_sitemapfaster','com_spupgrade','com_tags','com_tcpdf','com_templates','com_users','com_virtualdomains','com_virtuemart','com_virtuemart_allinone','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	hvg4j_assets	range	idx_asset_name	idx_asset_name	202	NULL	51	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    19	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1339
    18	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    17	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1000
    16	VmConfig::loadConfig()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:24
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.25 ms After last query: 6.30 ms Query memory: 0.029 MB Memory before query: 3.760 MB Rows returned: 1

    SELECT id, home,`template`,`params` 
      FROM `hvg4j_template_styles` 
      WHERE `id`="10"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/components/com_virtuemart/helpers/vmtemplate.php:92
    21	VmTemplate::getTemplateById()	JROOT/components/com_virtuemart/helpers/vmtemplate.php:40
    20	VmTemplate::loadVmTemplateStyle()	JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:265
    19	vmJsApi::setPath()	JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:233
    18	vmJsApi::css()	JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:467
    17	vmJsApi::loadPopUpLib()	JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:408
    16	vmJsApi::jPrice()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:44
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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: 3.20 ms Query memory: 0.034 MB Memory before query: 3.878 MB Rows returned: 1

    SELECT * 
      FROM `hvg4j_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	hvg4j_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
    21	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    20	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    19	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    18	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:467
    17	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1724
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.40 ms After last query: 0.46 ms Query memory: 0.035 MB Memory before query: 3.911 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    25	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    24	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031
    23	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    22	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
    21	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    20	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    19	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    18	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:467
    17	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1724
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 3.32 ms After last query: 3.41 ms Query memory: 0.027 MB Memory before query: 4.067 MB Rows returned: 3

    SELECT  p.`virtuemart_product_id` 
    		
      FROM `hvg4j_virtuemart_products` as p  
     
      LEFT JOIN `hvg4j_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `hvg4j_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `hvg4j_virtuemart_product_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
     
      WHERE ( `pc`.`virtuemart_category_id` = 19 
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
    
      ORDER BY RAND() 
      LIMIT 0, 3

    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	pp	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
    1	SIMPLE	p	range	PRIMARY,published	published	1	NULL	330	Using index condition
    1	SIMPLE	pc	eq_ref	virtuemart_product_id	virtuemart_product_id	8	bcdiff.p.virtuemart_product_id,const	1	Using index

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 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.02 ms
    init	0.06 ms
    optimizing	0.05 ms
    statistics	0.17 ms
    preparing	0.01 ms
    Unlocking tables	0.08 ms
    executing	0.01 ms
    Creating tmp table	0.10 ms
    Copying to tmp table	2.12 ms
    Sorting result	0.04 ms
    Sending data	0.02 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
    18	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:765
    17	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1724
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.24 ms After last query: 0.58 ms Query memory: 0.044 MB Memory before query: 4.093 MB Rows returned: 1

    SELECT `hvg4j_virtuemart_products`.* ,`hvg4j_virtuemart_products_en_gb`.*  
      FROM `hvg4j_virtuemart_products` 
      INNER JOIN `hvg4j_virtuemart_products_en_gb` using (`virtuemart_product_id`) 
      WHERE `hvg4j_virtuemart_products`.`virtuemart_product_id` = "371"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    21	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    20	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1394
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.19 ms After last query: 0.82 ms Query memory: 0.029 MB Memory before query: 4.134 MB Rows returned: 9

    SELECT `virtuemart_media_id` 
      FROM `hvg4j_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "371" 
      ORDER BY `ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	hvg4j_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	9	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    21	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    20	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1399
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.16 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 4.161 MB Rows returned: 0

    SELECT `virtuemart_shoppergroup_id` 
      FROM `hvg4j_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "371"

    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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    21	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    20	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1402
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.88 ms After last query: 0.25 ms Query memory: 0.034 MB Memory before query: 4.170 MB Rows returned: 0

    SELECT * 
      FROM `hvg4j_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "371"  
      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` <= "2018-12-15 07:42:21" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2018-12-15 07:42:21" ) ) 
      ORDER BY `product_price` DESC

    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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.15 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Waiting for query cache lock	0.05 ms
    init	0.07 ms
    optimizing	0.06 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.02 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.15 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    22	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1198
    21	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1217
    20	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1417
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.17 ms After last query: 0.55 ms Query memory: 0.028 MB Memory before query: 4.192 MB Rows returned: 1

    SELECT `virtuemart_manufacturer_id` 
      FROM `hvg4j_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "371"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	hvg4j_virtuemart_product_manufacturers	ref	virtuemart_product_id	virtuemart_product_id	5	const	3	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    21	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    20	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1421
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.23 ms After last query: 0.37 ms Query memory: 0.035 MB Memory before query: 4.219 MB Rows returned: 0

    SELECT `hvg4j_virtuemart_manufacturers`.* ,`hvg4j_virtuemart_manufacturers_en_gb`.*  
      FROM `hvg4j_virtuemart_manufacturers` 
      INNER JOIN `hvg4j_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`) 
      WHERE `hvg4j_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    21	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    20	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1426
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.20 ms After last query: 0.16 ms Query memory: 0.036 MB Memory before query: 4.231 MB Rows returned: 1

    SELECT `hvg4j_virtuemart_manufacturers`.* ,`hvg4j_virtuemart_manufacturers_fr_fr`.*  
      FROM `hvg4j_virtuemart_manufacturers` 
      INNER JOIN `hvg4j_virtuemart_manufacturers_fr_fr` using (`virtuemart_manufacturer_id`) 
      WHERE `hvg4j_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1077
    20	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1426
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.18 ms After last query: 0.30 ms Query memory: 0.030 MB Memory before query: 4.257 MB Rows returned: 5

    SELECT * 
      FROM `hvg4j_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 371

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    22	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1660
    21	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1637
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.19 ms After last query: 0.46 ms Query memory: 0.042 MB Memory before query: 4.305 MB Rows returned: 1

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_en_gb`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "3"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.27 ms After last query: 0.39 ms Query memory: 0.040 MB Memory before query: 4.329 MB Rows returned: 0

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_en_gb`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "11"

    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
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.18 ms After last query: 0.14 ms Query memory: 0.041 MB Memory before query: 4.345 MB Rows returned: 1

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_fr_fr`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_fr_fr` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "11"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    22	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1077
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.25 ms After last query: 0.45 ms Query memory: 0.040 MB Memory before query: 4.365 MB Rows returned: 0

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_en_gb`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "13"

    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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.19 ms After last query: 0.14 ms Query memory: 0.041 MB Memory before query: 4.381 MB Rows returned: 1

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_fr_fr`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_fr_fr` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "13"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    22	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1077
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.19 ms After last query: 0.56 ms Query memory: 0.040 MB Memory before query: 4.402 MB Rows returned: 0

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_en_gb`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "19"

    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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.19 ms After last query: 0.14 ms Query memory: 0.041 MB Memory before query: 4.418 MB Rows returned: 1

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_fr_fr`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_fr_fr` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "19"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    22	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1077
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.20 ms After last query: 0.48 ms Query memory: 0.041 MB Memory before query: 4.439 MB Rows returned: 1

    SELECT `hvg4j_virtuemart_categories`.* ,`hvg4j_virtuemart_categories_en_gb`.*  
      FROM `hvg4j_virtuemart_categories` 
      INNER JOIN `hvg4j_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
      WHERE `hvg4j_virtuemart_categories`.`virtuemart_category_id` = "20"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1641
    20	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1437
    19	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1000
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.22 ms After last query: 1.12 ms Query memory: 0.040 MB Memory before query: 4.540 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 `hvg4j_virtuemart_customs` AS c 
      LEFT JOIN `hvg4j_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (371) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering` ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	bcdiff.field.virtuemart_custom_id	1	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:150
    20	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2588
    19	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1086
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1732
    16	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    15	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/generique/html/com_blankcomponent/default/default.php:19
    13	include JROOT/templates/generique/html/com_blankcomponent/default/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_blankcomponent/views/default/view.html.php:61
    10	BlankComponentViewDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_blankcomponent/controller.php:24
    8	BlankComponentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_blankcomponent/blankcomponent.php:36
    6	require_once JROOT/components/com_blankcomponent/blankcomponent.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->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.34 ms After last query: 1.10 ms Query memory: 0.042 MB Memory before query: 4.578 MB Rows returned: 0

    SELECT *  
      FROM `hvg4j_virtuemart_currencies` AS c
    			
      LEFT JOIN `hvg4j_virtuemart_vendors` AS v 
      ON  c.virtuemart_currency_id = v.vendor_currency
    			
      WHERE v.virtuemart_vendor_id = "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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
    24	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    23	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
    22	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
    21	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    20	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2595
    19	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1086
    18	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1813
    17	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/m