Abfragezeit: 0.60 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.141 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `jos_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_viewlevels | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.56 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.153 MB Zeilen zurückgegeben: 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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.92 ms Nach letzter Abfrage: 23.09 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.215 MB Zeilen zurückgegeben: 1
SHOW TABLES LIKE "jos_virtuemart_configs"
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES LIKE "jos_virtuemart_configs"
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.08 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
checking permissions | 2.23 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:820 |
15 | VmTable::checkTableExists() | JROOT/administrator/components/com_virtuemart/models/config.php:590 |
14 | VirtueMartModelConfig::checkConfigTableExists() | JROOT/administrator/components/com_virtuemart/helpers/config.php:405 |
13 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:196 |
12 | vmrouterHelper::init() | JROOT/components/com_virtuemart/router.php:309 |
11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:118 |
10 | virtuemartParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.223 MB Zeilen zurückgegeben: 1
SELECT `config`
FROM `jos_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_configs | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/config.php:454 |
13 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:196 |
12 | vmrouterHelper::init() | JROOT/components/com_virtuemart/router.php:309 |
11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:118 |
10 | virtuemartParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.50 ms Nach letzter Abfrage: 0.95 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.291 MB Zeilen zurückgegeben: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_assets | NULL | ALL | idx_asset_name | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 121 | 33.06 | Using where |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.02 ms |
Opening tables | 0.11 ms |
init | 0.09 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.30 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.53 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
18 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
16 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
15 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136 |
14 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:476 |
13 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:196 |
12 | vmrouterHelper::init() | JROOT/components/com_virtuemart/router.php:309 |
11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:118 |
10 | virtuemartParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.98 ms Nach letzter Abfrage: 1.75 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 2.362 MB Zeilen zurückgegeben: 11
SELECT *
FROM `jos_menu`
WHERE `link` like "index.php?option=com_virtuemart%"
and (language="*" or language = "de-DE" )
AND client_id=0
AND published=1
AND ( access="1" OR access="5" )
and `menutype` = (SELECT `menutype`
FROM `jos_menu`
WHERE `id` = "209")
ORDER BY `language` DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | jos_menu | NULL | ref | idx_client_id_parent_id_alias_language,idx_menutype,idx_language | idx_menutype | 98 | const | 34 | 0.88 | Using index condition; Using where; filesort wurde genutzt |
2 | SUBQUERY | jos_menu | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.11 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
statistics | 0.20 ms |
preparing | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.84 ms |
end | 0.04 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_virtuemart/router.php:1661 |
14 | vmrouterHelper::setMenuItemId() | JROOT/components/com_virtuemart/router.php:290 |
13 | vmrouterHelper::setRoutingQuery() | JROOT/components/com_virtuemart/router.php:262 |
12 | vmrouterHelper::init() | JROOT/components/com_virtuemart/router.php:309 |
11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:118 |
10 | virtuemartParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.86 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.474 MB Zeilen zurückgegeben: 1
SELECT l.virtuemart_product_id
FROM `jos_virtuemart_products_de_de` as l
WHERE l.slug = "caipirinha-glas-ciao-klein"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | l | NULL | const | slug | slug | 575 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.14 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/components/com_virtuemart/router.php:1587 |
13 | vmrouterHelper::getFieldOfObjectWithLangFallBack() | JROOT/components/com_virtuemart/router.php:1524 |
12 | vmrouterHelper::getProductId() | JROOT/components/com_virtuemart/router.php:1085 |
11 | vmrouterHelper::parseRoute() | JROOT/components/com_virtuemart/router.php:121 |
10 | virtuemartParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.481 MB Zeilen zurückgegeben: 1
SELECT l.virtuemart_category_id
FROM `jos_virtuemart_categories_de_de` as l
WHERE l.slug = "glaeser"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | l | NULL | const | slug | slug | 575 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_virtuemart/router.php:1587 |
14 | vmrouterHelper::getFieldOfObjectWithLangFallBack() | JROOT/components/com_virtuemart/router.php:1381 |
13 | vmrouterHelper::getCategoryId() | JROOT/components/com_virtuemart/router.php:1528 |
12 | vmrouterHelper::getProductId() | JROOT/components/com_virtuemart/router.php:1085 |
11 | vmrouterHelper::parseRoute() | JROOT/components/com_virtuemart/router.php:121 |
10 | virtuemartParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.78 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.494 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"0a3d61c43269037a54c9e2e66ffcda2f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | jos_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.08 ms |
System lock | 0.15 ms |
updating | 0.13 ms |
end | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
end | 0.02 ms |
query end | 0.07 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.70 ms Nach letzter Abfrage: 3.65 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.682 MB Zeilen zurückgegeben: 1
SELECT id, home,`template`,`params`
FROM `jos_template_styles`
WHERE `id`="9"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_template_styles | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
12 | JDatabaseDriver->loadAssoc() | JROOT/components/com_virtuemart/helpers/vmtemplate.php:94 |
11 | VmTemplate::getTemplateById() | JROOT/components/com_virtuemart/helpers/vmtemplate.php:41 |
10 | VmTemplate::loadVmTemplateStyle() | JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:379 |
9 | vmJsApi::setPath() | JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:318 |
8 | vmJsApi::css() | JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:804 |
7 | vmJsApi::cssSite() | JROOT/components/com_virtuemart/virtuemart.php:92 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.91 ms Nach letzter Abfrage: 3.81 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.888 MB Zeilen zurückgegeben: 1
SELECT *
FROM `jos_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_shoppergroups | NULL | ref | virtuemart_vendor_id,shared,published | published | 1 | const | 1 | 50.00 | Using where |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
executing | 0.02 ms |
Sending data | 0.09 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.05 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101 |
14 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139 |
13 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:201 |
12 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:125 |
11 | VirtueMartModelUser->getCurrentUser() | JROOT/components/com_virtuemart/helpers/cart.php:188 |
10 | VirtueMartCart::getCart() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.55 ms Nach letzter Abfrage: 0.81 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.922 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_shoppergroups`.*
FROM `jos_virtuemart_shoppergroups`
WHERE `jos_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_shoppergroups | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
18 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
17 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1145 |
16 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50 |
15 | VirtueMartModelShopperGroup->getShopperGroup() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:109 |
14 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139 |
13 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:201 |
12 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:125 |
11 | VirtueMartModelUser->getCurrentUser() | JROOT/components/com_virtuemart/helpers/cart.php:188 |
10 | VirtueMartCart::getCart() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.57 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 2.962 MB Zeilen zurückgegeben: 32
SHOW FULL COLUMNS
FROM `jos_virtuemart_userfields`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos_virtuemart_userfields`
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.25 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.04 ms |
Opening tables | 0.09 ms |
checking permissions | 0.10 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.04 ms |
Sending data | 0.15 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.10 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
20 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:781 |
19 | VmTable->showFullColumns() | JROOT/administrator/components/com_virtuemart/tables/userfields.php:41 |
18 | TableUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:235 |
17 | VmTable::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:441 |
16 | VmModel->_createTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:403 |
15 | VmModel->getTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:615 |
14 | VmModel->setMainTable() | JROOT/administrator/components/com_virtuemart/models/userfields.php:49 |
13 | VirtueMartModelUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:567 |
12 | VmModel::getModel() | JROOT/components/com_virtuemart/helpers/cart.php:371 |
11 | VirtueMartCart->setupAddressFieldsForCart() | JROOT/components/com_virtuemart/helpers/cart.php:255 |
10 | VirtueMartCart::getCart() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.08 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 2.999 MB Zeilen zurückgegeben: 16
SELECT *
FROM `jos_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_userfields | NULL | ref | published,account | account | 1 | const | 19 | 72.41 | Using index condition; Using where; filesort wurde genutzt |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.39 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:512 |
14 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:575 |
13 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:456 |
12 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:412 |
11 | VirtueMartCart->setupAddressFieldsForCart() | JROOT/components/com_virtuemart/helpers/cart.php:255 |
10 | VirtueMartCart::getCart() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.06 ms Nach letzter Abfrage: 2.34 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.182 MB Zeilen zurückgegeben: 10
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_userfields | NULL | ref | published,shipment | shipment | 1 | const | 11 | 72.41 | Using index condition; Using where; filesort wurde genutzt |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.33 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:512 |
14 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:575 |
13 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:462 |
12 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:412 |
11 | VirtueMartCart->setupAddressFieldsForCart() | JROOT/components/com_virtuemart/helpers/cart.php:255 |
10 | VirtueMartCart::getCart() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.81 ms Nach letzter Abfrage: 0.65 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.315 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_de_de`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_de_de`
ON `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_products_de_de`.`virtuemart_product_id`
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "11"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_products | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | jos_virtuemart_products_de_de | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.11 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
13 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
12 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1717 |
11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:1273 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.354 MB Zeilen zurückgegeben: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "11"
ORDER BY `ordering`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_product_medias | NULL | ref | virtuemart_product_id,ordering | ordering | 4 | const | 1 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
13 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
12 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1750 |
11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:1273 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.366 MB Zeilen zurückgegeben: 1
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "11"
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-05-18 17:06:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-05-18 17:06:16" ) )
ORDER BY `product_price` DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_product_prices | NULL | ref | virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down | virtuemart_product_id | 4 | const | 1 | 97.42 | Using index condition; Using where; filesort wurde genutzt |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.18 ms |
preparing | 0.04 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.09 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
14 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1528 |
13 | VirtueMartModelProduct->loadProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1552 |
12 | VirtueMartModelProduct->getRawProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1780 |
11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:1273 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.375 MB Zeilen zurückgegeben: 3
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 11
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_product_categories | NULL | ref | virtuemart_product_id,virtuemart_product_id_uid | virtuemart_product_id | 4 | const | 2 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
14 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:2124 |
13 | VirtueMartModelProduct::getProductCategoryIds() | JROOT/administrator/components/com_virtuemart/models/product.php:2101 |
12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1801 |
11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:1273 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.407 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_de_de`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_de_de`
ON `jos_virtuemart_categories`.`virtuemart_category_id` = `jos_virtuemart_categories_de_de`.`virtuemart_category_id`
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "1"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | jos_virtuemart_categories_de_de | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.20 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:2105 |
12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1801 |
11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:1273 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.426 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_de_de`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_de_de`
ON `jos_virtuemart_categories`.`virtuemart_category_id` = `jos_virtuemart_categories_de_de`.`virtuemart_category_id`
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "28"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | jos_virtuemart_categories_de_de | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:2105 |
12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1801 |
11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:1273 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.444 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_de_de`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_de_de`
ON `jos_virtuemart_categories`.`virtuemart_category_id` = `jos_virtuemart_categories_de_de`.`virtuemart_category_id`
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "39"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | jos_virtuemart_categories_de_de | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:2105 |
12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1801 |
11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:1273 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.70 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.485 MB Zeilen zurückgegeben: 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.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `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 (11)
AND c.`published` = "1"
ORDER BY field.`ordering` ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.18 ms |
preparing | 0.01 ms |
executing | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/models/customfields.php:163 |
11 | VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields() | JROOT/administrator/components/com_virtuemart/models/product.php:1380 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.71 ms Nach letzter Abfrage: 0.54 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.523 MB Zeilen zurückgegeben: 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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | v | NULL | system | PRIMARY,vendor_currency | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.19 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/vendor.php:316 |
16 | VirtueMartModelVendor::getVendorCurrency() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 |
15 | CurrencyDisplay->__construct() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106 |
14 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89 |
13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111 |
12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:3249 |
11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1394 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.562 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_currencies`.*
FROM `jos_virtuemart_currencies`
WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "47"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_currencies | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
16 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1145 |
15 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122 |
14 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89 |
13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111 |
12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:3249 |
11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1394 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.88 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.603 MB Zeilen zurückgegeben: 2
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 ( ( ISNULL(`publish_up`) or `publish_up`="0000-00-00 00:00:00") OR publish_up <= "2024-05-18 17:06:16" )
AND ( ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00") OR publish_down >= "2024-05-18 17:06:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down | published | 1 | const | 3 | 25.00 | Using where |
1 | SIMPLE | cs | NULL | ref | virtuemart_calc_id | virtuemart_calc_id | 4 | Joomla_a.c.virtuemart_calc_id | 1 | 75.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.17 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.17 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
15 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:174 |
14 | calculationHelper->setVendorId() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95 |
13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111 |
12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:3249 |
11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:1394 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.625 MB Zeilen zurückgegeben: 0
SELECT `jos_virtuemart_ratings`.*
FROM `jos_virtuemart_ratings`
WHERE `jos_virtuemart_ratings`.`virtuemart_product_id` = "11"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_ratings | NULL | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
12 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
11 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1422 |
10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.658 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "277"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_medias | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.03 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/media.php:98 |
12 | VirtueMartModelMedia->createMediaByIds() | JROOT/administrator/components/com_virtuemart/models/media.php:497 |
11 | VirtueMartModelMedia->attachImages() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1305 |
10 | VmModel->addImages() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:159 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.31 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.799 MB Zeilen zurückgegeben: 0
SELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug
FROM jos_virtuemart_categories as c
LEFT JOIN `jos_virtuemart_categories_de_de` as l
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
WHERE (c.`category_parent_id` = 28)
AND c.`published` = 1
ORDER BY c.ordering,category_name ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | category_parent_id,published | category_parent_id | 5 | const | 1 | 75.00 | Using where; Using temporary; filesort wurde genutzt |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.c.virtuemart_category_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
Creating tmp table | 0.17 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.24 ms |
Creating sort index | 0.26 ms |
end | 0.02 ms |
query end | 0.01 ms |
removing tmp table | 0.12 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/models/category.php:408 |
13 | VirtueMartModelCategory::getChildCategoryListObject() | JROOT/administrator/components/com_virtuemart/models/category.php:222 |
12 | VirtueMartModelCategory->getChildCategoryList() | JROOT/administrator/components/com_virtuemart/models/product.php:582 |
11 | VirtueMartModelProduct->sortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:2340 |
10 | VirtueMartModelProduct->getNeighborProducts() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:180 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.34 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.815 MB Zeilen zurückgegeben: 1
SELECT `l`.`product_name`, `l`.product_desc, `p`.virtuemart_product_id
FROM `jos_virtuemart_products` as p
LEFT JOIN `jos_virtuemart_products_de_de` 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` IN (28)
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`!="11"
AND `l`.product_desc >= "<p><strong>Schlicht und modern - ein Glas aus dem Hause Leonardo für Caipirinhas. </strong></p>\\r\\n<p> </p>\\r\\n<p>Es ermöglicht den unverzerrten Blick auf den Inhalt - so ist es bestens für hochwertige Getränke geeignet. Hier kann gezeigt werden, was getrunken wird. Die moderne Architektur des Glases paßt auf jeden Tisch. Mit Stil anstoßen ist Dank des hochwertigen Materials kein Geheimnis - kein billiges Pressglas und ohne Branding.</p>\\r\\n<p> </p>\\r\\n<p>Wer hochwertige Zutaten verwendet - frische, glänzende Limetten und Eiswürfel für ein unverwässertes Caipirinha-Erlebnis, der sollte zu diesem Glas greifen.</p>\\r\\n<p> </p>\\r\\n<p>Inhalt: 250ml</p>\\r\\n<p>spülmaschinengeeignet</p>"
ORDER BY `l`.product_desc ASC, `p`.virtuemart_product_id ASC
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ps | NULL | system | virtuemart_product_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | c | NULL | const | PRIMARY,published | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; filesort wurde genutzt |
1 | SIMPLE | pc | NULL | range | virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid | virtuemart_category_id | 8 | NULL | 6 | 100.00 | Using where; Using index |
1 | SIMPLE | p | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | Joomla_a.pc.virtuemart_product_id | 1 | 70.78 | Using where |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.pc.virtuemart_product_id | 1 | 33.33 | Using where |
Status | Duration |
---|
starting | 0.19 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.12 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.21 ms |
preparing | 0.05 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.25 ms |
Creating sort index | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
11 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:2479 |
10 | VirtueMartModelProduct->getNeighborProducts() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:180 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.22 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.824 MB Zeilen zurückgegeben: 0
SELECT `l`.`product_name`, `l`.product_desc, `p`.virtuemart_product_id
FROM `jos_virtuemart_products` as p
LEFT JOIN `jos_virtuemart_products_de_de` 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` IN (28)
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`!="11"
AND p.`virtuemart_product_id`!="58"
AND `l`.product_desc <= "<p><strong>Schlicht und modern - ein Glas aus dem Hause Leonardo für Caipirinhas. </strong></p>\\r\\n<p> </p>\\r\\n<p>Es ermöglicht den unverzerrten Blick auf den Inhalt - so ist es bestens für hochwertige Getränke geeignet. Hier kann gezeigt werden, was getrunken wird. Die moderne Architektur des Glases paßt auf jeden Tisch. Mit Stil anstoßen ist Dank des hochwertigen Materials kein Geheimnis - kein billiges Pressglas und ohne Branding.</p>\\r\\n<p> </p>\\r\\n<p>Wer hochwertige Zutaten verwendet - frische, glänzende Limetten und Eiswürfel für ein unverwässertes Caipirinha-Erlebnis, der sollte zu diesem Glas greifen.</p>\\r\\n<p> </p>\\r\\n<p>Inhalt: 250ml</p>\\r\\n<p>spülmaschinengeeignet</p>"
ORDER BY `l`.product_desc DESC, `p`.virtuemart_product_id DESC
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ps | NULL | system | virtuemart_product_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | c | NULL | const | PRIMARY,published | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; filesort wurde genutzt |
1 | SIMPLE | pc | NULL | range | virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid | virtuemart_category_id | 8 | NULL | 6 | 100.00 | Using where; Using index |
1 | SIMPLE | p | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | Joomla_a.pc.virtuemart_product_id | 1 | 70.78 | Using where |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.pc.virtuemart_product_id | 1 | 33.33 | Using where |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.28 ms |
preparing | 0.04 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.21 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.06 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
11 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:2479 |
10 | VirtueMartModelProduct->getNeighborProducts() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:180 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.838 MB Zeilen zurückgegeben: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "28"
ORDER BY `ordering`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_category_medias | NULL | ref | virtuemart_category_id,ordering | ordering | 4 | const | 1 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
12 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
11 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/category.php:118 |
10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:218 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.851 MB Zeilen zurückgegeben: 1
SELECT count(`p`.virtuemart_product_id) AS total
FROM `jos_virtuemart_product_categories` as `pc`
LEFT JOIN `jos_virtuemart_products` as `p`
ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
WHERE `pc`.`virtuemart_category_id` = "28"
AND `p`.`virtuemart_vendor_id` = "1"
AND `p`.`published` = "1"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | pc | NULL | ref | virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid | virtuemart_category_id | 4 | const | 7 | 100.00 | Using index |
1 | SIMPLE | p | NULL | eq_ref | PRIMARY,virtuemart_vendor_id,published | PRIMARY | 4 | Joomla_a.pc.virtuemart_product_id | 1 | 69.86 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/models/category.php:669 |
11 | VirtueMartModelCategory->countProducts() | JROOT/administrator/components/com_virtuemart/models/category.php:159 |
10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:218 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.859 MB Zeilen zurückgegeben: 1
SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_categories
WHERE `virtuemart_category_id`= 28
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:1095 |
13 | VirtueMartModelCategory::getCategoryRecurseS() | JROOT/administrator/components/com_virtuemart/models/category.php:1019 |
12 | VirtueMartModelCategory::getParents() | JROOT/administrator/components/com_virtuemart/models/category.php:1002 |
11 | VirtueMartModelCategory->getParentsList() | JROOT/administrator/components/com_virtuemart/models/category.php:164 |
10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:218 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.869 MB Zeilen zurückgegeben: 1
SELECT l.virtuemart_category_id, l.category_name, published
FROM `jos_virtuemart_categories` as c
LEFT JOIN `jos_virtuemart_categories_de_de` as l
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
WHERE l.virtuemart_category_id = 28
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | l | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/category.php:1041 |
12 | VirtueMartModelCategory::getParents() | JROOT/administrator/components/com_virtuemart/models/category.php:1002 |
11 | VirtueMartModelCategory->getParentsList() | JROOT/administrator/components/com_virtuemart/models/category.php:164 |
10 | VirtueMartModelCategory->getCategory() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:218 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.875 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "305"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_medias | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/media.php:98 |
12 | VirtueMartModelMedia->createMediaByIds() | JROOT/administrator/components/com_virtuemart/models/media.php:497 |
11 | VirtueMartModelMedia->attachImages() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1305 |
10 | VmModel->addImages() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:222 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.96 ms Nach letzter Abfrage: 1.21 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.901 MB Zeilen zurückgegeben: 1
SELECT COLLATION_NAME
from information_schema.columns
where TABLE_SCHEMA = "Joomla_a"
and TABLE_NAME = "jos_users"
and COLUMN_NAME = "name";
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | columns | NULL | ALL | NULL | TABLE_SCHEMA,TABLE_NAME | NULL | NULL | NULL | NULL | Using where; Open_frm_only; Scanned 0 databases |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.21 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
checking permissions | 0.06 ms |
checking permissions | 0.04 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/models/ratings.php:95 |
11 | VirtueMartModelRatings::getSelect() | JROOT/administrator/components/com_virtuemart/models/ratings.php:229 |
10 | VirtueMartModelRatings->getReviews() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:301 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.90 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.907 MB Zeilen zurückgegeben: 1
SELECT COLLATION_NAME
from information_schema.columns
where TABLE_SCHEMA = "Joomla_a"
and TABLE_NAME = "jos_virtuemart_rating_reviews"
and COLUMN_NAME = "customer";
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | columns | NULL | ALL | NULL | TABLE_SCHEMA,TABLE_NAME | NULL | NULL | NULL | NULL | Using where; Open_frm_only; Scanned 0 databases |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
checking permissions | 0.12 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/models/ratings.php:103 |
11 | VirtueMartModelRatings::getSelect() | JROOT/administrator/components/com_virtuemart/models/ratings.php:229 |
10 | VirtueMartModelRatings->getReviews() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:301 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.96 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.916 MB Zeilen zurückgegeben: 0
SELECT `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer
FROM `jos_virtuemart_rating_reviews` AS `pr`
INNER JOIN `jos_virtuemart_products_de_de` AS `l`
ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_rating_votes` AS `rv`
on
(`pr`.`virtuemart_rating_vote_id` IS NOT NULL
AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR
(`pr`.`virtuemart_rating_vote_id` IS NULL
AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`pr`.`created_by`) )
LEFT JOIN `jos_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
WHERE `pr`.`virtuemart_product_id` = "11"
ORDER BY created_on DESC
LIMIT 0, 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | l | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; filesort wurde genutzt |
1 | SIMPLE | pr | NULL | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 1 | 100.00 | Using index condition |
1 | SIMPLE | rv | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.pr.created_by | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.39 ms |
init | 0.13 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.04 ms |
Creating tmp table | 0.22 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.25 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.13 ms |
removing tmp table | 0.08 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:880 |
11 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/ratings.php:230 |
10 | VirtueMartModelRatings->getReviews() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:301 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.32 ms Nach letzter Abfrage: 73.81 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.022 MB Zeilen zurückgegeben: 4
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , j.`system_data` , l.shipment_name, l.shipment_desc
FROM jos_virtuemart_shipmentmethods as i
LEFT JOIN `jos_virtuemart_shipmentmethods_de_de` as l
ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `jos_extensions` as j
ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT
OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s
ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
WHERE i.`published` = "1"
AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY i.`virtuemart_shipmentmethod_id`
ORDER BY i.`ordering`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | system | virtuemart_shipmentmethod_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | i | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 4 | 25.00 | Using where; Using temporary; filesort wurde genutzt |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.i.virtuemart_shipmentmethod_id | 1 | 100.00 | NULL |
1 | SIMPLE | j | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.i.shipment_jplugin_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.28 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.53 ms |
init | 0.12 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Creating tmp table | 0.10 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.46 ms |
Creating sort index | 0.19 ms |
end | 0.01 ms |
query end | 0.02 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:502 |
14 | vmPSPlugin->getPluginMethods() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:365 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.04 ms Nach letzter Abfrage: 0.76 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.080 MB Zeilen zurückgegeben: 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 ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-18 17:06:16" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-18 17:06:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calcs | NULL | ref | virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down | calc_kind | 50 | const | 1 | 25.00 | Using where |
1 | SIMPLE | jos_virtuemart_calc_shoppergroups | NULL | ref | virtuemart_calc_id | virtuemart_calc_id | 4 | Joomla_a.jos_virtuemart_calcs.virtuemart_calc_id | 1 | 75.00 | Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.19 ms |
preparing | 0.06 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
18 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521 |
17 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:773 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:382 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.90 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.090 MB Zeilen zurückgegeben: 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 ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-18 17:06:16" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-18 17:06:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calcs | NULL | ref | virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down | calc_kind | 50 | const | 1 | 25.00 | Using where |
1 | SIMPLE | jos_virtuemart_calc_shoppergroups | NULL | ref | virtuemart_calc_id | virtuemart_calc_id | 4 | Joomla_a.jos_virtuemart_calcs.virtuemart_calc_id | 1 | 75.00 | Using where |
Status | Duration |
---|
starting | 0.20 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.10 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
18 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521 |
17 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:774 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:382 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.099 MB Zeilen zurückgegeben: 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 ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-18 17:06:16" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-18 17:06:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calcs | NULL | ref | virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down | calc_kind | 50 | const | 1 | 25.00 | Using where |
1 | SIMPLE | jos_virtuemart_calc_shoppergroups | NULL | ref | virtuemart_calc_id | virtuemart_calc_id | 4 | Joomla_a.jos_virtuemart_calcs.virtuemart_calc_id | 1 | 75.00 | Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.14 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
18 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1521 |
17 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:382 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.05 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 5.115 MB Zeilen zurückgegeben: 4
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , j.`system_data` , l.payment_name, l.payment_desc
FROM jos_virtuemart_paymentmethods as i
LEFT JOIN `jos_virtuemart_paymentmethods_de_de` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
LEFT JOIN `jos_extensions` as j
ON j.`extension_id` = i.`payment_jplugin_id`
LEFT
OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s
ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE i.`published` = "1"
AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY i.`virtuemart_paymentmethod_id`
ORDER BY i.`ordering`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | system | virtuemart_paymentmethod_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | i | NULL | ALL | PRIMARY,virtuemart_vendor_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 20.00 | Using where; Using temporary; filesort wurde genutzt |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.i.virtuemart_paymentmethod_id | 1 | 100.00 | NULL |
1 | SIMPLE | j | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.i.payment_jplugin_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.19 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.54 ms |
init | 0.10 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
Creating tmp table | 0.08 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
Creating sort index | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
27 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:502 |
26 | vmPSPlugin->getPluginMethods() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:938 |
25 | vmPSPlugin->getSelectables() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:212 |
24 | vmPSPlugin->onCheckAutomaticSelected() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:194 |
23 | vmPSPlugin->plgVmOnCheckAutomaticSelected() | JROOT/libraries/joomla/event/event.php:70 |
22 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
21 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
20 | vDispatcher::trigger() | JROOT/components/com_virtuemart/helpers/cart.php:2178 |
19 | VirtueMartCart->checkAutomaticSelectedPlug() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1648 |
18 | calculationHelper->calculateMethodPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1703 |
17 | calculationHelper->calculatePaymentPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:985 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:382 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.81 ms Nach letzter Abfrage: 0.98 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.166 MB Zeilen zurückgegeben: 4
SELECT vm.*
FROM `jos_virtuemart_paymentmethods` AS vm, jos_extensions AS j
WHERE vm.payment_jplugin_id = j.extension_id
AND vm.published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | vm | NULL | ALL | payment_jplugin_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 20.00 | Using where |
1 | SIMPLE | j | NULL | eq_ref | PRIMARY | PRIMARY | 4 | Joomla_a.vm.payment_jplugin_id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.07 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.17 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:338 |
24 | vmPlugin->selectedThisByMethodId() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:171 |
23 | vmPSPlugin->onSelectedCalculatePrice() | JROOT/plugins/vmpayment/paypal_checkout/paypal_checkout.php:1045 |
22 | plgVmPaymentPaypal_checkout->plgVmOnSelectedCalculatePricePayment() | JROOT/libraries/joomla/event/event.php:70 |
21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
20 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
19 | vDispatcher::trigger() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1652 |
18 | calculationHelper->calculateMethodPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1703 |
17 | calculationHelper->calculatePaymentPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:985 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:382 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.49 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.209 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_paymentmethods`.* ,`jos_virtuemart_paymentmethods_de_de`.*
FROM `jos_virtuemart_paymentmethods`
INNER JOIN `jos_virtuemart_paymentmethods_de_de`
ON `jos_virtuemart_paymentmethods`.`virtuemart_paymentmethod_id` = `jos_virtuemart_paymentmethods_de_de`.`virtuemart_paymentmethod_id`
WHERE `jos_virtuemart_paymentmethods`.`virtuemart_paymentmethod_id` = "4"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_paymentmethods | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | jos_virtuemart_paymentmethods_de_de | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
26 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
25 | VmTable->load() | JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:620 |
24 | vmPlugin->getVmPluginMethod() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:174 |
23 | vmPSPlugin->onSelectedCalculatePrice() | JROOT/plugins/vmpayment/sofort/sofort.php:732 |
22 | plgVmPaymentSofort->plgVmOnSelectedCalculatePricePayment() | JROOT/libraries/joomla/event/event.php:70 |
21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
20 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
19 | vDispatcher::trigger() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1652 |
18 | calculationHelper->calculateMethodPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1703 |
17 | calculationHelper->calculatePaymentPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:985 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:382 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.87 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.225 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos_virtuemart_calcs
WHERE `virtuemart_calc_id`="2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calcs | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
25 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:1304 |
24 | vmPSPlugin->setCartPrices() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:187 |
23 | vmPSPlugin->onSelectedCalculatePrice() | JROOT/plugins/vmpayment/sofort/sofort.php:732 |
22 | plgVmPaymentSofort->plgVmOnSelectedCalculatePricePayment() | JROOT/libraries/joomla/event/event.php:70 |
21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
20 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
19 | vDispatcher::trigger() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1652 |
18 | calculationHelper->calculateMethodPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1703 |
17 | calculationHelper->calculatePaymentPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:985 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:382 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.64 ms Nach letzter Abfrage: 1.88 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.287 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos_virtuemart_calcs
WHERE `virtuemart_calc_id`="2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calcs | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.04 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
25 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:1304 |
24 | vmPSPlugin->setCartPrices() | JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:187 |
23 | vmPSPlugin->onSelectedCalculatePrice() | JROOT/plugins/vmpayment/sofort/sofort.php:732 |
22 | plgVmPaymentSofort->plgVmOnSelectedCalculatePricePayment() | JROOT/libraries/joomla/event/event.php:70 |
21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
20 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
19 | vDispatcher::trigger() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1652 |
18 | calculationHelper->calculateMethodPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1703 |
17 | calculationHelper->calculatePaymentPrice() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:985 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:404 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.310 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_calcs`.*
FROM `jos_virtuemart_calcs`
WHERE `jos_virtuemart_calcs`.`virtuemart_calc_id` = "2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calcs | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
20 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
19 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/calc.php:62 |
18 | VirtueMartModelCalc->getCalc() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1086 |
17 | calculationHelper->getCalcRuleData() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1061 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:404 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.336 MB Zeilen zurückgegeben: 0
SELECT `virtuemart_category_id`
FROM `jos_virtuemart_calc_categories`
WHERE `virtuemart_calc_id` = "2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calc_categories | NULL | ref | virtuemart_calc_id | virtuemart_calc_id | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.30 ms |
init | 0.03 ms |
System lock | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
20 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
19 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/calc.php:65 |
18 | VirtueMartModelCalc->getCalc() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1086 |
17 | calculationHelper->getCalcRuleData() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1061 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:404 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.357 MB Zeilen zurückgegeben: 0
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_calc_shoppergroups`
WHERE `virtuemart_calc_id` = "2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calc_shoppergroups | NULL | ref | virtuemart_calc_id | virtuemart_calc_id | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 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 | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
20 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
19 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/calc.php:68 |
18 | VirtueMartModelCalc->getCalc() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1086 |
17 | calculationHelper->getCalcRuleData() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1061 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:404 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.378 MB Zeilen zurückgegeben: 0
SELECT `virtuemart_country_id`
FROM `jos_virtuemart_calc_countries`
WHERE `virtuemart_calc_id` = "2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_calc_countries | NULL | ref | virtuemart_calc_id | virtuemart_calc_id | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.18 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
20 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
19 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/calc.php:71 |
18 | VirtueMartModelCalc->getCalc() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1086 |
17 | calculationHelper->getCalcRuleData() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1061 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:404 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.398 MB Zeilen zurückgegeben: 0
SELECT `virtuemart_state_id`
FROM `jos_virtuemart_calc_states`
WHERE `virtuemart_calc_id` = "2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.21 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
20 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
19 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/calc.php:74 |
18 | VirtueMartModelCalc->getCalc() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1086 |
17 | calculationHelper->getCalcRuleData() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1061 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:404 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.419 MB Zeilen zurückgegeben: 0
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_calc_manufacturers`
WHERE `virtuemart_calc_id` = "2"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
20 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
19 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/calc.php:77 |
18 | VirtueMartModelCalc->getCalc() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1086 |
17 | calculationHelper->getCalcRuleData() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1061 |
16 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2292 |
15 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:2402 |
14 | VirtueMartCart->prepareCartData() | JROOT/plugins/vmshipment/weight_countries/weight_countries.php:404 |
13 | plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39 |
10 | vDispatcher::trigger() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:370 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.04 ms Nach letzter Abfrage: 8.10 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 5.803 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_de_de`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_de_de`
ON `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_products_de_de`.`virtuemart_product_id`
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "58"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_products | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | jos_virtuemart_products_de_de | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.11 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
24 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1128 |
23 | VmTable->load() | JROOT/components/com_virtuemart/router.php:1408 |
22 | vmrouterHelper::getProductName() | JROOT/components/com_virtuemart/router.php:572 |
21 | vmrouterHelper::buildRoute() | JROOT/components/com_virtuemart/router.php:109 |
20 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
19 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
18 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
17 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/components/com_virtuemart/views/productdetails/tmpl/default.php:50 |
12 | include JROOT/components/com_virtuemart/views/productdetails/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:81 |
10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:437 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.69 ms Nach letzter Abfrage: 4.68 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.860 MB Zeilen zurückgegeben: 0
SELECT *
FROM `jos_virtuemart_ratings`
WHERE `virtuemart_product_id` = "11"
AND `published`="1"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_ratings | NULL | ref | virtuemart_product_id,published | virtuemart_product_id | 4 | const | 1 | 50.00 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/ratings.php:293 |
15 | VirtueMartModelRatings->getRatingByProduct() | JROOT/components/com_virtuemart/sublayouts/snippets.php:24 |
14 | include JROOT/components/com_virtuemart/sublayouts/snippets.php | JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:569 |
13 | shopFunctionsF::renderVmSubLayout() | JROOT/components/com_virtuemart/views/productdetails/tmpl/default.php:282 |
12 | include JROOT/components/com_virtuemart/views/productdetails/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_virtuemart/helpers/vmview.php:81 |
10 | VmView->display() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:437 |
9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_virtuemart/virtuemart.php:129 |
6 | require_once JROOT/components/com_virtuemart/virtuemart.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.89 ms Nach letzter Abfrage: 2.17 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 5.848 MB Zeilen zurückgegeben: 1
SELECT language,id
FROM `jos_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 52 | 1.00 | Using where |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.20 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_de_de`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_de_de`
ON `jos_virtuemart_categories`.`virtuemart_category_id` = `jos_virtuemart_categories_de_de`.`virtuemart_category_id`
3 × SELECT *
FROM jos_virtuemart_calcs
LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
2 × SELECT `l`.`product_name`, `l`.product_desc, `p`.virtuemart_product_id
FROM `jos_virtuemart_products` as p
LEFT JOIN `jos_virtuemart_products_de_de` 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 COLLATION_NAME
from information_schema.columns
2 × SELECT *
FROM jos_virtuemart_calcs
2 × SELECT *
FROM `jos_virtuemart_userfields`
2 × SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_de_de`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_de_de`
ON `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_products_de_de`.`virtuemart_product_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.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , j.`system_data` , l.payment_name, l.payment_desc
FROM jos_virtuemart_paymentmethods as i
LEFT JOIN `jos_virtuemart_paymentmethods_de_de` as l
ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
LEFT JOIN `jos_extensions` as j
ON j.`extension_id` = i.`payment_jplugin_id`
LEFT
OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s
ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
1 × SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_categories
1 × SELECT l.virtuemart_category_id, l.category_name, published
FROM `jos_virtuemart_categories` as c
LEFT JOIN `jos_virtuemart_categories_de_de` as l
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
1 × SELECT `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer
FROM `jos_virtuemart_rating_reviews` AS `pr`
INNER JOIN `jos_virtuemart_products_de_de` AS `l`
ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_rating_votes` AS `rv`
on (`pr`.`virtuemart_rating_vote_id` IS NOT NULL
AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR (`pr`.`virtuemart_rating_vote_id` IS NULL
AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`pr`.`created_by`) )
LEFT JOIN `jos_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , j.`system_data` , l.shipment_name, l.shipment_desc
FROM jos_virtuemart_shipmentmethods as i
LEFT JOIN `jos_virtuemart_shipmentmethods_de_de` 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 id, rules
FROM `jos_viewlevels
1 × SELECT vm.*
FROM `jos_virtuemart_paymentmethods` AS vm, jos_extensions AS j
1 × SELECT count(`p`.virtuemart_product_id) AS total
FROM `jos_virtuemart_product_categories` as `pc`
LEFT JOIN `jos_virtuemart_products` as `p`
ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
1 × SELECT `jos_virtuemart_calcs`.*
FROM `jos_virtuemart_calcs`
1 × SELECT `virtuemart_category_id`
FROM `jos_virtuemart_calc_categories`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_calc_shoppergroups`
1 × SELECT `virtuemart_country_id`
FROM `jos_virtuemart_calc_countries`
1 × SELECT `virtuemart_state_id`
FROM `jos_virtuemart_calc_states`
1 × SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_calc_manufacturers`
1 × SELECT *
FROM `jos_virtuemart_ratings`
1 × SELECT `jos_virtuemart_paymentmethods`.* ,`jos_virtuemart_paymentmethods_de_de`.*
FROM `jos_virtuemart_paymentmethods`
INNER JOIN `jos_virtuemart_paymentmethods_de_de`
ON `jos_virtuemart_paymentmethods`.`virtuemart_paymentmethod_id` = `jos_virtuemart_paymentmethods_de_de`.`virtuemart_paymentmethod_id`
1 × SELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug
FROM jos_virtuemart_categories as c
LEFT JOIN `jos_virtuemart_categories_de_de` as l
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
1 × SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
1 × SELECT `jos_virtuemart_shoppergroups`.*
FROM `jos_virtuemart_shoppergroups`
1 × SELECT `config`
FROM `jos_virtuemart_configs`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
1 × SELECT *
FROM `jos_menu`
1 × SELECT l.virtuemart_product_id
FROM `jos_virtuemart_products_de_de` as l
1 × SELECT l.virtuemart_category_id
FROM `jos_virtuemart_categories_de_de` as l
1 × SELECT id, home,`template`,`params`
FROM `jos_template_styles`
1 × SELECT *
FROM `jos_virtuemart_shoppergroups`
1 × SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
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 *
FROM `jos_virtuemart_product_prices`
1 × SELECT *
FROM `jos_virtuemart_product_categories`
1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`, field.`product_sku`, field.`product_gtin`, field.`product_mpn`
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 `jos_virtuemart_currencies`.*
FROM `jos_virtuemart_currencies`
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 `jos_virtuemart_ratings`.*
FROM `jos_virtuemart_ratings`
1 × SELECT language,id
FROM `jos_menu`