{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685865229,
                "last": 1685865229,
                "now": 1685865229
            },
            "client": {
                "forwarded": "3.239.129.52"
            },
            "token": "5zpeOGtNjTUJh7kEtUvkdIoPSVFNLi7P"
        },
        "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": {
        "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}"
    }
}

**Zeit**

**Speicher**

**109 ausgeführte Abfragen** 102.83 ms

1. **Abfragezeit: 0.94 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.030 MB** **Zeilen zurückgegeben: 0**

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'6136343635626233666430313834396666333132353337613738323631356163'

   **Erklären**

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

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

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

   ---

2. **Abfragezeit: 0.73 ms** **Nach letzter Abfrage: 0.68 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.044 MB** **Zeilen zurückgegeben: 0**

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'6136343635626233666430313834396666333132353337613738323631356163' 
     LIMIT 1

   **Erklären**

   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

   **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/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. **Abfragezeit: 1.40 ms** **Nach letzter Abfrage: 0.18 ms** **Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.049 MB**

   INSERT INTO `jos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   (X'6136343635626233666430313834396666333132353337613738323631356163', 1, 1685865229, 0, '')

   **Erklären**

   **„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'6136343635626233666430313834396666333132353337613738323631356163', 1, 1685865229, 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**]

   ---

4. **Abfragezeit: 2.33 ms** **Nach letzter Abfrage: 1.01 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**]

   ---

5. **Abfragezeit: 1.09 ms** **Nach letzter Abfrage: 1.11 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**]

   ---

6. **Abfragezeit: 1.09 ms** **Nach letzter Abfrage: 0.19 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**]

   ---

7. **Abfragezeit: 3.73 ms** **Nach letzter Abfrage: 0.30 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**]

   ---

8. **Abfragezeit: 0.98 ms** **Nach letzter Abfrage: 0.93 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**]

   ---

9. **Abfragezeit: 1.52 ms** **Nach letzter Abfrage: 16.20 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**]

   ---

10. **Abfragezeit: 4.52 ms** **Nach letzter Abfrage: 5.87 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**]

    ---

11. **Abfragezeit: 1.47 ms** **Nach letzter Abfrage: 9.61 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)**

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

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

    ---

12. **Abfragezeit: 1.58 ms** **Nach letzter Abfrage: 0.15 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.616 MB**

    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"af66beb5f86da372322ed0b5972cf434\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.04 ms
    System lock	0.03 ms
    Table lock	0.02 ms
    Init for update	0.15 ms
    Updating	0.14 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.52 ms
    Closing tables	0.05 ms
    Unlocking tables	0.03 ms
    Closing tables	0.06 ms
    Starting cleanup	0.05 ms
    Freeing items	0.03 ms
    Updating status	0.13 ms
    Reset for next command	0.04 ms

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

    ---

13. **Abfragezeit: 1.81 ms** **Nach letzter Abfrage: 0.50 ms** **Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 2.652 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)**

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

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

    ---

14. **Abfragezeit: 2.69 ms** **Nach letzter Abfrage: 10.66 ms** **Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.754 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)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

15. **Abfragezeit: 2.05 ms** **Nach letzter Abfrage: 0.21 ms** **Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.805 MB** **Zeilen zurückgegeben: 38**

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    **Erklären**

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

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

16. **Abfragezeit: 2.84 ms** **Nach letzter Abfrage: 1.99 ms** **Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 2.927 MB** **Zeilen zurückgegeben: 31**

    SHOW FULL COLUMNS 
      FROM `jos_content`

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.10 ms
    Checking permissions	0.03 ms
    Closing tables	0.02 ms
    Opening tables	0.69 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.06 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.08 ms
    Executing	0.02 ms
    Filling schema table	0.03 ms
    Opening tables	0.16 ms
    After opening tables	0.03 ms
    Checking permissions	0.38 ms
    Closing tables	0.03 ms
    Executing	0.02 ms
    Sending data	0.22 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Closing tables	0.02 ms
    Removing tmp table	0.32 ms
    Closing tables	0.03 ms
    Unlocking tables	0.02 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.10 ms
    Reset for next command	0.06 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

17. **Abfragezeit: 1.92 ms** **Nach letzter Abfrage: 15.73 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 2.986 MB**

    UPDATE jos_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '78'

    **Erklären**

    **„EXPLAIN“ unmöglich für Abfrage: UPDATE jos_content SET `hits` = (`hits` + 1) WHERE `id` = '78'**

    **Profil (Profile)**

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.03 ms
    Table lock	0.02 ms
    Init for update	0.13 ms
    Updating	0.42 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.49 ms
    Closing tables	0.05 ms
    Unlocking tables	0.02 ms
    Closing tables	0.08 ms
    Starting cleanup	0.02 ms
    Freeing items	0.07 ms
    Updating status	0.11 ms
    Reset for next command	0.05 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

18. **Abfragezeit: 2.70 ms** **Nach letzter Abfrage: 3.40 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.016 MB** **Zeilen zurückgegeben: 1**

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM jos_content AS a
    
      INNER JOIN jos_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN jos_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN jos_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jos_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 78 
      AND c.published > 0 
      AND a.language in ('de-DE','*') 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-04 07:53:49') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-04 07:53:49') 
      AND (a.state = 1 OR a.state =2)

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

    **Profil (Profile)**

    Status	Duration
    Starting	0.48 ms
    Checking permissions	0.03 ms
    Opening tables	0.15 ms
    After opening tables	0.03 ms
    System lock	0.04 ms
    Table lock	0.02 ms
    Init	0.17 ms
    Optimizing	0.14 ms
    Statistics	0.78 ms
    Preparing	0.03 ms
    Unlocking tables	0.03 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.12 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.02 ms
    Unlocking tables	0.03 ms
    Closing tables	0.07 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.11 ms
    Reset for next command	0.05 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

19. **Abfragezeit: 1.97 ms** **Nach letzter Abfrage: 1.18 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.126 MB** **Zeilen zurückgegeben: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m 
    
      INNER JOIN `jos_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 78 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	yorcks_pflanzen_de.m.tag_id	1	Using where

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

20. **Abfragezeit: 1.19 ms** **Nach letzter Abfrage: 0.64 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.173 MB** **Zeilen zurückgegeben: 1**

    SELECT MAX(ordering)
    
      FROM `jos_extensions`
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'content'

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

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
    13	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

21. **Abfragezeit: 0.69 ms** **Nach letzter Abfrage: 0.05 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.179 MB** **Zeilen zurückgegeben: 1**

    SELECT `ordering`
    
      FROM `jos_extensions`
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'content' 
      AND `element` = 'perfect_everything_in_everyway'

    **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	element_folder_clientid	804	const,const	1	Using index condition; Using where

    **Profil (Profile)**

    Status	Duration
    Starting	0.06 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.03 ms
    Statistics	0.12 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.06 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.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.07 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
    13	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

22. **Abfragezeit: 1.19 ms** **Nach letzter Abfrage: 6.31 ms** **Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.281 MB** **Zeilen zurückgegeben: 2**

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jos_categories` AS `s`
    
      INNER JOIN `jos_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('de-DE','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 79
    
      ORDER BY c.lft

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	**ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN**	NULL	NULL	72	Using where; **filesort wurde genutzt**

    **Profil (Profile)**

    Status	Duration
    Starting	0.18 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.08 ms
    Optimizing	0.05 ms
    Statistics	0.17 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.21 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.01 ms
    Updating status	0.06 ms
    Reset for next command	0.03 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

23. **Abfragezeit: 1.80 ms** **Nach letzter Abfrage: 0.22 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.302 MB** **Zeilen zurückgegeben: 0**

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jos_fields AS a
    
      LEFT JOIN `jos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jos_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jos_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (79,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; **filesort wurde genutzt**
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	yorcks_pflanzen_de.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	yorcks_pflanzen_de.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	yorcks_pflanzen_de.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	yorcks_pflanzen_de.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	yorcks_pflanzen_de.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	yorcks_pflanzen_de.a.id	1	Using where; Using index; Distinct

    **Profil (Profile)**

    Status	Duration
    Starting	0.18 ms
    Checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.16 ms
    Preparing	0.06 ms
    Creating tmp table	0.11 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.52 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.15 ms
    Creating sort index	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.01 ms
    Closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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**]

    ---

24. **Abfragezeit: 1.53 ms** **Nach letzter Abfrage: 19.08 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 3.406 MB** **Zeilen zurückgegeben: 1**

    SELECT language,id
    
      FROM `jos_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    **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_client_id_parent_id_alias_language	1	const	175	Using where

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. **Abfragezeit: 0.76 ms** **Nach letzter Abfrage: 0.32 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.417 MB** **Zeilen zurückgegeben: 0**

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `jos_menu` AS `c`
    
      INNER JOIN `jos_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `jos_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `jos_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 720

    **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	Impossible WHERE noticed after reading const tables

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. **Abfragezeit: 1.59 ms** **Nach letzter Abfrage: 1.14 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.432 MB** **Zeilen zurückgegeben: 0**

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `jos_content` AS `c`
    
      INNER JOIN `jos_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_content.item'
    
      INNER JOIN `jos_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `jos_content` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `jos_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_content'
    
      WHERE c.id = 78 
      AND c2.access IN (1,1,5) 
      AND c2.language != 'de-DE' 
      AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2023-06-04 07:53:49') 
      AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2023-06-04 07:53:49') 
      AND c2.state = 1

    **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	Impossible WHERE noticed after reading const tables

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
    8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. **Abfragezeit: 5.53 ms** **Nach letzter Abfrage: 1.78 ms** **Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 3.512 MB** **Zeilen zurückgegeben: 39**

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-04 07:53:49') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-04 07:53:49') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 720 OR mm.menuid <= 0) 
      AND m.language IN ('de-DE','*')
    
      ORDER BY m.position, m.ordering

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	50	Using index condition; Using where; **filesort wurde genutzt**
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	yorcks_pflanzen_de.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	yorcks_pflanzen_de.m.module,const	1	Using index condition; Using where

    **Profil (Profile)**

    Status	Duration
    Starting	0.27 ms
    Checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.11 ms
    Optimizing	0.10 ms
    Statistics	0.33 ms
    Preparing	0.19 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	3.77 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Closing tables	0.02 ms
    Unlocking tables	0.02 ms
    Closing tables	0.06 ms
    Starting cleanup	0.03 ms
    Freeing items	0.04 ms
    Updating status	0.10 ms
    Reset for next command	0.06 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	**Der selbe Aufruf in der Zeile darunter.**
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/elyse/index.php:193
    7	require JROOT/templates/elyse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

28. **Abfragezeit: 1.24 ms** **Nach letzter Abfrage: 1.79 ms** **Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.597 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)**

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Filling schema table	0.01 ms
    Checking permissions	0.56 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
    Removing tmp table	0.03 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:763
    20	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:578
    19	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:417
    18	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:190
    17	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
    16	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:113
    15	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/templates/elyse/index.php:2131
    7	require JROOT/templates/elyse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

29. **Abfragezeit: 0.62 ms** **Nach letzter Abfrage: 0.12 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.607 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)**

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 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.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:457
    18	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:190
    17	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
    16	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:113
    15	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/templates/elyse/index.php:2131
    7	require JROOT/templates/elyse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

30. **Abfragezeit: 3.44 ms** **Nach letzter Abfrage: 1.29 ms** **Abfragespeichernutzung: 0.089 MB Speichernutzung vor Abfrage: 3.753 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)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1594
    19	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:272
    18	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:254
    17	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
    16	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:113
    15	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/templates/elyse/index.php:2131
    7	require JROOT/templates/elyse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

31. **Abfragezeit: 0.76 ms** **Nach letzter Abfrage: 7.35 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.057 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)**

    Status	Duration
    Starting	0.06 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.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.22 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.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    **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/product.php:972
    14	VirtueMartModelProduct->getProductStockhandle()	JROOT/administrator/components/com_virtuemart/models/product.php:512
    13	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:2136
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

32. **Abfragezeit: 0.55 ms** **Nach letzter Abfrage: 0.03 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.064 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)**

    Status	Duration
    Starting	0.04 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.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.19 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.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    **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/product.php:975
    14	VirtueMartModelProduct->getProductStockhandle()	JROOT/administrator/components/com_virtuemart/models/product.php:512
    13	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:2136
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

33. **Abfragezeit: 0.54 ms** **Nach letzter Abfrage: 0.36 ms** **Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.132 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)**

    Status	Duration
    Starting	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 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.06 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 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.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
    18	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:138
    17	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
    16	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
    15	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    14	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:612
    13	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:2136
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

34. **Abfragezeit: 0.34 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.158 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)**

    Status	Duration
    Starting	0.04 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.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 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.01 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**
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1132
    20	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
    19	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:108
    18	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:138
    17	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
    16	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
    15	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1094
    14	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:612
    13	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:2136
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

35. **Abfragezeit: 2.75 ms** **Nach letzter Abfrage: 2.41 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.335 MB** **Zeilen zurückgegeben: 10**

    SELECT  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`  
     
      LEFT JOIN `jos_virtuemart_product_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`   
     
      WHERE ( `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 RAND() 
      LIMIT 0, 10

    **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	p	ref	PRIMARY,published	published	1	const	30	Using where
    1	SIMPLE	pp	ref	virtuemart_product_id	virtuemart_product_id	4	yorcks_pflanzen_de.p.virtuemart_product_id	1	Using index
    1	SIMPLE	pc	ref	virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_product_id	4	yorcks_pflanzen_de.p.virtuemart_product_id	1	Using index
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	yorcks_pflanzen_de.pc.virtuemart_category_id	1	Using where

    **Profil (Profile)**

    Status	Duration
    Starting	0.27 ms
    Checking permissions	0.03 ms
    Opening tables	0.12 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.24 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.08 ms
    Creating tmp table	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.98 ms
    Creating sort index	0.06 ms
    End of update loop	0.02 ms
    Removing tmp table	0.03 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.06 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.14 ms
    Reset for next command	0.07 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:867
    14	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:946
    13	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:2136
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

36. **Abfragezeit: 1.08 ms** **Nach letzter Abfrage: 0.12 ms** **Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 4.355 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)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1693
    15	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
    14	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
    13	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:2144
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

37. **Abfragezeit: 0.73 ms** **Nach letzter Abfrage: 0.27 ms** **Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.396 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)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
    16	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1718
    15	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
    14	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
    13	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:2144
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

38. **Abfragezeit: 1.34 ms** **Nach letzter Abfrage: 0.09 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.408 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 07:53:49" )
    		        
      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 07:53:49" ) ) 
      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)**

    Status	Duration
    Starting	0.15 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.10 ms
    Optimizing	0.08 ms
    Statistics	0.20 ms
    Preparing	0.07 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.19 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.08 ms
    Reset for next command	0.03 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1486
    17	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1510
    16	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1753
    15	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
    14	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
    13	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:2144
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

39. **Abfragezeit: 0.75 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.419 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.09 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.11 ms
    Reset for next command	0.03 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2066
    17	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:2043
    16	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1781
    15	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
    14	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
    13	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:2144
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

40. **Abfragezeit: 0.99 ms** **Nach letzter Abfrage: 0.11 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.452 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)**

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

    **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/models/product.php:2047
    16	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1781
    15	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1244
    14	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
    13	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:2144
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

41. **Abfragezeit: 1.12 ms** **Nach letzter Abfrage: 0.34 ms** **Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.494 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.23 ms
    Checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.08 ms
    Optimizing	0.05 ms
    Statistics	0.11 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.09 ms
    Reset for next command	0.04 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:159
    15	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1344
    14	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
    13	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:2144
    12	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/helper.php:49
    11	mod_virtuemart_product::displayProductsMod()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:48
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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**]

    ---

42. **Abfragezeit: 1.12 ms** **Nach letzter Abfrage: 0.28 ms** **Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.536 MB** **Zeilen zurückgegeben: 1**