Joomla!-Debug-Konsole

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1788497282,
                "last": 1788497283,
                "now": 1788497283
            }
        },
        "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
        },
        "gdpr_cookie_category_disabled_2": 1,
        "gdpr_cookie_category_disabled_3": 1,
        "gdpr_cookie_category_disabled_4": 1
    }
}

Zeit

Speicher

41 ausgeführte Abfragen 33.02 ms

1. Abfragezeit: 0.24 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 0.751 MB Zeilen zurückgegeben: 1

   SELECT `data`
   
     FROM `adqlu_session`
   
     WHERE `session_id` = '2acoa99q95roc8s8jhjq5fqbhj'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	adqlu_session	const	PRIMARY	PRIMARY	766	const	1

   Profil (Profile)

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.02 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Der selbe Aufruf in der Zeile darunter.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.770 MB

   DELETE 
   
     FROM `adqlu_session`
   
     WHERE `time` < '1788496383'

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: DELETE FROM `adqlu_session` WHERE `time` < '1788496383'

   Profil (Profile)

   Status	Duration
   Starting	0.02 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   Init for update	0.03 ms
   Updating	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.69 ms Abfragespeichernutzung: 0.061 MB Speichernutzung vor Abfrage: 0.798 MB Zeilen zurückgegeben: 47

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `adqlu_extensions`
   
     WHERE `type` = 'component'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	adqlu_extensions	ref	extension	extension	82	const	47	Using index condition

   Profil (Profile)

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.02 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.07 ms
   Waiting for query cache lock	0.01 ms
   Sending data	0.11 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.06 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 0.872 MB Zeilen zurückgegeben: 1

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.00 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

5. Abfragezeit: 0.05 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.878 MB Zeilen zurückgegeben: 5

   SELECT id, rules
   
     FROM `adqlu_viewlevels`

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.00 ms
   Checking privileges on cached	0.00 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Abfragezeit: 0.76 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 0.886 MB Zeilen zurückgegeben: 76

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

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	adqlu_extensions	ref	extension	extension	82	const	114	Using index condition; Using where; filesort wurde genutzt

   Profil (Profile)

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.03 ms
   Checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   Waiting for query cache lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.03 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.40 ms
   Waiting for query cache lock	0.01 ms
   Creating sort index	0.08 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Abfragezeit: 3.20 ms Nach letzter Abfrage: 6.09 ms Abfragespeichernutzung: 0.602 MB Speichernutzung vor Abfrage: 1.537 MB Zeilen zurückgegeben: 345

   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 adqlu_menu AS m
   
     LEFT JOIN adqlu_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	480	Using index condition; Using where; filesort wurde genutzt
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	staging_otterbein.m.component_id	1	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   13	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
   12	JApplicationSite->getTemplate()	JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:847
   11	require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php	JROOT/libraries/zauan/shortcodes/shortcodes.php:290
   10	include_once JROOT/libraries/zauan/shortcodes/shortcodes.php	JROOT/libraries/loader.php:219
   9	JLoader::import()	JROOT/libraries/loader.php:682
   8	jimport()	JROOT/plugins/system/hg_assets/hg_assets.php:16
   7	require_once JROOT/plugins/system/hg_assets/hg_assets.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.37 ms Nach letzter Abfrage: 3.88 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.988 MB Zeilen zurückgegeben: 6

   SELECT id, home, template, s.params
   
     FROM adqlu_template_styles as s
   
     LEFT JOIN adqlu_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	9	Using where
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	staging_otterbein.s.template,const	1	Using index condition; Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
   12	JApplicationSite->getTemplate()	JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:847
   11	require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php	JROOT/libraries/zauan/shortcodes/shortcodes.php:290
   10	include_once JROOT/libraries/zauan/shortcodes/shortcodes.php	JROOT/libraries/loader.php:219
   9	JLoader::import()	JROOT/libraries/loader.php:682
   8	jimport()	JROOT/plugins/system/hg_assets/hg_assets.php:16
   7	require_once JROOT/plugins/system/hg_assets/hg_assets.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Abfragezeit: 0.31 ms Nach letzter Abfrage: 4.63 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.253 MB Zeilen zurückgegeben: 1

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

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	adqlu_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   16	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
   15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   14	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   9	JFactory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1026
   8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.246 MB

    UPDATE `adqlu_extensions`
    
      SET `params` = '{\"mediaversion\":\"89fcb5190d16d4ef47f236a55716b8b3\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1026
    8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.09 ms Nach letzter Abfrage: 0.72 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.293 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.55 ms Nach letzter Abfrage: 2.22 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 5.382 MB Zeilen zurückgegeben: 8

    SHOW FULL COLUMNS 
      FROM `adqlu_assets`

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.06 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.474 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM adqlu_assets
    
      WHERE `id` = '1'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.05 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.481 MB Zeilen zurückgegeben: 1

    SELECT a.rules
    
      FROM adqlu_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.00 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.491 MB Zeilen zurückgegeben: 46

    SELECT element
    
      FROM adqlu_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	adqlu_extensions	ref	extension	extension	82	const	47	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.00 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 0.09 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 5.506 MB Zeilen zurückgegeben: 46

    SELECT a.name, a.rules
    
      FROM adqlu_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_customfilters','com_djimageslider','com_finder','com_flippingbook','com_gdpr','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_listmanager','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_seoglossary','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_virtuemart_magicscroll','com_virtuemart_magiczoomplus','com_weblinks','com_wrapper') OR a.name = 'root.1')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	47	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.59 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.760 MB Zeilen zurückgegeben: 30

    SHOW FULL COLUMNS 
      FROM `adqlu_content`

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.30 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 5.832 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM adqlu_content
    
      WHERE `id` = '263'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/components/com_content/models/article.php:265
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 8.91 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.839 MB

    UPDATE adqlu_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '263'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init for update	0.03 ms
    Updating	0.04 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	8.67 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
    10	JTable->hit()	JROOT/components/com_content/models/article.php:266
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.82 ms Nach letzter Abfrage: 0.65 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.863 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #24  #33  #35  #37  #40

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN adqlu_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 263 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03') 
      AND (a.state = 1 OR a.state =2)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	8	Using index condition; Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.16 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    Init	0.08 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Abfragezeit: 1.36 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.916 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 adqlu_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN adqlu_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=34
    
      GROUP BY 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
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	38	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	staging_otterbein.c.id	10	Using where
    2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	9	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	38	Using where; Using index; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.13 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.08 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Executing	0.01 ms
    Sending data	0.14 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.37 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Removing tmp table	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.61 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 5.960 MB Zeilen zurückgegeben: 0

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

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	59	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	staging_otterbein.t.id	4	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.30 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.71 ms Nach letzter Abfrage: 4.82 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.131 MB Zeilen zurückgegeben: 0

    SELECT t.* 
      FROM adqlu_seoglossary t 
      LEFT JOIN adqlu_seoglossaries g 
      ON t.catid = g.id 
      WHERE t.state = 1 
      AND g.state = 1 
      AND ( LOWER('') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') ) 
      AND ( g.language LIKE 'de-DE' OR g.language = '*' ) 
      ORDER BY ordering;

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	g	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.24 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.05 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/seoglossary/seoglossary.php:263
    13	plgContentSeoglossary->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.09 ms Nach letzter Abfrage: 0.97 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 6.183 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #20  #33  #35  #37  #40

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN adqlu_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 263 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03') 
      AND (a.state = 1 OR a.state =2)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	8	Using index condition; Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    15	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:221
    14	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:368
    13	plgContentMyShariff->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.51 ms Nach letzter Abfrage: 2.76 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.265 MB Zeilen zurückgegeben: 0

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM adqlu_modules AS m
    
      LEFT JOIN adqlu_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN adqlu_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND module = 'mod_maximenuck' 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-09-04 04:48:03') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:48:03') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 609 OR mm.menuid <= 0)
    
      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	newsfeeds	204	const,const	1	Using index condition; Using where; filesort wurde genutzt
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	staging_otterbein.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	staging_otterbein.m.id	3	Using where; Using index

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/maximenuckmobile/maximenuckmobile.php:248
    8	plgSystemMaximenuckmobile->getMaximenuModules()	JROOT/plugins/system/maximenuckmobile/maximenuckmobile.php:105
    7	plgSystemMaximenuckmobile->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.06 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.267 MB Zeilen zurückgegeben: 0

    SELECT id,placeholder
    
      FROM `adqlu_gdpr_checkbox`

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.00 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1291
    7	plgSystemGdpr->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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: 6.13 ms Nach letzter Abfrage: 3.11 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 6.322 MB Zeilen zurückgegeben: 24

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM adqlu_modules AS m
    
      LEFT JOIN adqlu_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN adqlu_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 <= '2026-09-04 04:48:03') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:48:03') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 609 OR mm.menuid <= 0)
    
      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	published	1	const	403	Using index condition; Using where; filesort wurde genutzt
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	staging_otterbein.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	staging_otterbein.m.id	3	Using where; Using index

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
    8	JDocumentHtml->countModules()	JROOT/templates/kallyas/index.php:18
    7	require JROOT/templates/kallyas/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Abfragezeit: 1.19 ms Nach letzter Abfrage: 13.39 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 6.656 MB Zeilen zurückgegeben: 3

    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN adqlu_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN adqlu_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (31) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03')
    
      ORDER BY a.created DESC 
      LIMIT 3

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	5	Using where; filesort wurde genutzt
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	staging_otterbein.a.created_by	1	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	staging_otterbein.a.modified_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	staging_otterbein.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	9	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.21 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.10 ms
    Optimizing	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.07 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Removing tmp table	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    12	ContentModelArticles->getItems()	JROOT/modules/mod_hg_latestposts/helper.php:96
    11	modHGLatestPostsHelper::getList()	JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9
    10	include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Abfragezeit: 1.40 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 6.760 MB Zeilen zurückgegeben: 3

    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 adqlu_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN adqlu_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=31
    
      GROUP BY 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
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	38	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	staging_otterbein.c.id	10	Using where
    2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	9	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	38	Using where; Using index; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.13 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.07 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Executing	0.00 ms
    Sending data	0.15 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.40 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    12	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_hg_latestposts/helper.php:104
    11	modHGLatestPostsHelper::getList()	JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9
    10	include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Abfragezeit: 1.21 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 6.696 MB Zeilen zurückgegeben: 3

    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN adqlu_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN adqlu_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (22) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03')
    
      ORDER BY a.created DESC 
      LIMIT 3

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	68	Using where; filesort wurde genutzt
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	staging_otterbein.a.created_by	1	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	staging_otterbein.a.modified_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	staging_otterbein.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	10	Using where
    2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	9	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	38	Using where; Using index; Using join buffer (flat, BNL join)

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    12	ContentModelArticles->getItems()	JROOT/modules/mod_hg_latestposts/helper.php:96
    11	modHGLatestPostsHelper::getList()	JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9
    10	include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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.10 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 6.807 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 adqlu_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN adqlu_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=22
    
      GROUP BY 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
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	38	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	staging_otterbein.c.id	10	Using where
    2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	9	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	38	Using where; Using index; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    12	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_hg_latestposts/helper.php:104
    11	modHGLatestPostsHelper::getList()	JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9
    10	include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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.72 ms Nach letzter Abfrage: 1.21 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.726 MB Zeilen zurückgegeben: 0

    SELECT t.* 
      FROM adqlu_seoglossary t 
      LEFT JOIN adqlu_seoglossaries g 
      ON t.catid = g.id 
      WHERE t.state = 1 
      AND g.state = 1 
      AND ( LOWER('\n  \n\nCALCEA®-FLYER\nLaden Sie den aktuellen Flyer zu den CALCEA® Kalksystemen hier herunter.\n	\n  \n  \n\nCAREMA®-FLYER\nLaden Sie den aktuellen Flyer zu den CAREMA® Kalk-Lehmputzen hier herunter.\n	\n	 \n\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '\n  \n\nCALCEA®-FLYER\nLaden Sie den aktuellen Flyer zu den CALCEA® Kalksystemen hier herunter.\n	\n  \n  \n\nCAREMA®-FLYER\nLaden Sie den aktuellen Flyer zu den CAREMA® Kalk-Lehmputzen hier herunter.\n	\n	 \n\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') ) 
      AND ( g.language LIKE 'de-DE' OR g.language = '*' ) 
      ORDER BY ordering;

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	g	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.28 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.04 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/seoglossary/seoglossary.php:263
    16	plgContentSeoglossary->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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.10 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 6.750 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #20  #24  #35  #37  #40

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN adqlu_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 263 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03') 
      AND (a.state = 1 OR a.state =2)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	8	Using index condition; Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    19	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    18	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:221
    17	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:368
    16	plgContentMyShariff->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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.71 ms Nach letzter Abfrage: 1.10 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.765 MB Zeilen zurückgegeben: 0

    SELECT t.* 
      FROM adqlu_seoglossary t 
      LEFT JOIN adqlu_seoglossaries g 
      ON t.catid = g.id 
      WHERE t.state = 1 
      AND g.state = 1 
      AND ( LOWER('\n  \n\nPRODUKTKATALOG\nLaden Sie unseren aktuellen Produktkatalog mit den Systemlösungen für den Fertighausbau hier herunter.\n	\n  \n  \n\nWEITERE DOWNLOADS\nHier finden Sie unsere Flyer, Farbkarten und technischen Merkblätter für unsere Produkte für den Fertighausbau.\n	\n	 \n\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '\n  \n\nPRODUKTKATALOG\nLaden Sie unseren aktuellen Produktkatalog mit den Systemlösungen für den Fertighausbau hier herunter.\n	\n  \n  \n\nWEITERE DOWNLOADS\nHier finden Sie unsere Flyer, Farbkarten und technischen Merkblätter für unsere Produkte für den Fertighausbau.\n	\n	 \n\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') ) 
      AND ( g.language LIKE 'de-DE' OR g.language = '*' ) 
      ORDER BY ordering;

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	g	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.28 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.04 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/seoglossary/seoglossary.php:263
    16	plgContentSeoglossary->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 6.783 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #20  #24  #33  #37  #40

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN adqlu_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 263 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03') 
      AND (a.state = 1 OR a.state =2)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	8	Using index condition; Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    19	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    18	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:221
    17	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:368
    16	plgContentMyShariff->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Abfragezeit: 0.08 ms Nach letzter Abfrage: 12.64 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.893 MB Zeilen zurückgegeben: 0

    SELECT t.* 
      FROM adqlu_seoglossary t 
      LEFT JOIN adqlu_seoglossaries g 
      ON t.catid = g.id 
      WHERE t.state = 1 
      AND g.state = 1 
      AND ( LOWER('{myshariff}\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '{myshariff}\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') ) 
      AND ( g.language LIKE 'de-DE' OR g.language = '*' ) 
      ORDER BY ordering;

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	g	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/seoglossary/seoglossary.php:263
    16	plgContentSeoglossary->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 6.912 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #20  #24  #33  #35  #40

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN adqlu_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 263 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03') 
      AND (a.state = 1 OR a.state =2)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	8	Using index condition; Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    19	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    18	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:221
    17	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:368
    16	plgContentMyShariff->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Abfragezeit: 0.11 ms Nach letzter Abfrage: 12.08 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 6.990 MB Zeilen zurückgegeben: 0

    SELECT *
    
      FROM `adqlu_modules`
    
      WHERE `id`='121' 
      AND `published`='1'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:60
    28	hg_module()	JROOT/libraries/zauan/shortcodes/shortcodes.php:98
    27	do_shortcode_tag()	Der selbe Aufruf in der Zeile darunter.
    26	preg_replace_callback()	JROOT/libraries/zauan/shortcodes/shortcodes.php:44
    25	do_shortcode()	JROOT/plugins/system/hg_assets/shortcodes/shortcodes_grid.php:34
    24	hg_grid()	JROOT/libraries/zauan/shortcodes/shortcodes.php:98
    23	do_shortcode_tag()	Der selbe Aufruf in der Zeile darunter.
    22	preg_replace_callback()	JROOT/libraries/zauan/shortcodes/shortcodes.php:44
    21	do_shortcode()	JROOT/plugins/system/hg_assets/shortcodes/shortcodes_grid.php:421
    20	hg_row()	JROOT/libraries/zauan/shortcodes/shortcodes.php:98
    19	do_shortcode_tag()	Der selbe Aufruf in der Zeile darunter.
    18	preg_replace_callback()	JROOT/libraries/zauan/shortcodes/shortcodes.php:44
    17	do_shortcode()	JROOT/plugins/system/hg_assets/hg_assets.php:136
    16	plgSystemHG_Assets->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.990 MB Zeilen zurückgegeben: 0

    SELECT t.* 
      FROM adqlu_seoglossary t 
      LEFT JOIN adqlu_seoglossaries g 
      ON t.catid = g.id 
      WHERE t.state = 1 
      AND g.state = 1 
      AND ( LOWER(' \nZEMENT- UND KALKWERKE OTTERBEIN GMBH & CO. KG\nHauptstraße 50\n36137 Großenlüder-Müs (Germany)\nTel.: +49 6648 68 - 0\nFax.: +49 6648 68 - 400\ninfo@zkw-otterbein.de\n\n\n\n\nyoutube\nfacebook\n\n\n\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR ' \nZEMENT- UND KALKWERKE OTTERBEIN GMBH & CO. KG\nHauptstraße 50\n36137 Großenlüder-Müs (Germany)\nTel.: +49 6648 68 - 0\nFax.: +49 6648 68 - 400\ninfo@zkw-otterbein.de\n\n\n\n\nyoutube\nfacebook\n\n\n\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') ) 
      AND ( g.language LIKE 'de-DE' OR g.language = '*' ) 
      ORDER BY ordering;

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	g	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/seoglossary/seoglossary.php:263
    16	plgContentSeoglossary->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.008 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #20  #24  #33  #35  #37

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM adqlu_content AS a
    
      LEFT JOIN adqlu_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN adqlu_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN adqlu_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN adqlu_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM adqlu_categories AS cat JOIN adqlu_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 263 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:03') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:03') 
      AND (a.state = 1 OR a.state =2)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	8	Using index condition; Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    19	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    18	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:221
    17	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:368
    16	plgContentMyShariff->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. Abfragezeit: 0.30 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 7.025 MB Zeilen zurückgegeben: 0

    SELECT *
     
      FROM adqlu_jmap_metainfo
     
      WHERE `linkurl` = 'https://staging.zkw-otterbein.de/sortiment/anwendungsgebiete/fertighausbau'
     
      AND `published` = 1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	adqlu_jmap_metainfo	ref	linkurl,published	linkurl	767	const	1	Using where

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
    8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
    7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---