Query Time: 1.91 ms Query memory: 0.022 MB Memory before query: 0.655 MB Rows returned: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '2c23ff89ae46049f0ddd79f51019f65a'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:44 |
| 12 | JSessionStorageDatabase->read() | Same as call in the line below. |
| 11 | session_start() | JROOT/libraries/joomla/session/handler/native.php:259 |
| 10 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:49 |
| 9 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:81 |
| 8 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:636 |
| 7 | JSession->_start() | JROOT/libraries/joomla/session/session.php:596 |
| 6 | JSession->start() | JROOT/libraries/cms/application/cms.php:773 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 9.54 ms After last query: 0.42 ms Query memory: 0.019 MB Memory before query: 0.672 MB Rows returned: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '2c23ff89ae46049f0ddd79f51019f65a'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 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.03 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.01 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:799 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 2.66 ms After last query: 0.11 ms Query memory: 0.003 MB Memory before query: 0.676 MB
INSERT INTO `jos_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES
('2c23ff89ae46049f0ddd79f51019f65a', 0, 1, '1714210740', 0, '')
EXPLAIN not possible on query: INSERT INTO `jos_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('2c23ff89ae46049f0ddd79f51019f65a', 0, 1, '1714210740', 0, '')
| Status | Duration |
|---|
| Starting | 0.18 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.01 ms |
| Update | 0.17 ms |
| Waiting for query cache lock | 0.02 ms |
| Update | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 1.81 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:212 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:799 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Query Time: 1.03 ms After last query: 0.47 ms Query memory: 0.023 MB Memory before query: 0.699 MB Rows returned: 38
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 38 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.25 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:448 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:120 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:589 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 0.38 ms Query memory: 0.021 MB Memory before query: 0.720 MB Rows returned: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| 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 |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:835 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:904 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 0.725 MB Rows returned: 5
SELECT id, rules
FROM `jos_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:921 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.25 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 0.733 MB Rows returned: 74
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 238 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.38 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:310 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.46 ms After last query: 3.55 ms Query memory: 0.022 MB Memory before query: 1.267 MB Rows returned: 12
SELECT *
FROM jos_loginradius_settings
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_loginradius_settings | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 10 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58 |
| 9 | plgSystemSocialLoginTools::sociallogin_getsettings() | JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51 |
| 8 | plgSystemSocialLoginAndSocialShare->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.03 ms After last query: 1.24 ms Query memory: 0.022 MB Memory before query: 1.347 MB Rows returned: 1
SHOW TABLES LIKE "jos_virtuemart_configs"
EXPLAIN not possible on query: SHOW TABLES LIKE "jos_virtuemart_configs"
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.01 ms |
| checking permissions | 0.53 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 11 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/models/config.php:533 |
| 10 | VirtueMartModelConfig::checkConfigTableExists() | JROOT/administrator/components/com_virtuemart/helpers/config.php:883 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.30 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 1.352 MB Rows returned: 1
SELECT `config`
FROM `jos_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_configs | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 10 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/config.php:931 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.25 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 1.412 MB Rows returned: 1
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:164 |
| 12 | JLanguageHelper::getLanguages() | JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:92 |
| 11 | vmLanguage::setLanguageByTag() | JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:69 |
| 10 | vmLanguage::initialise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:952 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.49 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 1.506 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `jos_assets`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_assets`
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.01 ms |
| Opening tables | 0.60 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| checking permissions | 0.07 ms |
| closing tables | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.20 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 18 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 17 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
| 16 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 15 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:696 |
| 14 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 12 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1265 |
| 11 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:640 |
| 10 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:953 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.21 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 1.528 MB Rows returned: 1
SELECT *
FROM jos_assets
WHERE `id` = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_assets | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 15 | JTable->load() | JROOT/libraries/joomla/access/access.php:697 |
| 14 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 12 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1265 |
| 11 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:640 |
| 10 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:953 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.15 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 1.534 MB Rows returned: 1
SELECT a.rules
FROM jos_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_asset_name | PRIMARY,idx_asset_name | 4,202 | NULL | 2 | Using union(PRIMARY,idx_asset_name); Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
| 13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 12 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1265 |
| 11 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:640 |
| 10 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:953 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.19 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 1.542 MB Rows returned: 1
SELECT id
FROM jos_assets
WHERE parent_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_assets | ref | idx_parent_id | idx_parent_id | 4 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.10 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/table/nested.php:1210 |
| 14 | JTableNested->getRootId() | JROOT/libraries/joomla/access/access.php:158 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 12 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1265 |
| 11 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:640 |
| 10 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:953 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.27 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 1.550 MB Rows returned: 1
SELECT a.rules
FROM jos_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_asset_name | PRIMARY,idx_asset_name | 4,202 | NULL | 2 | Using union(PRIMARY,idx_asset_name); Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
| 14 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:176 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 12 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1265 |
| 11 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:640 |
| 10 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:953 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.54 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 1.566 MB Rows returned: 38
SELECT element
FROM jos_extensions
WHERE type = 'component'
AND enabled = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 38 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:413 |
| 15 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 14 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 12 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1265 |
| 11 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:640 |
| 10 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:953 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.91 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 1.580 MB Rows returned: 38
SELECT a.name, a.rules
FROM jos_assets AS a
WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_socialloginandsocialshare','com_tags','com_tcpdf','com_templates','com_tmbox','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper') OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 170 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.10 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 16 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:441 |
| 15 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 14 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 12 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1265 |
| 11 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:640 |
| 10 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:953 |
| 9 | VmConfig::loadConfig() | JROOT/plugins/system/vm3_cart/vm3_cart.php:23 |
| 8 | plgSystemVM3_Cart->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.44 ms After last query: 1.17 ms Query memory: 0.070 MB Memory before query: 1.805 MB Rows returned: 51
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| 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 | 64 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | bktradingvm.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.32 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.24 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
| 14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:145 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:439 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:57 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:197 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:535 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:407 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1115 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.21 ms After last query: 2.06 ms Query memory: 0.025 MB Memory before query: 2.135 MB Rows returned: 2
SHOW FULL COLUMNS
FROM `jos_komento_configs`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_komento_configs`
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.01 ms |
| Opening tables | 0.48 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| checking permissions | 0.04 ms |
| closing tables | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.17 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 16 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 15 | JTable->__construct() | JROOT/administrator/components/com_komento/tables/parent.php:18 |
| 14 | KomentoParentTable->__construct() | JROOT/administrator/components/com_komento/tables/configs.php:40 |
| 13 | KomentoTableConfigs->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 12 | JTable::getInstance() | JROOT/administrator/components/com_komento/tables/parent.php:49 |
| 11 | KomentoParentTable::getInstance() | JROOT/components/com_komento/helpers/helper.php:99 |
| 10 | Komento::getTable() | JROOT/components/com_komento/helpers/helper.php:228 |
| 9 | Komento::getKonfig() | JROOT/components/com_komento/bootstrap.php:30 |
| 8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:16 |
| 7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/cms/router/site.php:738 |
| 6 | JRouterSite->getComponentRouter() | JROOT/libraries/cms/router/site.php:123 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1116 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.21 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.149 MB Rows returned: 1
SELECT *
FROM jos_komento_configs
WHERE `component` = 'com_komento'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_komento_configs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 10 | JTable->load() | JROOT/components/com_komento/helpers/helper.php:229 |
| 9 | Komento::getKonfig() | JROOT/components/com_komento/bootstrap.php:30 |
| 8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:16 |
| 7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/cms/router/site.php:738 |
| 6 | JRouterSite->getComponentRouter() | JROOT/libraries/cms/router/site.php:123 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1116 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 2.01 ms After last query: 2.23 ms Query memory: 0.022 MB Memory before query: 2.312 MB Rows returned: 3
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.35 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:484 |
| 13 | JApplicationSite->getTemplate() | JROOT/components/com_virtuemart/router.php:776 |
| 12 | vmrouterHelper->__construct() | JROOT/components/com_virtuemart/router.php:822 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:345 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:408 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:482 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:235 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:131 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1116 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.18 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 2.323 MB Rows returned: 1
SELECT `id`
FROM `jos_menu`
WHERE `home`="1"
and (language="*" or language = "en-GB" )
ORDER BY `language` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_menu | ALL | idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 123 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.07 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 13 | JDatabaseDriver->loadResult() | JROOT/components/com_virtuemart/router.php:787 |
| 12 | vmrouterHelper->__construct() | JROOT/components/com_virtuemart/router.php:822 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:345 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:408 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:482 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:235 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:131 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1116 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.046 MB Memory before query: 2.330 MB Rows returned: 13
SELECT *
FROM `jos_menu`
WHERE `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "en-GB" )
AND ( access="1" OR access="5" )
ORDER BY `language` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_menu | ALL | idx_client_id_parent_id_alias_language,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 123 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_virtuemart/router.php:1198 |
| 13 | vmrouterHelper->setMenuItemId() | JROOT/components/com_virtuemart/router.php:794 |
| 12 | vmrouterHelper->__construct() | JROOT/components/com_virtuemart/router.php:822 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:345 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:408 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:482 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:235 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:131 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1116 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.66 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 2.342 MB Rows returned: 1
SELECT virtuemart_product_id
FROM jos_virtuemart_products_en_gb
WHERE slug = "new-ashley-nail-head-sofa"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_products_en_gb | const | slug | slug | 578 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 13 | JDatabaseDriver->loadResult() | JROOT/components/com_virtuemart/router.php:1132 |
| 12 | vmrouterHelper->getFieldOfObjectWithLangFallBack() | JROOT/components/com_virtuemart/router.php:1065 |
| 11 | vmrouterHelper->getProductId() | JROOT/components/com_virtuemart/router.php:669 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:408 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:482 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:235 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:131 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1116 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.70 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 2.350 MB Rows returned: 1
SELECT virtuemart_category_id
FROM jos_virtuemart_categories_en_gb
WHERE slug = "sofas"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_categories_en_gb | const | slug | slug | 578 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.07 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_virtuemart/router.php:1132 |
| 13 | vmrouterHelper->getFieldOfObjectWithLangFallBack() | JROOT/components/com_virtuemart/router.php:946 |
| 12 | vmrouterHelper->getCategoryId() | JROOT/components/com_virtuemart/router.php:1069 |
| 11 | vmrouterHelper->getProductId() | JROOT/components/com_virtuemart/router.php:669 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:408 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:482 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:235 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:131 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1116 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.82 ms After last query: 0.31 ms Query memory: 0.022 MB Memory before query: 2.370 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.35 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 12 | JDatabaseDriver->loadObject() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 11 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:156 |
| 10 | JLibraryHelper::_load() | JROOT/libraries/cms/library/helper.php:47 |
| 9 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:90 |
| 8 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:274 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:977 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.52 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 2.360 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"4a1100b5e4dbecc2ca44282e1b15196d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"4a1100b5e4dbecc2ca44282e1b15196d\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.04 ms |
| Updating | 0.11 ms |
| End of update loop | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| End of update loop | 0.23 ms |
| Query end | 0.01 ms |
| Commit | 0.77 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:119 |
| 9 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:325 |
| 8 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:284 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:977 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.28 ms After last query: 3.60 ms Query memory: 0.024 MB Memory before query: 2.762 MB Rows returned: 1
SELECT *
FROM `jos_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_shoppergroups | ALL | virtuemart_vendor_id,shared,published | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102 |
| 15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
| 14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
| 13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
| 12 | VirtueMartModelUser->getCurrentUser() | JROOT/administrator/components/com_virtuemart/models/product.php:1325 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.20 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 2.790 MB Rows returned: 1
SELECT `jos_virtuemart_shoppergroups`.*
FROM `jos_virtuemart_shoppergroups`
WHERE `jos_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_shoppergroups | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 18 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:910 |
| 17 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52 |
| 16 | VirtueMartModelShopperGroup->getShopperGroup() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107 |
| 15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
| 14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
| 13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
| 12 | VirtueMartModelUser->getCurrentUser() | JROOT/administrator/components/com_virtuemart/models/product.php:1325 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 0.40 ms Query memory: 0.023 MB Memory before query: 2.826 MB Rows returned: 1
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1818"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_products | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_products_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 13 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 12 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1353 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.51 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 2.858 MB Rows returned: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1818"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_medias | ref | virtuemart_product_id,ordering | ordering | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 12 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1358 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.58 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.887 MB Rows returned: 0
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1818"
| 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 |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.14 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 12 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1361 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.72 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 2.895 MB Rows returned: 1
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1818"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-04-27 09:39:00" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-27 09:39:00" ) )
ORDER BY `product_price` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_prices | ref | virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down | virtuemart_product_id | 4 | const | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.18 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1156 |
| 13 | VirtueMartModelProduct->loadProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1175 |
| 12 | VirtueMartModelProduct->getRawProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1376 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.60 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 2.915 MB Rows returned: 1
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1818"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_manufacturers | ref | virtuemart_product_id | virtuemart_product_id | 5 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.12 ms |
| Waiting for query cache lock | 0.19 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 12 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1380 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.938 MB Rows returned: 1
SELECT `jos_virtuemart_manufacturers`.* ,`jos_virtuemart_manufacturers_en_gb`.*
FROM `jos_virtuemart_manufacturers`
INNER JOIN `jos_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
WHERE `jos_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "10"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_manufacturers | const | PRIMARY,virtuemart_manufacturercategories_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_manufacturers_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 13 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 12 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1385 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.49 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 2.958 MB Rows returned: 3
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1818
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_categories | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 3 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.06 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1617 |
| 13 | VirtueMartModelProduct::getProductCategoryIds() | JROOT/administrator/components/com_virtuemart/models/product.php:1594 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1396 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.24 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 2.994 MB Rows returned: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "38"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1598 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1396 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.33 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 3.013 MB Rows returned: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "44"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1598 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1396 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.52 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 3.031 MB Rows returned: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "46"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.09 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1598 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1396 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.77 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 3.059 MB Rows returned: 0
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE field.`virtuemart_product_id` IN (1818)
AND c.`published` = "1"
ORDER BY field.`ordering` ASC
| 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 |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/models/customfields.php:146 |
| 12 | VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields() | JROOT/administrator/components/com_virtuemart/models/product.php:2514 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.23 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 3.089 MB Rows returned: 1
SELECT *
FROM `jos_virtuemart_currencies` AS c
LEFT JOIN `jos_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"
| 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 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/vendor.php:264 |
| 16 | VirtueMartModelVendor::getVendorCurrency() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 |
| 15 | CurrencyDisplay->__construct() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103 |
| 14 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 3.85 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 3.127 MB Rows returned: 1
SELECT `jos_virtuemart_currencies`.*
FROM `jos_virtuemart_currencies`
WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "144"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_currencies | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 16 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:910 |
| 15 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119 |
| 14 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.53 ms After last query: 0.30 ms Query memory: 0.035 MB Memory before query: 3.229 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `jos_virtuemart_userfields`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_virtuemart_userfields`
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.01 ms |
| Opening tables | 0.71 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| checking permissions | 0.11 ms |
| closing tables | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.21 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 24 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:660 |
| 23 | VmTable->showFullColumns() | JROOT/administrator/components/com_virtuemart/tables/userfields.php:43 |
| 22 | TableUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:217 |
| 21 | VmTable::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:430 |
| 20 | VmModel->_createTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:392 |
| 19 | VmModel->getTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:598 |
| 18 | VmModel->setMainTable() | JROOT/administrator/components/com_virtuemart/models/userfields.php:51 |
| 17 | VirtueMartModelUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:550 |
| 16 | VmModel::getModel() | JROOT/components/com_virtuemart/helpers/cart.php:251 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:258 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 0.15 ms Query memory: 0.033 MB Memory before query: 3.267 MB Rows returned: 16
SELECT *
FROM `jos_virtuemart_userfields`
WHERE 1 = 1
AND `account`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_userfields | ALL | published,account | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495 |
| 18 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:602 |
| 17 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:493 |
| 16 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:262 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:258 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 3.311 MB Rows returned: 2
SELECT `fieldtitle`, `fieldvalue`
FROM `jos_virtuemart_userfield_values`
WHERE `virtuemart_userfield_id` = 23
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_userfield_values | ref | virtuemart_userfield_id | virtuemart_userfield_id | 4 | const | 2 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495 |
| 17 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:1018 |
| 16 | VirtueMartModelUserfields->getUserFieldsFilled() | JROOT/components/com_virtuemart/helpers/cart.php:264 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:258 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 0.32 ms Query memory: 0.096 MB Memory before query: 3.349 MB Rows returned: 246
SELECT *
FROM `jos_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_countries | ALL | published | NO INDEX KEY COULD BE USED | NULL | NULL | 246 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.10 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846 |
| 19 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/country.php:113 |
| 18 | VirtueMartModelCountry->getCountries() | JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:145 |
| 17 | shopFunctionsF::renderCountryList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:838 |
| 16 | VirtueMartModelUserfields->getUserFieldsFilled() | JROOT/components/com_virtuemart/helpers/cart.php:264 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:258 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 1.55 ms Query memory: 0.033 MB Memory before query: 3.661 MB Rows returned: 14
SELECT *
FROM `jos_virtuemart_userfields`
WHERE 1 = 1
AND `shipment`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_userfields | ALL | published,shipment | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495 |
| 18 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:602 |
| 17 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:499 |
| 16 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:262 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:258 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.23 ms After last query: 0.80 ms Query memory: 0.023 MB Memory before query: 3.744 MB Rows returned: 0
SELECT c.*
FROM jos_virtuemart_calcs as c
LEFT JOIN jos_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id
WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-04-27 09:39:00" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-27 09:39:00" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| 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 |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.26 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 15 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184 |
| 14 | calculationHelper->setVendorId() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2521 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1049 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:81 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.68 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 3.779 MB Rows returned: 1
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "2622"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_medias | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.05 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/media.php:98 |
| 12 | VirtueMartModelMedia->createMediaByIds() | JROOT/administrator/components/com_virtuemart/models/media.php:415 |
| 11 | VirtueMartModelMedia->attachImages() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1075 |
| 10 | VmModel->addImages() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:137 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.13 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 3.794 MB Rows returned: 1
SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.created_on
FROM `jos_virtuemart_products` as p
INNER JOIN `jos_virtuemart_products_en_gb` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_categories` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( `pc`.`virtuemart_category_id` = 38
AND `c`.`published` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`="1" )
AND p.`virtuemart_product_id`!="1818"
AND `p`.created_on <= "2023-01-20 14:32:54"
ORDER BY p.`created_on` DESC, `virtuemart_product_id` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ps | system | virtuemart_product_id | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | c | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | p | range | PRIMARY,published,created_on | created_on | 5 | NULL | 19 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | l | eq_ref | PRIMARY | PRIMARY | 4 | bktradingvm.p.virtuemart_product_id | 1 | |
| 1 | SIMPLE | pc | eq_ref | virtuemart_product_id | virtuemart_product_id | 8 | bktradingvm.p.virtuemart_product_id,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.10 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.42 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.04 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1893 |
| 10 | VirtueMartModelProduct->getNeighborProducts() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:158 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.85 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 3.802 MB Rows returned: 0
SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.created_on
FROM `jos_virtuemart_products` as p
INNER JOIN `jos_virtuemart_products_en_gb` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_categories` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( `pc`.`virtuemart_category_id` = 38
AND `c`.`published` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`="1" )
AND p.`virtuemart_product_id`!="1818"
AND p.`virtuemart_product_id`!="1810"
AND `p`.created_on >= "2023-01-20 14:32:54"
ORDER BY p.`created_on` ASC, `virtuemart_product_id` ASC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ps | system | virtuemart_product_id | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | c | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | p | range | PRIMARY,published,created_on | created_on | 5 | NULL | 8 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | l | eq_ref | PRIMARY | PRIMARY | 4 | bktradingvm.p.virtuemart_product_id | 1 | |
| 1 | SIMPLE | pc | eq_ref | virtuemart_product_id | virtuemart_product_id | 8 | bktradingvm.p.virtuemart_product_id,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.25 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.06 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1893 |
| 10 | VirtueMartModelProduct->getNeighborProducts() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:158 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.21 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 3.832 MB Rows returned: 0
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_manufacturer_medias`
WHERE `virtuemart_manufacturer_id` = "10"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_manufacturer_medias | ref | virtuemart_manufacturer_id | virtuemart_manufacturer_id | 4 | const | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.14 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 12 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 11 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/manufacturer.php:61 |
| 10 | VirtueMartModelManufacturer->getManufacturer() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:167 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.40 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 3.879 MB Rows returned: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "38"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_category_medias | ref | virtuemart_category_id,ordering | ordering | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.10 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.07 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 12 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 11 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/category.php:74 |
| 10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:182 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.81 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 3.886 MB Rows returned: 0
SELECT `category_child_id`
FROM `jos_virtuemart_category_categories`
WHERE `category_parent_id` = 38
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_category_categories | ref | category_parent_id | category_parent_id | 4 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_virtuemart/models/category.php:695 |
| 11 | VirtueMartModelCategory->hasChildren() | JROOT/administrator/components/com_virtuemart/models/category.php:94 |
| 10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:182 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 3.893 MB Rows returned: 1
SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total
FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`
WHERE `jos_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 38
AND `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id`
AND `jos_virtuemart_products`.`published` = "1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_products | ALL | PRIMARY,virtuemart_vendor_id,published | NO INDEX KEY COULD BE USED | NULL | NULL | 26 | Using where |
| 1 | SIMPLE | jos_virtuemart_product_categories | eq_ref | virtuemart_product_id | virtuemart_product_id | 8 | bktradingvm.jos_virtuemart_products.virtuemart_product_id,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 12 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/models/category.php:418 |
| 11 | VirtueMartModelCategory->countProducts() | JROOT/administrator/components/com_virtuemart/models/category.php:101 |
| 10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:182 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 3.30 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 3.899 MB Rows returned: 1
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 38
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.10 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 13 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:800 |
| 12 | VirtueMartModelCategory->getCategoryRecurse() | JROOT/administrator/components/com_virtuemart/models/category.php:724 |
| 11 | VirtueMartModelCategory->getParentsList() | JROOT/administrator/components/com_virtuemart/models/category.php:104 |
| 10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:182 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.71 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.907 MB Rows returned: 1
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 14 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:800 |
| 13 | VirtueMartModelCategory->getCategoryRecurse() | JROOT/administrator/components/com_virtuemart/models/category.php:807 |
| 12 | VirtueMartModelCategory->getCategoryRecurse() | JROOT/administrator/components/com_virtuemart/models/category.php:724 |
| 11 | VirtueMartModelCategory->getParentsList() | JROOT/administrator/components/com_virtuemart/models/category.php:104 |
| 10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:182 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 3.915 MB Rows returned: 1
SELECT `virtuemart_category_id`, `category_name`
FROM `jos_virtuemart_categories_en_gb` as l
WHERE `virtuemart_category_id`= 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | l | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 12 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:769 |
| 11 | VirtueMartModelCategory->getParentsList() | JROOT/administrator/components/com_virtuemart/models/category.php:104 |
| 10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:182 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 3.922 MB Rows returned: 1
SELECT `virtuemart_category_id`, `category_name`
FROM `jos_virtuemart_categories_en_gb` as l
WHERE `virtuemart_category_id`= 38
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | l | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 12 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:769 |
| 11 | VirtueMartModelCategory->getParentsList() | JROOT/administrator/components/com_virtuemart/models/category.php:104 |
| 10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:182 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.90 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 3.928 MB Rows returned: 1
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "339"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_medias | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.13 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/media.php:98 |
| 12 | VirtueMartModelMedia->createMediaByIds() | JROOT/administrator/components/com_virtuemart/models/media.php:415 |
| 11 | VirtueMartModelMedia->attachImages() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1075 |
| 10 | VmModel->addImages() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:185 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 0.38 ms Query memory: 0.025 MB Memory before query: 3.940 MB Rows returned: 1
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 20 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:800 |
| 19 | VirtueMartModelCategory->getCategoryRecurse() | JROOT/components/com_virtuemart/router.php:873 |
| 18 | vmrouterHelper->getCategoryRouteNocache() | JROOT/components/com_virtuemart/router.php:848 |
| 17 | vmrouterHelper->getCategoryRoute() | JROOT/components/com_virtuemart/router.php:82 |
| 16 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 15 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 14 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 13 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 12 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 11 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 10 | JRoute::_() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:192 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 3.950 MB Rows returned: 1
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 21 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:800 |
| 20 | VirtueMartModelCategory->getCategoryRecurse() | JROOT/administrator/components/com_virtuemart/models/category.php:807 |
| 19 | VirtueMartModelCategory->getCategoryRecurse() | JROOT/components/com_virtuemart/router.php:873 |
| 18 | vmrouterHelper->getCategoryRouteNocache() | JROOT/components/com_virtuemart/router.php:848 |
| 17 | vmrouterHelper->getCategoryRoute() | JROOT/components/com_virtuemart/router.php:82 |
| 16 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 15 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 14 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 13 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 12 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 11 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 10 | JRoute::_() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:192 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 3.977 MB Rows returned: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "6"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 22 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 21 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/category.php:71 |
| 20 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/router.php:919 |
| 19 | vmrouterHelper->getCategoryNames() | JROOT/components/com_virtuemart/router.php:888 |
| 18 | vmrouterHelper->getCategoryRouteNocache() | JROOT/components/com_virtuemart/router.php:848 |
| 17 | vmrouterHelper->getCategoryRoute() | JROOT/components/com_virtuemart/router.php:82 |
| 16 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 15 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 14 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 13 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 12 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 11 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 10 | JRoute::_() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:192 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.55 ms After last query: 0.11 ms Query memory: 0.031 MB Memory before query: 3.999 MB Rows returned: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "6"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_category_medias | ref | virtuemart_category_id,ordering | ordering | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 22 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 21 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/category.php:74 |
| 20 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/router.php:919 |
| 19 | vmrouterHelper->getCategoryNames() | JROOT/components/com_virtuemart/router.php:888 |
| 18 | vmrouterHelper->getCategoryRouteNocache() | JROOT/components/com_virtuemart/router.php:848 |
| 17 | vmrouterHelper->getCategoryRoute() | JROOT/components/com_virtuemart/router.php:82 |
| 16 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 15 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 14 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 13 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 12 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 11 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 10 | JRoute::_() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:192 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.34 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 4.014 MB Rows returned: 1
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 38
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 20 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:800 |
| 19 | VirtueMartModelCategory->getCategoryRecurse() | JROOT/components/com_virtuemart/router.php:873 |
| 18 | vmrouterHelper->getCategoryRouteNocache() | JROOT/components/com_virtuemart/router.php:848 |
| 17 | vmrouterHelper->getCategoryRoute() | JROOT/components/com_virtuemart/router.php:82 |
| 16 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 15 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 14 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 13 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 12 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 11 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 10 | JRoute::_() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:192 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.07 ms After last query: 1.07 ms Query memory: 0.023 MB Memory before query: 4.058 MB Rows returned: 0
SELECT l.*
FROM `jos_virtuemart_categories_en_gb` as l
INNER JOIN `jos_virtuemart_categories` as c
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
LEFT JOIN `jos_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 38
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering,category_name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cx | ref | category_parent_id,category_child_id | category_parent_id | 4 | const | 1 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | l | eq_ref | PRIMARY | PRIMARY | 4 | bktradingvm.cx.category_child_id | 1 | |
| 1 | SIMPLE | c | eq_ref | PRIMARY,virtuemart_vendor_id,published | PRIMARY | 4 | bktradingvm.cx.category_child_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.07 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.07 ms |
| Waiting for query cache lock | 0.17 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/models/category.php:244 |
| 13 | VirtueMartModelCategory::getChildCategoryListObject() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 12 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:40 |
| 11 | JCacheControllerCallback->call() | JROOT/administrator/components/com_virtuemart/models/category.php:168 |
| 10 | VirtueMartModelCategory->getChildCategoryList() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:199 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 3.23 ms After last query: 108.93 ms Query memory: 0.025 MB Memory before query: 4.182 MB Rows returned: 0
SELECT *
FROM jos_komento_configs
WHERE `component` = 'com_virtuemart'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_komento_configs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| Waiting for query cache lock | 2.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 17 | JTable->load() | JROOT/components/com_komento/helpers/helper.php:202 |
| 16 | Komento::getConfig() | JROOT/components/com_komento/helpers/helper.php:697 |
| 15 | Komento::commentify() | JROOT/plugins/content/komento/komento.php:166 |
| 14 | plgContentKomento->execute() | JROOT/plugins/content/komento/komento.php:111 |
| 13 | plgContentKomento->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:872 |
| 10 | shopFunctionsF::triggerContentPlugin() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:305 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 3.55 ms After last query: 5.33 ms Query memory: 0.024 MB Memory before query: 4.419 MB Rows returned: 2
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.*
FROM `jos_virtuemart_shipmentmethods` as i
LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l
ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `jos_extensions` as j
ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT
OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s
ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
WHERE i.`published` = "1"
AND j.`element` = "weight_countries"
AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY i.`virtuemart_shipmentmethod_id`
ORDER BY i.`ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | system | virtuemart_shipmentmethod_id | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | Const row not found; Using temporary; Using filesort |
| 1 | SIMPLE | j | ref | PRIMARY,element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | Using index condition |
| 1 | SIMPLE | i | ALL | shipment_jplugin_id | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using join buffer (flat, BNL join) |
| 1 | SIMPLE | l | eq_ref | PRIMARY | PRIMARY | 4 | bktradingvm.i.virtuemart_shipmentmethod_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.13 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.20 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.11 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.91 ms |
| Creating sort index | 0.09 ms |
| Removing tmp table | 0.25 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:544 |
| 13 | vmPSPlugin->getPluginMethods() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:425 |
| 12 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:69 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 10 | JEventDispatcher->trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:318 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.68 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 4.476 MB Rows returned: 0
SELECT *
FROM jos_virtuemart_calcs
LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-04-27 09:39:00" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-27 09:39:00" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| 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 |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.06 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 17 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1332 |
| 16 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:725 |
| 15 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1530 |
| 14 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1629 |
| 13 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:447 |
| 12 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:69 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 10 | JEventDispatcher->trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:318 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.10 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 4.486 MB Rows returned: 0
SELECT *
FROM jos_virtuemart_calcs
LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-04-27 09:39:00" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-27 09:39:00" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| 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 |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.38 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 17 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1332 |
| 16 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:726 |
| 15 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1530 |
| 14 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1629 |
| 13 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:447 |
| 12 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:69 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 10 | JEventDispatcher->trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:318 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.63 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 4.495 MB Rows returned: 0
SELECT *
FROM jos_virtuemart_calcs
LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-04-27 09:39:00" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-27 09:39:00" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| 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 |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 17 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1332 |
| 16 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:727 |
| 15 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1530 |
| 14 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1629 |
| 13 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:447 |
| 12 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:69 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 10 | JEventDispatcher->trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:318 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.33 ms After last query: 3.19 ms Query memory: 0.025 MB Memory before query: 4.892 MB Rows returned: 0
SELECT *
FROM `jos_virtuemart_ratings`
WHERE `virtuemart_product_id` = "1818"
AND `published`="1"
| 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 |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.02 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/ratings.php:269 |
| 15 | VirtueMartModelRatings->getRatingByProduct() | JROOT/templates/theme673/html/com_virtuemart/sublayouts/rating.php:5 |
| 14 | include JROOT/templates/theme673/html/com_virtuemart/sublayouts/rating.php | JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:493 |
| 13 | shopFunctionsF::renderVmSubLayout() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:352 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 0.60 ms Query memory: 0.028 MB Memory before query: 4.907 MB Rows returned: 1
SELECT slug
FROM jos_virtuemart_manufacturers_en_gb
WHERE virtuemart_manufacturer_id = "10"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_manufacturers_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.08 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 24 | JDatabaseDriver->loadResult() | JROOT/components/com_virtuemart/router.php:1132 |
| 23 | vmrouterHelper->getFieldOfObjectWithLangFallBack() | JROOT/components/com_virtuemart/router.php:1079 |
| 22 | vmrouterHelper->getManufacturerName() | JROOT/components/com_virtuemart/router.php:214 |
| 21 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 20 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 19 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 18 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 17 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 16 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 15 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default_manufacturer.php:26 |
| 14 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default_manufacturer.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 13 | JViewLegacy->loadTemplate() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:373 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.54 ms After last query: 0.42 ms Query memory: 0.028 MB Memory before query: 4.945 MB Rows returned: 1
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1810"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_products | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_products_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.06 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.09 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 24 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 23 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1353 |
| 22 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 21 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/router.php:978 |
| 20 | vmrouterHelper->getProductName() | JROOT/components/com_virtuemart/router.php:205 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 18 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 17 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 16 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 15 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 14 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 13 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:558 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 2.10 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 4.959 MB Rows returned: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1810"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_medias | ref | virtuemart_product_id,ordering | ordering | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 23 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1358 |
| 22 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 21 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/router.php:978 |
| 20 | vmrouterHelper->getProductName() | JROOT/components/com_virtuemart/router.php:205 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 18 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 17 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 16 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 15 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 14 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 13 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:558 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.01 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 4.975 MB Rows returned: 0
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1810"
| 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 |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.55 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 23 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1361 |
| 22 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 21 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/router.php:978 |
| 20 | vmrouterHelper->getProductName() | JROOT/components/com_virtuemart/router.php:205 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 18 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 17 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 16 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 15 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 14 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 13 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:558 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.02 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 4.984 MB Rows returned: 1
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1810"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-04-27 09:39:00" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-27 09:39:00" ) )
ORDER BY `product_price` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_prices | ref | virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down | virtuemart_product_id | 4 | const | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.05 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.30 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 25 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1156 |
| 24 | VirtueMartModelProduct->loadProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1175 |
| 23 | VirtueMartModelProduct->getRawProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1376 |
| 22 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 21 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/router.php:978 |
| 20 | vmrouterHelper->getProductName() | JROOT/components/com_virtuemart/router.php:205 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 18 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 17 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 16 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 15 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 14 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 13 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:558 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.55 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 4.997 MB Rows returned: 0
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1810"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_manufacturers | ref | virtuemart_product_id | virtuemart_product_id | 5 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 23 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1380 |
| 22 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 21 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/router.php:978 |
| 20 | vmrouterHelper->getProductName() | JROOT/components/com_virtuemart/router.php:205 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 18 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 17 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 16 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 15 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 14 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 13 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:558 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.60 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 5.009 MB Rows returned: 4
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1810
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_product_categories | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 4 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 25 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1617 |
| 24 | VirtueMartModelProduct::getProductCategoryIds() | JROOT/administrator/components/com_virtuemart/models/product.php:1594 |
| 23 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1396 |
| 22 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 21 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/router.php:978 |
| 20 | vmrouterHelper->getProductName() | JROOT/components/com_virtuemart/router.php:205 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 18 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 17 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 16 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 15 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 14 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 13 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:558 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.89 ms After last query: 0.26 ms Query memory: 0.028 MB Memory before query: 5.054 MB Rows returned: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "40"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | jos_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.09 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.14 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 25 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1010 |
| 24 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1598 |
| 23 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1396 |
| 22 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:963 |
| 21 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/router.php:978 |
| 20 | vmrouterHelper->getProductName() | JROOT/components/com_virtuemart/router.php:205 |
| 19 | virtuemartBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 18 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 17 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 16 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 15 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 14 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 13 | JRoute::_() | JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php:558 |
| 12 | include JROOT/templates/theme673/html/com_virtuemart/productdetails/default.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 11 | JViewLegacy->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:40 |
| 10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:345 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.21 ms After last query: 2.27 ms Query memory: 0.025 MB Memory before query: 5.113 MB Rows returned: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-27 09:39:00')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 09:39:00')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 29 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | bktradingvm.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | bktradingvm.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.38 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:425 |
| 12 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:361 |
| 11 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 10 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:501 |
| 9 | JDocumentHtml->countModules() | JROOT/templates/theme673/includes/includes.php:94 |
| 8 | include_once JROOT/templates/theme673/includes/includes.php | JROOT/templates/theme673/index.php:3 |
| 7 | require JROOT/templates/theme673/index.php | JROOT/libraries/joomla/document/html.php:578 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:640 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:455 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1072 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 1.30 ms After last query: 3.62 ms Query memory: 0.025 MB Memory before query: 5.291 MB Rows returned: 1
SELECT id,parent_id
FROM jos_menu
WHERE id = 101
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_menu | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| Waiting for query cache lock | 0.11 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.09 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 19 | JDatabaseDriver->loadObject() | JROOT/modules/mod_icemegamenu/libs/menucore.php:81 |
| 18 | IceMenuTree->getCurrentMenuItem() | JROOT/modules/mod_icemegamenu/libs/menucore.php:67 |
| 17 | IceMenuTree->__construct() | JROOT/modules/mod_icemegamenu/helper.php:45 |
| 16 | modIceMegamenuHelper::buildXML() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:40 |
| 14 | JCacheControllerCallback->call() | JROOT/modules/mod_icemegamenu/helper.php:114 |
| 13 | modIceMegamenuHelper->getXML() | JROOT/modules/mod_icemegamenu/helper.php:153 |
| 12 | modIceMegamenuHelper->render() | JROOT/templates/theme673/html/mod_icemegamenu/default.php:27 |
| 11 | require JROOT/templates/theme673/html/mod_icemegamenu/default.php | JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65 |
| 10 | include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Query Time: 0.18 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 5.301 MB Rows returned: 1
SELECT id,parent_id
FROM jos_menu
WHERE id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_menu | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending cached result to clien | 0.10 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 19 | JDatabaseDriver->loadObject() | JROOT/modules/mod_icemegamenu/libs/menucore.php:81 |
| 18 | IceMenuTree->getCurrentMenuItem() | JROOT/modules/mod_icemegamenu/libs/menucore.php:67 |
| 17 | IceMenuTree->__construct() | JROOT/modules/mod_icemegamenu/helper.php:45 |
| 16 | modIceMegamenuHelper::buildXML() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/joomla/cache/controller/callback.php:40 |
| 14 | JCacheControllerCallback->call() | JROOT/modules/mod_icemegamenu/helper.php:114 |
| 13 | modIceMegamenuHelper->getXML() | JROOT/modules/mod_icemegamenu/helper.php:153 |
| 12 | modIceMegamenuHelper->render() | JROOT/templates/theme673/html/mod_icemegamenu/default.php:27 |
| 11 | require JROOT/templates/theme673/html/mod_icemegamenu/default.php | JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65 |
| 10 | include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
5 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
5 × SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
3 × SELECT *
FROM jos_virtuemart_calcs
LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
2 × SELECT id,parent_id
FROM jos_menu
2 × SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
2 × SELECT `virtuemart_category_id`, `category_name`
FROM `jos_virtuemart_categories_en_gb` as l
2 × SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
2 × SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.created_on
FROM `jos_virtuemart_products` as p
INNER JOIN `jos_virtuemart_products_en_gb` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_categories` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
2 × SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
2 × SELECT *
FROM `jos_virtuemart_userfields`
2 × SELECT *
FROM `jos_virtuemart_product_categories`
2 × SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
2 × SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
2 × SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
2 × SELECT *
FROM `jos_virtuemart_product_prices`
2 × SELECT *
FROM jos_komento_configs
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
2 × SELECT a.rules
FROM jos_assets AS a
1 × SELECT `category_child_id`
FROM `jos_virtuemart_category_categories`
1 × SELECT c.*
FROM jos_virtuemart_calcs as c
LEFT JOIN jos_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id
1 × SELECT `config`
FROM `jos_virtuemart_configs`
1 × SELECT *
FROM jos_loginradius_setting
1 × SELECT `virtuemart_media_id`
FROM `jos_virtuemart_manufacturer_medias`
1 × SELECT folder AS type, element AS name, params
FROM jos_extensions
1 × SELECT id, rules
FROM `jos_viewlevels
1 × SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total
FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`
1 × SELECT `fieldtitle`, `fieldvalue`
FROM `jos_virtuemart_userfield_values`
1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT l.*
FROM `jos_virtuemart_categories_en_gb` as l
INNER JOIN `jos_virtuemart_categories` as c
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
LEFT JOIN `jos_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.*
FROM `jos_virtuemart_shipmentmethods` as i
LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l
ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `jos_extensions` as j
ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT
OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s
ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
1 × SELECT *
FROM `jos_virtuemart_ratings`
1 × SELECT slug
FROM jos_virtuemart_manufacturers_en_gb
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM `jos_virtuemart_countries`
1 × SELECT *
FROM jos_languages
1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `id`
FROM `jos_menu`
1 × SELECT *
FROM `jos_menu`
1 × SELECT virtuemart_product_id
FROM jos_virtuemart_products_en_gb
1 × SELECT virtuemart_category_id
FROM jos_virtuemart_categories_en_gb
1 × SELECT *
FROM `jos_virtuemart_shoppergroups`
1 × SELECT `jos_virtuemart_shoppergroups`.*
FROM `jos_virtuemart_shoppergroups`
1 × SELECT a.name, a.rules
FROM jos_assets AS a
1 × SELECT `jos_virtuemart_currencies`.*
FROM `jos_virtuemart_currencies`
1 × SELECT element
FROM jos_extensions
1 × SELECT `session_id`
FROM `jos_session`
1 × SELECT id
FROM jos_assets
1 × SELECT `jos_virtuemart_manufacturers`.* ,`jos_virtuemart_manufacturers_en_gb`.*
FROM `jos_virtuemart_manufacturers`
INNER JOIN `jos_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
1 × SELECT *
FROM jos_assets
1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
1 × SELECT *
FROM `jos_virtuemart_currencies` AS c
LEFT JOIN `jos_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
1 × SELECT `data`
FROM `jos_session`
English
Afrikaans
Arabic
Catalan
Chinese (Simplified)
Chinese (Traditional)
Filipino
Finnish
French
German
Greek
Haitian Creole
Irish
Italian
Japanese
Korean
Lithuanian
Norwegian
Persian
Polish
Portuguese
Romanian
Russian
Serbian
Slovak
Slovenian
Spanish
Swahili
Swedish
Thai
Turkish
Ukrainian
Urdu
Vietnamese
Welsh
Yiddish