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

35 ausgeführte Abfragen 333.77 ms

1. Abfragezeit: 0.75 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 2.936 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.17 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 3.008 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.23 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 3.025 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.72 ms Nach letzter Abfrage: 1.52 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 3.057 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: 2.27 ms Nach letzter Abfrage: 1.25 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 3.110 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	25	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: 8.83 ms Nach letzter Abfrage: 1.53 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.104 MB

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

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: UPDATE `l3yfr_extensions` SET `params` = '{\"mediaversion\":\"23320fe4b7b26390e52aa1ecc4d76a4e\"}' 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.39 ms Nach letzter Abfrage: 1.89 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.152 MB Zeilen zurückgegeben: 1

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

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   7	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   6	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   5	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
   4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.73 ms Nach letzter Abfrage: 6.51 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 3.269 MB Zeilen zurückgegeben: 39

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `l3yfr_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_falang','com_fields','com_finder','com_installer','com_jch_optimize','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_redirect','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l3yfr_assets	ALL	idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	166	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:282
   21	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
   15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
   14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
   11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
   10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 1.52 ms Nach letzter Abfrage: 2.12 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 3.434 MB Zeilen zurückgegeben: 0

   SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN c.published = 2 
     AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
   							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
   
     FROM l3yfr_content AS a
   
     INNER JOIN l3yfr_content_frontpage AS fp 
     ON fp.content_id = a.id
   
     LEFT JOIN l3yfr_categories AS c 
     ON c.id = a.catid
   
     LEFT JOIN l3yfr_users AS ua 
     ON ua.id = a.created_by
   
     LEFT JOIN l3yfr_users AS uam 
     ON uam.id = a.modified_by
   
     LEFT JOIN l3yfr_categories as parent 
     ON parent.id = c.parent_id
   
     LEFT JOIN l3yfr_content_rating AS v 
     ON a.id = v.content_id
   
     WHERE a.access IN (1,1,5) 
     AND c.access IN (1,1,5) 
     AND c.published = 1 
     AND a.state = 1 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-22 08:31:19') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-22 08:31:19') 
     AND a.language IN ('de-DE','*')
   
     ORDER BY c.lft, a.featured DESC, fp.ordering,  
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
     LIMIT 4

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fp	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using temporary; filesort wurde genutzt
   1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	dbmetallaser.fp.content_id	1	Using where
   1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	dbmetallaser.a.catid	1	Using where
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.created_by	1	Using where
   1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.modified_by	1	Using where
   1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.c.parent_id	1	Using where
   1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.id	1	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   17	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
   14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
   13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
   11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
   10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 5.59 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.480 MB Zeilen zurückgegeben: 1

    SELECT COUNT(*)
    
      FROM l3yfr_content AS a
    
      INNER JOIN l3yfr_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN l3yfr_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN l3yfr_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN l3yfr_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN l3yfr_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN l3yfr_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-22 08:31:19') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-22 08:31:19') 
      AND a.language IN ('de-DE','*')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
    1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	dbmetallaser.fp.content_id	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	dbmetallaser.a.catid	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    16	JFalangDatabase->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
    11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

11. Abfragezeit: 0.39 ms Nach letzter Abfrage: 14.35 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.502 MB Zeilen zurückgegeben: 0

    SELECT folder.*
    
      FROM `l3yfr_eventgallery_folder` AS folder
    
      LEFT JOIN `l3yfr_eventgallery_file` AS file 
      ON folder.folder = file.folder 
      and file.published=1 
      and file.ismainimage=0
    
      WHERE file.file IS NULL 
      AND folder.foldertypeid=1 OR folder.foldertypeid=2

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	folder	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	Using where
    1	SIMPLE	file	ref	file,index_folder	index_folder	377	dbmetallaser.folder.folder	12	Using where

    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/joomla/database/driver.php:1695
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    8	JFalangDatabase->loadObjectList()	JROOT/plugins/system/picasaupdater/picasaupdater.php:66
    7	plgSystemPicasaupdater->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]

    ---

12. Abfragezeit: 0.27 ms Nach letzter Abfrage: 1.11 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.576 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]

    ---

13. Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.589 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]

    ---

14. Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.603 MB Zeilen zurückgegeben: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `l3yfr_menu` AS `c`
    
      INNER JOIN `l3yfr_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `l3yfr_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `l3yfr_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 101

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    10	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

15. Abfragezeit: 6.43 ms Nach letzter Abfrage: 6.62 ms Abfragespeichernutzung: 0.049 MB Speichernutzung vor Abfrage: 3.668 MB Zeilen zurückgegeben: 12

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM l3yfr_modules AS m
    
      LEFT JOIN l3yfr_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN l3yfr_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-10-22 08:31:19') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-22 08:31:19') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0) 
      AND m.language IN ('de-DE','*')
    
      ORDER BY m.position, m.ordering

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    15	JFalangDatabase->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/metallaser/layout.php:32
    8	include JROOT/templates/metallaser/layout.php	JROOT/templates/metallaser/index.php:91
    7	require JROOT/templates/metallaser/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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]

    ---

16. Abfragezeit: 1.79 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.731 MB Zeilen zurückgegeben: 21

    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(94,152,110,88,89,90,123,91,92,93,1,87)
       
      AND falang_content.reference_table='modules'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	falang_content	range|filter	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	idxFalang1|language_id	4|4	NULL	33 (52%)	Using index condition; Using where; Using rowid filter

    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:277
    18	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    17	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    15	JFalangDatabase->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/metallaser/layout.php:32
    8	include JROOT/templates/metallaser/layout.php	JROOT/templates/metallaser/index.php:91
    7	require JROOT/templates/metallaser/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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]

    ---

17. Abfragezeit: 0.40 ms Nach letzter Abfrage: 12.65 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 4.009 MB Zeilen zurückgegeben: 8

    SELECT 
    					c.id AS CID
    				
      FROM 
    					l3yfr_categories AS c
    				
      LEFT JOIN 
    					l3yfr_content AS content 
    					
      ON 
    					c.id = content.catid 
    						
    				
      WHERE 
    					1=1 
    					 
      AND ( c.id = 8) 
    					
      AND 
    					c.extension = 'com_content' 
      AND 
    					c.published = 1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
    1	SIMPLE	content	ref	idx_catid	idx_catid	4	const	8	Using index

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    16	JFalangDatabase->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85
    15	NSP_GK5_com_content_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:100
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

18. Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 4.025 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(8)
       
      AND falang_content.reference_table='categories'

    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	falangContent	310	const,const,const	1	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
    19	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    18	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    17	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    16	JFalangDatabase->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85
    15	NSP_GK5_com_content_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:100
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

19. Abfragezeit: 1.81 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.036 MB Zeilen zurückgegeben: 4

    SELECT
    			content.id AS iid				
    		
      FROM 
    			l3yfr_content AS content
    			 
    			 
    			
    		
      WHERE 
    			content.state = 1
                     
      AND content.access IN (1,1,5)    
    		 		
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-10-22 08:31:19' )
    				
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-10-22 08:31:19' )
    			 
      AND (  content.catid = 8 ) 
    			 
      AND content.language in ('de-DE','*') 
    			 
    			
    			
    			
    		
    		
    		
      ORDER BY 
    			 content.created DESC 
    		
      LIMIT
    			0,16;

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	content	index_merge	idx_access,idx_state,idx_catid,idx_language	idx_catid,idx_state	4,1	NULL	6	Using intersect(idx_catid,idx_state); Using where; filesort wurde genutzt

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
    16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268
    15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

20. Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 4.052 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #22

    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(34,31,30,5)
       
      AND falang_content.reference_table='content'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_id	4	NULL	4	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
    20	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    19	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    18	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
    16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268
    15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

21. Abfragezeit: 0.56 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.070 MB Zeilen zurückgegeben: 4

    SELECT
    			content.id AS iid,
    			content.title AS title, 
    			content.introtext AS text,
    			content.publish_up AS date,  
    			content.publish_up AS date_publish,
    			content.hits AS hits,
    			content.images AS images,
    			content.featured AS frontpage,
    			content.access AS access,
    			content.language AS lang,
    			categories.title AS catname, 
    			users.email AS author_email,
    			content.created_by_alias AS author_alias,
    			users.name AS author_username,
    			content_rating.rating_sum AS rating_sum,
    			content_rating.rating_count AS rating_count,
    			
      CASE WHEN CHAR_LENGTH(content.alias) 
    				THEN CONCAT_WS(":", content.id, content.alias) 
    					ELSE content.id END as id, 
    			
      CASE WHEN CHAR_LENGTH(categories.alias) 
    				THEN CONCAT_WS(":", categories.id, categories.alias) 
    					ELSE categories.id END as cid			
    		
      FROM 
    			l3yfr_content AS content 
    			
      LEFT JOIN 
    				l3yfr_categories AS categories 
    				
      ON categories.id = content.catid 
    			
      LEFT JOIN 
    				l3yfr_users AS users 
    				
      ON users.id = content.created_by 			
    			
      LEFT JOIN 
    				l3yfr_content_rating AS content_rating 
    				
      ON content_rating.content_id = content.id
    			
      LEFT JOIN 
    				l3yfr_content_frontpage AS content_frontpage 
    				
      ON content_frontpage.content_id = content.id
    		
      WHERE 
    			1=1
    			 
      AND ( content.id = 34 OR  content.id = 31 OR  content.id = 30 OR  content.id = 5)
    		
      ORDER BY 
    			 content.created DESC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	4	Using where; filesort wurde genutzt
    1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.content.catid	1	Using where
    1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.content.created_by	1	Using where
    1	SIMPLE	content_rating	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.content.id	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
    16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332
    15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

22. Abfragezeit: 0.68 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 4.105 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #20

    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(34,31,30,5)
       
      AND falang_content.reference_table='content'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_id	4	NULL	4	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
    20	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    19	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    18	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
    16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332
    15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

23. Abfragezeit: 0.58 ms Nach letzter Abfrage: 1.72 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 4.122 MB Zeilen zurückgegeben: 2

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

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    28	ContentRouter->getCategorySegment()	Der selbe Aufruf in der Zeile darunter.
    27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

24. Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.40 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 4.162 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(1,8)
       
      AND falang_content.reference_table='categories'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	2	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    37	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    36	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    35	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
    34	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    33	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    32	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    31	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    28	ContentRouter->getCategorySegment()	Der selbe Aufruf in der Zeile darunter.
    27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

25. Abfragezeit: 0.58 ms Nach letzter Abfrage: 0.63 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.249 MB Zeilen zurückgegeben: 0

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 34 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'content'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	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
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

26. Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.255 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #28  #30  #32

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 8 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'categories'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

27. Abfragezeit: 0.59 ms Nach letzter Abfrage: 1.68 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.282 MB Zeilen zurückgegeben: 0

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 31 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'content'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	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
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

28. Abfragezeit: 0.55 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.304 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #26  #30  #32

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 8 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'categories'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

29. Abfragezeit: 291.70 ms Nach letzter Abfrage: 0.71 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.327 MB Zeilen zurückgegeben: 0

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 30 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'content'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	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
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

30. Abfragezeit: 0.85 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.349 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #26  #28  #32

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 8 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'categories'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

31. Abfragezeit: 0.61 ms Nach letzter Abfrage: 1.21 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.372 MB Zeilen zurückgegeben: 0

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 5 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'content'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	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
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

32. Abfragezeit: 0.61 ms Nach letzter Abfrage: 2.30 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.394 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #26  #28  #30

    SELECT fc.value
    
      FROM l3yfr_falang_content fc
    
      WHERE fc.reference_id = 8 
      AND fc.language_id = 3 
      AND fc.reference_field = 'alias' 
      AND fc.published = 1 
      AND fc.reference_table = 'categories'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
    27	plgSystemFalangdriver->buildRule()	Der selbe Aufruf in der Zeile darunter.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
    15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

33. Abfragezeit: 0.70 ms Nach letzter Abfrage: 12.95 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 4.340 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 = 'mod_custom.content' 
      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
    28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    25	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
    20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    13	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:598
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

34. Abfragezeit: 0.48 ms Nach letzter Abfrage: 54.99 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 4.758 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]

    ---