Campbell American
Hersteller:
Campbell American
Ergebnisse 1 - 1 von 1
Login Formular
Sortiment
Öffnungszeiten
Montags
Geschlossen
Dienstag bis Freitag
09.00 - 13.00 / 14.00 - 18.30
Samstags
09.00 - 17.00 durchgehend
Kontakt
Store
Münchensteinerstrasse 268
CH-4053 Basel
Werkstatt
Bordeaux-Strasse 5
CH-4053 Basel
Schule
Münchensteinerstrasse 268
CH-4053 Basel
+41 61 560 01 94
Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
Wir nutzen Cookies zum Speichern Ihrer Anmeldedaten, für eine sichere Anmeldung, zur Erhebung statistischer Daten, zur Optimierung der Website-Funktionen und um Ihnen insgesamt eine angenehmere Erfahrung zu bieten. Klicken Sie auf „Akzeptieren“, um Cookies zu akzeptieren oder klicken Sie unten auf „Ablehnen“.
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1611224787,
"last": 1611224787,
"now": 1611224787
},
"token": "X7rxGxM6bPKuxh1DanIZzCWVhqDvBDj3"
},
"registry": {
"com_virtuemart": {
"category": {
"limit": "6,12,18,24,100"
},
"categoryc0m63": {
"limitstart": 0
}
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "de-DE"
}
},
"__vm": {
"manage": 0,
"vmlastvisitedItemid": 560,
"vmlastvisitedcategoryid": 0,
"vmlastvisitedmanuid": 63,
"vmcartlastVendorId": 1
},
"__sige": {
"sigcount": null,
"sigcountarticles": null
}
}
Zeit
Speicher
Zeit: 5.90 ms / 5.90 ms Speicher: 0.505 MB / 0.89 MB Application: afterLoad
Zeit: 250.79 ms / 256.69 ms Speicher: 1.554 MB / 2.44 MB Application: Before Access::preloadComponents (all components)
Zeit: 1.48 ms / 258.17 ms Speicher: 0.062 MB / 2.50 MB Application: After Access::preloadComponents (all components)
Zeit: 0.04 ms / 258.21 ms Speicher: -0.002 MB / 2.50 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Zeit: 0.25 ms / 258.45 ms Speicher: 0.073 MB / 2.57 MB Application: After Access::getAssetRules (id:1 name:root.1)
Zeit: 0.03 ms / 258.48 ms Speicher: 0.001 MB / 2.58 MB Application: Before Access::getAssetRules (id:492 name:com_virtuemart)
Zeit: 0.01 ms / 258.49 ms Speicher: 0.002 MB / 2.58 MB Application: After Access::getAssetRules (id:492 name:com_virtuemart)
Zeit: 9.69 ms / 268.18 ms Speicher: 0.303 MB / 2.88 MB Application: afterInitialise
Zeit: 9.87 ms / 278.05 ms Speicher: 0.220 MB / 3.10 MB Application: afterRoute
Zeit: 6.77 ms / 284.82 ms Speicher: 0.119 MB / 3.22 MB Application: beforeRenderComponent com_virtuemart
Zeit: 132.67 ms / 417.49 ms Speicher: 3.494 MB / 6.71 MB Application: afterRenderComponent com_virtuemart
Zeit: 6.94 ms / 424.44 ms Speicher: 0.147 MB / 6.86 MB Application: afterDispatch
Zeit: 5.30 ms / 429.73 ms Speicher: 0.090 MB / 6.95 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Zeit: 0.06 ms / 429.79 ms Speicher: 0.007 MB / 6.96 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Zeit: 0.06 ms / 429.85 ms Speicher: 0.003 MB / 6.96 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Zeit: 1.05 ms / 430.91 ms Speicher: 0.022 MB / 6.98 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Zeit: 0.02 ms / 430.93 ms Speicher: 0.002 MB / 6.98 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Zeit: 0.13 ms / 431.06 ms Speicher: -0.014 MB / 6.97 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Zeit: 0.08 ms / 431.14 ms Speicher: -0.000 MB / 6.97 MB Application: beforeRenderModule mod_virtuemart_category (Sortiment)
Zeit: 2.95 ms / 434.10 ms Speicher: 0.075 MB / 7.04 MB Application: afterRenderModule mod_virtuemart_category (Sortiment)
Zeit: 0.06 ms / 434.16 ms Speicher: -0.051 MB / 6.99 MB Application: beforeRenderModule mod_menu (Navigation)
Zeit: 2.01 ms / 436.17 ms Speicher: 0.141 MB / 7.13 MB Application: afterRenderModule mod_menu (Navigation)
Zeit: 0.03 ms / 436.20 ms Speicher: -0.001 MB / 7.13 MB Application: beforeRenderModule mod_custom (Öffnungszeiten)
Zeit: 2.66 ms / 438.86 ms Speicher: 0.023 MB / 7.16 MB Application: afterRenderModule mod_custom (Öffnungszeiten)
Zeit: 0.03 ms / 438.89 ms Speicher: 0.000 MB / 7.16 MB Application: beforeRenderModule mod_custom (Kontakt)
Zeit: 1.82 ms / 440.71 ms Speicher: 0.008 MB / 7.17 MB Application: afterRenderModule mod_custom (Kontakt)
Zeit: 0.08 ms / 440.79 ms Speicher: -0.001 MB / 7.16 MB Application: beforeRenderModule mod_virtuemart_category (Kategorien)
Zeit: 0.68 ms / 441.47 ms Speicher: 0.056 MB / 7.22 MB Application: afterRenderModule mod_virtuemart_category (Kategorien)
Zeit: 0.03 ms / 441.50 ms Speicher: -0.051 MB / 7.17 MB Application: beforeRenderModule mod_virtuemart_manufacturer (Hersteller)
Zeit: 79.79 ms / 521.29 ms Speicher: 1.044 MB / 8.21 MB Application: afterRenderModule mod_virtuemart_manufacturer (Hersteller)
Zeit: 0.06 ms / 521.34 ms Speicher: 0.009 MB / 8.22 MB Application: beforeRenderModule mod_virtuemart_product_tm (Neuste)
Zeit: 9.23 ms / 530.58 ms Speicher: 0.086 MB / 8.31 MB Application: afterRenderModule mod_virtuemart_product_tm (Neuste)
Zeit: 0.11 ms / 530.68 ms Speicher: -0.020 MB / 8.29 MB Application: beforeRenderModule mod_virtuemart_search (Produktsuche)
Zeit: 1.11 ms / 531.79 ms Speicher: 0.017 MB / 8.31 MB Application: afterRenderModule mod_virtuemart_search (Produktsuche)
Zeit: 0.03 ms / 531.82 ms Speicher: -0.007 MB / 8.30 MB Application: beforeRenderModule mod_virtuemart_cart_tm (VirtueMart Shopping Cart)
Zeit: 3.20 ms / 535.02 ms Speicher: 0.156 MB / 8.45 MB Application: afterRenderModule mod_virtuemart_cart_tm (VirtueMart Shopping Cart)
Zeit: 0.04 ms / 535.06 ms Speicher: 0.004 MB / 8.46 MB Application: beforeRenderModule mod_icemegamenu (Navigation menu)
Zeit: 10.03 ms / 545.09 ms Speicher: 0.229 MB / 8.69 MB Application: afterRenderModule mod_icemegamenu (Navigation menu)
Zeit: 0.10 ms / 545.19 ms Speicher: -0.001 MB / 8.69 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login oder Registrieren)
Zeit: 4.15 ms / 549.35 ms Speicher: 0.052 MB / 8.74 MB Application: afterRenderModule mod_socialloginandsocialshare (Login oder Registrieren)
Zeit: 0.05 ms / 549.40 ms Speicher: -0.011 MB / 8.73 MB Application: beforeRenderModule mod_custom (Social Media Icons)
Zeit: 0.69 ms / 550.09 ms Speicher: 0.003 MB / 8.73 MB Application: afterRenderModule mod_custom (Social Media Icons)
Zeit: 20.90 ms / 570.99 ms Speicher: 0.160 MB / 8.89 MB Application: afterRender
Datenbankabfragen gesamt: 378.89 ms
10,01 MB (10.498.920 Bytes)
181 ausgeführte Abfragen 378.89 ms
- Abfragezeit: 0.72 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.251 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `vim87_session`
WHERE `session_id` = X'3133386132303031306563623566633734336431613430333433356337613537'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Derselbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.68 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.266 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `vim87_session`
WHERE `session_id` = X'3133386132303031306563623566633734336431613430333433356337613537'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 212.16 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.272 MB
INSERT INTO `vim87_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3133386132303031306563623566633734336431613430333433356337613537', 1, 1611224787, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `vim87_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3133386132303031306563623566633734336431613430333433356337613537', 1, 1611224787, 0, '', 0)Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.33 ms Nach letzter Abfrage: 1.45 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.308 MB Zeilen zurückgegeben: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vim87_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_extensions NULL ref extension extension 82 const 43 1.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Derselbe Aufruf in der Zeile darunter. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.77 ms Nach letzter Abfrage: 1.27 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.342 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `vim87_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.77 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.354 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM vim87_usergroups AS a
LEFT JOIN vim87_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.08 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.051 MB Speichernutzung vor Abfrage: 1.376 MB Zeilen zurückgegeben: 129
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM vim87_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_extensions NULL ref extension extension 82 const 170 0.60 Using index condition; Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Derselbe Aufruf in der Zeile darunter. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.73 ms Nach letzter Abfrage: 9.45 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.146 MB Zeilen zurückgegeben: 2
SELECT *
FROM vim87_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_languages NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.56 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.156 MB Zeilen zurückgegeben: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `vim87_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_extensions NULL ref extension extension 82 const 4 1.25 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.56 ms Nach letzter Abfrage: 2.30 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.202 MB Zeilen zurückgegeben: 10Doppelte Abfragen: #181
SELECT *
FROM vim87_loginradius_settingsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_loginradius_settings NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 10 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58 9 plgSystemSocialLoginTools::sociallogin_getsettings() JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51 8 plgSystemSocialLoginAndSocialShare->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.05 ms Nach letzter Abfrage: 2.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.374 MB Zeilen zurückgegeben: 1
SHOW TABLES LIKE "vim87_virtuemart_configs"
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES LIKE "vim87_virtuemart_configs"Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:727 11 VmTable::checkTableExists() JROOT/administrator/components/com_virtuemart/models/config.php:580 10 VirtueMartModelConfig::checkConfigTableExists() JROOT/administrator/components/com_virtuemart/helpers/config.php:415 9 VmConfig::loadConfig() JROOT/plugins/system/vm3_cart/vm3_cart.php:23 8 plgSystemVM3_Cart->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.381 MB Zeilen zurückgegeben: 1
SELECT `config`
FROM `vim87_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_virtuemart_configs NULL system PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/config.php:455 9 VmConfig::loadConfig() JROOT/plugins/system/vm3_cart/vm3_cart.php:23 8 plgSystemVM3_Cart->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.26 ms Nach letzter Abfrage: 0.71 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.449 MB Zeilen zurückgegeben: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `vim87_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','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_sige','com_socialloginandsocialshare','com_tags','com_tcpdf','com_templates','com_tmbox','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_assets NULL ALL idx_asset_name ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 243 18.11 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136 11 vmAccess::manager() JROOT/administrator/components/com_virtuemart/helpers/config.php:85 10 VmConfig::echoAdmin() JROOT/administrator/components/com_virtuemart/helpers/config.php:477 9 VmConfig::loadConfig() JROOT/plugins/system/vm3_cart/vm3_cart.php:23 8 plgSystemVM3_Cart->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.28 ms Nach letzter Abfrage: 3.24 ms Abfragespeichernutzung: 0.093 MB Speichernutzung vor Abfrage: 2.635 MB Zeilen zurückgegeben: 62
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM vim87_menu AS m
LEFT JOIN vim87_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 68 10.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 musicsto_musicJM.m.component_id 1 100.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Derselbe Aufruf in der Zeile darunter. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.36 ms Nach letzter Abfrage: 6.98 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.059 MB Zeilen zurückgegeben: 4
SELECT id, home, template, s.params
FROM vim87_template_styles as s
LEFT JOIN vim87_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 6 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 musicsto_musicJM.e.element 1 66.67 Using index condition; Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 13 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/components/com_virtuemart/router.php:852 12 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:970 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:374 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.84 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 3.080 MB Zeilen zurückgegeben: 14
SELECT *
FROM `vim87_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" )
ORDER BY `language` DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 69 0.81 Using index condition; Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_virtuemart/router.php:1405 14 vmrouterHelper->setMenuItemId() JROOT/components/com_virtuemart/router.php:920 13 vmrouterHelper->setRoutingQuery() JROOT/components/com_virtuemart/router.php:898 12 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:970 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:374 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.093 MB Zeilen zurückgegeben: 1
SELECT l.virtuemart_manufacturer_id
FROM `vim87_virtuemart_manufacturers_de_de` as l
WHERE l.slug = "campbell"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE l NULL const slug slug 578 const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_virtuemart/router.php:1333 12 vmrouterHelper->getFieldOfObjectWithLangFallBack() JROOT/components/com_virtuemart/router.php:1293 11 vmrouterHelper->getManufacturerId() JROOT/components/com_virtuemart/router.php:500 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:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.74 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.122 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vim87_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Derselbe Aufruf in der Zeile darunter. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 4.60 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 3.112 MB
UPDATE `vim87_extensions`
SET `params` = '{\"mediaversion\":\"10e99cc98bebee1214c13e51d38d1a3b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE vim87_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:1131 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.54 ms Nach letzter Abfrage: 7.04 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.480 MB Zeilen zurückgegeben: 1
SELECT l.slug
FROM `vim87_virtuemart_manufacturers_de_de` as l
WHERE l.virtuemart_manufacturer_id = "63"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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_virtuemart/router.php:1333 20 vmrouterHelper->getFieldOfObjectWithLangFallBack() JROOT/components/com_virtuemart/router.php:1287 19 vmrouterHelper->getManufacturerName() JROOT/components/com_virtuemart/router.php:68 18 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 17 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 16 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 15 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_virtuemart/views/category/view.html.php:581 10 VirtuemartViewCategory->setCanonicalLink() JROOT/components/com_virtuemart/views/category/view.html.php:130 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.99 ms Nach letzter Abfrage: 1.46 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.634 MB Zeilen zurückgegeben: 0
SELECT c.*
FROM vim87_virtuemart_customs as c
WHERE searchable="1"
and (field_type="S" or field_type="P")
and c.published = 1
GROUP BY c.virtuemart_custom_idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref PRIMARY,field_type,searchable,published searchable 1 const 1 30.56 Using index condition; Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_virtuemart/views/category/view.html.php:609 10 VirtuemartViewCategory->getSearchCustom() JROOT/components/com_virtuemart/views/category/view.html.php:233 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.95 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.716 MB Zeilen zurückgegeben: 1
SELECT *
FROM `vim87_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 vim87_virtuemart_shoppergroups NULL ref virtuemart_vendor_id,shared,published published 1 const 3 25.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:100 14 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 13 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:186 12 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 11 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:176 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/category/view.html.php:246 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.739 MB Zeilen zurückgegeben: 1
SELECT `vim87_virtuemart_shoppergroups`.*
FROM `vim87_virtuemart_shoppergroups`
WHERE `vim87_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_virtuemart_shoppergroups NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:1061 17 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024 16 VmModel->getData() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50 15 VirtueMartModelShopperGroup->getShopperGroup() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105 14 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 13 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:186 12 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 11 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:176 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/category/view.html.php:246 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.30 ms Nach letzter Abfrage: 0.97 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 3.789 MB Zeilen zurückgegeben: 32
SHOW FULL COLUMNS
FROM `vim87_virtuemart_userfields`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `vim87_virtuemart_userfields`Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:688 19 VmTable->showFullColumns() JROOT/administrator/components/com_virtuemart/tables/userfields.php:41 18 TableUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:211 17 VmTable::getInstance() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432 16 VmModel->_createTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394 15 VmModel->getTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:607 14 VmModel->setMainTable() JROOT/administrator/components/com_virtuemart/models/userfields.php:49 13 VirtueMartModelUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559 12 VmModel::getModel() JROOT/components/com_virtuemart/helpers/cart.php:344 11 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:231 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/category/view.html.php:246 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.89 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.825 MB Zeilen zurückgegeben: 21
SELECT *
FROM `vim87_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_virtuemart_userfields NULL ref published,account account 1 const 22 89.29 Using index condition; Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:503 14 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:602 13 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:483 12 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:385 11 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:231 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/category/view.html.php:246 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.81 ms Nach letzter Abfrage: 20.97 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 5.121 MB Zeilen zurückgegeben: 14
SELECT *
FROM `vim87_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 orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_virtuemart_userfields NULL ref published,shipment shipment 1 const 14 89.29 Using index condition; Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:503 14 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:602 13 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:489 12 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:385 11 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:231 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/category/view.html.php:246 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.55 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 5.180 MB Zeilen zurückgegeben: 0
SELECT p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `vim87_virtuemart_products` as p
LEFT JOIN `vim87_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `vim87_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `vim87_virtuemart_categories` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `vim87_virtuemart_product_manufacturers`
ON p.`virtuemart_product_id` = `vim87_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `vim87_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ((p.`product_parent_id` = "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")
AND ((p.`product_parent_id` > "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")
AND `c`.`published` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND `vim87_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 63
AND p.`product_special`="1"
AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `product_price` ASC, p.`virtuemart_product_id` ASC
LIMIT 0, 18id 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 p NULL ref PRIMARY,product_parent_id,product_special,published product_special 1 const 1 90.43 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE pp NULL ref virtuemart_product_id virtuemart_product_id 4 musicsto_musicJM.p.virtuemart_product_id 1 100.00 NULL 1 SIMPLE pc NULL ref virtuemart_product_id virtuemart_product_id 4 musicsto_musicJM.p.virtuemart_product_id 3 100.00 Using where; Using index 1 SIMPLE c NULL eq_ref PRIMARY,published PRIMARY 4 musicsto_musicJM.pc.virtuemart_category_id 1 90.48 Using where 1 SIMPLE vim87_virtuemart_product_manufacturers NULL ref virtuemart_product_id virtuemart_product_id 10 musicsto_musicJM.p.virtuemart_product_id,const 11 100.00 Using where; Using index Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:865 12 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:833 11 VirtueMartModelProduct->sortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:1992 10 VirtueMartModelProduct->getProductListing() JROOT/components/com_virtuemart/views/category/view.html.php:302 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.05 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 5.207 MB Zeilen zurückgegeben: 1
SELECT p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `vim87_virtuemart_products` as p
LEFT JOIN `vim87_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `vim87_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `vim87_virtuemart_categories` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `vim87_virtuemart_product_manufacturers`
ON p.`virtuemart_product_id` = `vim87_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `vim87_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ((p.`product_parent_id` = "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")
AND ((p.`product_parent_id` > "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")
AND `c`.`published` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND `vim87_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 63
AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY p.`created_on` DESC, p.`virtuemart_product_id` DESC
LIMIT 0, 6id 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 vim87_virtuemart_product_manufacturers NULL index virtuemart_product_id virtuemart_product_id 10 NULL 250 10.00 Using where; Using index; Using temporary; filesort wurde genutzt 1 SIMPLE p NULL eq_ref PRIMARY,product_parent_id,published PRIMARY 4 musicsto_musicJM.vim87_virtuemart_product_manufacturers.virtuemart_product_id 1 90.43 Using index condition; Using where 1 SIMPLE pp NULL ref virtuemart_product_id virtuemart_product_id 4 musicsto_musicJM.p.virtuemart_product_id 1 100.00 NULL 1 SIMPLE pc NULL ref virtuemart_product_id virtuemart_product_id 4 musicsto_musicJM.vim87_virtuemart_product_manufacturers.virtuemart_product_id 3 100.00 Using where; Using index 1 SIMPLE c NULL eq_ref PRIMARY,published PRIMARY 4 musicsto_musicJM.pc.virtuemart_category_id 1 90.48 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:865 12 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:833 11 VirtueMartModelProduct->sortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:1992 10 VirtueMartModelProduct->getProductListing() JROOT/components/com_virtuemart/views/category/view.html.php:302 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 5.224 MB Zeilen zurückgegeben: 1
SELECT `vim87_virtuemart_products`.* ,`vim87_virtuemart_products_de_de`.*
FROM `vim87_virtuemart_products`
INNER JOIN `vim87_virtuemart_products_de_de`
ON `vim87_virtuemart_products`.`virtuemart_product_id` = `vim87_virtuemart_products_de_de`.`virtuemart_product_id`
WHERE `vim87_virtuemart_products`.`virtuemart_product_id` = "248"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_virtuemart_products NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE vim87_virtuemart_products_de_de NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 14 VmTable->load() JROOT/administrator/components/com_virtuemart/models/product.php:1565 13 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1124 12 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:2073 11 VirtueMartModelProduct->getProducts() JROOT/administrator/components/com_virtuemart/models/product.php:2000 10 VirtueMartModelProduct->getProductListing() JROOT/components/com_virtuemart/views/category/view.html.php:302 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.63 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 5.262 MB Zeilen zurückgegeben: 3
SELECT `virtuemart_media_id`
FROM `vim87_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "248"
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_virtuemart_product_medias NULL ref virtuemart_product_id,ordering ordering 4 const 3 100.00 Using index condition Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128 14 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/product.php:1588 13 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1124 12 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:2073 11 VirtueMartModelProduct->getProducts() JROOT/administrator/components/com_virtuemart/models/product.php:2000 10 VirtueMartModelProduct->getProductListing() JROOT/components/com_virtuemart/views/category/view.html.php:302 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.274 MB Zeilen zurückgegeben: 1
SELECT *
FROM `vim87_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "248"
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` <= "2021-01-21 11:26:27" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-21 11:26:27" ) )
ORDER BY `product_price` DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vim87_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.53 Using index condition; Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/models/product.php:1359 15 VirtueMartModelProduct->loadProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:1380 14 VirtueMartModelProduct->getRawProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:1624 13 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1124 12 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:2073 11