Joomla!-Debug-Konsole

Sitzung

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

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

13 ausgeführte Abfragen 7.86 ms

Abfragezeit: 0.26 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 2.947 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `dvxft_session`

  WHERE `session_id` = '1d2e903fb89b6f81d02914c45b672619'

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.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 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.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.01 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.00 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.03 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]

Abfragezeit: 0.17 ms Nach letzter Abfrage: 1.81 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.153 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `dvxft_session`

  WHERE `session_id` = '1d2e903fb89b6f81d02914c45b672619' 
  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.01 ms
Waiting for query cache lock	0.00 ms
starting	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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 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.02 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.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 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]

Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.166 MB

INSERT INTO `dvxft_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('1d2e903fb89b6f81d02914c45b672619', 0, '1714848588')

Explain

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

Profil (Profile)

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

Abfragezeit: 0.55 ms Nach letzter Abfrage: 3.13 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.604 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.01 ms
Waiting for query cache lock	0.00 ms
starting	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.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.12 ms
Waiting for query cache lock	0.00 ms
Sending data	0.15 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.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 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]

Abfragezeit: 0.34 ms Nach letzter Abfrage: 1.36 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 3.832 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.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.04 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.06 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 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.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
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]

Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.908 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.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.01 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.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 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.01 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.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 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]

Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.928 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.01 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.00 ms
System lock	0.00 ms
table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.39 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.03 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]

Abfragezeit: 1.67 ms Nach letzter Abfrage: 14.51 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.055 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.08 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.73 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.23 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.10 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.02 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

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]

Abfragezeit: 0.43 ms Nach letzter Abfrage: 3.27 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.802 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.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.04 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.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	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.06 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

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]

Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 6.810 MB

UPDATE `dvxft_extensions`

  SET `params` = '{\"mediaversion\":\"134a7197d073d9d4c8dd511b18e9baac\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

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.00 ms
init for update	0.07 ms
Updating	0.06 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.00 ms
Commit	0.07 ms
Writing to binlog	0.00 ms
Commit	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 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
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]

Abfragezeit: 0.32 ms Nach letzter Abfrage: 3.70 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.344 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.01 ms
Waiting for query cache lock	0.00 ms
starting	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.01 ms
Preparing	0.01 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.00 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.02 ms
Reset for next command	0.00 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]

Abfragezeit: 0.59 ms Nach letzter Abfrage: 2.00 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.535 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.01 ms
Waiting for query cache lock	0.01 ms
starting	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.01 ms
System lock	0.00 ms
table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.05 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.02 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.02 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

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]

Abfragezeit: 1.82 ms Nach letzter Abfrage: 47.43 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 10.580 MB Zeilen zurückgegeben: 16

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM dvxft_modules AS m

  LEFT JOIN dvxft_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN dvxft_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-04 18:49:48') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-04 18:49:48') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 220 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	52	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	d02f17c8.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	d02f17c8.m.id	1	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.13 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.03 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.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.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.08 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.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
16	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
15	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
13	JDocumentHtml->countModules()	JROOT/templates/gk_restaurant/lib/framework/helper.api.php:36
12	GKTemplateAPI->modules()	JROOT/templates/gk_restaurant/lib/framework/helper.layout.php:152
11	GKTemplateLayout->generateColumnsWidth()	JROOT/templates/gk_restaurant/layouts/default.php:15
10	include JROOT/templates/gk_restaurant/layouts/default.php	JROOT/templates/gk_restaurant/lib/gk.framework.php:175
9	GKTemplate->getLayout()	JROOT/templates/gk_restaurant/lib/gk.framework.php:104
8	GKTemplate->__construct()	JROOT/templates/gk_restaurant/index.php:26
7	require JROOT/templates/gk_restaurant/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:1048
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
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:

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

```
1 × SELECT * 
  FROM dvxft_languages
```

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

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM dvxft_modules AS m 
  LEFT JOIN dvxft_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN dvxft_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id, rules 
  FROM `dvxft_viewlevels

1 × SELECT `session_id` 
  FROM `dvxft_session`

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

1 × SELECT `data` 
  FROM `dvxft_session`

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

Andere Tabellen:

1 × UPDATE `dvxft_extensions` 
  SET `params` = '{\"mediaversion\":\"134a7197d073d9d4c8dd511b18e9baac\"}'

1 × INSERT INTO `dvxft_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('1d2e903fb89b6f81d02914c45b672619', 0, '1714848588'

Login or Register

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

13 ausgeführte Abfragen 7.86 ms

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

SELECT-Tabellen:

Andere Tabellen:

Login or Register

LOG IN

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

13 ausgeführte Abfragen 7.86 ms

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

SELECT-Tabellen:

Andere Tabellen: