Abfragezeit: 0.51 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.074 MB Zeilen zurückgegeben: 1
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = X'6433653563373937373639356236383333613466303538366261366338316132'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 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 |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.37 ms Nach letzter Abfrage: 1.93 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.157 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.07 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.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.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.44 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.169 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.05 ms |
checking permissions | 0.01 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.09 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.02 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: 3.00 ms Nach letzter Abfrage: 24.58 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.231 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.16 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 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.29 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.02 ms |
closing tables | 0.02 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.75 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.239 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.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.15 ms |
init | 0.10 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
preparing | 0.03 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 |
---|
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.65 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.307 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.17 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.14 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.34 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.70 ms |
end | 0.02 ms |
query end | 0.02 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: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: 2.02 ms Nach letzter Abfrage: 1.67 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 2.378 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` = "206")
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.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.12 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 1.06 ms |
end | 0.02 ms |
query end | 0.02 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: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.53 ms Nach letzter Abfrage: 0.81 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.501 MB Zeilen zurückgegeben: 1
SELECT l.virtuemart_product_id
FROM `jos_virtuemart_products_de_de` as l
WHERE l.slug = "germana-clássica"
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.05 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.17 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.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.36 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.509 MB Zeilen zurückgegeben: 1
SELECT l.virtuemart_category_id
FROM `jos_virtuemart_categories_de_de` as l
WHERE l.slug = "neutral"
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.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.09 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 |
---|
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.62 ms Nach letzter Abfrage: 0.76 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.521 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"ed3c6bc785123f143381411fdce4de80\"}'
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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.05 ms |
System lock | 0.12 ms |
updating | 0.10 ms |
end | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
end | 0.01 ms |
query end | 0.07 ms |
closing tables | 0.01 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.48 ms Nach letzter Abfrage: 3.34 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.709 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.09 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.07 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.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.71 ms Nach letzter Abfrage: 3.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.914 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.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.11 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: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.40 ms Nach letzter Abfrage: 0.51 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.948 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.06 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.08 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.02 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.30 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 2.989 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.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.25 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Opening tables | 0.08 ms |
checking permissions | 0.07 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.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.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
Sending data | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.06 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: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: 0.99 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.025 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
Creating sort index | 0.41 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: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: 0.84 ms Nach letzter Abfrage: 2.33 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.209 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.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.26 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 |
---|
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.70 ms Nach letzter Abfrage: 0.68 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.344 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` = "140"
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.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.10 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.09 ms |
end | 0.01 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 |
---|
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.49 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.384 MB Zeilen zurückgegeben: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "140"
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.07 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.06 ms |
preparing | 0.04 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.77 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.395 MB Zeilen zurückgegeben: 1
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "140"
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-17 04:52:31" )
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-17 04:52:31" ) )
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.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.17 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.07 ms |
end | 0.03 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 |
---|
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.32 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.418 MB Zeilen zurückgegeben: 1
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "140"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_product_manufacturers | NULL | ref | virtuemart_product_id | virtuemart_product_id | 5 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 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:1789 |
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.30 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.422 MB Zeilen zurückgegeben: 5
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 140
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_uid | 4 | const | 4 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.02 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.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: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.67 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.455 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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.15 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 |
---|
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.51 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.474 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` = "7"
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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 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.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.45 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.493 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` = "9"
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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 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.02 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.42 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.511 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` = "14"
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.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 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 |
---|
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.43 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.530 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` = "27"
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.02 ms |
Opening tables | 0.02 ms |
init | 0.03 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.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.66 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.554 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_manufacturers`.* ,`jos_virtuemart_manufacturers_de_de`.*
FROM `jos_virtuemart_manufacturers`
INNER JOIN `jos_virtuemart_manufacturers_de_de`
ON `jos_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `jos_virtuemart_manufacturers_de_de`.`virtuemart_manufacturer_id`
WHERE `jos_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "36"
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_manufacturers | NULL | const | PRIMARY,virtuemart_manufacturercategories_id | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | jos_virtuemart_manufacturers_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.12 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.15 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 |
---|
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:1868 |
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.83 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.590 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 (140)
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.13 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.12 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.21 ms |
preparing | 0.02 ms |
executing | 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 |
---|
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.68 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.629 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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.17 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.39 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.668 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.05 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.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.02 ms |
query end | 0.02 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: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.91 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.709 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-17 04:52:31" )
AND ( ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00") OR publish_down >= "2024-05-17 04:52:31" )
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.07 ms |
init | 0.13 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.17 ms |
preparing | 0.07 ms |
executing | 0.01 ms |
Sending data | 0.11 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.37 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.731 MB Zeilen zurückgegeben: 0
SELECT `jos_virtuemart_ratings`.*
FROM `jos_virtuemart_ratings`
WHERE `jos_virtuemart_ratings`.`virtuemart_product_id` = "140"
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.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.04 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.46 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.778 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "371"
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.04 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.13 ms |
preparing | 0.01 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.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.90 ms Nach letzter Abfrage: 1.56 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.986 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 (27)
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`!="140"
AND `l`.product_desc >= "<p><strong>Ein milder Cachaça, der seid über 100 Jahren produziert wird und mit kräftigen Zuckerrohraromen glänzt. Durch seine neutrale Lagerung erhält er die erfrischenden Noten des Zuckerrohres und mildert das Destillat ab.</strong></p>\\r\\n<p> </p>\\r\\n<p>In der Brennerei werden seit 1912 mehrere Sorten Cachaça hergestellt. Die Region Nova União gehört zu den traditionsreichsten Zentren der Zuckerrohrverarbeitung in Brasilien. Mit der eigenen hohen Qualität konnte man bereits viele Erfolge bei Rankings und Wettbewerben erzielen. Geschmacklich würden wir ihn als vollmundig und auch als relativ weich beschreiben. Es gibt andere Destilate, die die typischen Zuckerroharomen kräftiger zeigen und auch in der Nase intensiver auftreten. Der Germana clássica zeigt schöne Zuckerrohrnoten, die auch in einer Caipirinha nicht untergehen. Der Reiz des Germanas liegen in seiner unspektakulären Ausgewogenheit.</p>\\r\\n<p> </p>\\r\\n<p>Wie es sich für einen guten Cachaça gehört, wird er gelagert, bevor er in Flaschen abgefüllt wird - hier sind es 6 Monate. So entstehen beim Germana clássica geschmackstragende Esther, die für einen frischen Duft sorgen und Zitrusnoten entfalten. Die Aggressivität der billigen Zuckerrohrsdestillate ist ihm fremd.</p>\\r\\n<p> </p>\\r\\n<p>Er ist ein authentischen Vertreter der jungen Qualitäts-Destillate aus Zuckerrohr und eignet sich nicht nur für ein zünftiges Churrasco. Eine Caipirinha lässt die Limettennoten in den Mittelpunkt rücken. Für das pure Vergnügen empfehlen wir ihn ähnlich wie Wodka kaltzustellen.</p>\\r\\n<p> </p>\\r\\n<p>Inhalt: 700 ml</p>\\r\\n<p>Alkoholgehalt: 40% Vol</p>\\r\\n<p>Typ: Cachaça artesanal - 6 Monate in Edelstahl gelagert - Spirituose aus Zuckerrohrsaft</p>\\r\\n<p> </p>\\r\\n<p><img src="images/stories/logos-buttons/badges/badge-1year-neutral-350x286.png" alt="bis zu 1 Jahr gelagert" width="123" height="100" /><img src="images/stories/logos-buttons/badges/badge-40-350x286.png" alt="badge 40 350x286" width="122" height="100" /><img src="images/stories/logos-buttons/badges/badge-artesanal-350x286.png" alt="Artesanal - Cachaca de Qualidade" width="123" height="100" /></p>\\r\\n<p> </p>\\r\\n<p><br /><span class="smarterwiki-popup-bubble" style="top: 4px;
left: 490px; margin-
left: -51px; margin-top: -57px; opacity: 0.25;"><span class="smarterwiki-popup-bubble-tip"></span></span></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 | 19 | 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.31 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.20 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.23 ms |
preparing | 0.04 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.53 ms |
Creating sort index | 0.19 ms |
end | 0.01 ms |
query end | 0.02 ms |
removing tmp table | 0.04 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 |
---|
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.39 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.999 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 (27)
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`!="140"
AND p.`virtuemart_product_id`!="128"
AND `l`.product_desc <= "<p><strong>Ein milder Cachaça, der seid über 100 Jahren produziert wird und mit kräftigen Zuckerrohraromen glänzt. Durch seine neutrale Lagerung erhält er die erfrischenden Noten des Zuckerrohres und mildert das Destillat ab.</strong></p>\\r\\n<p> </p>\\r\\n<p>In der Brennerei werden seit 1912 mehrere Sorten Cachaça hergestellt. Die Region Nova União gehört zu den traditionsreichsten Zentren der Zuckerrohrverarbeitung in Brasilien. Mit der eigenen hohen Qualität konnte man bereits viele Erfolge bei Rankings und Wettbewerben erzielen. Geschmacklich würden wir ihn als vollmundig und auch als relativ weich beschreiben. Es gibt andere Destilate, die die typischen Zuckerroharomen kräftiger zeigen und auch in der Nase intensiver auftreten. Der Germana clássica zeigt schöne Zuckerrohrnoten, die auch in einer Caipirinha nicht untergehen. Der Reiz des Germanas liegen in seiner unspektakulären Ausgewogenheit.</p>\\r\\n<p> </p>\\r\\n<p>Wie es sich für einen guten Cachaça gehört, wird er gelagert, bevor er in Flaschen abgefüllt wird - hier sind es 6 Monate. So entstehen beim Germana clássica geschmackstragende Esther, die für einen frischen Duft sorgen und Zitrusnoten entfalten. Die Aggressivität der billigen Zuckerrohrsdestillate ist ihm fremd.</p>\\r\\n<p> </p>\\r\\n<p>Er ist ein authentischen Vertreter der jungen Qualitäts-Destillate aus Zuckerrohr und eignet sich nicht nur für ein zünftiges Churrasco. Eine Caipirinha lässt die Limettennoten in den Mittelpunkt rücken. Für das pure Vergnügen empfehlen wir ihn ähnlich wie Wodka kaltzustellen.</p>\\r\\n<p> </p>\\r\\n<p>Inhalt: 700 ml</p>\\r\\n<p>Alkoholgehalt: 40% Vol</p>\\r\\n<p>Typ: Cachaça artesanal - 6 Monate in Edelstahl gelagert - Spirituose aus Zuckerrohrsaft</p>\\r\\n<p> </p>\\r\\n<p><img src="images/stories/logos-buttons/badges/badge-1year-neutral-350x286.png" alt="bis zu 1 Jahr gelagert" width="123" height="100" /><img src="images/stories/logos-buttons/badges/badge-40-350x286.png" alt="badge 40 350x286" width="122" height="100" /><img src="images/stories/logos-buttons/badges/badge-artesanal-350x286.png" alt="Artesanal - Cachaca de Qualidade" width="123" height="100" /></p>\\r\\n<p> </p>\\r\\n<p><br /><span class="smarterwiki-popup-bubble" style="top: 4px;
left: 490px; margin-
left: -51px; margin-top: -57px; opacity: 0.25;"><span class="smarterwiki-popup-bubble-tip"></span></span></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 | 18 | 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.28 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.14 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.20 ms |
preparing | 0.05 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
Creating sort index | 0.04 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: 0.55 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.018 MB Zeilen zurückgegeben: 0
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_manufacturer_medias`
WHERE `virtuemart_manufacturer_id` = "36"
ORDER BY `ordering`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos_virtuemart_manufacturer_medias | NULL | ref | virtuemart_manufacturer_id | virtuemart_manufacturer_id | 4 | const | 1 | 100.00 | Using index condition; filesort wurde genutzt |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.02 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 |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
12 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78 |
11 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/manufacturer.php:62 |
10 | VirtueMartModelManufacturer->getManufacturer() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:189 |
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.39 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.039 MB Zeilen zurückgegeben: 1
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "27"
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.01 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.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.52 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.046 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` = "27"
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 | 20 | 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.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 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.17 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: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.24 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.053 MB Zeilen zurückgegeben: 1
SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_categories
WHERE `virtuemart_category_id`= 27
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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 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.29 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.062 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 = 27
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.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.02 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 |
---|
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.28 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.069 MB Zeilen zurückgegeben: 1
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "287"
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.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 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.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: 1.10 ms Nach letzter Abfrage: 1.01 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.094 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.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
checking permissions | 0.07 ms |
checking permissions | 0.05 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.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.02 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
removing tmp table | 0.05 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: 1.08 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.101 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.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
checking permissions | 0.11 ms |
checking permissions | 0.04 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.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.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.04 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 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: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.92 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.109 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` = "140"
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.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.31 ms |
init | 0.11 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.05 ms |
Creating tmp table | 0.23 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.22 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.10 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.06 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: 3.19 ms Nach letzter Abfrage: 69.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.215 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.26 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.93 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.12 ms |
preparing | 0.05 ms |
Creating tmp table | 0.11 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.64 ms |
Creating sort index | 0.16 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.06 ms |
freeing items | 0.07 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: 0.93 ms Nach letzter Abfrage: 0.81 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.273 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-17 04:52:31" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-17 04:52:31" )
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.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.13 ms |
System lock | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.17 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | 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.66 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.283 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-17 04:52:31" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-17 04:52:31" )
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.10 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.04 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.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: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.54 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.293 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-17 04:52:31" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-17 04:52:31" )
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.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.03 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.02 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: 1.96 ms Nach letzter Abfrage: 0.58 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 5.308 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.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.47 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.03 ms |
Creating tmp table | 0.12 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
Creating sort index | 0.15 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.08 ms |
freeing items | 0.06 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.49 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.359 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.07 ms |
checking permissions | 0.01 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.03 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.11 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: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.43 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.403 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.07 ms |
checking permissions | 0.01 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.06 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 |
---|
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.86 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.419 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.04 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.13 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.02 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.47 ms Nach letzter Abfrage: 1.59 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.481 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.02 ms |
Opening tables | 0.02 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.07 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 |
---|
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.40 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.503 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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.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.61 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.530 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.25 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.02 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: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.24 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.551 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.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 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: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.49 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.571 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.20 ms |
init | 0.02 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.04 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.46 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.592 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.03 ms |
Opening tables | 0.24 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.31 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.613 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.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.00 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 |
---|
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: 0.88 ms Nach letzter Abfrage: 6.96 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 6.060 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` = "128"
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.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.13 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 |
---|
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.42 ms Nach letzter Abfrage: 2.63 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.106 MB Zeilen zurückgegeben: 1
SELECT l.slug
FROM `jos_virtuemart_manufacturers_de_de` as l
WHERE l.virtuemart_manufacturer_id = "36"
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 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.02 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.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
26 | JDatabaseDriver->loadResult() | JROOT/components/com_virtuemart/router.php:1587 |
25 | vmrouterHelper::getFieldOfObjectWithLangFallBack() | JROOT/components/com_virtuemart/router.php:1540 |
24 | vmrouterHelper::getManufacturerName() | JROOT/components/com_virtuemart/router.php:581 |
23 | vmrouterHelper::buildRoute() | JROOT/components/com_virtuemart/router.php:109 |
22 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
21 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_virtuemart/views/productdetails/tmpl/default_manufacturer.php:25 |
14 | include JROOT/components/com_virtuemart/views/productdetails/tmpl/default_manufacturer.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_virtuemart/views/productdetails/tmpl/default.php:180 |
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.51 ms Nach letzter Abfrage: 1.91 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 6.132 MB Zeilen zurückgegeben: 0
SELECT *
FROM `jos_virtuemart_ratings`
WHERE `virtuemart_product_id` = "140"
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.08 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.07 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.03 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.81 ms Nach letzter Abfrage: 1.72 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 6.120 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.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.27 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 |
---|
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 |
5 × 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 `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
2 × SELECT *
FROM jos_virtuemart_calcs
2 × SELECT COLLATION_NAME
from information_schema.columns
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 *
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 `virtuemart_category_id`
FROM `jos_virtuemart_calc_categories`
1 × SELECT l.slug
FROM `jos_virtuemart_manufacturers_de_de` as l
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 `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 *
FROM `jos_virtuemart_ratings`
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 `virtuemart_manufacturer_id`
FROM `jos_virtuemart_calc_manufacturers`
1 × SELECT `jos_virtuemart_calcs`.*
FROM `jos_virtuemart_calcs`
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 vm.*
FROM `jos_virtuemart_paymentmethods` AS vm, jos_extensions AS j
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 `virtuemart_state_id`
FROM `jos_virtuemart_calc_states`
1 × SELECT `virtuemart_country_id`
FROM `jos_virtuemart_calc_countries`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_calc_shoppergroups`
1 × SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
1 × SELECT `session_id`
FROM `jos_session`
1 × SELECT `virtuemart_media_id`
FROM `jos_virtuemart_manufacturer_medias`
1 × SELECT `jos_virtuemart_shoppergroups`.*
FROM `jos_virtuemart_shoppergroups`
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 `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 id, rules
FROM `jos_viewlevels
1 × SELECT *
FROM `jos_virtuemart_product_prices`
1 × SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
1 × SELECT *
FROM `jos_virtuemart_product_categories`
1 × SELECT `jos_virtuemart_manufacturers`.* ,`jos_virtuemart_manufacturers_de_de`.*
FROM `jos_virtuemart_manufacturers`
INNER JOIN `jos_virtuemart_manufacturers_de_de`
ON `jos_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `jos_virtuemart_manufacturers_de_de`.`virtuemart_manufacturer_id`
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`