Product details Core black extension dining table

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1745130452,
                "last": 1745130452,
                "now": 1745130452
            },
            "token": "w3U6Vc9HRN10tnsGTFpsZOmssuf194NI"
        },
        "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,
        "vmcartlastVendorId": 1,
        "vmlastvisitedcategoryid": 11
    }
}

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

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

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

#	Caller	File and line number
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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `u4gmh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3938306562346639366362316230643733346264353434333032623762666134', 1, 1745130452, 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.09 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.00 ms
query end	0.06 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 6.79 ms After last query: 4.79 ms Query memory: 0.025 MB Memory before query: 1.386 MB Rows returned: 42

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `u4gmh_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.93 ms After last query: 4.72 ms Query memory: 0.021 MB Memory before query: 1.419 MB Rows returned: 5

SELECT id, rules

  FROM `u4gmh_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 1.431 MB Rows returned: 2

SELECT b.id

  FROM u4gmh_usergroups AS a

  LEFT JOIN u4gmh_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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

Profile

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

Call Stack

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

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

Query Time: 2.13 ms After last query: 0.72 ms Query memory: 0.046 MB Memory before query: 1.454 MB Rows returned: 107

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM u4gmh_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.25 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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.14 ms After last query: 54.55 ms Query memory: 0.021 MB Memory before query: 2.024 MB Rows returned: 10

SELECT * 
  FROM u4gmh_loginradius_settings

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
9	plgSystemSocialLoginTools::sociallogin_getsettings()	JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
8	plgSystemSocialLoginAndSocialShare->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.48 ms After last query: 42.23 ms Query memory: 0.022 MB Memory before query: 2.191 MB Rows returned: 1

SHOW TABLES LIKE "u4gmh_virtuemart_configs"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:727
11	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:580
10	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:415
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.62 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 2.198 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:455
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 1.42 ms Query memory: 0.022 MB Memory before query: 2.261 MB Rows returned: 2

SELECT *

  FROM u4gmh_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:98
11	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:62
10	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:476
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.22 ms After last query: 0.66 ms Query memory: 0.028 MB Memory before query: 2.277 MB Rows returned: 42

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `u4gmh_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_komento','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_socialloginandsocialshare','com_tags','com_tcpdf','com_templates','com_tmbox','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u4gmh_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	173	24.86	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.36 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.90 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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:477
9	VmConfig::loadConfig()	JROOT/plugins/system/vm3_cart/vm3_cart.php:23
8	plgSystemVM3_Cart->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.51 ms After last query: 9.36 ms Query memory: 0.092 MB Memory before query: 2.438 MB Rows returned: 55

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 u4gmh_menu AS m

  LEFT JOIN u4gmh_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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}()	Same as call in the line below.
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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
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:65
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:561
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:1169
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.18 ms After last query: 27.96 ms Query memory: 0.025 MB Memory before query: 2.797 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `u4gmh_komento_configs`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 2.20 ms Query memory: 0.022 MB Memory before query: 2.814 MB Rows returned: 1

SELECT *

  FROM u4gmh_komento_configs

  WHERE `component` = 'com_komento'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 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.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.12 ms After last query: 20.81 ms Query memory: 0.022 MB Memory before query: 3.055 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM u4gmh_template_styles as s

  LEFT JOIN u4gmh_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	60.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	Sql1238540_1.s.template,const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:852
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:970
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.90 ms After last query: 1.16 ms Query memory: 0.047 MB Memory before query: 3.070 MB Rows returned: 15

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u4gmh_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	67	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.92 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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1405
14	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:920
13	vmrouterHelper->setRoutingQuery()	JROOT/components/com_virtuemart/router.php:898
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:970
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.56 ms After last query: 0.43 ms Query memory: 0.022 MB Memory before query: 3.083 MB Rows returned: 1

SELECT l.virtuemart_product_id  
  FROM `u4gmh_virtuemart_products_en_gb` as l  
  WHERE l.slug = "Core-black-extension-dining-table"

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1333
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1271
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:754
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.61 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.091 MB Rows returned: 1

SELECT l.virtuemart_category_id  
  FROM `u4gmh_virtuemart_categories_en_gb` as l  
  WHERE l.slug = "patio"

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1333
13	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1129
12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:1275
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:754
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 1.40 ms Query memory: 0.022 MB Memory before query: 3.116 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `u4gmh_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.62 ms After last query: 0.25 ms Query memory: 0.005 MB Memory before query: 3.106 MB

UPDATE `u4gmh_extensions`

  SET `params` = '{\"mediaversion\":\"df367b23594948c959d171b668d20454\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.08 ms
updating	0.07 ms
end	0.01 ms
Waiting for query cache lock	0.03 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 8.99 ms After last query: 27.80 ms Query memory: 0.024 MB Memory before query: 3.536 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/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:186
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:975
11	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1093
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 3.560 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 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.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024
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:186
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:975
11	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1093
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 11.27 ms After last query: 1.77 ms Query memory: 0.039 MB Memory before query: 3.596 MB Rows returned: 1

SELECT `u4gmh_virtuemart_products`.* ,`u4gmh_virtuemart_products_en_gb`.*  
  FROM `u4gmh_virtuemart_products` 
  INNER JOIN `u4gmh_virtuemart_products_en_gb` 
  ON `u4gmh_virtuemart_products`.`virtuemart_product_id` = `u4gmh_virtuemart_products_en_gb`.`virtuemart_product_id`  
  WHERE `u4gmh_virtuemart_products`.`virtuemart_product_id` = "6"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1559
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.43 ms After last query: 1.00 ms Query memory: 0.022 MB Memory before query: 3.633 MB Rows returned: 6

SELECT `virtuemart_media_id` 
  FROM `u4gmh_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "6"  
  ORDER BY `ordering`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1582
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.68 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 3.645 MB Rows returned: 1

SELECT * 
  FROM `u4gmh_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "6"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-20 06:27:32" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-20 06:27:32" ) ) 
  ORDER BY `product_price` DESC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1353
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1374
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1618
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.87 ms After last query: 0.83 ms Query memory: 0.022 MB Memory before query: 3.668 MB Rows returned: 1

SELECT `virtuemart_manufacturer_id` 
  FROM `u4gmh_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "6"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1623
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 16.18 ms After last query: 0.31 ms Query memory: 0.023 MB Memory before query: 3.696 MB Rows returned: 1

SELECT `u4gmh_virtuemart_manufacturers`.* ,`u4gmh_virtuemart_manufacturers_en_gb`.*  
  FROM `u4gmh_virtuemart_manufacturers` 
  INNER JOIN `u4gmh_virtuemart_manufacturers_en_gb` 
  ON `u4gmh_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `u4gmh_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id`  
  WHERE `u4gmh_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "3"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u4gmh_virtuemart_manufacturers	const	PRIMARY,virtuemart_manufacturercategories_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u4gmh_virtuemart_manufacturers_en_gb	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1633
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.65 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 3.716 MB Rows returned: 10

SELECT * 
  FROM `u4gmh_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 6

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1929
13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1906
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.98 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 3.741 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "11"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.98 ms After last query: 0.70 ms Query memory: 0.023 MB Memory before query: 3.759 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "12"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.64 ms Query memory: 0.023 MB Memory before query: 3.778 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "13"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 0.71 ms Query memory: 0.024 MB Memory before query: 3.802 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "14"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 0.76 ms Query memory: 0.023 MB Memory before query: 3.823 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "15"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.75 ms After last query: 0.74 ms Query memory: 0.023 MB Memory before query: 3.842 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "16"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.79 ms Query memory: 0.023 MB Memory before query: 3.861 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "17"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.81 ms After last query: 0.75 ms Query memory: 0.023 MB Memory before query: 3.879 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "18"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.98 ms After last query: 0.72 ms Query memory: 0.023 MB Memory before query: 3.898 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "19"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.76 ms After last query: 0.69 ms Query memory: 0.023 MB Memory before query: 3.917 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "20"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1910
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1646
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1118
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 14.00 ms After last query: 1.89 ms Query memory: 0.023 MB Memory before query: 3.945 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	12.94 ms
init	0.07 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.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:157
11	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1213
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 13.42 ms After last query: 1.99 ms Query memory: 0.025 MB Memory before query: 4.064 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:323
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:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2961
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 2.02 ms Query memory: 0.025 MB Memory before query: 4.103 MB Rows returned: 1

SELECT `u4gmh_virtuemart_currencies`.*  
  FROM `u4gmh_virtuemart_currencies`  
  WHERE `u4gmh_virtuemart_currencies`.`virtuemart_currency_id` = "144"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024
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:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2961
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.09 ms After last query: 2.13 ms Query memory: 0.035 MB Memory before query: 4.151 MB Rows returned: 32

SHOW FULL COLUMNS  
  FROM `u4gmh_virtuemart_userfields`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:688
24	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
23	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:211
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:607
19	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
18	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559
17	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:345
16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:232
15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2961
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 0.73 ms Query memory: 0.037 MB Memory before query: 4.189 MB Rows returned: 21

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u4gmh_virtuemart_userfields	ref	published,account	account	1	const	22	100.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:483
17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:386
16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:232
15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2961
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.38 ms After last query: 17.06 ms Query memory: 0.033 MB Memory before query: 4.431 MB Rows returned: 14

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:489
17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:386
16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:232
15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2961
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 16.32 ms After last query: 1.29 ms Query memory: 0.023 MB Memory before query: 4.512 MB Rows returned: 0

SELECT c.* 
  FROM u4gmh_virtuemart_calcs as c  
  LEFT JOIN u4gmh_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 <= "2025-04-20 06:27:32" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-20 06:27:32" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2961
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 7.09 ms Query memory: 0.026 MB Memory before query: 4.533 MB Rows returned: 1

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  u4gmh_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 11

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1044
20	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:1052
19	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:1026
18	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:182
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:79
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 4.544 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1044
21	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:1051
20	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:1052
19	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:1026
18	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:182
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:79
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.98 ms After last query: 0.20 ms Query memory: 0.027 MB Memory before query: 4.569 MB Rows returned: 1

SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `u4gmh_virtuemart_categories`.`virtuemart_category_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
22	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:92
21	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1100
20	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:1067
19	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:1026
18	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:182
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:79
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.74 ms After last query: 0.59 ms Query memory: 0.026 MB Memory before query: 4.598 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
22	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:95
21	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1100
20	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:1067
19	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:1026
18	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:182
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:79
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.37 ms Query memory: 0.026 MB Memory before query: 4.623 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `u4gmh_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "11"  
  ORDER BY `ordering`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
22	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:95
21	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1100
20	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:1067
19	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:1026
18	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:182
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:79
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.66 ms After last query: 3.15 ms Query memory: 0.023 MB Memory before query: 4.667 MB Rows returned: 1

SELECT `u4gmh_virtuemart_medias`.*  
  FROM `u4gmh_virtuemart_medias`  
  WHERE `u4gmh_virtuemart_medias`.`virtuemart_media_id` = "231"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:484
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:92
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.37 ms After last query: 2.69 ms Query memory: 0.022 MB Memory before query: 4.692 MB Rows returned: 1

SELECT count(`p`.virtuemart_product_id) AS total	
	  
  FROM `u4gmh_virtuemart_product_categories` as `pc`
	  
  LEFT JOIN `u4gmh_virtuemart_products` as `p` 
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
	  
  WHERE `pc`.`virtuemart_category_id` = "11"
	  
  AND `p`.`virtuemart_vendor_id` = "1"
	  
  AND `p`.`published` = "1"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	ALL	PRIMARY,virtuemart_vendor_id,published	NO INDEX KEY COULD BE USED	NULL	NULL	125	92.80	Using where
1	SIMPLE	pc	eq_ref	virtuemart_product_id	virtuemart_product_id	8	Sql1238540_1.p.virtuemart_product_id,const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:628
11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:135
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 4.700 MB Rows returned: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `u4gmh_virtuemart_categories` as c  
  LEFT JOIN `u4gmh_virtuemart_categories_en_gb` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 1

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 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.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:998
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:138
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.707 MB Rows returned: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `u4gmh_virtuemart_categories` as c  
  LEFT JOIN `u4gmh_virtuemart_categories_en_gb` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 11

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:998
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:138
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:225
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.91 ms After last query: 19.86 ms Query memory: 0.025 MB Memory before query: 4.844 MB Rows returned: 16

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM u4gmh_modules AS m

  LEFT JOIN u4gmh_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN u4gmh_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-20 06:27:32') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-20 06:27:32') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 560 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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	39	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql1238540_1.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql1238540_1.m.module,const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/theme673/includes/includes.php:94
8	include_once JROOT/templates/theme673/includes/includes.php	JROOT/templates/theme673/component.php:16
7	require JROOT/templates/theme673/component.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

11 × SELECT `u4gmh_virtuemart_categories`.* ,`u4gmh_virtuemart_categories_en_gb`.*  
  FROM `u4gmh_virtuemart_categories` 
  INNER JOIN `u4gmh_virtuemart_categories_en_gb` 
  ON `u4gmh_virtuemart_categories`.`virtuemart_category_id` = `u4gmh_virtuemart_categories_en_gb`.`virtuemart_category_id`

2 × SELECT * 
  FROM `u4gmh_virtuemart_userfields`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `u4gmh_extensions`

2 × SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `u4gmh_virtuemart_categories` as c  
  LEFT JOIN `u4gmh_virtuemart_categories_en_gb` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`

2 × SELECT `virtuemart_media_id` 
  FROM `u4gmh_virtuemart_category_medias`

2 × SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  u4gmh_virtuemart_categories

1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,   c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,   field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`   
  FROM `u4gmh_virtuemart_customs` AS c 
  LEFT JOIN `u4gmh_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `u4gmh_virtuemart_product_manufacturers`

1 × SELECT `u4gmh_virtuemart_manufacturers`.* ,`u4gmh_virtuemart_manufacturers_en_gb`.*  
  FROM `u4gmh_virtuemart_manufacturers` 
  INNER JOIN `u4gmh_virtuemart_manufacturers_en_gb` 
  ON `u4gmh_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `u4gmh_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id`

1 × SELECT * 
  FROM `u4gmh_virtuemart_product_categories`

1 × SELECT `data` 
  FROM `u4gmh_session`

1 × SELECT *  
  FROM `u4gmh_virtuemart_currencies` AS c    
  LEFT JOIN `u4gmh_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 × SELECT `u4gmh_virtuemart_currencies`.*  
  FROM `u4gmh_virtuemart_currencies`

1 × SELECT `virtuemart_media_id` 
  FROM `u4gmh_virtuemart_product_medias`

1 × SELECT c.* 
  FROM u4gmh_virtuemart_calcs as c  
  LEFT JOIN u4gmh_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT `u4gmh_virtuemart_medias`.*  
  FROM `u4gmh_virtuemart_medias`

1 × SELECT count(`p`.virtuemart_product_id) AS total     
  FROM `u4gmh_virtuemart_product_categories` as `pc`    
  LEFT JOIN `u4gmh_virtuemart_products` as `p` 
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id

1 × SELECT * 
  FROM `u4gmh_virtuemart_product_prices`

1 × SELECT `u4gmh_virtuemart_products`.* ,`u4gmh_virtuemart_products_en_gb`.*  
  FROM `u4gmh_virtuemart_products` 
  INNER JOIN `u4gmh_virtuemart_products_en_gb` 
  ON `u4gmh_virtuemart_products`.`virtuemart_product_id` = `u4gmh_virtuemart_products_en_gb`.`virtuemart_product_id`

1 × SELECT `session_id` 
  FROM `u4gmh_session`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `u4gmh_assets`

1 × SELECT id, rules 
  FROM `u4gmh_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM u4gmh_extensions

1 × SELECT * 
  FROM u4gmh_loginradius_setting

1 × SELECT `config` 
  FROM `u4gmh_virtuemart_configs`

```
1 × SELECT * 
  FROM u4gmh_languages
```

1 × 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 u4gmh_menu AS m 
  LEFT JOIN u4gmh_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `u4gmh_virtuemart_shoppergroups`.*  
  FROM `u4gmh_virtuemart_shoppergroups`

1 × SELECT * 
  FROM u4gmh_komento_configs

1 × SELECT id, home, template, s.params 
  FROM u4gmh_template_styles as s 
  LEFT JOIN u4gmh_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM `u4gmh_menu`
```

1 × SELECT l.virtuemart_product_id  
  FROM `u4gmh_virtuemart_products_en_gb` as l

1 × SELECT l.virtuemart_category_id  
  FROM `u4gmh_virtuemart_categories_en_gb` as l

1 × SELECT * 
  FROM `u4gmh_virtuemart_shoppergroups`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM u4gmh_modules AS m 
  LEFT JOIN u4gmh_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN u4gmh_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

OTHER Tables:

1 × INSERT INTO `u4gmh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3938306562346639366362316230643733346264353434333032623762666134', 1, 1745130452, 0, '', 0

1 × SHOW TABLES LIKE "u4gmh_virtuemart_configs

1 × SHOW FULL COLUMNS 
  FROM `u4gmh_komento_configs

1 × UPDATE `u4gmh_extensions` 
  SET `params` = '{\"mediaversion\":\"df367b23594948c959d171b668d20454\"}'

1 × SHOW FULL COLUMNS  
  FROM `u4gmh_virtuemart_userfields

Ask a question

Core black extension dining table

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

56 Queries Logged 223.30 ms

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: