Joomla!-Debug-Konsole

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1745085197,
                "last": 1745085197,
                "now": 1745085197
            },
            "token": "Noqwp27Tao0vGjA2awJBcAe6SnTCDA2H"
        },
        "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
        },
        "com_mailto": {
            "formtime": 1745085197
        }
    }
}

Zeit

Speicher

13 ausgeführte Abfragen 7.73 ms

1. Abfragezeit: 0.42 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 2.976 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `dvxft_session`
   
     WHERE `session_id` = '148ad2f2928555b80532c15364601499'

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.00 ms
   starting	0.01 ms
   Checking query cache for query	0.04 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.02 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	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.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.02 ms
   Reset for next command	0.01 ms

   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()	Derselbe Aufruf in der Zeile darunter.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
   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:748
   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:404
   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.49 ms Nach letzter Abfrage: 3.41 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 3.181 MB

   DELETE 
   
     FROM `dvxft_session`
   
     WHERE `time` < '1745084297'

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.04 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.01 ms
   init for update	0.05 ms
   Updating	0.13 ms
   End of update loop	0.01 ms
   Waiting for query cache lock	0.00 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.07 ms
   Writing to binlog	0.01 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:765
   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:404
   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.96 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.193 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `dvxft_session`
   
     WHERE `session_id` = '148ad2f2928555b80532c15364601499' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	dvxft_session	const	PRIMARY	PRIMARY	766	const	1	Using index

   Profil (Profile)

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	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.01 ms
   Waiting for query cache lock	0.63 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	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.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   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:404
   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]

   ---

4. Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.206 MB

   INSERT INTO `dvxft_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('148ad2f2928555b80532c15364601499', 0, '1745085197')

   Explain

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `dvxft_session` (`session_id`, `client_id`, `time`) VALUES ('148ad2f2928555b80532c15364601499', 0, '1745085197')

   Profil (Profile)

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.01 ms
   init for update	0.02 ms
   Update	0.06 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.05 ms
   Writing to binlog	0.01 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   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:404
   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]

   ---

5. Abfragezeit: 0.71 ms Nach letzter Abfrage: 5.58 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.642 MB Zeilen zurückgegeben: 35

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

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	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.02 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.01 ms
   Sending data	0.17 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	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.03 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.01 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	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:584
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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.15 ms Nach letzter Abfrage: 2.42 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 3.869 MB Zeilen zurückgegeben: 2

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

   Explain

   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	2	Using where; Using index

   Profil (Profile)

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	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.01 ms
   Reset for next command	0.01 ms

   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:852
   9	JAccess::getGroupsByUser()	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:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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: 0.14 ms Nach letzter Abfrage: 0.92 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.946 MB Zeilen zurückgegeben: 4

   SELECT id, rules
   
     FROM `dvxft_viewlevels`

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	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.01 ms
   Reset for next command	0.01 ms

   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:938
   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:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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.86 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.965 MB Zeilen zurückgegeben: 61

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

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.05 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.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.05 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
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	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.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.06 ms
   Reset for next command	0.01 ms

   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:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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: 1.68 ms Nach letzter Abfrage: 26.83 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.102 MB Zeilen zurückgegeben: 54

   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 dvxft_menu AS m
   
     LEFT JOIN dvxft_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language,published,parent_id	idx_client_id_parent_id_alias_language	1	const	122	Using index condition; Using where; filesort wurde genutzt
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d02f17c8.m.component_id	1	Using where

   Profil (Profile)

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.03 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.09 ms
   Preparing	0.04 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.71 ms
   Waiting for query cache lock	0.01 ms
   Creating sort index	0.21 ms
   Waiting for query cache lock	0.01 ms
   Creating sort index	0.12 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	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.01 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1091
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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.46 ms Nach letzter Abfrage: 3.92 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.734 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.04 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.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.03 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
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	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.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	Derselbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:388
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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.60 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 6.741 MB

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 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.01 ms
    init for update	0.07 ms
    Updating	0.08 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.14 ms
    Query end	0.01 ms
    Commit	0.09 ms
    Writing to binlog	0.01 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:388
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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.15 ms Nach letzter Abfrage: 5.23 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.276 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
    10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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.72 ms Nach letzter Abfrage: 1.89 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.465 MB Zeilen zurückgegeben: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	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.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.07 ms
    Executing	0.01 ms
    Sending data	0.11 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:335
    19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:680
    18	JHtml::script()	Derselbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    15	JHtml::_()	JROOT/libraries/cms/html/jquery.php:53
    14	JHtmlJquery::framework()	Derselbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
    10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM dvxft_extensions

2. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
     FROM dvxft_menu AS m 
     LEFT JOIN dvxft_extensions AS e 
     ON m.component_id = e.extension_id

3. 1 × SELECT * 
     FROM dvxft_languages

4. 1 × SELECT folder AS type, element AS name, params 
     FROM dvxft_extensions

5. 1 × SELECT id, home, template, s.params 
     FROM dvxft_template_styles as s 
     LEFT JOIN dvxft_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

6. 1 × SELECT id, rules 
     FROM `dvxft_viewlevels

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

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

9. 1 × SELECT `data` 
     FROM `dvxft_session`

Andere Tabellen:

1. 1 × UPDATE `dvxft_extensions` 
     SET `params` = '{\"mediaversion\":\"bb628ead4d0c3c1bd5f9971c4db22206\"}'

2. 1 × INSERT INTO `dvxft_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('148ad2f2928555b80532c15364601499', 0, '1745085197'

3. 1 × DELETE  
     FROM `dvxft_session`