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

**Zeit**

**Speicher**

**48 ausgeführte Abfragen** 68.37 ms

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

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

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

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

   **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: 1.30 ms** **Nach letzter Abfrage: 0.91 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'3335306532303435346537386230653039303730613434653539313164316631' 
     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)**

   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.05 ms
   Table lock	0.02 ms
   Init	0.04 ms
   Optimizing	0.07 ms
   Statistics	0.06 ms
   Preparing	0.05 ms
   Executing	0.04 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.04 ms
   Closing tables	0.08 ms
   Starting cleanup	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.08 ms
   Reset for next command	0.03 ms

   **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.85 ms** **Nach letzter Abfrage: 0.20 ms** **Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.049 MB**

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

   **Erklären**

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

   **Profil (Profile)**

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

   **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.08 ms** **Nach letzter Abfrage: 1.14 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.080 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)**

   Status	Duration
   Starting	0.11 ms
   Checking permissions	0.05 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   Init	0.12 ms
   Optimizing	0.05 ms
   Statistics	0.10 ms
   Preparing	0.06 ms
   Executing	0.01 ms
   Sending data	0.62 ms
   End of update loop	0.04 ms
   Query end	0.01 ms
   Commit	0.05 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.06 ms

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

   Status	Duration
   Starting	0.08 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.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Executing	0.06 ms
   Sending data	0.10 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.05 ms
   Starting cleanup	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.10 ms
   Reset for next command	0.03 ms

   **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.47 ms** **Nach letzter Abfrage: 0.14 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.121 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)**

   Status	Duration
   Starting	0.10 ms
   Checking permissions	0.02 ms
   Opening tables	0.09 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.11 ms
   Preparing	0.10 ms
   Unlocking tables	0.03 ms
   Preparing	0.07 ms
   Executing	0.03 ms
   Sending data	0.08 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.05 ms
   Closing tables	0.02 ms
   Unlocking tables	0.02 ms
   Closing tables	0.09 ms
   Starting cleanup	0.05 ms
   Freeing items	0.03 ms
   Updating status	0.10 ms
   Reset for next command	0.04 ms

   **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.36 ms** **Nach letzter Abfrage: 0.29 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)**

   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.04 ms
   Table lock	0.03 ms
   Init	0.06 ms
   Optimizing	0.06 ms
   Statistics	0.09 ms
   Preparing	0.06 ms
   Sorting result	0.03 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	2.05 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.04 ms
   Unlocking tables	0.01 ms
   Closing tables	0.03 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.13 ms
   Reset for next command	0.04 ms

   **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: 1.16 ms** **Nach letzter Abfrage: 0.77 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)**

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

   **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.66 ms** **Nach letzter Abfrage: 25.29 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)**

   Status	Duration
   Starting	0.13 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.06 ms
   Init	0.07 ms
   Optimizing	0.06 ms
   Statistics	0.11 ms
   Preparing	0.07 ms
   Executing	0.04 ms
   Sending data	0.18 ms
   End of update loop	0.05 ms
   Query end	0.03 ms
   Commit	0.02 ms
   Closing tables	0.05 ms
   Unlocking tables	0.04 ms
   Closing tables	0.05 ms
   Starting cleanup	0.04 ms
   Freeing items	0.06 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/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.08 ms** **Nach letzter Abfrage: 6.62 ms** **Abfragespeichernutzung: 0.113 MB Speichernutzung vor Abfrage: 1.827 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)**

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

    **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.23 ms** **Nach letzter Abfrage: 10.41 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.17 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.03 ms
    Init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.15 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	0.12 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Closing tables	0.02 ms
    Unlocking tables	0.02 ms
    Closing tables	0.03 ms
    Starting cleanup	0.02 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**
    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.63 ms** **Nach letzter Abfrage: 0.17 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.616 MB**

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

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.14 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 for update	0.16 ms
    Updating	0.18 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.60 ms
    Closing tables	0.04 ms
    Unlocking tables	0.02 ms
    Closing tables	0.04 ms
    Starting cleanup	0.03 ms
    Freeing items	0.03 ms
    Updating status	0.12 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.38 ms** **Nach letzter Abfrage: 0.43 ms** **Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 2.641 MB** **Zeilen zurückgegeben: 5**

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.14 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.06 ms
    Optimizing	0.06 ms
    Statistics	0.15 ms
    Preparing	0.07 ms
    Executing	0.03 ms
    Sending data	0.28 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Closing tables	0.05 ms
    Unlocking tables	0.02 ms
    Closing tables	0.03 ms
    Starting cleanup	0.02 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**
    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: 1.65 ms** **Nach letzter Abfrage: 3.03 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.960 MB** **Zeilen zurückgegeben: 1**

    SHOW TABLES LIKE "jos_virtuemart_configs"

    **Erklären**

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

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:763
    9	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:578
    8	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:417
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. **Abfragezeit: 0.90 ms** **Nach letzter Abfrage: 0.09 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.966 MB** **Zeilen zurückgegeben: 1**

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

    **Erklären**

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

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    8	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:457
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. **Abfragezeit: 2.35 ms** **Nach letzter Abfrage: 0.41 ms** **Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.030 MB** **Zeilen zurückgegeben: 41**

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_awocoupon','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.17 ms
    Checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.15 ms
    Optimizing	0.04 ms
    Statistics	0.33 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	1.02 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.05 ms
    Closing tables	0.02 ms
    Unlocking tables	0.03 ms
    Closing tables	0.02 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**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    10	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:479
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. **Abfragezeit: 3.31 ms** **Nach letzter Abfrage: 6.41 ms** **Abfragespeichernutzung: 0.090 MB Speichernutzung vor Abfrage: 3.255 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.13 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.08 ms
    Optimizing	0.05 ms
    Statistics	0.15 ms
    Preparing	0.08 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	2.19 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Closing tables	0.03 ms
    Unlocking tables	0.02 ms
    Closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.07 ms
    Reset for next command	0.06 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1594
    22	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:272
    21	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:254
    20	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:291
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:113
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/category/view.html.php:578
    10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:133
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. **Abfragezeit: 1.19 ms** **Nach letzter Abfrage: 4.65 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.377 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` = "19"

    **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.12 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	0.10 ms
    Optimizing	0.05 ms
    Statistics	0.14 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.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Closing tables	0.02 ms
    Unlocking tables	0.02 ms
    Closing tables	0.05 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.10 ms
    Reset for next command	0.07 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:102
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:179
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. **Abfragezeit: 0.91 ms** **Nach letzter Abfrage: 0.21 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.394 MB** **Zeilen zurückgegeben: 1**

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

    **Erklären**

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

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

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

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

    ---

20. **Abfragezeit: 2.92 ms** **Nach letzter Abfrage: 0.32 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.486 MB** **Zeilen zurückgegeben: 0**

    SELECT c.* 
      FROM jos_virtuemart_customs  as c 
      INNER JOIN jos_virtuemart_product_customfields as pc 
      on (c.virtuemart_custom_id=pc.virtuemart_custom_id)
    
      INNER JOIN jos_virtuemart_product_categories as cat 
      ON (pc.virtuemart_product_id=cat.virtuemart_product_id) 
      WHERE virtuemart_category_id="19" 
      and searchable="1" 
      and (field_type="S" or field_type="P") 
      and c.published = 1 
      GROUP BY c.virtuemart_custom_id

    **Erklären**

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

    **Profil (Profile)**

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

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/views/category/view.html.php:606
    10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:217
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. **Abfragezeit: 1.01 ms** **Nach letzter Abfrage: 0.67 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.563 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.08 ms
    Checking permissions	0.04 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.12 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.03 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**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:138
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
    11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:175
    10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. **Abfragezeit: 0.74 ms** **Nach letzter Abfrage: 0.09 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.586 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.06 ms
    Checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 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.02 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**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
    17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1132
    16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
    15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:108
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:138
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:198
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:126
    11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:175
    10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. **Abfragezeit: 1.68 ms** **Nach letzter Abfrage: 1.34 ms** **Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 3.635 MB** **Zeilen zurückgegeben: 32**

    SHOW FULL COLUMNS  
      FROM `jos_virtuemart_userfields`

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.02 ms
    Closing tables	0.02 ms
    Opening tables	0.40 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    Checking permissions	0.21 ms
    Closing tables	0.02 ms
    Executing	0.01 ms
    Sending data	0.12 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.16 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.08 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    20	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:724
    19	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
    18	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:210
    17	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:433
    16	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:395
    15	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:607
    14	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
    13	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559
    12	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:350
    11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:237
    10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/category/view.html.php:226
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. **Abfragezeit: 1.19 ms** **Nach letzter Abfrage: 0.18 ms** **Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.671 MB** **Zeilen zurückgegeben: 19**

    SELECT * 
      FROM `jos_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `account`="1" 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type') = 0  
      ORDER BY ordering

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.07 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.06 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.46 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.02 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

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

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

    ---

25. **Abfragezeit: 1.15 ms** **Nach letzter Abfrage: 2.96 ms** **Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.780 MB** **Zeilen zurückgegeben: 11**

    SELECT * 
      FROM `jos_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `shipment`="1" 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
      ORDER BY ordering

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.10 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.06 ms
    Optimizing	0.04 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.28 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.02 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

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

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

    ---

26. **Abfragezeit: 0.97 ms** **Nach letzter Abfrage: 0.34 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.828 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.07 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 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.05 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.27 ms
    End of update loop	0.04 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**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/product.php:972
    11	VirtueMartModelProduct->getProductStockhandle()	JROOT/administrator/components/com_virtuemart/models/product.php:512
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. **Abfragezeit: 0.75 ms** **Nach letzter Abfrage: 0.04 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.835 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.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.20 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.05 ms
    Reset for next command	0.01 ms

    **Aufrufstapel (Call Stack)**

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

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

    ---

28. **Abfragezeit: 1.42 ms** **Nach letzter Abfrage: 0.10 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.845 MB** **Zeilen zurückgegeben: 0**

    SELECT  c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.category_parent_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug  
      FROM jos_virtuemart_categories as c  
      LEFT JOIN `jos_virtuemart_categories_de_de` as l 
      ON l.`virtuemart_category_id` = c.`virtuemart_category_id`  
      WHERE  (c.`category_parent_id` = 19 ) 
      AND  c.`published` = 1  
      ORDER BY c.ordering,category_name ASC

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; **filesort wurde genutzt**
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	yorcks_pflanzen_de.c.virtuemart_category_id	1

    **Profil (Profile)**

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.03 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Creating tmp table	0.07 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.36 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.11 ms
    Creating sort index	0.01 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.06 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

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

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

    ---

29. **Abfragezeit: 1.25 ms** **Nach letzter Abfrage: 2.49 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.869 MB** **Zeilen zurückgegeben: 1**

    SELECT count(`p`.virtuemart_product_id) AS total	
    	  
      FROM `jos_virtuemart_product_categories` as `pc`
    	  
      LEFT JOIN `jos_virtuemart_products` as `p` 
      ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
    	  
      WHERE `pc`.`virtuemart_category_id` = "19"
    	  
      AND `p`.`virtuemart_vendor_id` = "1"
    	  
      AND `p`.`published` = "1"

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.09 ms
    Checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.32 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**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:684
    14	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:146
    13	VirtueMartModelCategory->getCategory()	JROOT/administrator/components/com_virtuemart/models/product.php:1012
    12	VirtueMartModelProduct->setPaginationLimits()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:946
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. **Abfragezeit: 1.24 ms** **Nach letzter Abfrage: 0.21 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.877 MB** **Zeilen zurückgegeben: 0**

    SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
    		
      FROM `jos_virtuemart_products` as p   
     
      LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `jos_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `jos_virtuemart_categories` as c 
      ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` 
     
      WHERE ( `pc`.`virtuemart_category_id` IN (19)  
      AND  `c`.`published` = 1  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
     
      group by p.`virtuemart_product_id` 
     
      ORDER BY `pc`.`ordering` ASC, p.`virtuemart_product_id` ASC 
      LIMIT 0, 24

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.10 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.04 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting for group	0.02 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.33 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.01 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.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**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:867
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:946
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. **Abfragezeit: 0.42 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.883 MB** **Zeilen zurückgegeben: 1**

    SELECT FOUND_ROWS()

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.03 ms
    Checking permissions	0.04 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.02 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**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:881
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:946
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:281
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. **Abfragezeit: 0.90 ms** **Nach letzter Abfrage: 3.05 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.021 MB** **Zeilen zurückgegeben: 1**

    SELECT *  
      FROM `jos_virtuemart_currencies` AS c
    			
      LEFT JOIN `jos_virtuemart_vendors` AS v 
      ON  c.virtuemart_currency_id = v.vendor_currency
    			
      WHERE v.virtuemart_vendor_id = "1"

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v	system	PRIMARY,vendor_currency	**ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN**	NULL	NULL	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    **Profil (Profile)**

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 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**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:323
    12	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    11	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:302
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. **Abfragezeit: 0.51 ms** **Nach letzter Abfrage: 0.71 ms** **Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.064 MB** **Zeilen zurückgegeben: 1**

    SELECT `jos_virtuemart_currencies`.*  
      FROM `jos_virtuemart_currencies`  
      WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "47"

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.03 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.03 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.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.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**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1132
    11	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:302
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. **Abfragezeit: 0.56 ms** **Nach letzter Abfrage: 0.51 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.085 MB** **Zeilen zurückgegeben: 1**

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "107"

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.03 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.02 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**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:487
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1292
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:351
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. **Abfragezeit: 0.92 ms** **Nach letzter Abfrage: 2.49 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.133 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.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.23 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.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: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_virtuemart/helpers/shopfunctionsf.php:1134
    10	shopFunctionsF::triggerContentPlugin()	JROOT/components/com_virtuemart/views/category/view.html.php:365
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. **Abfragezeit: 0.55 ms** **Nach letzter Abfrage: 0.09 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.140 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.05 ms
    Checking permissions	0.02 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.07 ms
    Preparing	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.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.05 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_virtuemart/helpers/shopfunctionsf.php:1134
    10	shopFunctionsF::triggerContentPlugin()	JROOT/components/com_virtuemart/views/category/view.html.php:365
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. **Abfragezeit: 1.89 ms** **Nach letzter Abfrage: 1.16 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.230 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
    
      WHERE a.context = 'com_virtuemart.category' 
      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

    **Profil (Profile)**

    Status	Duration
    Starting	0.17 ms
    Checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.12 ms
    Preparing	0.05 ms
    Creating tmp table	0.07 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.45 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.12 ms
    Creating sort index	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.03 ms
    Starting cleanup	0.01 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**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
    11	vDispatcher::trigger()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:1142
    10	shopFunctionsF::triggerContentPlugin()	JROOT/components/com_virtuemart/views/category/view.html.php:365
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. **Abfragezeit: 1.49 ms** **Nach letzter Abfrage: 0.66 ms** **Abfragespeichernutzung: 0.155 MB Speichernutzung vor Abfrage: 4.260 MB** **Zeilen zurückgegeben: 1**

    SELECT `jos_virtuemart_vendors`.* ,`jos_virtuemart_vendors_de_de`.*  
      FROM `jos_virtuemart_vendors` 
      INNER JOIN `jos_virtuemart_vendors_de_de` 
      ON `jos_virtuemart_vendors`.`virtuemart_vendor_id` = `jos_virtuemart_vendors_de_de`.`virtuemart_vendor_id`  
      WHERE `jos_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.78 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.04 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1093
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:84
    10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:407
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:61
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:114
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. **Abfragezeit: 0.54 ms** **Nach letzter Abfrage: 0.57 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.361 MB** **Zeilen zurückgegeben: 1**

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_vendor_medias` 
      WHERE `virtuemart_vendor_id` = "1"  
      ORDER BY `ordering`

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_vendor_medias	ref	virtuemart_vendor_id	virtuemart_vendor_id	4	const	1	Using where; **filesort wurde genutzt**

    **Profil (Profile)**

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.04 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.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    **Aufrufstapel (Call Stack)**

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

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

    ---

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

    ---

41. **Abfragezeit: 0.68 ms** **Nach letzter Abfrage: 0.55 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.412 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 = 626

    **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.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Executing	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.05 ms
    Starting cleanup	0.03 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**
    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**]

    ---

42. **Abfragezeit: 2.32 ms** **Nach letzter Abfrage: 1.80 ms** **Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 4.490 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-03-31 09:13:46') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-31 09:13:46') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 626 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.14 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.06 ms
    Statistics	0.11 ms
    Preparing	0.08 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	1.32 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.02 ms
    Freeing items	0.06 ms
    Updating status	0.05 ms
    Reset for next command	0.02 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**]

    ---

43. **Abfragezeit: 1.51 ms** **Nach letzter Abfrage: 5.19 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.758 MB** **Zeilen zurückgegeben: 0**

    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 ( `pc`.`virtuemart_category_id` IN (19)  
      AND  `c`.`published` = 1  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
    
      ORDER BY 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	c	const	PRIMARY,published	PRIMARY	4	const	1
    1	SIMPLE	pc	ref	virtuemart_product_id,virtuemart_category_id,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_category_id	4	const	25	Using where; Using index
    1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	yorcks_pflanzen_de.pc.virtuemart_product_id	1	Using where
    1	SIMPLE	pp	ref	virtuemart_product_id	virtuemart_product_id	4	yorcks_pflanzen_de.pc.virtuemart_product_id	1	Using index

    **Profil (Profile)**

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.17 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Creating tmp table	0.03 ms
    Sorting for group	0.01 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.37 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 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.01 ms
    Updating status	0.07 ms
    Reset for next command	0.02 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**]

    ---

44. **Abfragezeit: 1.31 ms** **Nach letzter Abfrage: 6.60 ms** **Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.018 MB** **Zeilen zurückgegeben: 3**

    SELECT c.* 
      FROM jos_virtuemart_calcs as c  
      LEFT JOIN jos_virtuemart_calc_shoppergroups as cs 
      ON cs.virtuemart_calc_id=c.virtuemart_calc_id  
      WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( ISNULL(publish_up) OR  ( ISNULL("publish_up") or publish_up="0000-00-00 00:00:00")  OR publish_up <= "2023-03-31 09:13:46" )
    				
      AND ( ISNULL(publish_down) OR  ( ISNULL("publish_down") or publish_down="0000-00-00 00:00:00")  OR publish_down >= "2023-03-31 09:13:46" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cs	system	virtuemart_calc_id	**ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN**	NULL	NULL	0	Const row not found
    1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	2	Using where

    **Profil (Profile)**

    Status	Duration
    Starting	0.15 ms
    Checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.08 ms
    Optimizing	0.07 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.12 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.07 ms
    Reset for next command	0.04 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:176
    16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:110
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2247
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:57
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.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**]

    ---

45. **Abfragezeit: 1.10 ms** **Nach letzter Abfrage: 0.22 ms** **Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.058 MB** **Zeilen zurückgegeben: 0**

    SELECT * 
      FROM jos_virtuemart_calcs  
      LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="DBTaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-31 09:13:46" )
    				
      AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-31 09:13:46" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	**ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN**	NULL	NULL	0	Const row not found
    1	SIMPLE	jos_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	Using index condition; Using where

    **Profil (Profile)**

    Status	Duration
    Starting	0.14 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.02 ms
    Init	0.13 ms
    Optimizing	0.08 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	0.07 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.03 ms
    Updating status	0.08 ms
    Reset for next command	0.03 ms

    **Aufrufstapel (Call Stack)**

    #	**Aufrufer**	**Datei und Zeilennummer**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1517
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:774
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:57
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.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**]

    ---

46. **Abfragezeit: 1.07 ms** **Nach letzter Abfrage: 0.04 ms** **Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.068 MB** **Zeilen zurückgegeben: 0**

    SELECT * 
      FROM jos_virtuemart_calcs  
      LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="TaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-31 09:13:46" )
    				
      AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-31 09:13:46" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	**ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN**	NULL	NULL	0	Const row not found
    1	SIMPLE	jos_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	Using index condition; Using where

    **Profil (Profile)**

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.12 ms
    Optimizing	0.08 ms
    Statistics	0.13 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.06 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.02 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 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**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1517
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:57
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.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**]

    ---

47. **Abfragezeit: 1.10 ms** **Nach letzter Abfrage: 0.03 ms** **Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.076 MB** **Zeilen zurückgegeben: 0**

    SELECT * 
      FROM jos_virtuemart_calcs  
      LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="DATaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-31 09:13:46" )
    				
      AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-31 09:13:46" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    **Erklären**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	**ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN**	NULL	NULL	0	Const row not found
    1	SIMPLE	jos_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	Using index condition; Using where

    **Profil (Profile)**

    Status	Duration
    Starting	0.15 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.13 ms
    Optimizing	0.08 ms
    Statistics	0.14 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.06 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.02 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**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1517
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:776
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2251
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2360
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2555
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:57
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.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**]

    ---

48. **Abfragezeit: 1.76 ms** **Nach letzter Abfrage: 47.93 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.413 MB** **Zeilen zurückgegeben: 0**

    SHOW TABLES LIKE "jos_virtuemart_payment_plg_amazon"

    **Erklären**

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

    **Profil (Profile)**

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.03 ms
    Opening tables	0.09 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    Checking permissions	0.69 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.02 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**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/plugins/vmpayment/amazon/amazon.php:537
    11	plgVmpaymentAmazon->plgVmRetrieveIPN()	JROOT/libraries/joomla/event/event.php:70
    10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    9	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    8	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/amazon/amazon.php:42
    7	PlgSystemAmazon->onAfterRender()	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/CMSApplication.php:1118
    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**]

    ---