Deposit Millesim GT Tour 2026

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1765380393,
                "last": 1765380394,
                "now": 1765380395
            }
        },
        "registry": {
            "com_virtuemart": {
                "category": {
                    "limit": "24"
                }
            }
        },
        "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"
        }
    },
    "__vm": {
        "vmcartlastVendorId": 1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":1,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":[],\"ST\":{\"address_type_name\":\"**Address Nickname**\"},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"OrderIdOrderDone\":false,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":[],\"byDefaultST\":{\"address_type_name\":1},\"productCartLoaded\":[],\"loadedCart\":true,\"lastAddedProduct\":0}",
        "vmlastvisitedItemid": 893,
        "vmlastvisitedcategoryid": 1,
        "vmlastvisitedmanuid": 0,
        "vmlastvisitedproductids": [
            2,
            11
        ]
    }
}

**Time**

**Memory**

**55 Queries Logged** 42.02 ms

1. **Query Time: 0.91 ms** **Query memory: 0.023 MB Memory before query: 1.047 MB** **Rows returned: 1**

   SELECT `data`
   
     FROM `jnew_session`
   
     WHERE `session_id` = X'74733162686a6c736436766b74686d6d6b767132726c636e756a'

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jnew_session	const	PRIMARY	PRIMARY	194	const	1

   **Profile**

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

   **Call Stack**

   #	**Caller**	**File and line number**
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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: 1.25 ms** **After last query: 4.16 ms** **Query memory: 0.042 MB Memory before query: 1.099 MB** **Rows returned: 50**

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jnew_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	jnew_extensions	ref	extension	extension	82	const	50	Using index condition; Using where

   **Profile**

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.11 ms
   Preparing	0.05 ms
   Executing	0.01 ms
   Sending data	0.48 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.03 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   **Call Stack**

   #	**Caller**	**File and line number**
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   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:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   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:594
   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:225
   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.**]

   ---

3. **Query Time: 0.66 ms** **After last query: 3.15 ms** **Query memory: 0.021 MB Memory before query: 1.149 MB** **Rows returned: 3**

   SELECT id, rules
   
     FROM `jnew_viewlevels`

   **Explain**

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

   **Profile**

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

   **Call Stack**

   #	**Caller**	**File and line number**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   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:318
   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:604
   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:225
   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.**]

   ---

4. **Query Time: 0.74 ms** **After last query: 0.15 ms** **Query memory: 0.021 MB Memory before query: 1.160 MB** **Rows returned: 1**

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

   **Explain**

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

   **Profile**

   Status	Duration
   Starting	0.07 ms
   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
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.02 ms
   Unlocking tables	0.01 ms
   Preparing	0.04 ms
   Executing	0.02 ms
   Sending data	0.04 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   **Call Stack**

   #	**Caller**	**File and line number**
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   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:318
   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:604
   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:225
   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: 1.97 ms** **After last query: 0.56 ms** **Query memory: 0.035 MB Memory before query: 1.182 MB** **Rows returned: 130**

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

   **Explain**

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

   **Profile**

   Status	Duration
   Starting	0.11 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
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.10 ms
   Preparing	0.03 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	1.08 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   **Call Stack**

   #	**Caller**	**File and line number**
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   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:356
   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:604
   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:225
   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.77 ms** **After last query: 36.02 ms** **Query memory: 0.021 MB Memory before query: 2.045 MB** **Rows returned: 2**

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

   **Explain**

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

   **Profile**

   Status	Duration
   Starting	0.06 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
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.15 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   **Call Stack**

   #	**Caller**	**File and line number**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:225
   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: 0.63 ms** **After last query: 0.15 ms** **Query memory: 0.021 MB Memory before query: 2.054 MB** **Rows returned: 4**

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `jnew_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	jnew_extensions	ref	extension	extension	82	const	4	Using index condition; Using where

   **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.04 ms
   Optimizing	0.03 ms
   Statistics	0.07 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.07 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   **Call Stack**

   #	**Caller**	**File and line number**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:225
   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: 3.11 ms** **After last query: 11.42 ms** **Query memory: 0.133 MB Memory before query: 2.194 MB** **Rows returned: 86**

   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 jnew_menu AS m
   
     LEFT JOIN jnew_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	208	Using index condition; Using where; **Using filesort**
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.m.component_id	1	Using where

   **Profile**

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

   **Call Stack**

   #	**Caller**	**File and line number**
   23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	**Same as call in the line below.**
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
   8	PlgSystemLanguageFilter->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:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:225
   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: 1.75 ms** **After last query: 32.62 ms** **Query memory: 0.024 MB Memory before query: 2.963 MB** **Rows returned: 1**

   SHOW TABLES LIKE "jnew_virtuemart_configs"

   **Explain**

   **EXPLAIN not possible on query: SHOW TABLES LIKE "jnew_virtuemart_configs"**

   **Profile**

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.03 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.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Filling schema table	0.02 ms
   checking permissions	1.19 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Removing tmp table	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   **Call Stack**

   #	**Caller**	**File and line number**
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:826
   15	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:600
   14	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:408
   13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:202
   12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
   11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
   10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
   9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   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: 1.12 ms** **After last query: 0.06 ms** **Query memory: 0.022 MB Memory before query: 2.971 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.06 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
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.57 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:457
    13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:202
    12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 3.03 ms** **After last query: 0.55 ms** **Query memory: 0.030 MB Memory before query: 3.038 MB** **Rows returned: 50**

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jnew_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eorisis_pixels','com_favicon','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_popup_anywhere','com_postinstall','com_privacy','com_redirect','com_search','com_spambotcheck','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.18 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
    init	0.08 ms
    Optimizing	0.03 ms
    Statistics	0.23 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	2.10 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:479
    13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:202
    12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.92 ms** **After last query: 1.57 ms** **Query memory: 0.023 MB Memory before query: 3.110 MB** **Rows returned: 9**

    SELECT id, home, template, s.params
    
      FROM jnew_template_styles as s
    
      LEFT JOIN jnew_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,idx_client_id,idx_client_id_home	**NO INDEX KEY COULD BE USED**	NULL	NULL	15	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	millesimclassicrally-testv16.s.template,const	1	Using index condition; Using where

    **Profile**

    Status	Duration
    Starting	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.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.20 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:222
    12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 1.54 ms** **After last query: 1.10 ms** **Query memory: 0.026 MB Memory before query: 3.135 MB** **Rows returned: 7**

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

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1727
    14	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:301
    13	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:267
    12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 0.80 ms** **After last query: 1.74 ms** **Query memory: 0.022 MB Memory before query: 3.219 MB** **Rows returned: 1**

    SELECT IFNULL(l.virtuemart_product_id,ld.virtuemart_product_id) as virtuemart_product_id  
      FROM `jnew_virtuemart_products_fr_fr` as ld   
      LEFT JOIN `jnew_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = ld.`virtuemart_product_id` 
      WHERE IFNULL(l.slug,ld.slug) = "deposit-gt-tour-2026" OR ld.slug = "deposit-gt-tour-2026"

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ld	index	slug	slug	767	NULL	13	Using index
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.ld.virtuemart_product_id	1	Using where

    **Profile**

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.15 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1652
    13	vmrouterHelper::getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1567
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 0.85 ms** **After last query: 6.91 ms** **Query memory: 0.026 MB Memory before query: 3.864 MB** **Rows returned: 1**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
    18	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
    17	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
    16	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
    15	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1152
    14	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1280
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 0.57 ms** **After last query: 1.00 ms** **Query memory: 0.027 MB Memory before query: 3.900 MB** **Rows returned: 1**

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

    **Explain**

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

    **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.04 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1161
    20	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
    19	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:109
    18	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
    17	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
    16	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
    15	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1152
    14	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1280
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 0.88 ms** **After last query: 0.26 ms** **Query memory: 0.043 MB Memory before query: 3.933 MB** **Rows returned: 1**

    SELECT `jnew_virtuemart_products`.* ,`jnew_virtuemart_products_en_gb`.*  
      FROM `jnew_virtuemart_products` 
      INNER JOIN `jnew_virtuemart_products_en_gb` 
      ON `jnew_virtuemart_products`.`virtuemart_product_id` = `jnew_virtuemart_products_en_gb`.`virtuemart_product_id`  
      WHERE `jnew_virtuemart_products`.`virtuemart_product_id` = "2"

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1780
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 0.71 ms** **After last query: 1.43 ms** **Query memory: 0.024 MB Memory before query: 4.068 MB** **Rows returned: 1**

    SELECT `virtuemart_media_id` 
      FROM `jnew_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "2"  
      ORDER BY `ordering`

    **Explain**

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

    **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.03 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
    15	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1817
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.56 ms** **After last query: 0.45 ms** **Query memory: 0.025 MB Memory before query: 4.082 MB** **Rows returned: 1**

    SELECT * 
      FROM `jnew_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "2"  
      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` <= "2025-12-10 16:26:35" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-12-10 16:26:35" ) ) 
      ORDER BY `product_price` DESC

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    16	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1613
    15	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1847
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.32 ms** **After last query: 0.65 ms** **Query memory: 0.024 MB Memory before query: 4.109 MB** **Rows returned: 1**

    SELECT `virtuemart_manufacturer_id` 
      FROM `jnew_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "2"

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
    15	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1856
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.31 ms** **After last query: 0.08 ms** **Query memory: 0.024 MB Memory before query: 4.113 MB** **Rows returned: 1**

    SELECT * 
      FROM `jnew_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 2

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_virtuemart_product_categories	ref	virtuemart_product_id,virtuemart_product_id_uid	virtuemart_product_id	4	const	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2195
    16	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:2172
    15	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1868
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.44 ms** **After last query: 0.59 ms** **Query memory: 0.025 MB Memory before query: 4.178 MB** **Rows returned: 0**

    SELECT `jnew_virtuemart_categories`.* ,`jnew_virtuemart_categories_en_gb`.*  
      FROM `jnew_virtuemart_categories` 
      INNER JOIN `jnew_virtuemart_categories_en_gb` 
      ON `jnew_virtuemart_categories`.`virtuemart_category_id` = `jnew_virtuemart_categories_en_gb`.`virtuemart_category_id`  
      WHERE `jnew_virtuemart_categories`.`virtuemart_category_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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:2176
    15	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1868
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.41 ms** **After last query: 0.11 ms** **Query memory: 0.026 MB Memory before query: 4.188 MB** **Rows returned: 1**

    SELECT `jnew_virtuemart_categories`.* ,`jnew_virtuemart_categories_fr_fr`.*  
      FROM `jnew_virtuemart_categories` 
      INNER JOIN `jnew_virtuemart_categories_fr_fr` 
      ON `jnew_virtuemart_categories`.`virtuemart_category_id` = `jnew_virtuemart_categories_fr_fr`.`virtuemart_category_id`  
      WHERE `jnew_virtuemart_categories`.`virtuemart_category_id` = "1"

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1207
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:2176
    15	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1868
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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: 0.36 ms** **After last query: 0.55 ms** **Query memory: 0.024 MB Memory before query: 4.220 MB** **Rows returned: 0**

    SELECT `jnew_virtuemart_manufacturers`.* ,`jnew_virtuemart_manufacturers_en_gb`.*  
      FROM `jnew_virtuemart_manufacturers` 
      INNER JOIN `jnew_virtuemart_manufacturers_en_gb` 
      ON `jnew_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `jnew_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id`  
      WHERE `jnew_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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1935
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.36 ms** **After last query: 0.09 ms** **Query memory: 0.025 MB Memory before query: 4.229 MB** **Rows returned: 1**

    SELECT `jnew_virtuemart_manufacturers`.* ,`jnew_virtuemart_manufacturers_fr_fr`.*  
      FROM `jnew_virtuemart_manufacturers` 
      INNER JOIN `jnew_virtuemart_manufacturers_fr_fr` 
      ON `jnew_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `jnew_virtuemart_manufacturers_fr_fr`.`virtuemart_manufacturer_id`  
      WHERE `jnew_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_virtuemart_manufacturers	const	PRIMARY,virtuemart_manufacturercategories_id	PRIMARY	4	const	1
    1	SIMPLE	jnew_virtuemart_manufacturers_fr_fr	const	PRIMARY	PRIMARY	4	const	1

    **Profile**

    Status	Duration
    Starting	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
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1207
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1935
    14	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1305
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.56 ms** **After last query: 0.92 ms** **Query memory: 0.026 MB Memory before query: 4.266 MB** **Rows returned: 4**

    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.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, 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.`noninheritable`, field.`ordering`,
    		field.`product_sku`, field.`product_gtin`, field.`product_mpn`
    		
      FROM `jnew_virtuemart_customs` AS c 
      LEFT JOIN `jnew_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (2) 
      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_product_id,virtuemart_custom_id,unique_cust_prd_value	virtuemart_product_id	4	const	4	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	millesimclassicrally-testv16.field.virtuemart_custom_id	1	Using where

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:163
    14	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1436
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.42 ms** **After last query: 5.34 ms** **Query memory: 0.025 MB Memory before query: 4.485 MB** **Rows returned: 1**

    SELECT `extension_id` as `id`, `folder` as `type`, `element` as `name`, `params`, `state` 
      FROM jnew_extensions 
      WHERE 
    						`type`="plugin" 
      and `folder`="vmcustom" 
      and `element` = "textinput"

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:260
    18	vDispatcher::getPlugin()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:186
    17	vDispatcher::createPlugin()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:148
    16	vDispatcher::directTrigger()	JROOT/administrator/components/com_virtuemart/models/customfields.php:276
    15	VirtueMartModelCustomfields::bindCustomEmbeddedFieldParams()	JROOT/administrator/components/com_virtuemart/models/customfields.php:251
    14	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1436
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.40 ms** **After last query: 2.06 ms** **Query memory: 0.027 MB Memory before query: 4.526 MB** **Rows returned: 1**

    SELECT *  
      FROM `jnew_virtuemart_currencies` AS c
    			
      LEFT JOIN `jnew_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	v	const	PRIMARY,vendor_currency	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:316
    19	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    18	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
    17	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    16	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    15	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3333
    14	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.33 ms** **After last query: 1.18 ms** **Query memory: 0.026 MB Memory before query: 4.629 MB** **Rows returned: 1**

    SELECT `jnew_virtuemart_currencies`.*  
      FROM `jnew_virtuemart_currencies`  
      WHERE `jnew_virtuemart_currencies`.`virtuemart_currency_id` = "47"

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    19	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1161
    18	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
    17	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    16	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    15	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3333
    14	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.93 ms** **After last query: 1.06 ms** **Query memory: 0.036 MB Memory before query: 4.681 MB** **Rows returned: 33**

    SHOW FULL COLUMNS  
      FROM `jnew_virtuemart_userfields`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jnew_virtuemart_userfields`**

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    28	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:787
    27	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
    26	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:239
    25	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:441
    24	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:403
    23	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:620
    22	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
    21	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:572
    20	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:381
    19	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
    18	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
    17	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
    16	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    15	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3333
    14	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.52 ms** **After last query: 0.19 ms** **Query memory: 0.039 MB Memory before query: 4.724 MB** **Rows returned: 16**

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

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
    22	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
    21	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:441
    20	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
    19	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
    18	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
    17	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
    16	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    15	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3333
    14	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.34 ms** **After last query: 1.76 ms** **Query memory: 0.027 MB Memory before query: 4.808 MB** **Rows returned: 1**

    SELECT COUNT(*)
    
      FROM `jnew_extensions`
    
      WHERE `element` = 'com_spambotcheck' 
      AND `enabled` = '1'

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    25	JDatabaseDriver->loadResult()	JROOT/plugins/user/spambotcheck/SpambotCheck/SpambotCheckHelpers.php:632
    24	plgSpambotCheckHelpers::checkComponentInstalled()	JROOT/plugins/user/spambotcheck/spambotcheck.php:23
    23	plgUserSpambotCheck->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    22	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    21	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_virtuemart/models/userfields.php:482
    20	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
    19	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
    18	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
    17	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
    16	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    15	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3333
    14	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.55 ms** **After last query: 1.73 ms** **Query memory: 0.036 MB Memory before query: 4.882 MB** **Rows returned: 14**

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

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
    22	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
    21	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:447
    20	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
    19	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
    18	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
    17	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
    16	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    15	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3333
    14	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.67 ms** **After last query: 0.66 ms** **Query memory: 0.026 MB Memory before query: 4.979 MB** **Rows returned: 1**

    SELECT c.* 
      FROM jnew_virtuemart_calcs as c  
      LEFT JOIN jnew_virtuemart_calc_shoppergroups as cs 
      ON cs.virtuemart_calc_id=c.virtuemart_calc_id  
      WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND (  ( ISNULL(`publish_up`) or `publish_up`="0000-00-00 00:00:00")  OR publish_up <= "2025-12-10 14:26:35" )
    				
      AND (  ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00")  OR publish_down >= "2025-12-10 14:26:35" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
      ORDER BY c.ordering

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where; **Using filesort**
    1	SIMPLE	cs	ref	virtuemart_calc_id	virtuemart_calc_id	4	millesimclassicrally-testv16.c.virtuemart_calc_id	1	Using where; Using index

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:174
    17	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95
    16	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    15	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3333
    14	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
    13	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1575
    12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1168
    11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:123
    10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
    9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    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.38 ms** **After last query: 4.83 ms** **Query memory: 0.022 MB Memory before query: 5.040 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    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:1137
    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:225
    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.40 ms** **After last query: 0.18 ms** **Query memory: 0.005 MB Memory before query: 5.030 MB**

    UPDATE `jnew_extensions`
    
      SET `params` = '{\"mediaversion\":\"9773a01d2a1cc02721c134f534d64651\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **Explain**

    **EXPLAIN not possible on query: UPDATE `jnew_extensions` SET `params` = '{\"mediaversion\":\"9773a01d2a1cc02721c134f534d64651\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

    **Profile**

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init for update	0.07 ms
    Updating	0.09 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.03 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 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:1137
    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:225
    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.35 ms** **After last query: 22.70 ms** **Query memory: 0.024 MB Memory before query: 6.143 MB** **Rows returned: 1**

    SELECT `jnew_virtuemart_medias`.*  
      FROM `jnew_virtuemart_medias`  
      WHERE `jnew_virtuemart_medias`.`virtuemart_media_id` = "6"

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:99
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:560
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1321
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:159
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.32 ms** **After last query: 5.74 ms** **Query memory: 0.022 MB Memory before query: 6.641 MB** **Rows returned: 0**

    SELECT `virtuemart_media_id` 
      FROM `jnew_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "1"  
      ORDER BY `ordering`

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
    11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:118
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.29 ms** **After last query: 0.10 ms** **Query memory: 0.023 MB Memory before query: 6.647 MB** **Rows returned: 1**

    SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
    				
      FROM  jnew_virtuemart_categories 
    				
      WHERE `virtuemart_category_id`= 1

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1095
    13	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1018
    12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
    11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.38 ms** **After last query: 0.09 ms** **Query memory: 0.022 MB Memory before query: 6.658 MB** **Rows returned: 1**

    SELECT IFNULL(l.virtuemart_category_id,ld.virtuemart_category_id) as virtuemart_category_id, IFNULL(l.category_name,ld.category_name) as category_name, published 
      FROM `jnew_virtuemart_categories` as c  
      LEFT JOIN `jnew_virtuemart_categories_fr_fr` as ld 
      ON ld.`virtuemart_category_id` = c.`virtuemart_category_id`  
      LEFT JOIN `jnew_virtuemart_categories_en_gb` as l 
      ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
      WHERE IFNULL(l.virtuemart_category_id,ld.virtuemart_category_id) = 1

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	index	NULL	published	1	NULL	1	Using index
    1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.c.virtuemart_category_id	1
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.c.virtuemart_category_id	1	Using where

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1041
    12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
    11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.69 ms** **After last query: 1.18 ms** **Query memory: 0.025 MB Memory before query: 6.665 MB** **Rows returned: 1**

    SELECT id 
      FROM `jnew_menu` 
      WHERE `link` like "index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=2%" 
      and (language="*" or language = "en-GB" ) 
      AND client_id=0 
      AND published=1 
      AND ( access="1" )  
      ORDER BY `language` DESC

    **Explain**

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

    **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.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.33 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    17	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    16	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    15	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    14	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:270
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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: 1.32 ms** **After last query: 47.90 ms** **Query memory: 0.025 MB Memory before query: 7.341 MB** **Rows returned: 1**

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    				j.`params`, j.`custom_data`, j.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , IFNULL(l.shipment_name,ld.shipment_name) as shipment_name, IFNULL(l.shipment_desc,ld.shipment_desc) as shipment_desc 
      FROM jnew_virtuemart_shipmentmethods as i 
     
      LEFT JOIN `jnew_virtuemart_shipmentmethods_fr_fr` as ld 
      ON ld.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
     
      LEFT JOIN `jnew_virtuemart_shipmentmethods_en_gb` as l 
      ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
     
      LEFT JOIN `jnew_extensions` as j 
      ON j.`extension_id` =  i.`shipment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jnew_virtuemart_shipmentmethod_shoppergroups` AS s 
      ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
      WHERE 
     i.`published` = "1" 
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")  
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )  
      GROUP BY i.`virtuemart_shipmentmethod_id` 
      ORDER BY i.`ordering` ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	index	NULL	PRIMARY	4	NULL	1	Using where; Using temporary; **Using filesort**
    1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1
    1	SIMPLE	j	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.shipment_jplugin_id	1
    1	SIMPLE	s	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1	Using where; Using index

    **Profile**

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Creating tmp table	0.08 ms
    Sorting for group	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.41 ms
    Creating sort index	0.08 ms
    Removing tmp table	0.12 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:513
    14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:365
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
    10	vDispatcher::trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:370
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

43. **Query Time: 1.22 ms** **After last query: 0.38 ms** **Query memory: 0.025 MB Memory before query: 7.357 MB** **Rows returned: 2**

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    				j.`params`, j.`custom_data`, j.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , IFNULL(l.payment_name,ld.payment_name) as payment_name, IFNULL(l.payment_desc,ld.payment_desc) as payment_desc 
      FROM jnew_virtuemart_paymentmethods as i 
     
      LEFT JOIN `jnew_virtuemart_paymentmethods_fr_fr` as ld 
      ON ld.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
     
      LEFT JOIN `jnew_virtuemart_paymentmethods_en_gb` as l 
      ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
     
      LEFT JOIN `jnew_extensions` as j 
      ON j.`extension_id` =  i.`payment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jnew_virtuemart_paymentmethod_shoppergroups` AS s 
      ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
      WHERE 
     i.`published` = "1" 
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")  
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )  
      GROUP BY i.`virtuemart_paymentmethod_id` 
      ORDER BY i.`ordering` ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	index	virtuemart_vendor_id	PRIMARY	4	NULL	5	Using where; Using temporary; **Using filesort**
    1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1
    1	SIMPLE	j	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.payment_jplugin_id	1
    1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1	Using where; Using index

    **Profile**

    Status	Duration
    Starting	0.09 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
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting for group	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.42 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.09 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:513
    14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/paypal/paypal.php:254
    13	plgVmPaymentPaypal->plgVmOnProductDisplayPayment()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
    10	vDispatcher::trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:371
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

44. **Query Time: 0.77 ms** **After last query: 29.94 ms** **Query memory: 0.027 MB Memory before query: 7.846 MB** **Rows returned: 0**

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

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.14 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.28 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    23	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    22	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    21	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    20	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    15	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/com_virtuemart/sublayouts/addtocart.php:39
    14	include JROOT/templates/horme_3_pro/html/com_virtuemart/sublayouts/addtocart.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:598
    13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:149
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

45. **Query Time: 0.67 ms** **After last query: 0.09 ms** **Query memory: 0.027 MB Memory before query: 7.858 MB** **Rows returned: 0**
    **Duplicate queries**: #50

    SELECT id 
      FROM `jnew_menu` 
      WHERE `link` like "index.php?option=com_virtuemart&view=category&virtuemart_category_id=0&virtuemart_manufacturer_id=0%" 
      and (language="*" or language = "en-GB" ) 
      AND client_id=0 
      AND published=1 
      AND ( access="1" )  
      ORDER BY `language` DESC

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.25 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    24	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    23	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:2096
    22	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    21	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    20	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    15	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/com_virtuemart/sublayouts/addtocart.php:39
    14	include JROOT/templates/horme_3_pro/html/com_virtuemart/sublayouts/addtocart.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:598
    13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:149
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

46. **Query Time: 0.62 ms** **After last query: 2.44 ms** **Query memory: 0.026 MB Memory before query: 7.859 MB** **Rows returned: 0**

    SELECT id 
      FROM `jnew_menu` 
      WHERE `link` like "index.php?option=com_virtuemart&view=productdetails&task=askquestion&virtuemart_product_id=2%" 
      and (language="*" or language = "en-GB" ) 
      AND client_id=0 
      AND published=1 
      AND ( access="1" )  
      ORDER BY `language` DESC

    **Explain**

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

    **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.00 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.23 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    21	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    20	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    19	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    18	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:174
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

47. **Query Time: 0.55 ms** **After last query: 0.09 ms** **Query memory: 0.026 MB Memory before query: 7.870 MB** **Rows returned: 0**

    SELECT id 
      FROM `jnew_menu` 
      WHERE `link` like "index.php?option=com_virtuemart&view=category&task=askquestion&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
      and (language="*" or language = "en-GB" ) 
      AND client_id=0 
      AND published=1 
      AND ( access="1" )  
      ORDER BY `language` DESC

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    21	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:2096
    20	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    19	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    18	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:174
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

48. **Query Time: 0.56 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 7.882 MB** **Rows returned: 0**

    SELECT id 
      FROM `jnew_menu` 
      WHERE `link` like "index.php?option=com_virtuemart&view=category&task=askquestion&virtuemart_category_id=0&virtuemart_manufacturer_id=0%" 
      and (language="*" or language = "en-GB" ) 
      AND client_id=0 
      AND published=1 
      AND ( access="1" )  
      ORDER BY `language` DESC

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    23	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    22	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:2100
    21	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:2096
    20	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    19	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    18	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:174
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

49. **Query Time: 0.70 ms** **After last query: 1.75 ms** **Query memory: 0.026 MB Memory before query: 7.896 MB** **Rows returned: 0**

    SELECT id 
      FROM `jnew_menu` 
      WHERE `link` like "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
      and (language="*" or language = "en-GB" ) 
      AND client_id=0 
      AND published=1 
      AND ( access="1" )  
      ORDER BY `language` DESC

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.32 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    21	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    20	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    19	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    18	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:295
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

50. **Query Time: 0.57 ms** **After last query: 0.09 ms** **Query memory: 0.026 MB Memory before query: 7.908 MB** **Rows returned: 0**
    **Duplicate queries**: #45

    SELECT id 
      FROM `jnew_menu` 
      WHERE `link` like "index.php?option=com_virtuemart&view=category&virtuemart_category_id=0&virtuemart_manufacturer_id=0%" 
      and (language="*" or language = "en-GB" ) 
      AND client_id=0 
      AND published=1 
      AND ( access="1" )  
      ORDER BY `language` DESC

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.23 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
    21	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:2100
    20	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
    19	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
    18	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:295
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

51. **Query Time: 0.34 ms** **After last query: 3.70 ms** **Query memory: 0.025 MB Memory before query: 7.963 MB** **Rows returned: 0**

    SELECT * 
      FROM `jnew_virtuemart_ratings` 
      WHERE `virtuemart_product_id` = "2" 
      AND `published`="1"

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_virtuemart_ratings	ref	virtuemart_product_id,published	virtuemart_product_id	4	const	1	Using where

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/ratings.php:293
    15	VirtueMartModelRatings->getRatingByProduct()	JROOT/templates/horme_3_pro/html/com_virtuemart/sublayouts/snippets.php:9
    14	include JROOT/templates/horme_3_pro/html/com_virtuemart/sublayouts/snippets.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:598
    13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php:392
    12	include JROOT/templates/horme_3_pro/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
    10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    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.**]

    ---

52. **Query Time: 0.44 ms** **After last query: 4.14 ms** **Query memory: 0.021 MB Memory before query: 7.935 MB** **Rows returned: 3**

    SELECT language,id
    
      FROM `jnew_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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:225
    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.**]

    ---

53. **Query Time: 1.13 ms** **After last query: 4.59 ms** **Query memory: 0.024 MB Memory before query: 8.018 MB** **Rows returned: 8**

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jnew_modules AS m
    
      LEFT JOIN jnew_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jnew_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 <= '2025-12-10 15:26:35') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-10 15:26:35') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 0 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	5	const,const	42	Using where; **Using filesort**
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	millesimclassicrally-testv16.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.m.id	3	Using where; Using index

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	**Same as call in the line below.**
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/horme_3_pro/logic.php:180
    8	require_once JROOT/templates/horme_3_pro/logic.php	JROOT/templates/horme_3_pro/component.php:22
    7	require JROOT/templates/horme_3_pro/component.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.**]

    ---

54. **Query Time: 0.28 ms** **After last query: 4.27 ms** **Query memory: 0.024 MB Memory before query: 8.018 MB** **Rows returned: 1**

    SELECT `params`
    
      FROM `jnew_eorisis_pixels_sections`
    
      WHERE `name`='metapixelopt'

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_eorisis_pixels_sections	const	name	name	402	const	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_eorisis_pixels/app/src/Core/Model/Database.php:42
    15	Eorisis\Pixels\Core\Model\Database::getFirstResult()	JROOT/administrator/components/com_eorisis_pixels/app/src/Core/Model/Section.php:42
    14	Eorisis\Pixels\Core\Model\Section::getParams()	JROOT/administrator/components/com_eorisis_pixels/app/src/Core/Model/Head.php:25
    13	Eorisis\Pixels\Core\Model\Head->process()	JROOT/plugins/system/eorisis_pixels/eorisis_pixels.php:105
    12	PlgSystemEorisis_pixels->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.**]

    ---

55. **Query Time: 0.40 ms** **After last query: 11.60 ms** **Query memory: 0.033 MB Memory before query: 8.226 MB** **Rows returned: 178**

    SELECT * 
      FROM jnew_acymailing_config

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
    10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:145
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.**]

    ---