Register

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734849428,
                "last": 1734849428,
                "now": 1734849428
            },
            "token": "Jq6MoGmRFdnI1z8lbEQI8TauW03Ax3Qf"
        },
        "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
        }
    }
}

Zeit

Speicher

24 ausgeführte Abfragen 72.13 ms

1. Abfragezeit: 2.64 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.827 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `faokq_session`
   
     WHERE `session_id` = X'36366f65696e337274396766756d6e7535733930716865326c39'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	faokq_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.67 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	1.52 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.00 ms

   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()	Derselbe Aufruf in der Zeile darunter.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php: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.18 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 0.838 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `faokq_session`
   
     WHERE `session_id` = X'36366f65696e337274396766756d6e7535733930716865326c39' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	faokq_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.76 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   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: 16.83 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 0.844 MB

   INSERT INTO `faokq_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'36366f65696e337274396766756d6e7535733930716865326c39', 1, 1734849428, 0, '', 0)

   Explain

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `faokq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'36366f65696e337274396766756d6e7535733930716865326c39', 1, 1734849428, 0, '', 0)

   Profil (Profile)

   Status	Duration
   starting	0.96 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   update	8.04 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	7.41 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.00 ms

   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: 4.55 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 0.872 MB Zeilen zurückgegeben: 43

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `faokq_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	faokq_extensions	NULL	ref	extension	extension	82	const	45	1.00	Using where

   Profil (Profile)

   Status	Duration
   starting	1.36 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	1.65 ms
   preparing	0.03 ms
   executing	0.99 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   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}()	Derselbe Aufruf in der Zeile darunter.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 0.45 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.888 MB Zeilen zurückgegeben: 14

   SELECT id, rules
   
     FROM `faokq_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	faokq_viewlevels	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	11	100.00	NULL

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.07 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   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.13 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.904 MB Zeilen zurückgegeben: 2

   SELECT b.id
   
     FROM faokq_usergroups AS a
   
     LEFT JOIN faokq_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profil (Profile)

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.61 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.00 ms

   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.45 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 0.925 MB Zeilen zurückgegeben: 86

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM faokq_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	faokq_extensions	NULL	ref	extension	extension	82	const	127	0.60	Using where; filesort wurde genutzt

   Profil (Profile)

   Status	Duration
   starting	0.96 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	1.53 ms
   executing	0.45 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   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}()	Derselbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Abfragezeit: 0.53 ms Nach letzter Abfrage: 1.97 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.217 MB Zeilen zurückgegeben: 7

   SELECT *
   
     FROM faokq_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.03 ms
   executing	0.07 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   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:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
   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]

   ---

9. Abfragezeit: 2.30 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.231 MB Zeilen zurückgegeben: 16

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `faokq_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	faokq_extensions	NULL	ref	extension	extension	82	const	16	1.00	Using where

   Profil (Profile)

   Status	Duration
   starting	1.70 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.03 ms
   executing	0.12 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   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: 2.26 ms Nach letzter Abfrage: 4.79 ms Abfragespeichernutzung: 0.170 MB Speichernutzung vor Abfrage: 1.296 MB Zeilen zurückgegeben: 208

    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 faokq_menu AS m
    
      LEFT JOIN faokq_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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	315	8.76	Using where; filesort wurde genutzt
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.m.component_id	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	1.61 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    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}()	Derselbe Aufruf in der Zeile darunter.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php: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.05 ms Nach letzter Abfrage: 4.76 ms Abfragespeichernutzung: 0.068 MB Speichernutzung vor Abfrage: 2.079 MB Zeilen zurückgegeben: 31

    SELECT id, home, template, s.params
    
      FROM faokq_template_styles as s
    
      LEFT JOIN faokq_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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	32	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	Xdbl0zz14_joomla33.e.element	1	93.94	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.43 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
    8	plgSystemT3->onAfterRoute()	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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 0.53 ms Nach letzter Abfrage: 2.15 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.198 MB Zeilen zurückgegeben: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `faokq_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	faokq_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    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}()	Derselbe Aufruf in der Zeile darunter.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php: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: 4.72 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.188 MB

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

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.08 ms
    updating	0.53 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	3.73 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.00 ms

    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]

    ---

14. Abfragezeit: 5.90 ms Nach letzter Abfrage: 3.34 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.420 MB Zeilen zurückgegeben: 1

    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 faokq_fields AS a
    
      LEFT JOIN `faokq_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN faokq_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN faokq_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN faokq_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN faokq_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.user' 
      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

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	2.32 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.18 ms
    preparing	0.03 ms
    Creating tmp table	0.14 ms
    executing	2.55 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.03 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    23	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
    22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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: 3.83 ms Nach letzter Abfrage: 3.62 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 2.599 MB Zeilen zurückgegeben: 43

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `faokq_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_api','com_associations','com_banners','com_biodiv','com_cache','com_categories','com_checkin','com_comment','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_helloworld','com_installer','com_j2xml','com_jaextmanager','com_jalang','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_quicklogout','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	faokq_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	Using index condition

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 ms
    preparing	0.02 ms
    executing	3.16 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    30	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    29	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    28	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    27	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    26	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_fields/models/groups.php:162
    25	FieldsModelGroups->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    24	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:410
    22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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: 1.27 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.662 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #21

    SELECT a.*,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name
    
      FROM faokq_fields_groups AS a
    
      LEFT JOIN `faokq_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN faokq_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN faokq_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN faokq_users AS ua 
      ON ua.id = a.created_by
    
      WHERE a.context = 'com_users.user' 
      AND a.access IN (1,1,5) 
      AND a.state IN (0, 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	100.00	Using where; filesort wurde genutzt
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	Xdbl0zz14_joomla33.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.created_by	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.04 ms
    executing	0.59 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/groups.php:232
    24	FieldsModelGroups->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:410
    22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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: 7.39 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 2.681 MB Zeilen zurückgegeben: 4

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	faokq_assets	NULL	ALL	idx_asset_name,idx_parent_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1649	21.36	Using where

    Profil (Profile)

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	5.94 ms
    preparing	0.03 ms
    executing	1.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    35	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    34	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    33	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    32	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    31	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    30	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_fields/helpers/fields.php:542
    29	FieldsHelper::canEditFieldValue()	JROOT/administrator/components/com_fields/helpers/fields.php:568
    28	FieldsHelper::displayFieldOnForm()	JROOT/administrator/components/com_fields/libraries/fieldsplugin.php:161
    27	FieldsPlugin->onCustomFieldsPrepareDom()	JROOT/administrator/components/com_fields/libraries/fieldslistplugin.php:33
    26	FieldsListPlugin->onCustomFieldsPrepareDom()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    23	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_fields/helpers/fields.php:460
    22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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: 3.15 ms Nach letzter Abfrage: 1.65 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.696 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #19

    SELECT profile_key, profile_value 
      FROM faokq_user_profiles 
      WHERE user_id = 0 
      AND profile_key LIKE 'profileMW.%' 
      ORDER BY ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	faokq_user_profiles	NULL	range	idx_user_id_profile_key	idx_user_id_profile_key	406	NULL	1	100.00	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	2.60 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
    18	JDatabaseDriver->loadRowList()	JROOT/plugins/user/profileMW/profileMW.php:54
    17	plgUserProfileMW->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/components/com_users/models/registration.php:302
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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.41 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.710 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #18

    SELECT profile_key, profile_value 
      FROM faokq_user_profiles 
      WHERE user_id = 0 
      AND profile_key LIKE 'profileMW.%' 
      ORDER BY ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	faokq_user_profiles	NULL	range	idx_user_id_profile_key	idx_user_id_profile_key	406	NULL	1	100.00	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
    18	JDatabaseDriver->loadRowList()	JROOT/plugins/user/profileMW/profileMW.php:54
    17	plgUserProfileMW->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:292
    14	Joomla\CMS\MVC\Model\FormModel->preprocessData()	JROOT/components/com_users/models/registration.php:363
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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: 0.92 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.722 MB Zeilen zurückgegeben: 1

    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 faokq_fields AS a
    
      LEFT JOIN `faokq_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN faokq_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN faokq_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN faokq_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN faokq_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.user' 
      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) 
      AND a.language in ('*','de-DE')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	100.00	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	Xdbl0zz14_joomla33.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.group_id	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.02 ms
    Creating tmp table	0.05 ms
    executing	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:350
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    13	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.754 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #16

    SELECT a.*,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name
    
      FROM faokq_fields_groups AS a
    
      LEFT JOIN `faokq_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN faokq_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN faokq_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN faokq_users AS ua 
      ON ua.id = a.created_by
    
      WHERE a.context = 'com_users.user' 
      AND a.access IN (1,1,5) 
      AND a.state IN (0, 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	100.00	Using where; filesort wurde genutzt
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	Xdbl0zz14_joomla33.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.created_by	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/groups.php:232
    20	FieldsModelGroups->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:410
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    13	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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.90 ms Nach letzter Abfrage: 12.41 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.877 MB Zeilen zurückgegeben: 7

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	faokq_menu	NULL	ALL	idx_client_id_parent_id_alias_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	315	0.88	Using where

    Profil (Profile)

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.30 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    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]

    ---

23. Abfragezeit: 2.35 ms Nach letzter Abfrage: 1.98 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.028 MB Zeilen zurückgegeben: 7

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM faokq_modules AS m
    
      LEFT JOIN faokq_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN faokq_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 <= '2024-12-22 06:37:08') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 06:37:08') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 717 OR mm.menuid <= 0) 
      AND m.language IN ('de-DE','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds,idx_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	70	1.43	Using where; filesort wurde genutzt
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	Xdbl0zz14_joomla33.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.m.id	3	40.00	Using where; Using index

    Profil (Profile)

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	1.28 ms
    statistics	0.12 ms
    preparing	0.07 ms
    executing	0.38 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:441
    16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:371
    15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:655
    12	T3Template->countModules()	JROOT/templates/puritygreen/tpls/blocks/header.php:62
    11	include JROOT/templates/puritygreen/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/puritygreen/tpls/blog.php:38
    9	include JROOT/templates/puritygreen/tpls/blog.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/puritygreen/index.php:35
    7	require JROOT/templates/puritygreen/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]

    ---

24. Abfragezeit: 3.86 ms Nach letzter Abfrage: 1.13 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.105 MB Zeilen zurückgegeben: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `faokq_menu` AS `c`
    
      INNER JOIN `faokq_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `faokq_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `faokq_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 717

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	2.43 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.67 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.40 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    14	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    13	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
    12	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    11	include JROOT/modules/mod_languages/mod_languages.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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]

    ---

19 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `faokq_extensions`

2. 2 × 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 faokq_fields AS a 
     LEFT JOIN `faokq_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN faokq_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN faokq_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN faokq_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN faokq_fields_groups AS g 
     ON g.id = a.group_id

3. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `faokq_assets`

4. 2 × SELECT a.*,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name 
     FROM faokq_fields_groups AS a 
     LEFT JOIN `faokq_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN faokq_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN faokq_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN faokq_users AS ua 
     ON ua.id = a.created_by

5. 2 × SELECT profile_key, profile_value 
     FROM faokq_user_profiles

6. 1 × SELECT `data` 
     FROM `faokq_session`

7. 1 × SELECT `session_id` 
     FROM `faokq_session`

8. 1 × SELECT id, rules 
     FROM `faokq_viewlevels

9. 1 × SELECT b.id 
     FROM faokq_usergroups AS a 
     LEFT JOIN faokq_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

10. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM faokq_extensions

11. 1 × SELECT * 
      FROM faokq_languages

12. 1 × SELECT `element`,`name`,`client_id`,`extension_id` 
      FROM `faokq_extensions`

13. 1 × 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 faokq_menu AS m 
      LEFT JOIN faokq_extensions AS e 
      ON m.component_id = e.extension_id

14. 1 × SELECT id, home, template, s.params 
      FROM faokq_template_styles as s 
      LEFT JOIN faokq_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

15. 1 × SELECT language,id 
      FROM `faokq_menu`

16. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM faokq_modules AS m 
      LEFT JOIN faokq_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN faokq_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

17. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `faokq_menu` AS `c` 
      INNER JOIN `faokq_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item' 
      INNER JOIN `faokq_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key` 
      INNER JOIN `faokq_menu` AS `c2` 
      ON a2.id = c2.`id`

Andere Tabellen:

1. 1 × INSERT INTO `faokq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'36366f65696e337274396766756d6e7535733930716865326c39', 1, 1734849428, 0, '', 0

2. 1 × UPDATE `faokq_extensions` 
     SET `params` = '{\"mediaversion\":\"e486caf47a228ab86bc2ecefd32357bd\"}'