Joomla!-Debug-Konsole

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

Zeit

Speicher

57 ausgeführte Abfragen 50.54 ms

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

   SELECT `data`
   
     FROM `dvxft_session`
   
     WHERE `session_id` = 'af5818c2e2980adb56c27f59b37aa4e5'

   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.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.01 ms
   Checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.92 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.03 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   closing tables	0.02 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.06 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/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Abfragezeit: 1.85 ms Nach letzter Abfrage: 4.81 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 3.153 MB

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

   Explain

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

   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.91 ms
   Updating	0.64 ms
   End of update loop	0.01 ms
   Waiting for query cache lock	0.00 ms
   End of update loop	0.02 ms
   Query end	0.00 ms
   Commit	0.08 ms
   Writing to binlog	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

3. Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.165 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `dvxft_session`
   
     WHERE `session_id` = 'af5818c2e2980adb56c27f59b37aa4e5' 
     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.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   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.04 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
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Abfragezeit: 0.45 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.178 MB

   INSERT INTO `dvxft_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('af5818c2e2980adb56c27f59b37aa4e5', 0, '1716004855')

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	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
   init for update	0.02 ms
   Update	0.05 ms
   Waiting for query cache lock	0.00 ms
   Update	0.10 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.06 ms
   Writing to binlog	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.02 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]

   ---

5. Abfragezeit: 3.79 ms Nach letzter Abfrage: 7.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.614 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.01 ms
   starting	0.00 ms
   Checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	1.92 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.07 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   closing tables	0.02 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.06 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	1.21 ms
   Waiting for query cache lock	0.01 ms
   Sending data	0.14 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.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 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.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]

   ---

6. Abfragezeit: 1.38 ms Nach letzter Abfrage: 3.15 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 3.841 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.01 ms
   starting	0.00 ms
   Checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.53 ms
   After opening tables	0.02 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.03 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   closing tables	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.34 ms
   Preparing	0.01 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

7. Abfragezeit: 1.16 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.917 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.01 ms
   starting	0.00 ms
   Checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.77 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   closing tables	0.01 ms
   init	0.01 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.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.01 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.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]

   ---

8. Abfragezeit: 1.53 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.937 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.01 ms
   starting	0.00 ms
   Checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.02 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.03 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.07 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]

   ---

9. Abfragezeit: 4.20 ms Nach letzter Abfrage: 42.00 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.065 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.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.07 ms
   checking permissions	0.01 ms
   Opening tables	2.08 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.01 ms
   table lock	0.04 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Waiting for query cache lock	0.00 ms
   closing tables	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.39 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.15 ms
   Waiting for query cache lock	0.00 ms
   Creating sort index	0.11 ms
   Waiting for query cache lock	0.00 ms
   Creating sort index	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.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
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1091
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Abfragezeit: 0.40 ms Nach letzter Abfrage: 7.92 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.798 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.02 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.02 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.05 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.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]

    ---

11. Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 6.806 MB

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

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_extensions` SET `params` = '{\"mediaversion\":\"f3b4dc8e2d5634809be0459b7e5288dc\"}' 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.04 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.08 ms
    Query end	0.00 ms
    Commit	0.05 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:388
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Abfragezeit: 1.08 ms Nach letzter Abfrage: 9.38 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.341 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.59 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.05 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.03 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	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.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.07 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
    10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Abfragezeit: 0.65 ms Nach letzter Abfrage: 3.23 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.530 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.04 ms
    checking permissions	0.00 ms
    Opening tables	0.19 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.06 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.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.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.05 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]

    ---

14. Abfragezeit: 1.45 ms Nach letzter Abfrage: 13.73 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 8.576 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
    Opening tables	0.23 ms
    After opening tables	0.00 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.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.84 ms
    After opening tables	0.01 ms
    checking permissions	0.06 ms
    closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.07 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
    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]

    ---

15. Abfragezeit: 0.32 ms Nach letzter Abfrage: 1.46 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 8.642 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.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.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.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.01 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]

    ---

16. Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 8.654 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.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.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.47 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.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.01 ms
    Storing result in query cache	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: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]

    ---

17. Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.98 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 8.705 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.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
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.08 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.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.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    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]

    ---

18. Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 8.728 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.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.05 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.13 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.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.03 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]

    ---

19. Abfragezeit: 1.86 ms Nach letzter Abfrage: 14.70 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 10.237 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.05 ms
    checking permissions	0.00 ms
    Opening tables	0.90 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.03 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.55 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.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: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]

    ---

20. Abfragezeit: 0.51 ms Nach letzter Abfrage: 1.22 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.347 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
    Opening tables	0.17 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 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.08 ms
    closing tables	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
    Removing tmp table	0.07 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
    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:40
    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]

    ---

21. Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.396 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM dvxft_k2_categories 
      WHERE id = '12'

    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.00 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
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	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.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.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
    12	TableK2Category->load()	JROOT/components/com_k2/views/itemlist/view.html.php:41
    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]

    ---

22. Abfragezeit: 0.41 ms Nach letzter Abfrage: 2.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.553 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.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.01 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
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.08 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.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.01 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/components/com_k2/models/itemlist.php:1077
    14	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
    13	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
    12	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/views/itemlist/view.html.php:104
    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]

    ---

23. Abfragezeit: 0.49 ms Nach letzter Abfrage: 11.53 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.277 MB Zeilen zurückgegeben: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dvxft_k2_categories	ref	category,parent,published,access,trash	parent	5	const	1	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.02 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.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.01 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:657
    12	K2ModelItemlist->getCategoryFirstChildren()	JROOT/components/com_k2/views/itemlist/view.html.php:152
    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]

    ---

24. Abfragezeit: 0.25 ms Nach letzter Abfrage: 1.21 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 11.373 MB Zeilen zurückgegeben: 0

    SELECT id
                            
      FROM dvxft_k2_categories
                            
      WHERE parent IN (12)
                            
      AND id NOT IN (12) 
                                    
      AND 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	PRIMARY,category,parent,published,access,trash	parent	5	const	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.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.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.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.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:109
    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]

    ---

25. Abfragezeit: 2.56 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 11.393 MB Zeilen zurückgegeben: 3

    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 <= '2024-05-18 04:00:55' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-18 04:00:55' ) 
      AND c.id IN (12) 
      ORDER BY i.id DESC 
      LIMIT 0, 14

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,category,published,access,trash	PRIMARY	4	const	1
    1	SIMPLE	i	ref	item,catid,publish_up,publish_down,access,trash	catid	4	const	3	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.00 ms
    Opening tables	0.96 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.04 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.03 ms
    Optimizing	0.06 ms
    Statistics	0.44 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.74 ms
    Waiting for query cache lock	0.00 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 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
    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]

    ---

26. Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.84 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 11.469 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 <= '2024-05-18 04:00:55' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-18 04:00:55' ) 
      AND c.id IN (12)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,category,published,access,trash	PRIMARY	4	const	1
    1	SIMPLE	i	ref	item,catid,publish_up,publish_down,access,trash	catid	4	const	3	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.08 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.08 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    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]

    ---

27. Abfragezeit: 1.63 ms Nach letzter Abfrage: 2.76 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.701 MB Zeilen zurückgegeben: 0

    SELECT tag.*
                
      FROM dvxft_k2_tags AS tag
                JOIN dvxft_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
                
      WHERE tag.published=1
                
      AND xref.itemID = 129 
      ORDER BY xref.id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; filesort wurde genutzt
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	d02f17c8.xref.tagID	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	1.07 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.13 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1174
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:98
    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]

    ---

28. Abfragezeit: 1.01 ms Nach letzter Abfrage: 2.13 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 11.836 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
    Opening tables	0.17 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.46 ms
    After opening tables	0.00 ms
    checking permissions	0.08 ms
    closing tables	0.01 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
    Removing tmp table	0.07 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
    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/libraries/joomla/table/user.php:39
    22	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:304
    21	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:583
    20	JUser::getTable()	JROOT/libraries/joomla/user/user.php:861
    19	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    18	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    17	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    16	JFactory::getUser()	JROOT/components/com_k2/models/item.php:211
    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]

    ---

29. Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 11.906 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.01 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.03 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	0.02 ms
    End of update loop	0.00 ms
    Query end	0.01 ms
    Commit	0.00 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.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
    20	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
    19	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    18	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    17	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    16	JFactory::getUser()	JROOT/components/com_k2/models/item.php:211
    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]

    ---

30. Abfragezeit: 1.15 ms Nach letzter Abfrage: 1.52 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.953 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #34  #37

    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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.75 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.19 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 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.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.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]

    ---

31. Abfragezeit: 0.59 ms Nach letzter Abfrage: 5.57 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.105 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.02 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    Opening tables	0.22 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 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.10 ms
    closing tables	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
    Removing tmp table	0.07 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
    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]

    ---

32. Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.65 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.220 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM dvxft_k2_items
    
      WHERE `id` = '129'

    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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.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.01 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]

    ---

33. Abfragezeit: 0.37 ms Nach letzter Abfrage: 2.78 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.372 MB Zeilen zurückgegeben: 0

    SELECT tag.*
                
      FROM dvxft_k2_tags AS tag
                JOIN dvxft_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
                
      WHERE tag.published=1
                
      AND xref.itemID = 128 
      ORDER BY xref.id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; filesort wurde genutzt
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	d02f17c8.xref.tagID	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.01 ms
    Opening tables	0.02 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.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1174
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:98
    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]

    ---

34. Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.397 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #30  #37

    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]

    ---

35. Abfragezeit: 0.34 ms Nach letzter Abfrage: 3.78 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.388 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM dvxft_k2_items
    
      WHERE `id` = '128'

    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.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.03 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.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.01 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]

    ---

36. Abfragezeit: 0.36 ms Nach letzter Abfrage: 1.40 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 12.509 MB Zeilen zurückgegeben: 0

    SELECT tag.*
                
      FROM dvxft_k2_tags AS tag
                JOIN dvxft_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
                
      WHERE tag.published=1
                
      AND xref.itemID = 127 
      ORDER BY xref.id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where; filesort wurde genutzt
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	d02f17c8.xref.tagID	1	Using where

    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.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
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1174
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:98
    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]

    ---

37. Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.533 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #30  #34

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

    ---

38. Abfragezeit: 0.41 ms Nach letzter Abfrage: 2.60 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.525 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM dvxft_k2_items
    
      WHERE `id` = '127'

    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.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.00 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
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    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]

    ---

39. Abfragezeit: 4.48 ms Nach letzter Abfrage: 18.68 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 13.526 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-18 04:00:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-18 04:00:55') 
      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	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.03 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.11 ms
    checking permissions	0.01 ms
    Opening tables	1.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.06 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.02 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.83 ms
    Preparing	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.89 ms
    End of update loop	0.01 ms
    Query end	0.01 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.02 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	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/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]

    ---

40. Abfragezeit: 0.23 ms Nach letzter Abfrage: 51.42 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 14.705 MB

    LOCK TABLES `dvxft_extensions` WRITE

    Explain

    „EXPLAIN“ unmöglich für Abfrage: LOCK TABLES `dvxft_extensions` WRITE

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Query end	0.00 ms
    Commit	0.01 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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:543
    9	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:71
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

41. Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 14.718 MB

    UPDATE `dvxft_extensions`
    
      SET `params` = '{\"lastrun\":1716004855}'
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'system' 
      AND `element` = 'updatenotification'

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_extensions` SET `params` = '{\"lastrun\":1716004855}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    init for update	0.14 ms
    Updating	0.09 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.03 ms
    Query end	0.00 ms
    Commit	0.10 ms
    Writing to binlog	0.00 ms
    Commit	0.01 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
    9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:82
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

42. Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 14.734 MB

    UNLOCK TABLES

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UNLOCK TABLES

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Commit	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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:918
    9	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:96
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

43. Abfragezeit: 2.17 ms Nach letzter Abfrage: 1.23 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 14.830 MB Zeilen zurückgegeben: 2

    SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
    
      FROM `dvxft_update_sites` AS `a`
    
      INNER JOIN dvxft_update_sites_extensions AS b 
      ON a.update_site_id = b.update_site_id
    
      WHERE a.enabled = 1 
      AND b.extension_id IN (700)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	Using where; Using temporary
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	8	d02f17c8.a.update_site_id,const	1	Using index; Distinct

    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.05 ms
    checking permissions	0.01 ms
    Opening tables	1.37 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.03 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Executing	0.00 ms
    Sending data	0.29 ms
    Removing tmp table	0.09 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    11	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/updater/updater.php:229
    10	JUpdater->getUpdateSites()	JROOT/libraries/joomla/updater/updater.php:119
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

44. Abfragezeit: 1.38 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 14.850 MB Zeilen zurückgegeben: 2

    SELECT DISTINCT update_site_id
    
      FROM dvxft_updates
    
      WHERE `update_site_id` IN (
    SELECT update_site_id
    
      FROM dvxft_update_sites
    
      WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1715983255')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	dvxft_updates	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	77	Using where; Using temporary
    1	PRIMARY	dvxft_update_sites	eq_ref	PRIMARY	PRIMARY	4	d02f17c8.dvxft_updates.update_site_id	1	Using where; Distinct

    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.01 ms
    Opening tables	0.81 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Creating tmp table	0.02 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    Removing tmp table	0.01 ms
    Sending data	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.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.04 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/updater/updater.php:400
    10	JUpdater->getSitesWithUpdates()	JROOT/libraries/joomla/updater/updater.php:132
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

45. Abfragezeit: 0.28 ms Nach letzter Abfrage: 1.94 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 14.949 MB Zeilen zurückgegeben: 1

    SELECT `name`
    
      FROM `dvxft_update_sites`
    
      WHERE `update_site_id` = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dvxft_update_sites	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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	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.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/updater/updateadapter.php:188
    13	JUpdateAdapter->getUpdateSiteName()	JROOT/libraries/joomla/updater/updateadapter.php:215
    12	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    11	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

46. Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 14.969 MB

    UPDATE `dvxft_update_sites`
    
      SET `enabled` = '0'
    
      WHERE `update_site_id` = '1'

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '1'

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
    13	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:238
    12	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    11	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

47. Abfragezeit: 0.58 ms Nach letzter Abfrage: 244.82 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 15.102 MB

    UPDATE `dvxft_update_sites`
    
      SET `enabled` = '1'
    
      WHERE `update_site_id` = '1'

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '1'

    Profil (Profile)

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.06 ms
    Updating	0.09 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.09 ms
    Writing to binlog	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
    13	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:254
    12	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    11	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

48. Abfragezeit: 0.93 ms Nach letzter Abfrage: 1.13 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 15.153 MB Zeilen zurückgegeben: 14

    SHOW FULL COLUMNS 
      FROM `dvxft_updates`

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.34 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.02 ms
    Preparing	0.02 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.09 ms
    closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.13 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    16	JTable->__construct()	JROOT/libraries/joomla/table/update.php:31
    15	JTableUpdate->__construct()	JROOT/libraries/joomla/table/table.php:304
    14	JTable::getInstance()	JROOT/libraries/joomla/updater/adapters/collection.php:117
    13	JUpdaterCollection->_startElement()	Derselbe Aufruf in der Zeile darunter.
    12	xml_parse()	JROOT/libraries/joomla/updater/adapters/collection.php:234
    11	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

49. Abfragezeit: 0.94 ms Nach letzter Abfrage: 3.52 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 15.250 MB Zeilen zurückgegeben: 17

    SHOW FULL COLUMNS 
      FROM `dvxft_extensions`

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	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.11 ms
    closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.15 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    13	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
    12	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:304
    11	JTable::getInstance()	JROOT/libraries/joomla/updater/updater.php:311
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

50. Abfragezeit: 0.55 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 15.311 MB Zeilen zurückgegeben: 1

    SELECT `update_id`
    
      FROM `dvxft_updates`
    
      WHERE element = 'joomla' 
      AND type = 'file' 
      AND client_id = '0' 
      AND folder = ''

    Explain

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

    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.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.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.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/update.php:110
    11	JTableUpdate->find()	JROOT/libraries/joomla/updater/updater.php:321
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

51. Abfragezeit: 0.45 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 15.327 MB Zeilen zurückgegeben: 1

    SELECT `extension_id`
    
      FROM `dvxft_extensions`
    
      WHERE element = 'joomla' 
      AND type = 'file' 
      AND client_id = '0' 
      AND folder = ''

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    11	JTableExtension->find()	JROOT/libraries/joomla/updater/updater.php:331
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

52. Abfragezeit: 0.46 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 15.345 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM dvxft_updates
    
      WHERE `update_id` = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dvxft_updates	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.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.04 ms
    Optimizing	0.11 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 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.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
    11	JTable->load()	JROOT/libraries/joomla/updater/updater.php:356
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

53. Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 15.348 MB

    UPDATE `dvxft_update_sites`
    
      SET `last_check_timestamp` = '1716004855'
    
      WHERE `update_site_id` = '1'

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_update_sites` SET `last_check_timestamp` = '1716004855' WHERE `update_site_id` = '1'

    Profil (Profile)

    Status	Duration
    Starting	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.00 ms
    init for update	0.04 ms
    Updating	0.05 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.07 ms
    Writing to binlog	0.01 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 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/updater/updater.php:429
    10	JUpdater->updateLastCheckTimestamp()	JROOT/libraries/joomla/updater/updater.php:165
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

54. Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 15.363 MB Zeilen zurückgegeben: 1

    SELECT `name`
    
      FROM `dvxft_update_sites`
    
      WHERE `update_site_id` = '2'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dvxft_update_sites	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.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/updater/updateadapter.php:188
    13	JUpdateAdapter->getUpdateSiteName()	JROOT/libraries/joomla/updater/updateadapter.php:215
    12	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    11	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

55. Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 15.382 MB

    UPDATE `dvxft_update_sites`
    
      SET `enabled` = '0'
    
      WHERE `update_site_id` = '2'

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '2'

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
    13	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:238
    12	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    11	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

56. Abfragezeit: 0.45 ms Nach letzter Abfrage: 317.34 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 15.405 MB

    UPDATE `dvxft_update_sites`
    
      SET `enabled` = '1'
    
      WHERE `update_site_id` = '2'

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '2'

    Profil (Profile)

    Status	Duration
    Starting	0.06 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
    init for update	0.06 ms
    Updating	0.06 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.01 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.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
    13	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:254
    12	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
    11	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
    10	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---

57. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 15.416 MB

    UPDATE `dvxft_update_sites`
    
      SET `last_check_timestamp` = '1716004856'
    
      WHERE `update_site_id` = '2'

    Explain

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dvxft_update_sites` SET `last_check_timestamp` = '1716004856' WHERE `update_site_id` = '2'

    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.03 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 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.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updater.php:429
    10	JUpdater->updateLastCheckTimestamp()	JROOT/libraries/joomla/updater/updater.php:165
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:115
    8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1068
    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]

    ---