Yorcks Garnelen und Pflanzenhöhle - Oberschopfheim | Pflanzen|Garnelen|Schnecken|Zubehör für Aquarien|Aquaristik |Topfpflanzen|Bundpflanzen|Mutterpflanzen|Teichpflanzen|In Vitro|Lahr|Offenburg|Schwanau|Meißenheim|Gegenbach|Nordrach|Biberach|Zell am Hammersbach|Steinach|Hohberg

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685867910,
                "last": 1685867910,
                "now": 1685867910
            },
            "client": {
                "forwarded": "3.239.129.52"
            },
            "token": "RbkRbq8jN7snYrxjgyk8h69Ae7ARUboN"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "de-DE"
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 773,
        "vmlastvisitedcategoryid": 33,
        "vmlastvisitedmanuid": 0,
        "vmcartlastVendorId": 1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":1,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":[],\"ST\":{\"address_type_name\":\"??Shipment??\"},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"de-DE\",\"pricesCurrency\":\"47\",\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":[],\"byDefaultST\":{\"address_type_name\":1},\"productCartLoaded\":[],\"loadedCart\":true}"
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

**Zeit**: 14.42 ms / 14.42 ms **Speicher**: 0.419 MB / 0.74 MB Application: afterLoad

**Zeit**: 57.25 ms / 71.66 ms **Speicher**: 1.361 MB / 2.10 MB Application: afterInitialise

**Zeit**: 9.02 ms / 80.68 ms **Speicher**: 0.503 MB / 2.61 MB Application: afterRoute

**Zeit**: 5.36 ms / 86.04 ms **Speicher**: 0.077 MB / 2.68 MB Application: beforeRenderComponent com_virtuemart

**Zeit**: 45.22 ms / 131.26 ms **Speicher**: 0.339 MB / 3.02 MB Application: Before Access::preloadComponents (all components)

**Zeit**: 2.28 ms / 133.53 ms **Speicher**: 0.059 MB / 3.08 MB Application: After Access::preloadComponents (all components)

**Zeit**: 0.06 ms / 133.59 ms **Speicher**: -0.002 MB / 3.08 MB Application: Before Access::getAssetRules (id:1 name:root.1)

**Zeit**: 0.45 ms / 134.04 ms **Speicher**: 0.009 MB / 3.09 MB Application: After Access::getAssetRules (id:1 name:root.1)

**Zeit**: 0.05 ms / 134.10 ms **Speicher**: 0.001 MB / 3.09 MB Application: Before Access::getAssetRules (id:179 name:com_virtuemart)

**Zeit**: 0.15 ms / 134.25 ms **Speicher**: 0.002 MB / 3.09 MB Application: After Access::getAssetRules (id:179 name:com_virtuemart)

**Zeit**: 128.00 ms / 262.24 ms **Speicher**: 2.980 MB / 6.07 MB Application: afterRenderComponent com_virtuemart

**Zeit**: 6.12 ms / 268.37 ms **Speicher**: 0.106 MB / 6.18 MB Application: afterDispatch

**Zeit**: 6.26 ms / 274.62 ms **Speicher**: 0.132 MB / 6.31 MB Application: beforeRenderModule mod_custom (Sonderangebot)

**Zeit**: 0.35 ms / 274.98 ms **Speicher**: 0.006 MB / 6.32 MB Application: afterRenderModule mod_custom (Sonderangebot)

**Zeit**: 0.06 ms / 275.04 ms **Speicher**: -0.002 MB / 6.31 MB Application: beforeRenderModule mod_custom (Footer Menu)

**Zeit**: 0.06 ms / 275.09 ms **Speicher**: 0.004 MB / 6.32 MB Application: afterRenderModule mod_custom (Footer Menu)

**Zeit**: 0.03 ms / 275.13 ms **Speicher**: -0.001 MB / 6.32 MB Application: beforeRenderModule mod_custom (Copyrights)

**Zeit**: 0.05 ms / 275.17 ms **Speicher**: 0.005 MB / 6.32 MB Application: afterRenderModule mod_custom (Copyrights)

**Zeit**: 0.03 ms / 275.20 ms **Speicher**: -0.001 MB / 6.32 MB Application: beforeRenderModule mod_custom (Yorcks Garnelen und Pflanzenhöhle)

**Zeit**: 0.05 ms / 275.25 ms **Speicher**: 0.003 MB / 6.32 MB Application: afterRenderModule mod_custom (Yorcks Garnelen und Pflanzenhöhle)

**Zeit**: 0.03 ms / 275.28 ms **Speicher**: -0.001 MB / 6.32 MB Application: beforeRenderModule mod_custom (Kontakt)

**Zeit**: 0.05 ms / 275.33 ms **Speicher**: 0.003 MB / 6.33 MB Application: afterRenderModule mod_custom (Kontakt)

**Zeit**: 0.03 ms / 275.35 ms **Speicher**: -0.001 MB / 6.32 MB Application: beforeRenderModule mod_custom (Support)

**Zeit**: 0.05 ms / 275.40 ms **Speicher**: 0.003 MB / 6.33 MB Application: afterRenderModule mod_custom (Support)

**Zeit**: 0.03 ms / 275.43 ms **Speicher**: -0.001 MB / 6.33 MB Application: beforeRenderModule mod_custom (Service)

**Zeit**: 0.05 ms / 275.47 ms **Speicher**: 0.003 MB / 6.33 MB Application: afterRenderModule mod_custom (Service)

**Zeit**: 0.03 ms / 275.50 ms **Speicher**: -0.000 MB / 6.33 MB Application: beforeRenderModule mod_custom (Lieferzeiten)

**Zeit**: 0.05 ms / 275.55 ms **Speicher**: 0.003 MB / 6.33 MB Application: afterRenderModule mod_custom (Lieferzeiten)

**Zeit**: 0.05 ms / 275.60 ms **Speicher**: 0.001 MB / 6.33 MB Application: beforeRenderModule mod_custom (Banner 2 Right)

**Zeit**: 0.05 ms / 275.65 ms **Speicher**: 0.003 MB / 6.34 MB Application: afterRenderModule mod_custom (Banner 2 Right)

**Zeit**: 0.02 ms / 275.66 ms **Speicher**: 0.000 MB / 6.34 MB Application: beforeRenderModule mod_virtuemart_product (Auch interessant... )

**Zeit**: 7.67 ms / 283.34 ms **Speicher**: 0.141 MB / 6.48 MB Application: afterRenderModule mod_virtuemart_product (Auch interessant... )

**Zeit**: 0.10 ms / 283.44 ms **Speicher**: 0.016 MB / 6.49 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

**Zeit**: 0.48 ms / 283.92 ms **Speicher**: 0.013 MB / 6.51 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

**Zeit**: 0.06 ms / 283.97 ms **Speicher**: -0.004 MB / 6.50 MB Application: beforeRenderModule mod_menu (Zubehör & Co)

**Zeit**: 1.38 ms / 285.36 ms **Speicher**: 0.065 MB / 6.57 MB Application: afterRenderModule mod_menu (Zubehör & Co)

**Zeit**: 0.02 ms / 285.38 ms **Speicher**: -0.005 MB / 6.56 MB Application: beforeRenderModule mod_custom (Zubehör Image)

**Zeit**: 0.06 ms / 285.44 ms **Speicher**: 0.003 MB / 6.57 MB Application: afterRenderModule mod_custom (Zubehör Image)

**Zeit**: 0.04 ms / 285.48 ms **Speicher**: 0.002 MB / 6.57 MB Application: beforeRenderModule mod_menu (Tiere & Co)

**Zeit**: 0.59 ms / 286.07 ms **Speicher**: 0.035 MB / 6.60 MB Application: afterRenderModule mod_menu (Tiere & Co)

**Zeit**: 0.02 ms / 286.09 ms **Speicher**: -0.004 MB / 6.60 MB Application: beforeRenderModule mod_custom (Tiere Image)

**Zeit**: 0.05 ms / 286.15 ms **Speicher**: 0.003 MB / 6.60 MB Application: afterRenderModule mod_custom (Tiere Image)

**Zeit**: 0.04 ms / 286.19 ms **Speicher**: 0.002 MB / 6.61 MB Application: beforeRenderModule mod_menu (Pflanzen & Co)

**Zeit**: 1.44 ms / 287.63 ms **Speicher**: 0.084 MB / 6.69 MB Application: afterRenderModule mod_menu (Pflanzen & Co)

**Zeit**: 0.02 ms / 287.65 ms **Speicher**: -0.004 MB / 6.68 MB Application: beforeRenderModule mod_custom (Pflanzen Image)

**Zeit**: 0.06 ms / 287.71 ms **Speicher**: 0.003 MB / 6.69 MB Application: afterRenderModule mod_custom (Pflanzen Image)

**Zeit**: 0.05 ms / 287.76 ms **Speicher**: 0.002 MB / 6.69 MB Application: beforeRenderModule mod_virtuemart_search (VM - Search in Shop)

**Zeit**: 0.64 ms / 288.39 ms **Speicher**: 0.013 MB / 6.70 MB Application: afterRenderModule mod_virtuemart_search (VM - Search in Shop)

**Zeit**: 0.05 ms / 288.44 ms **Speicher**: -0.003 MB / 6.70 MB Application: beforeRenderModule mod_custom (Logo Top)

**Zeit**: 0.11 ms / 288.56 ms **Speicher**: 0.004 MB / 6.70 MB Application: afterRenderModule mod_custom (Logo Top)

**Zeit**: 0.04 ms / 288.59 ms **Speicher**: -0.001 MB / 6.70 MB Application: beforeRenderModule mod_login (My Account)

**Zeit**: 1.11 ms / 289.70 ms **Speicher**: 0.041 MB / 6.74 MB Application: afterRenderModule mod_login (My Account)

**Zeit**: 0.04 ms / 289.74 ms **Speicher**: -0.004 MB / 6.74 MB Application: beforeRenderModule mod_virtuemart_cart (Shopping cart)

**Zeit**: 50.60 ms / 340.34 ms **Speicher**: 1.249 MB / 7.99 MB Application: afterRenderModule mod_virtuemart_cart (Shopping cart)

**Zeit**: 0.08 ms / 340.43 ms **Speicher**: -0.002 MB / 7.99 MB Application: beforeRenderModule mod_menu (Menu)

**Zeit**: 0.91 ms / 341.34 ms **Speicher**: 0.041 MB / 8.03 MB Application: afterRenderModule mod_menu (Menu)

**Zeit**: 25.06 ms / 366.40 ms **Speicher**: 0.253 MB / 8.28 MB Application: afterRender

**Datenbankabfragen gesamt: 107.00 ms**

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1	Using index

**„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'3063613565616634323437633730366233373862333134316139643732396236', 1, 1685867910, 0, '')**

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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: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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.69 ms** **Nach letzter Abfrage: 0.63 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.081 MB** **Zeilen zurückgegeben: 41**

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

  FROM `jos_extensions`

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

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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}()	*Der selbe 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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.09 ms** **Nach letzter Abfrage: 0.68 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.109 MB** **Zeilen zurückgegeben: 6**

SELECT id, rules

  FROM `jos_viewlevels`

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_viewlevels	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.99 ms** **Nach letzter Abfrage: 0.13 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.122 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 = 13

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 3.12 ms** **Nach letzter Abfrage: 0.19 ms** **Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 1.143 MB** **Zeilen zurückgegeben: 115**

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

  FROM jos_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	160	Using index condition; Using where; filesort wurde genutzt

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	*Der selbe 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:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.20 ms** **Nach letzter Abfrage: 0.59 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.266 MB** **Zeilen zurückgegeben: 2**

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_languages	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; filesort wurde genutzt

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.33 ms** **Nach letzter Abfrage: 17.33 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.677 MB** **Zeilen zurückgegeben: 4**

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `jos_extensions`

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

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:280
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:667
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 3.99 ms** **Nach letzter Abfrage: 6.89 ms** **Abfragespeichernutzung: 0.113 MB Speichernutzung vor Abfrage: 1.826 MB** **Zeilen zurückgegeben: 70**

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

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

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

  ORDER BY m.lft

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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}()	*Der selbe 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:78
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:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:533
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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.21 ms** **Nach letzter Abfrage: 10.09 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.626 MB** **Zeilen zurückgegeben: 1**

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

  FROM `jos_extensions`

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

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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}()	*Der selbe 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: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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.49 ms** **Nach letzter Abfrage: 0.12 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.616 MB**

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"669a0cccb69a04c8933ccb8162315701\"}'

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

**Erklären**

**„EXPLAIN“ unmöglich für Abfrage: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"669a0cccb69a04c8933ccb8162315701\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.55 ms** **Nach letzter Abfrage: 0.41 ms** **Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 2.641 MB** **Zeilen zurückgegeben: 5**

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	yorcks_pflanzen_de.s.template,const	1	Using index condition; Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.44 ms** **Nach letzter Abfrage: 42.02 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.960 MB** **Zeilen zurückgegeben: 1**

SHOW TABLES LIKE "jos_virtuemart_configs"

**Erklären**

**„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES LIKE "jos_virtuemart_configs"**

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:763
9	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:578
8	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:417
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.05 ms** **Nach letzter Abfrage: 0.24 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.965 MB** **Zeilen zurückgegeben: 1**

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_configs	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:457
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.82 ms** **Nach letzter Abfrage: 1.15 ms** **Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.030 MB** **Zeilen zurückgegeben: 41**

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_awocoupon','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_redirect','com_search','com_sppagebuilder','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	ALL	idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	181	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:479
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
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

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 4.46 ms** **Nach letzter Abfrage: 14.73 ms** **Abfragespeichernutzung: 0.090 MB Speichernutzung vor Abfrage: 3.256 MB** **Zeilen zurückgegeben: 41**

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" )  
  ORDER BY `language` DESC

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	175	Using index condition; Using where; filesort wurde genutzt

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1594
22	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:272
21	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:254
20	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:113
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:578
10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:133
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.29 ms** **Nach letzter Abfrage: 1.49 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.478 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` = "33"

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:1093
11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:102
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:179
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.66 ms** **Nach letzter Abfrage: 0.18 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.494 MB** **Zeilen zurückgegeben: 1**

SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "33"  
  ORDER BY `ordering`

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:105
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:179
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 2.83 ms** **Nach letzter Abfrage: 0.23 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.586 MB** **Zeilen zurückgegeben: 1**

SELECT c.* 
  FROM jos_virtuemart_customs  as c 
  INNER JOIN jos_virtuemart_product_customfields as pc 
  on (c.virtuemart_custom_id=pc.virtuemart_custom_id)

  INNER JOIN jos_virtuemart_product_categories as cat 
  ON (pc.virtuemart_product_id=cat.virtuemart_product_id) 
  WHERE virtuemart_category_id="33" 
  and searchable="1" 
  and (field_type="S" or field_type="P") 
  and c.published = 1 
  GROUP BY c.virtuemart_custom_id

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,field_type,published,searchable,field_type_searchable_published	searchable	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	pc	ref	virtuemart_custom_id,virtuemart_product_id,unique_cust_prd_value	virtuemart_custom_id	4	yorcks_pflanzen_de.c.virtuemart_custom_id	24	Using index condition
1	SIMPLE	cat	eq_ref	virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_product_id	8	yorcks_pflanzen_de.pc.virtuemart_product_id,const	1	Using where; Using index

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:606
10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:217
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 2.17 ms** **Nach letzter Abfrage: 0.04 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.595 MB** **Zeilen zurückgegeben: 0**

SELECT pc.* 
  FROM jos_virtuemart_product_customfields  as pc 
  INNER JOIN jos_virtuemart_products as p 
  on (pc.virtuemart_product_id=p.virtuemart_product_id)
  INNER JOIN jos_virtuemart_product_categories as cat 
  on (pc.virtuemart_product_id=cat.virtuemart_product_id) 
  WHERE virtuemart_custom_id="21" 
  and p.published="1"  
  and virtuemart_category_id="33"  
  GROUP BY `customfield_value`

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	virtuemart_custom_id,virtuemart_product_id,unique_cust_prd_value	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	39	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	yorcks_pflanzen_de.pc.virtuemart_product_id	1	Using index condition; Using where
1	SIMPLE	cat	eq_ref	virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_product_id	8	yorcks_pflanzen_de.pc.virtuemart_product_id,const	1	Using where; Using index

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:633
10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:217
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.03 ms** **Nach letzter Abfrage: 0.57 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.671 MB** **Zeilen zurückgegeben: 1**

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

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:138
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:175
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.56 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.694 MB** **Zeilen zurückgegeben: 1**

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

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:1093
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1132
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:108
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:138
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:175
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.80 ms** **Nach letzter Abfrage: 1.09 ms** **Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 3.743 MB** **Zeilen zurückgegeben: 32**

SHOW FULL COLUMNS  
  FROM `jos_virtuemart_userfields`

**Erklären**

**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos_virtuemart_userfields`**

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:724
19	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
18	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:210
17	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:433
16	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:395
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:350
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.82 ms** **Nach letzter Abfrage: 0.16 ms** **Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.779 MB** **Zeilen zurückgegeben: 19**

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_userfields	ref	published,account	published	1	const	22	Using where; filesort wurde genutzt

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:504
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:603
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:484
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:391
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 1.03 ms** **Nach letzter Abfrage: 4.77 ms** **Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.889 MB** **Zeilen zurückgegeben: 11**

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_userfields	ref	published,shipment	shipment	1	const	13	Using where; filesort wurde genutzt

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:504
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:603
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:490
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:391
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.53 ms** **Nach letzter Abfrage: 0.27 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.937 MB** **Zeilen zurückgegeben: 0**

SELECT `product_stockhandle` 
  FROM `jos_virtuemart_products` 
  WHERE `product_stockhandle` = "disableit_children" 
  AND `published` = "1" 
  LIMIT 1

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_products	ref	published	published	1	const	30	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/product.php:972
11	VirtueMartModelProduct->getProductStockhandle()	JROOT/administrator/components/com_virtuemart/models/product.php:512
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.47 ms** **Nach letzter Abfrage: 0.03 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.943 MB** **Zeilen zurückgegeben: 0**

SELECT `product_stockhandle` 
  FROM `jos_virtuemart_products` 
  WHERE `product_stockhandle` = "disableit" 
  AND `published` = "1" 
  LIMIT 1

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_products	ref	published	published	1	const	30	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/product.php:975
11	VirtueMartModelProduct->getProductStockhandle()	JROOT/administrator/components/com_virtuemart/models/product.php:512
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.69 ms** **Nach letzter Abfrage: 0.23 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.970 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` = "33"
	  
  AND `p`.`virtuemart_vendor_id` = "1"
	  
  AND `p`.`published` = "1"

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ref	virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_category_id	4	const	22	Using index
1	SIMPLE	p	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	yorcks_pflanzen_de.pc.virtuemart_product_id	1	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:684
14	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:146
13	VirtueMartModelCategory->getCategory()	JROOT/administrator/components/com_virtuemart/models/product.php:1012
12	VirtueMartModelProduct->setPaginationLimits()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:946
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.95 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.978 MB** **Zeilen zurückgegeben: 12**

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
		
  FROM `jos_virtuemart_products` as p   
 
  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 (33)  
  AND  `c`.`published` = 1  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
 
  group by p.`virtuemart_product_id` 
 
  ORDER BY `pc`.`ordering` ASC, p.`virtuemart_product_id` ASC 
  LIMIT 0, 24

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ps	system	virtuemart_product_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	Const row not found; Using temporary; filesort wurde genutzt
1	SIMPLE	c	const	PRIMARY,published	PRIMARY	4	const	1
1	SIMPLE	pc	ref	virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_category_id	4	const	22	Using where
1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	yorcks_pflanzen_de.pc.virtuemart_product_id	1	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:867
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:946
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.24 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.985 MB** **Zeilen zurückgegeben: 1**

SELECT FOUND_ROWS()

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	No tables used

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:881
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:946
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.62 ms** **Nach letzter Abfrage: 1.09 ms** **Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.087 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` = "439"

**Erklären**

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

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	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:1093
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1693
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:286
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.41 ms** **Nach letzter Abfrage: 0.30 ms** **Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.122 MB** **Zeilen zurückgegeben: 1**

SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "439"  
  ORDER BY `ordering`

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	1	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1718
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:286
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.53 ms** **Nach letzter Abfrage: 0.12 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.135 MB** **Zeilen zurückgegeben: 1**

SELECT * 
  FROM `jos_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "439"  
  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` <= "2023-06-04 08:38:31" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-06-04 08:38:31" ) ) 
  ORDER BY `product_price` DESC

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; filesort wurde genutzt

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1486
14	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1510
13	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1753
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:286
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.30 ms** **Nach letzter Abfrage: 0.05 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.144 MB** **Zeilen zurückgegeben: 1**

SELECT * 
  FROM `jos_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 439

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_virtuemart_product_categories	ref	virtuemart_product_id,virtuemart_product_id_uid	virtuemart_product_id	4	const	1

**Profil (Profile)**

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2066
14	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:2043
13	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1781
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:286
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.49 ms** **Nach letzter Abfrage: 0.38 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.193 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 (439) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id,unique_cust_prd_value	virtuemart_product_id	4	const	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	yorcks_pflanzen_de.field.virtuemart_custom_id	1	Using index condition; Using where

**Profil (Profile)**

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:159
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1344
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:286
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

**Abfragezeit: 0.51 ms** **Nach letzter Abfrage: 0.28 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.233 MB** **Zeilen zurückgegeben: 1**

#	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()	*Der selbe 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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Pflanzen & Co

Tiere & Co

Zubehör & Co

Pflanzendünger

Banner 2 Right

Auch interessant...

* Lieferzeit gilt für Lieferungen innerhalb Deutschlands, Lieferzeiten für andere Länder entnehmen Sie bitte den Informationen unter Versand & Lieferung.

Service

Rechtliches

Follow us

Support

Kontakt

Über Yorcks Garnelen und Pflanzenhöhle

Versand & Bezahlung

**Joomla!-Debug-Konsole**

**Sitzung**

**Profil zum Laufzeitverhalten**

**Zeit**

**Speicher**

**Speichernutzung**

**Datenbankabfragen**

**133 ausgeführte Abfragen** 107.00 ms

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

133 ausgeführte Abfragen 107.00 ms