Joomla!-Debug-Konsole

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

46 ausgeführte Abfragen 25.97 ms

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

   SELECT `data`
   
     FROM `dvxft_session`
   
     WHERE `session_id` = '28ceaea51b8576a5e83746d9e5d0d419'

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Executing	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.02 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.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.01 ms

   Call Stack

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

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

   ---

2. Abfragezeit: 0.48 ms Nach letzter Abfrage: 2.05 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 3.153 MB

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

   Explain

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

   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.06 ms
   Updating	0.18 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.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.02 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: 1.63 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.165 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `dvxft_session`
   
     WHERE `session_id` = '28ceaea51b8576a5e83746d9e5d0d419' 
     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.01 ms
   starting	0.00 ms
   Checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   Waiting for query cache lock	0.53 ms
   init	0.03 ms
   Optimizing	0.01 ms
   Statistics	0.82 ms
   Preparing	0.01 ms
   Executing	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.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
   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.25 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.178 MB

   INSERT INTO `dvxft_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('28ceaea51b8576a5e83746d9e5d0d419', 0, '1716016163')

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.01 ms
   Update	0.03 ms
   Waiting for query cache lock	0.00 ms
   Update	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.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.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

5. Abfragezeit: 0.55 ms Nach letzter Abfrage: 5.89 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.613 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.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.05 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.11 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Abfragezeit: 0.38 ms Nach letzter Abfrage: 2.48 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.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.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.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.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
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:852
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.93 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.01 ms
   Waiting for query cache lock	0.02 ms
   starting	0.01 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.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.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.01 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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:938
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Abfragezeit: 0.90 ms Nach letzter Abfrage: 0.32 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.05 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.43 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.01 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.05 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: 1.98 ms Nach letzter Abfrage: 19.04 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.064 MB Zeilen zurückgegeben: 54

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM dvxft_menu AS m
   
     LEFT JOIN dvxft_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

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

   Profil (Profile)

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.03 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.12 ms
   Preparing	0.07 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   Creating sort index	0.83 ms
   Waiting for query cache lock	0.00 ms
   Creating sort index	0.28 ms
   Waiting for query cache lock	0.01 ms
   Creating sort index	0.07 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.01 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.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1091
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Abfragezeit: 0.56 ms Nach letzter Abfrage: 3.87 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.797 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.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.02 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.06 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.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.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.62 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 6.805 MB

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

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:388
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Abfragezeit: 0.52 ms Nach letzter Abfrage: 5.87 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.340 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.07 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.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.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
    10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Abfragezeit: 0.63 ms Nach letzter Abfrage: 2.95 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.529 MB Zeilen zurückgegeben: 3

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.06 ms
    Executing	0.00 ms
    Sending data	0.10 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.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.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:335
    19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:680
    18	JHtml::script()	Derselbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    15	JHtml::_()	JROOT/libraries/cms/html/jquery.php:53
    14	JHtmlJquery::framework()	Derselbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
    10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    9	plgSystemK2->onAfterRoute()	Derselbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Abfragezeit: 1.06 ms Nach letzter Abfrage: 12.00 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.05 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.38 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.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 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.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.14 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
    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.54 ms Nach letzter Abfrage: 0.77 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.02 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.03 ms
    Commit	0.01 ms
    closing tables	0.01 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.05 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
    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.52 ms Nach letzter Abfrage: 0.14 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.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.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.04 ms
    Executing	0.00 ms
    Sending data	0.11 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.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.46 ms Nach letzter Abfrage: 0.79 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 8.704 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.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.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.02 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.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: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.62 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 8.727 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.02 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.06 ms
    Optimizing	0.01 ms
    Statistics	0.13 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.14 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.04 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: 0.69 ms Nach letzter Abfrage: 9.88 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.02 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.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.12 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.09 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.88 ms Nach letzter Abfrage: 0.82 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.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.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.05 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.12 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
    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.39 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.395 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM dvxft_k2_categories 
      WHERE id = '16'

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.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.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 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.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    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.40 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.447 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM dvxft_k2_categories 
      WHERE id = '23'

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 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.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.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.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.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
    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:98
    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.57 ms Nach letzter Abfrage: 1.43 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.580 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.02 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.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.07 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.15 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    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]

    ---

24. Abfragezeit: 0.61 ms Nach letzter Abfrage: 7.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.303 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM dvxft_k2_categories 
      WHERE parent=16 
      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.01 ms
    starting	0.00 ms
    Checking query cache for query	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.10 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 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.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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.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]

    ---

25. Abfragezeit: 0.39 ms Nach letzter Abfrage: 1.14 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 11.404 MB Zeilen zurückgegeben: 0

    SELECT id
                            
      FROM dvxft_k2_categories
                            
      WHERE parent IN (16)
                            
      AND id NOT IN (16) 
                                    
      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.02 ms
    Waiting for query cache lock	0.02 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.06 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.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
    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]

    ---

26. Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 11.424 MB Zeilen zurückgegeben: 5

    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 07:09:23' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-18 07:09:23' ) 
      AND c.id IN (16) 
      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	5	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.07 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.05 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.09 ms
    Waiting for query cache lock	0.00 ms
    Creating sort index	0.04 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.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.03 ms
    Reset for next command	0.01 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]

    ---

27. Abfragezeit: 0.46 ms Nach letzter Abfrage: 0.87 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 11.525 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 07:09:23' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-18 07:09:23' ) 
      AND c.id IN (16)

    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	5	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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.01 ms

    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]

    ---

28. Abfragezeit: 0.42 ms Nach letzter Abfrage: 2.41 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.757 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 = 167 
      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.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.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 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]

    ---

29. Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.88 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 11.892 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.01 ms
    closing tables	0.00 ms
    Opening tables	0.26 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    checking permissions	0.09 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.10 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]

    ---

30. Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 11.962 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.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.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	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.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
    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]

    ---

31. Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.94 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.009 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #35  #38  #41  #44

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.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.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.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.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
    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]

    ---

32. Abfragezeit: 0.79 ms Nach letzter Abfrage: 4.82 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.158 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.03 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    Opening tables	0.25 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    checking permissions	0.12 ms
    closing tables	0.01 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
    Removing tmp table	0.09 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]

    ---

33. Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 12.273 MB Zeilen zurückgegeben: 1

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

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
    22	JTable->load()	JROOT/administrator/components/com_k2/tables/table.php:23
    21	K2Table->load()	JROOT/administrator/components/com_k2store/library/prices.php:185
    20	K2StorePrices->_getK2Item()	JROOT/administrator/components/com_k2store/library/prices.php:122
    19	K2StorePrices->_getK2StoreVars()	JROOT/administrator/components/com_k2store/library/prices.php:95
    18	K2StorePrices->getItemEnabled()	JROOT/plugins/k2/k2store/k2store.php:189
    17	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:96
    16	plgK2K2Store->onK2AfterDisplay()	Derselbe Aufruf in der Zeile darunter.
    15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:724
    12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:428
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Abfragezeit: 0.50 ms Nach letzter Abfrage: 2.41 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 12.429 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 = 166 
      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.02 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 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.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.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 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.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.01 ms

    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]

    ---

35. Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.74 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.453 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #31  #38  #41  #44

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

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1550
    16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:214
    15	K2ModelItem->prepareItem()	Derselbe Aufruf in der Zeile darunter.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:421
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Abfragezeit: 0.40 ms Nach letzter Abfrage: 2.66 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.441 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.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.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.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.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
    22	JTable->load()	JROOT/administrator/components/com_k2/tables/table.php:23
    21	K2Table->load()	JROOT/administrator/components/com_k2store/library/prices.php:185
    20	K2StorePrices->_getK2Item()	JROOT/administrator/components/com_k2store/library/prices.php:122
    19	K2StorePrices->_getK2StoreVars()	JROOT/administrator/components/com_k2store/library/prices.php:95
    18	K2StorePrices->getItemEnabled()	JROOT/plugins/k2/k2store/k2store.php:189
    17	plgK2K2Store->_loadCart()	JROOT/plugins/k2/k2store/k2store.php:96
    16	plgK2K2Store->onK2AfterDisplay()	Derselbe Aufruf in der Zeile darunter.
    15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:724
    12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:428
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:19
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:45
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:64
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Abfragezeit: 0.42 ms Nach letzter Abfrage: 1.55 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 12.566 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 = 165 
      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.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.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 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.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.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]

    ---

38. Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.54 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.589 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #31  #35  #41  #44

    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.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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]

    ---

39. Abfragezeit: 0.39 ms Nach letzter Abfrage: 2.64 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 12.578 MB Zeilen zurückgegeben: 1

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

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

    ---

40. Abfragezeit: 0.41 ms Nach letzter Abfrage: 1.61 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 12.702 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 = 164 
      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.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.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 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]

    ---

41. Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.726 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #31  #35  #38  #44

    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]

    ---

42. Abfragezeit: 0.42 ms Nach letzter Abfrage: 2.71 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.714 MB Zeilen zurückgegeben: 1

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

    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.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.06 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.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    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]

    ---

43. Abfragezeit: 0.43 ms Nach letzter Abfrage: 1.66 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 12.839 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 = 163 
      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.02 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.01 ms
    init	0.02 ms
    Optimizing	0.02 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.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.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.00 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]

    ---

44. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.863 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #31  #35  #38  #41

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

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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]

    ---

45. Abfragezeit: 0.40 ms Nach letzter Abfrage: 2.85 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 12.851 MB Zeilen zurückgegeben: 1

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

    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.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.05 ms
    Optimizing	0.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.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.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
    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]

    ---

46. Abfragezeit: 1.67 ms Nach letzter Abfrage: 13.43 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 13.858 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 07:09:23') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-18 07:09:23') 
      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.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.12 ms
    Preparing	0.07 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.89 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.03 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.08 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/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]

    ---