C5 PANEL GUARDAFANGO GM UNIVERSAL

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686396915,
                "last": 1686396915,
                "now": 1686396915
            },
            "token": "z0F2FrRRtC2iV8byOwzrsCmyxpm896YY"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 692,
        "vmlastvisitedcategoryid": 33,
        "vmlastvisitedproductids": [
            154
        ]
    }
}

**PLG_DEBUG_TIME**

**PLG_DEBUG_MEMORY**

**PLG_DEBUG_QUERIES_LOGGED** 66.82 ms

1. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'6564633665616264363435353138396337396561326466373332343132306130'

   **PLG_DEBUG_EXPLAIN**

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

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.13 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.02 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

2. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'6564633665616264363435353138396337396561326466373332343132306130' 
     LIMIT 1

   **PLG_DEBUG_EXPLAIN**

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

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.02 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

3. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY**

   INSERT INTO `jos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6564633665616264363435353138396337396561326466373332343132306130', 1, 1686396915, 0, '', 0)

   **PLG_DEBUG_EXPLAIN**

   **PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.09 ms
   end	0.01 ms
   query end	17.15 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.02 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

4. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

   **PLG_DEBUG_EXPLAIN**

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

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.12 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.27 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.10 ms
   cleaning up	0.02 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   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}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

5. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

   SELECT id, rules
   
     FROM `jos_viewlevels`

   **PLG_DEBUG_EXPLAIN**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_viewlevels	ALL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	6	100.00	NULL

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	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	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php: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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

6. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

   **PLG_DEBUG_EXPLAIN**

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

   **PLG_DEBUG_PROFILE**

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

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php: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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

7. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

   **PLG_DEBUG_EXPLAIN**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	128	100.00	Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT**

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.03 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.66 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php: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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

8. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

   **PLG_DEBUG_EXPLAIN**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.12 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.02 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   11	JDatabaseDriver->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
   10	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
   9	PlgSystemJhackguard->onAfterInitialise()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
   8	call_user_func_array()	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:626
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

9. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

   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 jos_menu AS m
   
     LEFT JOIN jos_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

   **PLG_DEBUG_EXPLAIN**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	128	100.00	Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT**
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	comerc21_max.m.component_id	1	100.00	Using where

   **PLG_DEBUG_PROFILE**

   Status	Duration
   starting	0.12 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.07 ms
   preparing	0.04 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	0.70 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.02 ms

   **PLG_DEBUG_CALL_STACK**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [**PLG_DEBUG_LINK_FORMAT**]

   ---

10. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SHOW TABLES LIKE "jos_virtuemart_configs"

    **PLG_DEBUG_EXPLAIN**

    **PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:724
    14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:574
    13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:415
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:916
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:379
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

11. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_virtuemart_configs	system	PRIMARY	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	1	100.00	NULL

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:455
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:916
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:379
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

12. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_languages	ALL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	2	100.00	Using where; **PLG_DEBUG_WARNING_USING_FILESORT**

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.08 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:90
    14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:56
    13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:476
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:916
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:379
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

13. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jhackguard','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_assets	ALL	idx_asset_name	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	260	16.15	Using where

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.19 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.66 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    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:145
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
    13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:477
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:916
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:379
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

14. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_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

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2	100.00	NULL
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	comerc21_max.s.template,const	1	100.00	Using index condition; Using where

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    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:830
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:937
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:379
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

15. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `id` 
      FROM `jos_menu` 
      WHERE `home`="1" 
      and (language="*" or language = "es-ES" ) 
      ORDER BY `language` DESC

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	ALL	idx_language	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	183	81.97	Using where; **PLG_DEBUG_WARNING_USING_FILESORT**

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.18 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:890
    13	vmrouterHelper->setRoutingQuery()	JROOT/components/com_virtuemart/router.php:873
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:937
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:379
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

16. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and client_id=0 
      and published=1 
      and (language="*" or language = "es-ES" ) 
      AND ( access="1" OR access="5" )  
      ORDER BY `language` DESC

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	129	100.00	Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT**

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1375
    14	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:903
    13	vmrouterHelper->setRoutingQuery()	JROOT/components/com_virtuemart/router.php:873
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:937
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:379
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

17. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT l.virtuemart_product_id  
      FROM `jos_virtuemart_products_es_es` as l  
      WHERE l.slug = "c5-panel-guardafango-gm-universal"

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l	const	slug	slug	578	const	1	100.00	NULL

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1297
    12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1247
    11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:716
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

18. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT l.virtuemart_category_id  
      FROM `jos_virtuemart_categories_es_es` as l  
      WHERE l.slug = ""

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1297
    13	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1105
    12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:1251
    11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:716
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    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:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

19. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    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}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
    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:1130
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

20. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY**

    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"2a9134f9e201f1ea8182556fcc625874\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.07 ms
    updating	0.08 ms
    end	0.02 ms
    query end	16.38 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    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:1130
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

21. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	3	100.00	Using where

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:180
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:951
    11	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1069
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

22. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.02 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1045
    18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1033
    17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:180
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:951
    11	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1069
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

23. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_es_es`.*  
      FROM `jos_virtuemart_products` 
      INNER JOIN `jos_virtuemart_products_es_es` using (`virtuemart_product_id`) 
      WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "154"

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1045
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1496
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

24. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "154" 
      ORDER BY `ordering`

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:127
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1501
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

25. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `virtuemart_shoppergroup_id` 
      FROM `jos_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "154"

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:127
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1504
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

26. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT * 
      FROM `jos_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "154"  
      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` <= "2023-06-10 11:35:15" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-06-10 11:35:15" ) ) 
      ORDER BY `product_price` DESC

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1310
    13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1329
    12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

27. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `virtuemart_manufacturer_id` 
      FROM `jos_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "154"

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:127
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1524
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

28. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT * 
      FROM `jos_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 154

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1772
    13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1749
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1540
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

29. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_es_es`.*  
      FROM `jos_virtuemart_categories` 
      INNER JOIN `jos_virtuemart_categories_es_es` using (`virtuemart_category_id`) 
      WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "33"

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1045
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1753
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1540
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

30. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
    		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, 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`
    		
      FROM `jos_virtuemart_customs` AS c 
      LEFT JOIN `jos_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (154) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering` ASC

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:154
    11	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1181
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

31. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT *  
      FROM `jos_virtuemart_currencies` AS c
    			
      LEFT JOIN `jos_virtuemart_vendors` AS v 
      ON  c.virtuemart_currency_id = v.vendor_currency
    			
      WHERE v.virtuemart_vendor_id = "1"

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	v	system	PRIMARY,vendor_currency	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	1	100.00	NULL
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:316
    16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2828
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1195
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

32. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `jos_virtuemart_currencies`.*  
      FROM `jos_virtuemart_currencies`  
      WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "29"

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1045
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1033
    15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2828
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1195
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

33. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SHOW FULL COLUMNS  
      FROM `jos_virtuemart_userfields`

    **PLG_DEBUG_EXPLAIN**

    **PLG_DEBUG_QUERY_EXPLAIN_NOT_POSSIBLE**

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:685
    24	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
    23	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:210
    22	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
    21	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
    20	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:600
    19	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
    18	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:552
    17	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:296
    16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
    15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:270
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2828
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1195
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

34. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT * 
      FROM `jos_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

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_virtuemart_userfields	ref	published,account	account	1	const	23	100.00	Using where; **PLG_DEBUG_WARNING_USING_FILESORT**

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.30 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
    19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
    18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:486
    17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:337
    16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
    15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:270
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2828
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1195
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

35. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT * 
      FROM `jos_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

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_virtuemart_userfields	ref	published,shipment	shipment	1	const	14	100.00	Using where; **PLG_DEBUG_WARNING_USING_FILESORT**

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.22 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
    19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
    18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:492
    17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:337
    16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
    15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:270
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2828
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1195
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

36. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT c.* 
      FROM jos_virtuemart_calcs as c  
      LEFT JOIN jos_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 ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-06-10 11:35:15" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-06-10 11:35:15" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cs	system	virtuemart_calc_id	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	100.00	Using where

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:171
    14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2828
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1195
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

37. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `jos_virtuemart_ratings`.*  
      FROM `jos_virtuemart_ratings`  
      WHERE `jos_virtuemart_ratings`.`virtuemart_product_id` = "154"

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1045
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

38. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "113"

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1045
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:480
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1197
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:157
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

39. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "33" 
      ORDER BY `ordering`

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:127
    11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:93
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:215
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

40. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT COLLATION_NAME 
      from information_schema.columns 
      where TABLE_SCHEMA = "comerc21_max"
    				
      and TABLE_NAME = "jos_users"
    				
      and COLUMN_NAME = "name";

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	columns	ALL	NULL	TABLE_SCHEMA,TABLE_NAME	NULL	NULL	NULL	NULL	Using where; Open_frm_only; Scanned 0 databases

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/ratings.php:94
    11	VirtueMartModelRatings::getSelect()	JROOT/administrator/components/com_virtuemart/models/ratings.php:212
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:298
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

41. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT COLLATION_NAME 
      from information_schema.columns 
      where TABLE_SCHEMA = "comerc21_max"
    				
      and TABLE_NAME = "jos_virtuemart_rating_reviews"
    				
      and COLUMN_NAME = "customer";

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	columns	ALL	NULL	TABLE_SCHEMA,TABLE_NAME	NULL	NULL	NULL	NULL	Using where; Open_frm_only; Scanned 0 databases

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/ratings.php:102
    11	VirtueMartModelRatings::getSelect()	JROOT/administrator/components/com_virtuemart/models/ratings.php:212
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:298
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

42. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT  `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer   
      FROM `jos_virtuemart_rating_reviews` AS `pr`
    			
      INNER JOIN `jos_virtuemart_products_es_es` AS `l` 
      ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`  
      LEFT JOIN `jos_virtuemart_rating_votes` AS `rv` 
      on
    			(`pr`.`virtuemart_rating_vote_id` IS NOT NULL 
      AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR
    			(`pr`.`virtuemart_rating_vote_id` IS NULL 
      AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` 
      and `rv`.`created_by`=`pr`.`created_by`) )
    			
      LEFT JOIN `jos_users` AS `u`	
      ON `pr`.`created_by` = `u`.`id` 
     
      WHERE  `pr`.`virtuemart_product_id` = "154" 
    
     
      ORDER BY created_on DESC 
      LIMIT 0, 3

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:861
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/ratings.php:213
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:298
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

43. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    				j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
      FROM jos_virtuemart_shipmentmethods as i 
     
      LEFT JOIN `jos_virtuemart_shipmentmethods_es_es` as l 
      ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`shipment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_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`

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l	system	PRIMARY	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	s	system	virtuemart_shipmentmethod_id	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	i	ALL	PRIMARY	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	2	100.00	Using where; Using temporary; **PLG_DEBUG_WARNING_USING_FILESORT**
    1	SIMPLE	j	eq_ref	PRIMARY	PRIMARY	4	comerc21_max.i.shipment_jplugin_id	1	100.00	NULL

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.27 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    removing tmp table	0.05 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:524
    14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:361
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

44. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    				j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc 
      FROM jos_virtuemart_paymentmethods as i 
     
      LEFT JOIN `jos_virtuemart_paymentmethods_es_es` as l 
      ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`payment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_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`

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l	system	PRIMARY	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	s	system	virtuemart_paymentmethod_id	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	i	ALL	PRIMARY,virtuemart_vendor_id	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	2	100.00	Using where; Using temporary; **PLG_DEBUG_WARNING_USING_FILESORT**
    1	SIMPLE	j	eq_ref	PRIMARY	PRIMARY	4	comerc21_max.i.payment_jplugin_id	1	100.00	NULL

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.25 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    removing tmp table	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:524
    14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/paypal/paypal.php:252
    13	plgVmPaymentPaypal->plgVmOnProductDisplayPayment()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:369
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

45. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_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 <= '2023-06-10 11:35:15') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-10 11:35:15') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 692 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	42	100.00	Using index condition; Using where; **PLG_DEBUG_WARNING_USING_FILESORT**
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	comerc21_max.m.id	1	100.00	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	comerc21_max.m.module,const	1	100.00	Using index condition; Using where

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.69 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/illusion/index.php:109
    7	require JROOT/templates/illusion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

46. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

    SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
    				
      FROM  jos_virtuemart_category_categories AS `xref`
    				
      WHERE `xref`.`category_child_id`= 33

    **PLG_DEBUG_EXPLAIN**

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

    **PLG_DEBUG_PROFILE**

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

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:773
    11	VirtueMartModelCategory->getCategoryRecurse()	JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:64
    10	include JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---

47. **PLG_DEBUG_QUERY_TIME** **PLG_DEBUG_QUERY_AFTER_LAST** **PLG_DEBUG_MEMORY_USED_FOR_QUERY** **PLG_DEBUG_ROWS_RETURNED_BY_QUERY**

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

    **PLG_DEBUG_EXPLAIN**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	**PLG_DEBUG_WARNING_NO_INDEX**	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    **PLG_DEBUG_PROFILE**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    **PLG_DEBUG_CALL_STACK**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jhackguard/jhackguard.php:91
    8	PlgSystemJhackguard->onAfterRender()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
    7	call_user_func_array()	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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [**PLG_DEBUG_LINK_FORMAT**]

    ---