Author Details

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1781800881,
                "last": 1781800881,
                "now": 1781800881
            },
            "token": "chwy5U5gTGu5BnfE2OxAG2NBuNfQwYBP"
        },
        "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,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":1,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":{\"virtuemart_country_id\":223},\"ST\":{\"virtuemart_country_id\":223},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":\"144\",\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":{\"virtuemart_country_id\":1},\"byDefaultST\":{\"virtuemart_country_id\":1},\"productCartLoaded\":[],\"loadedCart\":true}"
    },
    "__com_awocoupon": {
        "site": {
            "virtuemart_use_injection_mode": 0,
            "coupon_auto": 0
        }
    }
}

Profile Information

Time

Memory

Time: 102.52 ms / 102.52 ms Memory: 1.766 MB / 2.15 MB Application: afterLoad

Time: 499.41 ms / 601.92 ms Memory: 4.182 MB / 6.33 MB Application: afterInitialise

Time: 198.72 ms / 800.64 ms Memory: 1.978 MB / 8.31 MB Application: Before Access::preloadComponents (all components)

Time: 1.20 ms / 801.84 ms Memory: 0.070 MB / 8.38 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 801.88 ms Memory: -0.000 MB / 8.38 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.69 ms / 802.56 ms Memory: 0.025 MB / 8.40 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.03 ms / 802.60 ms Memory: 0.001 MB / 8.41 MB Application: Before Access::getAssetRules (id:54 name:com_virtuemart)

Time: 0.03 ms / 802.63 ms Memory: 0.001 MB / 8.41 MB Application: After Access::getAssetRules (id:54 name:com_virtuemart)

Time: 90.11 ms / 892.73 ms Memory: 0.110 MB / 8.52 MB Application: afterRoute

Time: 6.05 ms / 898.78 ms Memory: 0.222 MB / 8.74 MB Application: beforeRenderComponent com_virtuemart

Time: 403.70 ms / 1302.48 ms Memory: 3.605 MB / 12.34 MB Application: afterRenderComponent com_virtuemart

Time: 2.03 ms / 1304.51 ms Memory: 0.097 MB / 12.44 MB Application: afterDispatch

Time: 194.73 ms / 1499.24 ms Memory: 0.425 MB / 12.87 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 197.54 ms / 1696.78 ms Memory: 0.368 MB / 13.24 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.15 ms / 1696.94 ms Memory: -0.004 MB / 13.23 MB Application: beforeRenderModule mod_menu (My Account)

Time: 1.46 ms / 1698.40 ms Memory: 0.017 MB / 13.25 MB Application: afterRenderModule mod_menu (My Account)

Time: 0.04 ms / 1698.44 ms Memory: -0.002 MB / 13.25 MB Application: beforeRenderModule mod_menu (Informations)

Time: 94.84 ms / 1793.28 ms Memory: 0.024 MB / 13.27 MB Application: afterRenderModule mod_menu (Informations)

Time: 0.08 ms / 1793.36 ms Memory: -0.002 MB / 13.27 MB Application: beforeRenderModule mod_custom (Secure payments)

Time: 0.76 ms / 1794.11 ms Memory: 0.006 MB / 13.27 MB Application: afterRenderModule mod_custom (Secure payments)

Time: 0.04 ms / 1794.15 ms Memory: -0.001 MB / 13.27 MB Application: beforeRenderModule mod_custom (Contact)

Time: 0.25 ms / 1794.40 ms Memory: 0.003 MB / 13.27 MB Application: afterRenderModule mod_custom (Contact)

Time: 0.10 ms / 1794.49 ms Memory: -0.001 MB / 13.27 MB Application: beforeRenderModule mod_virtuemart_category (Categories)

Time: 4.29 ms / 1798.79 ms Memory: 0.301 MB / 13.58 MB Application: afterRenderModule mod_virtuemart_category (Categories)

Time: 0.04 ms / 1798.83 ms Memory: -0.001 MB / 13.57 MB Application: beforeRenderModule mod_virtuemart_product (Recently Viewed)

Time: 100.36 ms / 1899.19 ms Memory: 0.463 MB / 14.04 MB Application: afterRenderModule mod_virtuemart_product (Recently Viewed)

Time: 93.26 ms / 1992.45 ms Memory: -0.004 MB / 14.03 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.13 ms / 1993.58 ms Memory: 0.022 MB / 14.06 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.09 ms / 1993.67 ms Memory: -0.003 MB / 14.05 MB Application: beforeRenderModule mod_virtuemart_cart (VM - Shopping cart)

Time: 1502.25 ms / 3495.92 ms Memory: 7.817 MB / 21.87 MB Application: afterRenderModule mod_virtuemart_cart (VM - Shopping cart)

Time: 0.07 ms / 3495.99 ms Memory: -0.003 MB / 21.87 MB Application: beforeRenderModule mod_virtuemart_search (VM - Search in Shop)

Time: 0.76 ms / 3496.75 ms Memory: 0.012 MB / 21.88 MB Application: afterRenderModule mod_virtuemart_search (VM - Search in Shop)

Time: 0.05 ms / 3496.80 ms Memory: -0.002 MB / 21.88 MB Application: beforeRenderModule mod_login (Login Form)

Time: 3.89 ms / 3500.69 ms Memory: 0.246 MB / 22.12 MB Application: afterRenderModule mod_login (Login Form)

Time: 0.04 ms / 3500.74 ms Memory: -0.002 MB / 22.12 MB Application: beforeRenderModule mod_menu (Menu Topper (real))

Time: 1.29 ms / 3502.03 ms Memory: 0.055 MB / 22.17 MB Application: afterRenderModule mod_menu (Menu Topper (real))

Time: 94.09 ms / 3596.12 ms Memory: 0.311 MB / 22.49 MB Application: afterRender

Database queries total: 474.67 ms

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ttcmy_session	const	PRIMARY	PRIMARY	194	const	1	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:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:49

EXPLAIN not possible on query: INSERT INTO `ttcmy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3835636135323531656564313839613766363463306333656363613538643162', 1, 1781800881, 0, '', 0)

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.04 ms
Update	0.17 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.09 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.02 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:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:49

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

Query Time: 1.26 ms After last query: 3.55 ms Query memory: 0.022 MB Memory before query: 4.289 MB Rows returned: 50

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

  FROM `ttcmy_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::{closure:Joomla\CMS\Component\ComponentHelper::load():434}()	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:52

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

Query Time: 0.98 ms After last query: 93.06 ms Query memory: 0.020 MB Memory before query: 4.469 MB Rows returned: 5

SELECT id, rules

  FROM `ttcmy_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.01 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 4.479 MB Rows returned: 2

SELECT b.id

  FROM ttcmy_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
table lock	0.04 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.04 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:52

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

Query Time: 1.66 ms After last query: 1.16 ms Query memory: 0.022 MB Memory before query: 4.547 MB Rows returned: 112

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

  FROM ttcmy_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	Extra
1	SIMPLE	ttcmy_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	289	Using where; Using filesort

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	0.77 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.02 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::{closure:Joomla\CMS\Plugin\PluginHelper::load():323}()	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:52

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

Query Time: 88.15 ms After last query: 204.91 ms Query memory: 0.072 MB Memory before query: 6.528 MB Rows returned: 68

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

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

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

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.05 ms
table lock	0.05 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.07 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.54 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.02 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->{closure:Joomla\CMS\Menu\SiteMenu::load():77}()	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:417
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:533
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:1141
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:52

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

Query Time: 1.04 ms After last query: 104.85 ms Query memory: 0.023 MB Memory before query: 8.122 MB Rows returned: 1

SHOW TABLES LIKE "ttcmy_virtuemart_configs"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:763
15	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:578
14	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:417
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:190
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:125
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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

[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.76 ms Query memory: 0.022 MB Memory before query: 8.231 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:457
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:190
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:125
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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 0.89 ms After last query: 1.08 ms Query memory: 0.025 MB Memory before query: 8.315 MB Rows returned: 50

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

  FROM `ttcmy_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_awocoupon','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyorderexport','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_jsecure','com_languages','com_login','com_mailcatcher','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_search','com_spupgrade','com_tags','com_tcpdf','com_templates','com_uniterevolution2','com_users','com_virtuemart','com_virtuemart_allinone','com_vm_products_csv','com_webfonts','com_widgetkit','com_wrapper','com_xlsoutput')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
15	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:479
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:190
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:125
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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

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

SELECT *

  FROM ttcmy_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
16	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:100
15	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:65
14	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:483
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:190
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:125
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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 0.75 ms After last query: 0.50 ms Query memory: 0.022 MB Memory before query: 8.481 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM ttcmy_template_styles as s

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:211
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:125
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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.02 ms After last query: 0.31 ms Query memory: 0.054 MB Memory before query: 8.501 MB Rows returned: 53

SELECT * 
  FROM `ttcmy_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	Extra
1	SIMPLE	ttcmy_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	155	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1594
14	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:272
13	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:254
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:125
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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 84.51 ms After last query: 0.50 ms Query memory: 0.022 MB Memory before query: 8.523 MB Rows returned: 0

SELECT l.virtuemart_manufacturer_id  
  FROM `ttcmy_virtuemart_manufacturers_en_gb` as l  
  WHERE l.slug = "books"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1522
13	vmrouterHelper::getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1481
12	vmrouterHelper::getManufacturerId()	JROOT/components/com_virtuemart/router.php:988
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:128
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:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 0.90 ms After last query: 1.16 ms Query memory: 0.022 MB Memory before query: 8.554 MB Rows returned: 1

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

  FROM `ttcmy_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::{closure:Joomla\CMS\Helper\LibraryHelper::loadLibrary():157}()	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:52

[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.22 ms Query memory: 0.005 MB Memory before query: 8.545 MB

UPDATE `ttcmy_extensions`

  SET `params` = '{\"mediaversion\":\"6349bac8132b6a6f70dd9b5c9015a650\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.04 ms
table lock	0.03 ms
init for update	0.10 ms
Updating	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.04 ms
Query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.02 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:52

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

Query Time: 0.70 ms After last query: 99.55 ms Query memory: 0.021 MB Memory before query: 9.563 MB Rows returned: 0

SELECT `virtuemart_media_id` 
  FROM `ttcmy_virtuemart_manufacturer_medias` 
  WHERE `virtuemart_manufacturer_id` = "0"  
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ttcmy_virtuemart_manufacturer_medias	ref	virtuemart_manufacturer_id	virtuemart_manufacturer_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:58
10	VirtueMartModelManufacturer->getManufacturer()	JROOT/components/com_virtuemart/views/manufacturer/view.html.php:44
9	VirtuemartViewManufacturer->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
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:52

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

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ttcmy_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
16	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:138
15	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
14	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
13	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:175
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:86
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:76
10	VmView->display()	JROOT/components/com_virtuemart/views/manufacturer/view.html.php:98
9	VirtuemartViewManufacturer->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
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:52

[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.17 ms Query memory: 0.024 MB Memory before query: 11.534 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
19	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1132
18	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
17	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:108
16	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:138
15	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
14	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
13	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:175
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:86
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:76
10	VmView->display()	JROOT/components/com_virtuemart/views/manufacturer/view.html.php:98
9	VirtuemartViewManufacturer->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
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:52

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

Query Time: 1.47 ms After last query: 4.22 ms Query memory: 0.026 MB Memory before query: 11.737 MB Rows returned: 32

SHOW FULL COLUMNS  
  FROM `ttcmy_virtuemart_userfields`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
22	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:724
21	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
20	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:210
19	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:433
18	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:395
17	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:607
16	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
15	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559
14	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:350
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:86
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:76
10	VmView->display()	JROOT/components/com_virtuemart/views/manufacturer/view.html.php:98
9	VirtuemartViewManufacturer->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
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:52

[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.27 ms Query memory: 0.024 MB Memory before query: 11.773 MB Rows returned: 16

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:504
16	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:603
15	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:483
14	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:391
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:86
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:76
10	VmView->display()	JROOT/components/com_virtuemart/views/manufacturer/view.html.php:98
9	VirtuemartViewManufacturer->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
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:52

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

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

SELECT `ttcmy_virtuemart_countries`.*  
  FROM `ttcmy_virtuemart_countries`  
  WHERE `ttcmy_virtuemart_countries`.`virtuemart_country_id` = "223"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/userfields.php:865
14	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:393
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:86
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:76
10	VmView->display()	JROOT/components/com_virtuemart/views/manufacturer/view.html.php:98
9	VirtuemartViewManufacturer->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
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:52

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

Query Time: 0.96 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 12.052 MB Rows returned: 10

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:504
16	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:603
15	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:489
14	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:391
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:86
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:76
10	VmView->display()	JROOT/components/com_virtuemart/views/manufacturer/view.html.php:98
9	VirtuemartViewManufacturer->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
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:52

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

Query Time: 1.16 ms After last query: 200.12 ms Query memory: 0.023 MB Memory before query: 12.812 MB Rows returned: 12

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

  FROM ttcmy_modules AS m

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

  LEFT JOIN ttcmy_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 <= '2026-06-18 16:41:22') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-18 16:41:22') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 294 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.08 ms After last query: 501.87 ms Query memory: 0.024 MB Memory before query: 15.140 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:323
18	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
17	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:83
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:110
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2247
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

[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.91 ms Query memory: 0.024 MB Memory before query: 15.209 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.05 ms
closing tables	0.04 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	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:1093
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1132
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:83
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:110
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2247
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.12 ms After last query: 90.99 ms Query memory: 0.023 MB Memory before query: 15.291 MB Rows returned: 0

SELECT c.* 
  FROM ttcmy_virtuemart_calcs as c  
  LEFT JOIN ttcmy_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id  
  LEFT JOIN ttcmy_virtuemart_calc_countries as cc 
  ON cc.virtuemart_calc_id=c.virtuemart_calc_id  
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) OR  ( ISNULL("publish_up") or publish_up="0000-00-00 00:00:00")  OR publish_up <= "2026-06-18 16:41:22" )
				
  AND ( ISNULL(publish_down) OR  ( ISNULL("publish_down") or publish_down="0000-00-00 00:00:00")  OR publish_down >= "2026-06-18 16:41:22" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
 
  AND ( virtuemart_country_id = "223" OR (virtuemart_country_id) IS NULL)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:176
16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:110
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2247
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 0.82 ms After last query: 2.88 ms Query memory: 0.023 MB Memory before query: 15.515 MB Rows returned: 0

SELECT * 
  FROM ttcmy_virtuemart_calcs  
  LEFT JOIN ttcmy_virtuemart_calc_shoppergroups using(virtuemart_calc_id) 
  LEFT JOIN ttcmy_virtuemart_calc_countries using(virtuemart_calc_id) 
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-06-18 16:41:22" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-06-18 16:41:22" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
 
  AND ( virtuemart_country_id = 223 OR (virtuemart_country_id) IS NULL)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1517
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:774
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

[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.05 ms Query memory: 0.023 MB Memory before query: 15.523 MB Rows returned: 1

SELECT * 
  FROM ttcmy_virtuemart_calcs  
  LEFT JOIN ttcmy_virtuemart_calc_shoppergroups using(virtuemart_calc_id) 
  LEFT JOIN ttcmy_virtuemart_calc_countries using(virtuemart_calc_id) 
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-06-18 16:41:22" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-06-18 16:41:22" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
 
  AND ( virtuemart_country_id = 223 OR (virtuemart_country_id) IS NULL)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ttcmy_virtuemart_calcs	system	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	ttcmy_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
1	SIMPLE	ttcmy_virtuemart_calc_countries	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1517
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.06 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 15.539 MB Rows returned: 1

SELECT `ttcmy_virtuemart_calcs`.*  
  FROM `ttcmy_virtuemart_calcs`  
  WHERE `ttcmy_virtuemart_calcs`.`virtuemart_calc_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/calc.php:58
16	VirtueMartModelCalc->getCalc()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 0.91 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 15.565 MB Rows returned: 0

SELECT `virtuemart_category_id` 
  FROM `ttcmy_virtuemart_calc_categories` 
  WHERE `virtuemart_calc_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
17	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/calc.php:61
16	VirtueMartModelCalc->getCalc()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

[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.20 ms Query memory: 0.024 MB Memory before query: 15.588 MB Rows returned: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `ttcmy_virtuemart_calc_shoppergroups` 
  WHERE `virtuemart_calc_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
17	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/calc.php:64
16	VirtueMartModelCalc->getCalc()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 0.88 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 15.609 MB Rows returned: 1

SELECT `virtuemart_country_id` 
  FROM `ttcmy_virtuemart_calc_countries` 
  WHERE `virtuemart_calc_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
17	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/calc.php:67
16	VirtueMartModelCalc->getCalc()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 89.19 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 15.635 MB Rows returned: 1

SELECT `virtuemart_state_id` 
  FROM `ttcmy_virtuemart_calc_states` 
  WHERE `virtuemart_calc_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
17	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/calc.php:70
16	VirtueMartModelCalc->getCalc()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 0.94 ms After last query: 0.47 ms Query memory: 0.024 MB Memory before query: 15.656 MB Rows returned: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `ttcmy_virtuemart_calc_manufacturers` 
  WHERE `virtuemart_calc_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
17	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/calc.php:73
16	VirtueMartModelCalc->getCalc()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.19 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 15.657 MB Rows returned: 0

SELECT * 
  FROM ttcmy_virtuemart_calcs  
  LEFT JOIN ttcmy_virtuemart_calc_shoppergroups using(virtuemart_calc_id) 
  LEFT JOIN ttcmy_virtuemart_calc_countries using(virtuemart_calc_id) 
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-06-18 16:41:22" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-06-18 16:41:22" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
 
  AND ( virtuemart_country_id = 223 OR (virtuemart_country_id) IS NULL)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1517
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:776
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 93.87 ms After last query: 1004.06 ms Query memory: 0.026 MB Memory before query: 20.279 MB Rows returned: 54

SELECT id,name,is_json,value 
  FROM ttcmy_awocoupon_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_awocoupon/helper/class-awocoupon-helper-database.php:25
20	AwoCoupon_Helper_Database->get_objectlist()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-param.php:31
19	Awocoupon_Library_Param->__construct()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-helper.php:460
18	AwoCoupon_Library_Helper->new_class()	JROOT/administrator/components/com_awocoupon/helper/awocoupon.php:73
17	AwoCoupon->init()	JROOT/plugins/vmpayment/awocoupon/awocoupon.php:51
16	plgVmPaymentAwoCoupon->plgVmgetPaymentCurrency()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
13	vDispatcher::trigger()	JROOT/components/com_virtuemart/helpers/cart.php:2363
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 2.64 ms After last query: 109.36 ms Query memory: 0.025 MB Memory before query: 21.648 MB Rows returned: 1

SHOW FULL COLUMNS 
  FROM ttcmy_awocoupon LIKE "coupon_code"

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM ttcmy_awocoupon LIKE "coupon_code"

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_awocoupon/helper/class-awocoupon-helper-database.php:32
22	AwoCoupon_Helper_Database->get_object()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-coupon.php:330
21	AwoCoupon_Library_Coupon->is_case_sensitive()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-discount.php:84
20	AwoCoupon_Library_Discount->__construct()	JROOT/administrator/components/com_awocoupon/helper/estore/virtuemart/class-awocoupon-helper-estore-virtuemart-discount.php:39
19	AwoCoupon_Helper_Estore_Virtuemart_Discount->__construct()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-helper.php:460
18	AwoCoupon_Library_Helper->new_class()	JROOT/administrator/components/com_awocoupon/helper/awocoupon.php:91
17	AwoCoupon->init()	JROOT/plugins/vmpayment/awocoupon/awocoupon.php:51
16	plgVmPaymentAwoCoupon->plgVmgetPaymentCurrency()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
13	vDispatcher::trigger()	JROOT/components/com_virtuemart/helpers/cart.php:2363
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

Query Time: 1.51 ms After last query: 88.73 ms Query memory: 0.024 MB Memory before query: 21.803 MB Rows returned: 0

SELECT c.id,c.coupon_code,c.num_of_uses_total,c.num_of_uses_customer,c.coupon_value_type,c.coupon_value,c.min_value,c.discount_type,
					c.function_type,c.coupon_value_def,c.params,1 as isauto,note,c.state,0 as balance
				  
  FROM ttcmy_awocoupon c
				  JOIN ttcmy_awocoupon_auto a 
  ON a.coupon_id=c.id
				 
  WHERE c.estore="virtuemart" 
  AND c.state="published" 
  AND a.published=1
				   
  AND ( (c.startdate IS NULL 
  AND c.expiration IS NULL) OR
						 (c.expiration IS NULL 
  AND c.startdate<="2026-06-18 16:41:22") OR
						 (c.startdate IS NULL 
  AND c.expiration>="2026-06-18 16:41:22") OR
						 (c.startdate<="2026-06-18 16:41:22"      
  AND c.expiration>="2026-06-18 16:41:22")
					   )
				 
  ORDER BY a.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	bbusaorg_joomla.a.coupon_id	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.05 ms
System lock	0.06 ms
table lock	0.06 ms
init	0.10 ms
Optimizing	0.08 ms
Statistics	0.07 ms
Preparing	0.09 ms
Sorting result	0.06 ms
Executing	0.06 ms
Sending data	0.06 ms
Creating sort index	0.09 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.04 ms
Query end	0.07 ms
closing tables	0.04 ms
Unlocking tables	0.04 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.05 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_awocoupon/helper/class-awocoupon-helper-database.php:22
19	AwoCoupon_Helper_Database->get_objectlist()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-discount.php:167
18	AwoCoupon_Library_Discount->process_autocoupon_helper()	JROOT/administrator/components/com_awocoupon/helper/estore/virtuemart/class-awocoupon-helper-estore-virtuemart-discount.php:281
17	AwoCoupon_Helper_Estore_Virtuemart_Discount->cart_coupon_validate_auto()	JROOT/plugins/vmpayment/awocoupon/awocoupon.php:52
16	plgVmPaymentAwoCoupon->plgVmgetPaymentCurrency()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
13	vDispatcher::trigger()	JROOT/components/com_virtuemart/helpers/cart.php:2363
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:52

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

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT * 
  FROM ttcmy_virtuemart_calcs  
  LEFT JOIN ttcmy_virtuemart_calc_shoppergroups using(virtuemart_calc_id) 
  LEFT JOIN ttcmy_virtuemart_calc_countries using(virtuemart_calc_id)

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

2 × SELECT * 
  FROM `ttcmy_virtuemart_userfields`

1 × SELECT `data` 
  FROM `ttcmy_session`

1 × SELECT `session_id` 
  FROM `ttcmy_session`

1 × SELECT id, rules 
  FROM `ttcmy_viewlevels

1 × SELECT b.id 
  FROM ttcmy_usergroups AS a 
  LEFT JOIN ttcmy_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 ttcmy_extensions

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 ttcmy_menu AS m 
  LEFT JOIN ttcmy_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `config` 
  FROM `ttcmy_virtuemart_configs`

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

```
1 × SELECT * 
  FROM ttcmy_languages
```

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

```
1 × SELECT * 
  FROM `ttcmy_menu`
```

1 × SELECT l.virtuemart_manufacturer_id  
  FROM `ttcmy_virtuemart_manufacturers_en_gb` as l

1 × SELECT `virtuemart_media_id` 
  FROM `ttcmy_virtuemart_manufacturer_medias`

1 × SELECT * 
  FROM `ttcmy_virtuemart_shoppergroups`

1 × SELECT `ttcmy_virtuemart_shoppergroups`.*  
  FROM `ttcmy_virtuemart_shoppergroups`

1 × SELECT `ttcmy_virtuemart_countries`.*  
  FROM `ttcmy_virtuemart_countries`

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

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

1 × SELECT `ttcmy_virtuemart_currencies`.*  
  FROM `ttcmy_virtuemart_currencies`

1 × SELECT c.* 
  FROM ttcmy_virtuemart_calcs as c  
  LEFT JOIN ttcmy_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id  
  LEFT JOIN ttcmy_virtuemart_calc_countries as cc 
  ON cc.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT `ttcmy_virtuemart_calcs`.*  
  FROM `ttcmy_virtuemart_calcs`

1 × SELECT `virtuemart_category_id` 
  FROM `ttcmy_virtuemart_calc_categories`

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM `ttcmy_virtuemart_calc_shoppergroups`

1 × SELECT `virtuemart_country_id` 
  FROM `ttcmy_virtuemart_calc_countries`

1 × SELECT `virtuemart_state_id` 
  FROM `ttcmy_virtuemart_calc_states`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `ttcmy_virtuemart_calc_manufacturers`

1 × SELECT id,name,is_json,value 
  FROM ttcmy_awocoupon_confi

1 × SELECT c.id,c.coupon_code,c.num_of_uses_total,c.num_of_uses_customer,c.coupon_value_type,c.coupon_value,c.min_value,c.discount_type,      c.function_type,c.coupon_value_def,c.params,1 as isauto,note,c.state,0 as balance       
  FROM ttcmy_awocoupon c       JOIN ttcmy_awocoupon_auto a 
  ON a.coupon_id=c.id

OTHER Tables:

1 × INSERT INTO `ttcmy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3835636135323531656564313839613766363463306333656363613538643162', 1, 1781800881, 0, '', 0

1 × SHOW TABLES LIKE "ttcmy_virtuemart_configs

1 × UPDATE `ttcmy_extensions` 
  SET `params` = '{\"mediaversion\":\"6349bac8132b6a6f70dd9b5c9015a650\"}'

1 × SHOW FULL COLUMNS  
  FROM `ttcmy_virtuemart_userfields

1 × SHOW FULL COLUMNS 
  FROM ttcmy_awocoupon LIKE "coupon_code

My Account

Informations

Secure payments

Contact

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

40 Queries Logged 474.67 ms

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: