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": 1685862364,
                "last": 1685862364,
                "now": 1685862364
            },
            "client": {
                "forwarded": "3.239.129.52"
            },
            "token": "j9oiRhKyuiK956ima7zTt4VmccpcBoto"
        },
        "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": 620,
        "vmlastvisitedcategoryid": 20,
        "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**: 5.20 ms / 5.20 ms **Speicher**: 0.419 MB / 0.74 MB Application: afterLoad

**Zeit**: 53.69 ms / 58.89 ms **Speicher**: 1.361 MB / 2.10 MB Application: afterInitialise

**Zeit**: 31.03 ms / 89.92 ms **Speicher**: 0.503 MB / 2.61 MB Application: afterRoute

**Zeit**: 5.01 ms / 94.93 ms **Speicher**: 0.077 MB / 2.68 MB Application: beforeRenderComponent com_virtuemart

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

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

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

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

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

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

**Zeit**: 187.76 ms / 291.61 ms **Speicher**: 5.174 MB / 8.27 MB Application: afterRenderComponent com_virtuemart

**Zeit**: 4.59 ms / 296.20 ms **Speicher**: 0.043 MB / 8.31 MB Application: afterDispatch

**Zeit**: 6.39 ms / 302.59 ms **Speicher**: 0.128 MB / 8.44 MB Application: beforeRenderModule mod_custom (Sonderangebot)

**Zeit**: 0.82 ms / 303.41 ms **Speicher**: 0.006 MB / 8.44 MB Application: afterRenderModule mod_custom (Sonderangebot)

**Zeit**: 0.05 ms / 303.46 ms **Speicher**: -0.002 MB / 8.44 MB Application: beforeRenderModule mod_custom (Footer Menu)

**Zeit**: 0.05 ms / 303.51 ms **Speicher**: 0.004 MB / 8.45 MB Application: afterRenderModule mod_custom (Footer Menu)

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

**Zeit**: 0.05 ms / 303.59 ms **Speicher**: 0.005 MB / 8.45 MB Application: afterRenderModule mod_custom (Copyrights)

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

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

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

**Zeit**: 0.05 ms / 303.75 ms **Speicher**: 0.003 MB / 8.45 MB Application: afterRenderModule mod_custom (Kontakt)

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

**Zeit**: 0.05 ms / 303.83 ms **Speicher**: 0.003 MB / 8.46 MB Application: afterRenderModule mod_custom (Support)

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

**Zeit**: 0.05 ms / 303.90 ms **Speicher**: 0.003 MB / 8.46 MB Application: afterRenderModule mod_custom (Service)

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

**Zeit**: 0.05 ms / 303.97 ms **Speicher**: 0.003 MB / 8.46 MB Application: afterRenderModule mod_custom (Lieferzeiten)

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

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

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

**Zeit**: 7.26 ms / 311.35 ms **Speicher**: 0.236 MB / 8.70 MB Application: afterRenderModule mod_virtuemart_product (Auch interessant... )

**Zeit**: 0.08 ms / 311.43 ms **Speicher**: 0.016 MB / 8.72 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

**Zeit**: 0.42 ms / 311.85 ms **Speicher**: 0.013 MB / 8.73 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

**Zeit**: 0.05 ms / 311.90 ms **Speicher**: -0.004 MB / 8.73 MB Application: beforeRenderModule mod_menu (Zubehör & Co)

**Zeit**: 1.35 ms / 313.25 ms **Speicher**: 0.072 MB / 8.80 MB Application: afterRenderModule mod_menu (Zubehör & Co)

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

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

**Zeit**: 0.05 ms / 313.38 ms **Speicher**: 0.002 MB / 8.80 MB Application: beforeRenderModule mod_menu (Tiere & Co)

**Zeit**: 0.51 ms / 313.90 ms **Speicher**: 0.027 MB / 8.83 MB Application: afterRenderModule mod_menu (Tiere & Co)

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

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

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

**Zeit**: 1.31 ms / 315.32 ms **Speicher**: 0.084 MB / 8.91 MB Application: afterRenderModule mod_menu (Pflanzen & Co)

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

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

**Zeit**: 0.04 ms / 315.44 ms **Speicher**: 0.002 MB / 8.91 MB Application: beforeRenderModule mod_virtuemart_search (VM - Search in Shop)

**Zeit**: 0.62 ms / 316.06 ms **Speicher**: 0.013 MB / 8.93 MB Application: afterRenderModule mod_virtuemart_search (VM - Search in Shop)

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

**Zeit**: 0.07 ms / 316.18 ms **Speicher**: 0.004 MB / 8.93 MB Application: afterRenderModule mod_custom (Logo Top)

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

**Zeit**: 1.22 ms / 317.43 ms **Speicher**: 0.035 MB / 8.96 MB Application: afterRenderModule mod_login (My Account)

**Zeit**: 0.05 ms / 317.48 ms **Speicher**: -0.004 MB / 8.96 MB Application: beforeRenderModule mod_virtuemart_cart (Shopping cart)

**Zeit**: 44.61 ms / 362.09 ms **Speicher**: 1.151 MB / 10.11 MB Application: afterRenderModule mod_virtuemart_cart (Shopping cart)

**Zeit**: 0.07 ms / 362.17 ms **Speicher**: -0.002 MB / 10.10 MB Application: beforeRenderModule mod_menu (Menu)

**Zeit**: 0.76 ms / 362.92 ms **Speicher**: 0.041 MB / 10.15 MB Application: afterRenderModule mod_menu (Menu)

**Zeit**: 39.73 ms / 402.66 ms **Speicher**: 0.362 MB / 10.51 MB Application: afterRender

**Datenbankabfragen gesamt: 143.42 ms**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	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

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'3863396433653363363239393739333430646332653232393766636436666162', 1, 1685862364, 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.28 ms** **Nach letzter Abfrage: 0.96 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: 0.87 ms** **Nach letzter Abfrage: 1.00 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.83 ms** **Nach letzter Abfrage: 0.17 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: 2.84 ms** **Nach letzter Abfrage: 0.27 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.04 ms** **Nach letzter Abfrage: 0.80 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.16 ms** **Nach letzter Abfrage: 15.19 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.87 ms** **Nach letzter Abfrage: 5.42 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.32 ms** **Nach letzter Abfrage: 31.88 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.39 ms** **Nach letzter Abfrage: 0.11 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.616 MB**

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"542498b595563c6cebe639e4b5e5c9eb\"}'

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

**Erklären**

**„EXPLAIN“ unmöglich für Abfrage: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"542498b595563c6cebe639e4b5e5c9eb\"}' 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.24 ms** **Nach letzter Abfrage: 0.36 ms** **Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 2.642 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.55 ms** **Nach letzter Abfrage: 2.97 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: 0.85 ms** **Nach letzter Abfrage: 0.09 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.966 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: 3.15 ms** **Nach letzter Abfrage: 0.39 ms** **Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.031 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: 2.88 ms** **Nach letzter Abfrage: 5.75 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.07 ms** **Nach letzter Abfrage: 3.78 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.477 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` = "20"

**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.62 ms** **Nach letzter Abfrage: 0.17 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.493 MB** **Zeilen zurückgegeben: 1**

SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "20"  
  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.34 ms** **Nach letzter Abfrage: 0.22 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.586 MB** **Zeilen zurückgegeben: 0**

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="20" 
  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	cat	ref	virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_category_id	4	const	1	Using index
1	SIMPLE	pc	ref	virtuemart_custom_id,virtuemart_product_id,unique_cust_prd_value	unique_cust_prd_value	8	yorcks_pflanzen_de.c.virtuemart_custom_id,yorcks_pflanzen_de.cat.virtuemart_product_id	2	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: 0.80 ms** **Nach letzter Abfrage: 0.56 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.662 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.61 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.686 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: 2.03 ms** **Nach letzter Abfrage: 1.11 ms** **Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 3.734 MB** **Zeilen zurückgegeben: 32**
</

Pflanzen & Co

Tiere & Co

Zubehör & Co

Zubehör

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**

**242 ausgeführte Abfragen** 143.42 ms

**6 Duplikate gefunden!**

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

242 ausgeführte Abfragen 143.42 ms

6 Duplikate gefunden!