Warnung

JUser: :_load: Fehler beim Laden des Benutzers mit der ID: 42

Kismet Restaurant

Home
»

11 Nov

Tagesmenü

Published in Allgemein

MontagDienstagMittwoch

1. makarna

2. corba

3. kofte

Tagesmenü

1) Menü 1

Inhalt ...

2) Menü 2

Inhalt ...

3) Menü 3

Inhalt ...

09 Nov

Catering

Published in Allgemein

Catering ile ilgili yazilar buraya gelebilir

Login or Register

Joomla!-Debug-Konsole

Sitzung

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

33 ausgeführte Abfragen 9.87 ms

3 Duplikate gefunden!

3 Duplikate: #21 #28 #31

Abfragezeit: 0.22 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 2.972 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `dvxft_session`

  WHERE `session_id` = '36e7b3f44c4bce80797c11eb9c978b6d'

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.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.01 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.00 ms
Executing	0.01 ms
End of update loop	0.00 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.00 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
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.20 ms Nach letzter Abfrage: 2.00 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.178 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `dvxft_session`

  WHERE `session_id` = '36e7b3f44c4bce80797c11eb9c978b6d' 
  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.02 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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.31 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.190 MB

INSERT INTO `dvxft_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('36e7b3f44c4bce80797c11eb9c978b6d', 0, '1745083218')

Explain

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

Profil (Profile)

Status	Duration
Starting	0.03 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.07 ms
Waiting for query cache lock	0.00 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.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 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]

Abfragezeit: 0.14 ms Nach letzter Abfrage: 3.46 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.629 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.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 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.11 ms Nach letzter Abfrage: 1.56 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 3.857 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.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.01 ms
Reset for next command	0.00 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.09 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.933 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.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.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.13 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.953 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.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.01 ms
Reset for next command	0.00 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: 0.84 ms Nach letzter Abfrage: 18.10 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.088 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.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.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.37 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.11 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 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.00 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
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.32 ms Nach letzter Abfrage: 4.03 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.821 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.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.03 ms
End of update loop	0.00 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.00 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
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.27 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 6.829 MB

UPDATE `dvxft_extensions`

  SET `params` = '{\"mediaversion\":\"ce2d009874921cad57fb1f6cb6c87268\"}'

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

Explain

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

Profil (Profile)

Status	Duration
Starting	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
init for update	0.04 ms
Updating	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.03 ms
Writing to binlog	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.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
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.10 ms Nach letzter Abfrage: 4.55 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.364 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.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

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.07 ms Nach letzter Abfrage: 1.53 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.554 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.00 ms
starting	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

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: 0.95 ms Nach letzter Abfrage: 7.88 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 8.606 MB Zeilen zurückgegeben: 8

SHOW FULL COLUMNS 
  FROM `dvxft_assets`

Explain

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.30 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.02 ms
After opening tables	0.00 ms
checking permissions	0.07 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.15 ms
closing tables	0.01 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.02 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/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/joomla/table/asset.php:60
11	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:304
10	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:714
9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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: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.09 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 8.672 MB Zeilen zurückgegeben: 1

SELECT *

  FROM dvxft_assets

  WHERE `id` = '1'

Explain

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

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.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

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:715
10	JTable->load()	JROOT/libraries/joomla/access/access.php:715
9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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: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.17 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 8.684 MB Zeilen zurückgegeben: 1

SELECT a.rules

  FROM dvxft_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

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.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 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:1538
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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: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.09 ms Nach letzter Abfrage: 0.84 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 8.734 MB Zeilen zurückgegeben: 35

SELECT element

  FROM dvxft_extensions

  WHERE type = 'component' 
  AND enabled = '1'

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

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.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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:412
10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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: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.08 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 8.757 MB Zeilen zurückgegeben: 35

SELECT a.name, a.rules

  FROM dvxft_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_k2','com_k2store','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sptransfer','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explain

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

Profil (Profile)

Status	Duration
Starting	0.00 ms
Waiting for query cache lock	0.00 ms
starting	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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:439
10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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: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.11 ms Nach letzter Abfrage: 9.82 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 10.269 MB Zeilen zurückgegeben: 16

SELECT id 
  FROM dvxft_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dvxft_k2_categories	ref	category,published,access,trash	category	2	const	23	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.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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/itemlist/view.html.php:28
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.71 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 10.402 MB Zeilen zurückgegeben: 16

SHOW FULL COLUMNS 
  FROM `dvxft_users`

Explain

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 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.00 ms
checking permissions	0.11 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 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.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
18	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:304
17	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:583
16	JUser::getTable()	JROOT/libraries/joomla/user/user.php:861
15	JUser->load()	JROOT/libraries/joomla/user/user.php:243
14	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
13	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
12	JFactory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:193
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.06 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.468 MB Zeilen zurückgegeben: 0

SELECT *

  FROM `dvxft_users`

  WHERE `id` = 42

Explain

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.01 ms
Waiting for query cache lock	0.00 ms
starting	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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
16	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
15	JUser->load()	JROOT/libraries/joomla/user/user.php:243
14	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
13	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
12	JFactory::getUser()	JROOT/components/com_k2/views/itemlist/view.html.php:193
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.06 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 10.508 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #28 #31

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dvxft_k2_users 
  WHERE userID=42

Explain

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.01 ms
Waiting for query cache lock	0.00 ms
starting	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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/itemlist.php:707
12	K2ModelItemlist->getUserProfile()	JROOT/components/com_k2/views/itemlist/view.html.php:202
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.64 ms Nach letzter Abfrage: 2.69 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 10.748 MB Zeilen zurückgegeben: 2

SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM dvxft_k2_items as i RIGHT JOIN dvxft_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-19 17:20:18' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-19 17:20:18' ) 
  AND i.created_by=42 
  AND i.created_by_alias='' 
  ORDER BY i.id DESC 
  LIMIT 0, 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	index	item,catid,created_by,publish_up,publish_down,access,trash	PRIMARY	4	NULL	2	Using where
1	SIMPLE	c	eq_ref\|filter	PRIMARY,category,published,access,trash	PRIMARY\|trash	4\|2	d02f17c8.i.catid	1 (70%)	Using index condition; Using where; Using rowid filter

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.10 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	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.00 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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:322
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:351
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.18 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 10.792 MB Zeilen zurückgegeben: 1

SELECT COUNT(*) 
  FROM dvxft_k2_items as i RIGHT JOIN dvxft_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-19 17:20:18' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-19 17:20:18' ) 
  AND i.created_by=42 
  AND i.created_by_alias=''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	item,catid,created_by,publish_up,publish_down,access,trash	item	2	const	71	Using index condition; Using where
1	SIMPLE	c	eq_ref\|filter	PRIMARY,category,published,access,trash	PRIMARY\|trash	4\|2	d02f17c8.i.catid	1 (70%)	Using index condition; Using where; Using rowid filter

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.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.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.77 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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.02 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:521
12	K2ModelItemlist->getTotal()	JROOT/components/com_k2/views/itemlist/view.html.php:375
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.62 ms Nach letzter Abfrage: 1.66 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 11.028 MB Zeilen zurückgegeben: 14

SHOW FULL COLUMNS 
  FROM `dvxft_k2_categories`

Explain

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.20 ms
After opening tables	0.00 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.00 ms
checking permissions	0.07 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 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.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
13	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:304
12	JTable::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:417
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.09 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 11.102 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM dvxft_k2_categories 
  WHERE id = '22'

Explain

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

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.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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
15	K2ModelItem->prepareItem()	Derselbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:421
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.13 ms Nach letzter Abfrage: 1.14 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 11.227 MB Zeilen zurückgegeben: 16

SELECT id, name,  parent  
  FROM dvxft_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1,5) 
  ORDER BY parent

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dvxft_k2_categories	ref	category,published,access,trash	category	2	const	23	Using index condition; 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.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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1077
18	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
17	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
16	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:68
15	K2ModelItem->prepareItem()	Derselbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:421
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.13 ms Nach letzter Abfrage: 1.11 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 11.342 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM dvxft_k2_categories 
  WHERE id = '23'

Explain

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

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.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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:85
15	K2ModelItem->prepareItem()	Derselbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:421
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.11 ms Nach letzter Abfrage: 1.04 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.389 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #21 #31

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dvxft_k2_users 
  WHERE userID=42

Explain

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.01 ms
Waiting for query cache lock	0.00 ms
starting	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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1550
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	Derselbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:421
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.85 ms Nach letzter Abfrage: 8.53 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.000 MB Zeilen zurückgegeben: 36

SHOW FULL COLUMNS 
  FROM `dvxft_k2_items`

Explain

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

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.26 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.00 ms
checking permissions	0.17 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
24	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
23	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:58
22	TableK2Item->__construct()	JROOT/libraries/joomla/table/table.php:304
21	JTable::getInstance()	JROOT/administrator/components/com_k2store/library/prices.php:183
20	K2StorePrices->_getK2Item()	JROOT/administrator/components/com_k2store/library/prices.php:122
19	K2StorePrices->_getK2StoreVars()	JROOT/administrator/components/com_k2store/library/prices.php:95
18	K2StorePrices->getItemEnabled()	JROOT/plugins/k2/k2store/k2store.php:189
17	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:96
16	plgK2K2Store->onK2AfterDisplay()	Derselbe Aufruf in der Zeile darunter.
15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:724
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:428
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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: 0.41 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.115 MB Zeilen zurückgegeben: 1

SELECT *

  FROM dvxft_k2_items

  WHERE `id` = '177'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dvxft_k2_items	const	PRIMARY	PRIMARY	4	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.03 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	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.00 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.00 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
22	JTable->load()	JROOT/administrator/components/com_k2/tables/table.php:23
21	K2Table->load()	JROOT/administrator/components/com_k2store/library/prices.php:185
20	K2StorePrices->_getK2Item()	JROOT/administrator/components/com_k2store/library/prices.php:122
19	K2StorePrices->_getK2StoreVars()	JROOT/administrator/components/com_k2store/library/prices.php:95
18	K2StorePrices->getItemEnabled()	JROOT/plugins/k2/k2store/k2store.php:189
17	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:96
16	plgK2K2Store->onK2AfterDisplay()	Derselbe Aufruf in der Zeile darunter.
15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:724
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:428
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.12 ms Nach letzter Abfrage: 2.36 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.272 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #21 #28

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dvxft_k2_users 
  WHERE userID=42

Explain

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
starting	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.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1550
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
15	K2ModelItem->prepareItem()	Derselbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:421
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.38 ms Nach letzter Abfrage: 2.93 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 12.267 MB Zeilen zurückgegeben: 1

SELECT *

  FROM dvxft_k2_items

  WHERE `id` = '176'

Explain

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

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.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.05 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
22	JTable->load()	JROOT/administrator/components/com_k2/tables/table.php:23
21	K2Table->load()	JROOT/administrator/components/com_k2store/library/prices.php:185
20	K2StorePrices->_getK2Item()	JROOT/administrator/components/com_k2store/library/prices.php:122
19	K2StorePrices->_getK2StoreVars()	JROOT/administrator/components/com_k2store/library/prices.php:95
18	K2StorePrices->getItemEnabled()	JROOT/plugins/k2/k2store/k2store.php:189
17	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:96
16	plgK2K2Store->onK2AfterDisplay()	Derselbe Aufruf in der Zeile darunter.
15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:724
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:428
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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: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.15 ms Nach letzter Abfrage: 11.07 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.280 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 <= '2025-04-19 17:20:18') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-19 17:20:18') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 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	mm	ref	PRIMARY	PRIMARY	4	d02f17c8.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	d02f17c8.m.module,const	1	Using index condition; Using where

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.02 ms
Updating status	0.00 ms
Reset for next command	0.00 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]

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

SELECT-Tabellen:

3 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dvxft_k2_users

```
2 × SELECT * 
  FROM dvxft_k2_items
```

2 × SELECT * 
  FROM dvxft_k2_categories

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

```
1 × SELECT * 
  FROM `dvxft_users`
```

1 × SELECT id 
  FROM dvxft_k2_categories

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 COUNT(*) 
  FROM dvxft_k2_items as i RIGHT JOIN dvxft_k2_categories c 
  ON c.id = i.catid

1 × SELECT id, name,  parent  
  FROM dvxft_k2_categories

1 × SELECT a.name, a.rules 
  FROM dvxft_assets AS a

1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM dvxft_k2_items as i RIGHT JOIN dvxft_k2_categories AS c 
  ON c.id = i.catid

1 × SELECT a.rules 
  FROM dvxft_assets AS a

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

1 × SELECT id, rules 
  FROM `dvxft_viewlevels

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 `session_id` 
  FROM `dvxft_session`

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 * 
  FROM dvxft_languages
```

1 × SELECT `data` 
  FROM `dvxft_session`

```
1 × SELECT * 
  FROM dvxft_assets
```

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 element 
  FROM dvxft_extensions

Andere Tabellen:

1 × SHOW FULL COLUMNS 
  FROM `dvxft_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `dvxft_k2_items

1 × SHOW FULL COLUMNS 
  FROM `dvxft_users

1 × SHOW FULL COLUMNS 
  FROM `dvxft_assets

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

1 × INSERT INTO `dvxft_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('36e7b3f44c4bce80797c11eb9c978b6d', 0, '1745083218'

Warnung

Login or Register

LOG IN

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

33 ausgeführte Abfragen 9.87 ms

3 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: