Joomla!-Debug-Konsole

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

58 ausgeführte Abfragen 66.50 ms

1. Abfragezeit: 0.90 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 0.727 MB

   DELETE 
   
     FROM `dof0p_session`
   
     WHERE `time` < '1695655021'

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.06 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.09 ms
   Updating	0.26 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.07 ms
   closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
   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:413
   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.64 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 0.737 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `dof0p_session`
   
     WHERE `session_id` = 'sde3jgqmj29llijs4dg45nr7v0'

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   closing tables	0.04 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.03 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Der selbe Aufruf in der Zeile darunter.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
   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:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.95 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.755 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `dof0p_session`
   
     WHERE `session_id` = 'sde3jgqmj29llijs4dg45nr7v0' 
     LIMIT 1

   Erklären

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

   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.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.02 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.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   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:413
   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.56 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 0.761 MB

   INSERT INTO `dof0p_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('sde3jgqmj29llijs4dg45nr7v0', 1, '1695655921', 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `dof0p_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('sde3jgqmj29llijs4dg45nr7v0', 1, '1695655921', 0, '', 0)

   Profil (Profile)

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.02 ms
   Update	0.11 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.04 ms
   closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.03 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   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:413
   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: 1.31 ms Nach letzter Abfrage: 1.69 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.787 MB Zeilen zurückgegeben: 41

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.09 ms
   Preparing	0.05 ms
   Executing	0.02 ms
   Sending data	0.50 ms
   End of update loop	0.02 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.03 ms
   Updating status	0.05 ms
   Reset for next command	0.04 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.55 ms Nach letzter Abfrage: 2.16 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.832 MB Zeilen zurückgegeben: 3

   SELECT id, rules
   
     FROM `dof0p_viewlevels`

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.05 ms
   End of update loop	0.02 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.02 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.74 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.846 MB Zeilen zurückgegeben: 1

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.13 ms
   Preparing	0.02 ms
   Unlocking tables	0.01 ms
   Preparing	0.03 ms
   Executing	0.02 ms
   Sending data	0.05 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   closing tables	0.04 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Abfragezeit: 1.77 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 0.931 MB Zeilen zurückgegeben: 90

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.08 ms
   Preparing	0.04 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	1.06 ms
   End of update loop	0.02 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.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
   8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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: 0.87 ms Nach letzter Abfrage: 18.91 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.357 MB Zeilen zurückgegeben: 1
   Doppelte Abfragen: #10

   SELECT template
   
     FROM dof0p_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.03 ms
   System lock	0.03 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.05 ms
   Statistics	0.07 ms
   Preparing	0.04 ms
   Executing	0.02 ms
   Sending data	0.06 ms
   End of update loop	0.02 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.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:271
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.52 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.367 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #9

    SELECT template
    
      FROM dof0p_template_styles as s
    
      WHERE s.client_id = 0 
      AND s.home = 1

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 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.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:271
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.85 ms Nach letzter Abfrage: 5.56 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.514 MB Zeilen zurückgegeben: 2

    SELECT extension, file, type
    
      FROM dof0p_rokcommon_configs
    
      ORDER BY priority

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.03 ms
    Opening tables	0.15 ms
    After opening tables	0.03 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:271
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Abfragezeit: 1.46 ms Nach letzter Abfrage: 16.60 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.857 MB Zeilen zurückgegeben: 116
    Doppelte Abfragen: #21  #57

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.03 ms
    Opening tables	0.09 ms
    After opening tables	0.05 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    checking permissions	0.52 ms
    Executing	0.02 ms
    Sending data	0.08 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
    8	plgSystemjdownloads->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.89 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.880 MB Zeilen zurückgegeben: 0

    SELECT file_id 
      from dof0p_jdownloads_files 
      WHERE published = 1 
      AND use_timeframe = 1 
      AND publish_to != '0000-00-00 00:00:00' 
      AND publish_to <= '2023-09-25 17:32:01'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.18 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
    8	plgSystemjdownloads->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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: 0.61 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.887 MB Zeilen zurückgegeben: 0

    SELECT file_id 
      from dof0p_jdownloads_files 
      WHERE published = 0 
      AND use_timeframe = 1 
      AND publish_from != '0000-00-00 00:00:00' 
      AND publish_from <= '2023-09-25 17:32:01'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dof0p_jdownloads_files	ref	idx_published	idx_published	1	const	1	Using where

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
    8	plgSystemjdownloads->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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: 1.65 ms Nach letzter Abfrage: 0.71 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.882 MB Zeilen zurückgegeben: 18

    SHOW FULL COLUMNS 
      FROM `dof0p_extensions`

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    Opening tables	0.55 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Filling schema table	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    checking permissions	0.14 ms
    closing tables	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.01 ms
    Removing tmp table	0.17 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    12	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    11	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
    10	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:311
    9	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.75 ms Nach letzter Abfrage: 1.03 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.927 MB Zeilen zurückgegeben: 1

    SELECT `extension_id`
    
      FROM `dof0p_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dof0p_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    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.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.18 ms
    Preparing	0.06 ms
    Executing	0.03 ms
    Sending data	0.06 ms
    End of update loop	0.02 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.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:120
    9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.53 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.937 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #19

    SELECT *
    
      FROM dof0p_extensions
    
      WHERE `extension_id` = '10057'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.02 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.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.66 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.944 MB Zeilen zurückgegeben: 1

    SELECT `extension_id`
    
      FROM `dof0p_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dof0p_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.14 ms
    Preparing	0.04 ms
    Executing	0.03 ms
    Sending data	0.06 ms
    End of update loop	0.03 ms
    Query end	0.02 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.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:120
    9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.56 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.952 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #17

    SELECT *
    
      FROM dof0p_extensions
    
      WHERE `extension_id` = '10057'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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: 5.23 ms Nach letzter Abfrage: 202.16 ms Abfragespeichernutzung: 0.196 MB Speichernutzung vor Abfrage: 2.209 MB Zeilen zurückgegeben: 135

    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 dof0p_menu AS m
    
      LEFT JOIN dof0p_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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.07 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	4.35 ms
    End of update loop	0.03 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.02 ms
    Updating status	0.04 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
    16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    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:129
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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: 1.15 ms Nach letzter Abfrage: 14.13 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 2.952 MB Zeilen zurückgegeben: 116
    Doppelte Abfragen: #12  #57

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    checking permissions	0.38 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
    8	plgSystemjdownloads->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.75 ms Nach letzter Abfrage: 0.52 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.980 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.16 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    End of update loop	0.02 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.03 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.64 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 2.973 MB

    UPDATE `dof0p_extensions`
    
      SET `params` = '{\"mediaversion\":\"9ee89e95a17b64bbac65cc09f8dabbcc\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `dof0p_extensions` SET `params` = '{\"mediaversion\":\"9ee89e95a17b64bbac65cc09f8dabbcc\"}' 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.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.12 ms
    Updating	0.11 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.04 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.55 ms Nach letzter Abfrage: 0.94 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.012 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.02 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.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.87 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.027 MB Zeilen zurückgegeben: 6

    SELECT id, home, template, s.params
    
      FROM dof0p_template_styles as s
    
      LEFT JOIN dof0p_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

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	web688_2016_db.s.template,const	1	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.23 ms
    End of update loop	0.03 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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: 1.47 ms Nach letzter Abfrage: 4.31 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.086 MB Zeilen zurückgegeben: 41

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dof0p_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_jdownloads','com_jmgadventcalendar','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_pressearchiv','com_redirect','com_roksprocket','com_search','com_spidercontacts','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dof0p_assets	range	idx_asset_name	idx_asset_name	202	NULL	42	Using index condition

    Profil (Profile)

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.16 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.72 ms
    End of update loop	0.02 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.03 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Abfragezeit: 1.43 ms Nach letzter Abfrage: 1.32 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.153 MB Zeilen zurückgegeben: 30

    SHOW FULL COLUMNS 
      FROM `dof0p_content`

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    Opening tables	0.45 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    checking permissions	0.16 ms
    closing tables	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.15 ms
    closing tables	0.02 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.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.71 ms Nach letzter Abfrage: 2.69 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.288 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM dof0p_content
    
      WHERE `id` = '355'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    10	JTable->load()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.54 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.298 MB

    UPDATE dof0p_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '355'

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: UPDATE dof0p_content SET `hits` = (`hits` + 1) WHERE `id` = '355'

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.05 ms
    Updating	0.10 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.04 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
    10	JTable->hit()	JROOT/components/com_content/models/article.php:252
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Abfragezeit: 1.16 ms Nach letzter Abfrage: 1.61 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.325 MB Zeilen zurückgegeben: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM dof0p_content AS a
    
      INNER JOIN dof0p_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN dof0p_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN dof0p_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN dof0p_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 355 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 15:32:01') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 15:32:01') 
      AND (a.state = 1 OR a.state =2)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	Const row not found
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.02 ms
    Opening tables	0.09 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.07 ms
    Statistics	0.21 ms
    Preparing	0.03 ms
    Unlocking tables	0.04 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
    12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 1.00 ms Nach letzter Abfrage: 2.44 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 3.375 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=18
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	32	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.13 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.15 ms
    End of update loop	0.02 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/components/com_content/router.php:72
    18	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
    17	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    16	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    15	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    11	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.62 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.411 MB Zeilen zurückgegeben: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `dof0p_contentitem_tag_map` AS m 
    
      INNER JOIN `dof0p_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 355 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    Erklären

    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.06 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.03 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    End of update loop	0.02 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 1.23 ms Nach letzter Abfrage: 4.81 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 3.543 MB Zeilen zurückgegeben: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM dof0p_fields AS a
    
      LEFT JOIN `dof0p_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN dof0p_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN dof0p_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN dof0p_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN dof0p_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `dof0p_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (18,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; filesort wurde genutzt
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	web688_2016_db.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	web688_2016_db.a.id	1	Using where; Using index

    Profil (Profile)

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.03 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.10 ms
    Statistics	0.15 ms
    Preparing	0.08 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.07 ms
    End of update loop	0.02 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.02 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
    16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 4.23 ms Nach letzter Abfrage: 43.70 ms Abfragespeichernutzung: 0.151 MB Speichernutzung vor Abfrage: 3.954 MB Zeilen zurückgegeben: 170

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM dof0p_modules AS m
    
      LEFT JOIN dof0p_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN dof0p_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 <= '2023-09-25 15:32:01') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 15:32:01') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 467 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	6	NULL	48	Using index condition; Using where; filesort wurde genutzt
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	web688_2016_db.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	web688_2016_db.m.id	14	Using where; Using index

    Profil (Profile)

    Status	Duration
    Starting	0.18 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.07 ms
    Statistics	0.15 ms
    Preparing	0.10 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.02 ms
    Creating sort index	3.12 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    12	JDocumentHtml->countModules()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
    11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/jp-surfing/layouts/theme.config.php:26
    10	include JROOT/templates/jp-surfing/layouts/theme.config.php	JROOT/templates/jp-surfing/layouts/theme.php:10
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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: 1.58 ms Nach letzter Abfrage: 80.27 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 4.941 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=14
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	7	Using index condition; Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.26 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.09 ms
    Optimizing	0.06 ms
    Statistics	0.18 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.19 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.11 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.06 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    18	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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: 1.13 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.966 MB Zeilen zurückgegeben: 8

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dof0p_assets`
    
      WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.55 ms
    End of update loop	0.02 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
    23	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
    22	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
    21	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    20	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    19	JUser->authorise()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:56
    18	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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: 1.08 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 4.999 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=15
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	7	Using index condition; Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.14 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.18 ms
    End of update loop	0.02 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.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    18	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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.97 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 5.027 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=16
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	7	Using index condition; Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.15 ms
    End of update loop	0.04 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    18	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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.98 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 5.051 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=17
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	7	Using index condition; Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.12 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.15 ms
    End of update loop	0.02 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.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    18	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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.94 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 5.074 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=25
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	7	Using index condition; Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.15 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.03 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    18	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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: 1.13 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 5.096 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=26
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	7	Using index condition; Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.17 ms
    End of update loop	0.02 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    18	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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: 1.26 ms Nach letzter Abfrage: 2.20 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 5.209 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #58

    SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
    
      FROM `dof0p_dpcalendar_caldav_calendars` c
    
      LEFT 
      OUTER JOIN dof0p_dpcalendar_caldav_principals mainp 
      on mainp.uri = c.principaluri
    
      LEFT 
      OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
      from dof0p_dpcalendar_caldav_principals memberp
    				
      inner join dof0p_dpcalendar_caldav_groupmembers m 
      on memberp.id = m.member_id
    				
      inner join dof0p_dpcalendar_caldav_principals linkp 
      on m.principal_id = linkp.id) as mp
    				
      on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
    
      WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
    
      ORDER BY c.displayname ASC 
      LIMIT 20

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	filesort wurde genutzt
    1	SIMPLE	mainp	eq_ref	uri	uri	602	web688_2016_db.c.principaluri	1	Using where
    1	SIMPLE	m	index	principal_id	principal_id	8	NULL	1	Using where; Using index
    1	SIMPLE	memberp	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.m.member_id	1	Using where
    1	SIMPLE	linkp	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.m.principal_id	1	Using where

    Profil (Profile)

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.10 ms
    Optimizing	0.06 ms
    Statistics	0.13 ms
    Preparing	0.11 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.13 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    24	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    23	JModelList->getItems()	JROOT/components/com_dpcalendar/models/profile.php:38
    22	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:235
    21	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509
    20	DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/components/com_dpcalendar/models/calendar.php:100
    17	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. Abfragezeit: 2.14 ms Nach letzter Abfrage: 1.17 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.229 MB Zeilen zurückgegeben: 47

    SHOW FULL COLUMNS 
      FROM `dof0p_dpcalendar_events`

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    closing tables	0.02 ms
    Opening tables	0.68 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    checking permissions	0.34 ms
    closing tables	0.03 ms
    Executing	0.02 ms
    Sending data	0.12 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.01 ms
    Removing tmp table	0.25 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    21	JTable->__construct()	JROOT/administrator/components/com_dpcalendar/tables/event.php:19
    20	DPCalendarTableEvent->__construct()	JROOT/components/com_dpcalendar/models/events.php:570
    19	DPCalendarModelEvents->_getList()	JROOT/libraries/legacy/model/list.php:186
    18	JModelList->getItems()	JROOT/components/com_dpcalendar/models/events.php:137
    17	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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: 4.19 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.058 MB Speichernutzung vor Abfrage: 5.329 MB Zeilen zurückgegeben: 12

    SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
    
      FROM `dof0p_dpcalendar_events` AS a
    
      LEFT JOIN dof0p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN dof0p_dpcalendar_events_location AS rel 
      ON a.id = rel.event_id
    
      LEFT JOIN dof0p_dpcalendar_locations AS v 
      ON rel.location_id = v.id
    
      LEFT JOIN dof0p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN dof0p_users AS uam 
      ON uam.id = a.modified_by
    
      WHERE a.access IN (1,1) 
      AND a.original_id > -1 
      AND a.catid IN ('14','15','16','17','25','26') 
      AND (c.access IN (1,1) or c.access is null) 
      AND a.state = 1 
      AND a.state != -2 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 15:32:01') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 15:32:01') 
      AND (a.start_date  >= '2023-09-25 15:30:00') 
      AND a.language in ('de-DE','*')
    
      GROUP BY a.id
    
      ORDER BY a.start_date asc 
      LIMIT 12

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	idx_access,idx_start_date,idx_state,idx_catid,idx_language	idx_start_date	5	NULL	17	Using index condition; Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.catid	1	Using where
    1	SIMPLE	rel	ref	PRIMARY	PRIMARY	4	web688_2016_db.a.id	1	Using where; Using index
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.rel.location_id	1	Using where; Using index
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.created_by	1	Using where

    Profil (Profile)

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.02 ms
    Opening tables	0.09 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.14 ms
    Optimizing	0.09 ms
    Statistics	0.33 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.20 ms
    Creating tmp table	0.12 ms
    Sorting for group	0.06 ms
    Sorting result	0.06 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	1.59 ms
    Creating sort index	0.19 ms
    Removing tmp table	0.20 ms
    Creating sort index	0.05 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Removing tmp table	0.03 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_dpcalendar/models/events.php:573
    19	DPCalendarModelEvents->_getList()	JROOT/libraries/legacy/model/list.php:186
    18	JModelList->getItems()	JROOT/components/com_dpcalendar/models/events.php:137
    17	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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.99 ms Nach letzter Abfrage: 4.21 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.480 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=774
    
      ORDER BY c.lft

    Erklären

    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.20 ms
    checking permissions	0.06 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.06 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

46. Abfragezeit: 0.85 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.501 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=781
    
      ORDER BY c.lft

    Erklären

    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.16 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

47. Abfragezeit: 0.79 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.523 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=782
    
      ORDER BY c.lft

    Erklären

    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.14 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.05 ms
    End of update loop	0.02 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.02 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.544 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=783
    
      ORDER BY c.lft

    Erklären

    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.15 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.565 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=784
    
      ORDER BY c.lft

    Erklären

    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.14 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.06 ms
    Reset for next command	0.04 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

50. Abfragezeit: 0.90 ms Nach letzter Abfrage: 0.76 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.587 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=785
    
      ORDER BY c.lft

    Erklären

    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.14 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.09 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

51. Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.609 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=777
    
      ORDER BY c.lft

    Erklären

    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.15 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.05 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

52. Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.82 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.630 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=786
    
      ORDER BY c.lft

    Erklären

    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.14 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

53. Abfragezeit: 0.88 ms Nach letzter Abfrage: 0.97 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.652 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=788
    
      ORDER BY c.lft

    Erklären

    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.18 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.04 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

54. Abfragezeit: 0.78 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.673 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=787
    
      ORDER BY c.lft

    Erklären

    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.14 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

55. Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.86 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.701 MB Zeilen zurückgegeben: 0

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM dof0p_categories as c
    
      LEFT JOIN dof0p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=789
    
      ORDER BY c.lft

    Erklären

    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.14 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    25	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    24	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    23	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    22	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    21	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    20	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    19	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    18	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:110
    17	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    16	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-surfing/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-surfing/layouts/theme.php:135
    9	include JROOT/templates/jp-surfing/layouts/theme.php	JROOT/templates/jp-surfing/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-surfing/index.php:16
    7	require JROOT/templates/jp-surfing/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

56. Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.722 MB Zeilen zurückgegeben: 0