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

Zeit

Speicher

11 ausgeführte Abfragen 6.05 ms

1. Abfragezeit: 1.07 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 2.938 MB Zeilen zurückgegeben: 16

   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 l3yfr_menu AS m
   
     LEFT JOIN l3yfr_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	17	Using index condition; Using where; filesort wurde genutzt
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.m.component_id	1	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
   11	plgSystemFalangdriver->parseRule()	Der selbe Aufruf in der Zeile darunter.
   10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
   8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
   7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   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:196
   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]

   ---

2. Abfragezeit: 0.21 ms Nach letzter Abfrage: 1.61 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 3.010 MB Zeilen zurückgegeben: 10

   SELECT joomlatablename,tablepkID 
     FROM `l3yfr_falang_tableinfo`

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   23	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
   22	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
   21	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
   20	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
   19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
   11	plgSystemFalangdriver->parseRule()	Der selbe Aufruf in der Zeile darunter.
   10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
   8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
   7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   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:196
   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]

   ---

3. Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 3.028 MB Zeilen zurückgegeben: 3

   SELECT * 
     FROM l3yfr_languages 
     ORDER BY ordering

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l3yfr_languages	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	filesort wurde genutzt

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   23	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
   22	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
   21	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
   20	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
   19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
   11	plgSystemFalangdriver->parseRule()	Der selbe Aufruf in der Zeile darunter.
   10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
   8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
   7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   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:196
   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]

   ---

4. Abfragezeit: 0.88 ms Nach letzter Abfrage: 1.95 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 3.060 MB Zeilen zurückgegeben: 14

   SHOW FULL COLUMNS 
     FROM `l3yfr_languages`

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   30	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   29	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   27	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   24	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
   23	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
   22	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
   21	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
   20	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
   19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
   11	plgSystemFalangdriver->parseRule()	Der selbe Aufruf in der Zeile darunter.
   10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
   8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
   7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   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:196
   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.06 ms Nach letzter Abfrage: 1.40 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 3.113 MB Zeilen zurückgegeben: 25

   SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
   
     FROM l3yfr_falang_content AS falang_content
   
     WHERE falang_content.language_id=3
   	
     AND falang_content.published=1
      
     AND falang_content.reference_id IN(101,102,103,104,105,106,107,108,109,110,111,112,113,114,123,124)
      
     AND falang_content.reference_table='menu'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	falang_content	index_merge	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id,reference_table	4,302	NULL	26	Using intersect(language_id,reference_table); Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
   21	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
   20	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
   19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
   11	plgSystemFalangdriver->parseRule()	Der selbe Aufruf in der Zeile darunter.
   10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
   8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
   7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   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:196
   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: 0.63 ms Nach letzter Abfrage: 2.76 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.107 MB

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

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   10	JFalangDatabase->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:1119
   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:196
   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: 0.71 ms Nach letzter Abfrage: 11.05 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 3.336 MB Zeilen zurückgegeben: 0

   SELECT 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 l3yfr_fields AS a
   
     LEFT JOIN `l3yfr_languages` AS l 
     ON l.lang_code = a.language
   
     LEFT JOIN l3yfr_users AS uc 
     ON uc.id=a.checked_out
   
     LEFT JOIN l3yfr_viewlevels AS ag 
     ON ag.id = a.access
   
     LEFT JOIN l3yfr_users AS ua 
     ON ua.id = a.created_user_id
   
     LEFT JOIN l3yfr_fields_groups AS g 
     ON g.id = a.group_id
   
     WHERE a.context = 'com_users.remind' 
     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; filesort wurde genutzt
   1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	dbmetallaser.a.language	1	Using where
   1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.checked_out	1
   1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.access	1	Using where
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.created_user_id	1	Using where
   1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.group_id	1	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   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:187
   20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
   19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
   18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:288
   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:321
   14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/remind.php:59
   13	UsersModelRemind->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
   12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/remind.php:34
   11	UsersModelRemind->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/remind/view.html.php:37
   9	UsersViewRemind->display()	JROOT/components/com_users/controller.php:139
   8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   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:196
   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.39 ms Nach letzter Abfrage: 29.83 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.507 MB Zeilen zurückgegeben: 1

   SELECT language,id
   
     FROM `l3yfr_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	l3yfr_menu	ALL	idx_client_id_parent_id_alias_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	54	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   11	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   9	JFalangDatabase->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:196
   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: 0.38 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.521 MB Zeilen zurückgegeben: 0

   SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
   
     FROM l3yfr_falang_content AS falang_content
   
     WHERE falang_content.language_id=3
   	
     AND falang_content.published=1
      
     AND falang_content.reference_id IN(101)
      
     AND falang_content.reference_table='menu'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_id	4	const	1	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
   12	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
   11	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
   10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   9	JFalangDatabase->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:196
   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: 0.46 ms Nach letzter Abfrage: 19.88 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 3.771 MB Zeilen zurückgegeben: 140

    SELECT * 
      FROM l3yfr_acymailing_config

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
    13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
    11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
    10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
    7	plgSystemRegacymailing->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:1050
    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:202
    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 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 2 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
     FROM l3yfr_falang_content AS falang_content

2. 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 l3yfr_menu AS m 
     LEFT JOIN l3yfr_extensions AS e 
     ON m.component_id = e.extension_id

3. 1 × SELECT joomlatablename,tablepkID 
     FROM `l3yfr_falang_tableinfo

4. 1 × SELECT * 
     FROM l3yfr_languages

5. 1 × SELECT 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 l3yfr_fields AS a 
     LEFT JOIN `l3yfr_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN l3yfr_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN l3yfr_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN l3yfr_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN l3yfr_fields_groups AS g 
     ON g.id = a.group_id

6. 1 × SELECT language,id 
     FROM `l3yfr_menu`

7. 1 × SELECT * 
     FROM l3yfr_acymailing_confi

Andere Tabellen:

1. 1 × SHOW FULL COLUMNS 
     FROM `l3yfr_languages

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